private static void GetAC() { PadSYNC.Model.AssignCourse ac = AssignCourseBLL.GetById(16961); string json = JsonConvert.SerializeObject(ac); ac.AssignID = 0; ac.AsignCourseID = 0; ac.StartTime = new DateTime(2015, 1, 30, 12, 0, 0); ac.EndTime = new DateTime(2015, 1, 30, 13, 0, 0); AssignCourseDataContract acdc = Translate.TranslateAssignCourseEntityToGuest(ac); bool b = false; string result = ""; AssignCourseServiceClient client = new AssignCourseServiceClient(); Console.WriteLine("处理消息*---*"); if (ac.PadOperType == 0) { b = client.AddNewAssignCourseRetErrowString(out result, acdc); } else { List <CancelReasonConditionsDataContract> CancelReasonConditionsList = new List <CancelReasonConditionsDataContract>(); CancelReasonConditionsDataContract cancelReasonConditions = new CancelReasonConditionsDataContract(); cancelReasonConditions.AssignID = ac.AsignCourseID; cancelReasonConditions.Reason = ""; CancelReasonConditionsList.Add(cancelReasonConditions); CancelReasonConditionsDataContract[] arr = CancelReasonConditionsList.ToArray(); b = client.CancleAssignCourse(arr, 0, 0, 1); result = "取消失败"; } Console.WriteLine("处理成功 {0}", "*---*" + result); }
public void UpdateTable(string tableName, string data) { List <AssignCourse> list = JsonConvert.DeserializeObject <List <AssignCourse> >(data); foreach (AssignCourse item in list) { AssignCourseBLL.Save(item); } ; //Common.UpdateTableVersion("CloudCourse.dbo.AssignCourse"); }
public List <AssignCourse> GetList(TableObject table) { string CacheEnable = ConfigurationManager.AppSettings["CacheEnable"]; string key = CacheUtility.GetKey(table); object obj = CacheUtility.Get(key); if (obj != null) { return((List <AssignCourse>)obj); } string sqlStr = "select * from AssignCourse where CompanyID=@BranchID and SchoolID=@SchoolID and 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 StartTime>@StartDate"; pms.Add(new SqlParameter("StartDate", table.StartDate)); } if (!string.IsNullOrEmpty(table.EndDate)) { sqlStr += " and StartTime<@EndDate"; pms.Add(new SqlParameter("EndDate", table.EndDate)); } List <AssignCourse> list = AssignCourseBLL.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); }