public void UpdateTable(string tableName, string data) { List <ProductAssign> list = JsonConvert.DeserializeObject <List <ProductAssign> >(data); foreach (ProductAssign item in list) { ProductAssignBLL.Save(item); } ; //Common.UpdateTableVersion("CloudAsset.dbo.ProductAssign"); }
public List <ProductAssign> GetList(TableObject table) { string CacheEnable = ConfigurationManager.AppSettings["CacheEnable"]; string key = CacheUtility.GetKey(table); object obj = CacheUtility.Get(key); if (obj != null) { return((List <ProductAssign>)obj); } string sqlStr = "select * from ProductAssign where LastModified>@LastModified"; List <SqlParameter> pms = new List <SqlParameter>(); //pms.Add(new SqlParameter("BranchID", table.BranchID)); //pms.Add(new SqlParameter("SchoolID", table.SchoolID)); pms.Add(new SqlParameter("LastModified", table.LastModified)); //if (!string.IsNullOrEmpty(table.StartDate)) //{ // sqlStr += " and OperateTime>@StartDate"; // pms.Add(new SqlParameter("StartDate", table.StartDate)); //} //if (!string.IsNullOrEmpty(table.EndDate)) //{ // sqlStr += " and OperateTime<@EndDate"; // pms.Add(new SqlParameter("EndDate", table.EndDate)); //} List <ProductAssign> list = ProductAssignBLL.Search(sqlStr, pms.ToArray()); if (list.Count > 0) { byte[] b = new byte[8]; if (CacheUtility.GetCollectionKey(table.LastModified) == CacheUtility.GetCollectionKey(b)) { CacheUtility.Insert(key, list); } else { if (CacheEnable == "true") { CacheUtility.Insert(key, list); } } } return(list); }