public void UpdateTable(string tableName, string data)
{
List <OrderStatistics> list = JsonConvert.DeserializeObject <List <OrderStatistics> >(data);
foreach (OrderStatistics item in list)
{
OrderStatisticsBLL.Save(item);
}
;
//Common.UpdateTableVersion("CloudTrade.dbo.OrderStatistics");
}
public List <OrderStatistics> GetList(TableObject table)
{
string CustomerLink = ConfigurationManager.AppSettings["CustomerLink"];
string CacheEnable = ConfigurationManager.AppSettings["CacheEnable"];
string key = CacheUtility.GetKey(table);
object obj = CacheUtility.Get(key);
if (obj != null)
{
return((List <OrderStatistics>)obj);
}
string sqlStr = "";
string sqlAdd = "";
if (table.IsValid == 1)
{
sqlAdd = " AND (TotalCourseAmount>0 OR CommonCourseAmount>0 OR SpecialCourseAmount>0) ";
}
sqlStr = @"select * from OrderStatistics where LastModified>@LastModified
and CustomerID
in(
select CustomerID FROM " + CustomerLink + @"[CloudCustomer].[dbo].[CustomerSearch] ss where ss.XDSchoolID=@SchoolID " + sqlAdd + ")";
// byte[] TimeStamp = new byte[8];
// if (CacheUtility.GetCollectionKey(table.LastModified) == CacheUtility.GetCollectionKey(TimeStamp))
// {
// sqlStr = @"select * from OrderStatistics where LastModified>@LastModified
//and CustomerID
//in(
//select CustomerID FROM " + CustomerLink + @"[CloudCustomer].[dbo].[CustomerSearch] ss where ss.XDSchoolID=@SchoolID
//
// )";
// //AND (SS.TotalCourseAmount>0 OR SS.CommonCourseAmount>0 OR SS.SpecialCourseAmount>0)
// }
// else
// {
// sqlStr = @"select * from OrderStatistics where LastModified>@LastModified";
// }
//string sqlStr = "select * from OrderStatistics where LastModified>@LastModified";
List <SqlParameter> pms = new List <SqlParameter>();
pms.Add(new SqlParameter("LastModified", table.LastModified));
pms.Add(new SqlParameter("SchoolID", table.SchoolID));
List <OrderStatistics> list = OrderStatisticsBLL.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);
}