Advertisement
Guest User

Untitled

a guest
Dec 9th, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.83 KB | None | 0 0
  1. public void clearInformationFields()
  2.         {
  3.             List<double> listFieldsToClear = new List<double>();
  4.             var mainProvider = RTLAPIEngine.DataManager.MainProvider;
  5.             string query =  "SELECT FamilyID" +
  6.                             " FROM dbo.Family";
  7.  
  8.             var rs = mainProvider.Execute(query);
  9.             while (!rs.EOF)
  10.             {
  11.                 listFieldsToClear.Add(System.Convert.ToInt64(rs.Fields["FamilyID"].Value));
  12.                 rs.MoveNext();
  13.             }
  14.             rs.Close();
  15.             rs = null;
  16.  
  17.             foreach(double id in listFieldsToClear)
  18.             {
  19.                 var item = RTLAPIEngine.DSOCache.FamilyProvider.GetFamily(id);
  20.                 item.InformationField10 = "";
  21.                 dsoCache.FamilyProvider.Save(item, id, false);
  22.             }
  23.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement