/// <summary> /// 获得日程安排 /// </summary> /// <param name="DP_UType"></param> /// <param name="DP_AU_AD_Code"></param> private dynamic Get_Schedule(int DP_UType, int DP_AU_AD_Code) { var schedule = new CT_Daily_PLanner(); if (DP_UType > 0 && DP_AU_AD_Code > 0) { schedule = CT_Daily_PLanner.SingleOrDefault(@"where [DP_UType] = @0 AND [DP_AU_AD_Code] = @1", DP_UType, DP_AU_AD_Code); } return(schedule); }
/// <summary> /// 保存日程安排 /// </summary> /// <param name="data"></param> /// <param name="au_code"></param> private void Save_Schedule(dynamic data, long au_code) { var s_schedule = JsonConvert.SerializeObject(data.schedule); if (string.IsNullOrWhiteSpace(s_schedule)) { return; } CT_Daily_PLanner daily = JsonConvert.DeserializeObject <CT_Daily_PLanner>(s_schedule); daily.DP_AU_AD_Code = au_code; daily.DP_Update_dt = DateTime.Now; if (CT_Daily_PLanner.Exists("DP_UType = @0 AND DP_AU_AD_Code = @1", daily.DP_UType, au_code)) { var db = DBCRMTree.GetInstance(); db.Update <CT_Daily_PLanner>(@" SET [DP_D1_AM_S] = @DP_D1_AM_S ,[DP_D1_AM_E] = @DP_D1_AM_E ,[DP_D1_PM_S] = @DP_D1_PM_S ,[DP_D1_PM_E] = @DP_D1_PM_E ,[DP_D2_AM_S] = @DP_D2_AM_S ,[DP_D2_AM_E] = @DP_D2_AM_E ,[DP_D2_PM_S] = @DP_D2_PM_S ,[DP_D2_PM_E] = @DP_D2_PM_E ,[DP_D3_AM_S] = @DP_D3_AM_S ,[DP_D3_AM_E] = @DP_D3_AM_E ,[DP_D3_PM_S] = @DP_D3_PM_S ,[DP_D3_PM_E] = @DP_D3_PM_E ,[DP_D4_AM_S] = @DP_D4_AM_S ,[DP_D4_AM_E] = @DP_D4_AM_E ,[DP_D4_PM_S] = @DP_D4_PM_S ,[DP_D4_PM_E] = @DP_D4_PM_E ,[DP_D5_AM_S] = @DP_D5_AM_S ,[DP_D5_AM_E] = @DP_D5_AM_E ,[DP_D5_PM_S] = @DP_D5_PM_S ,[DP_D5_PM_E] = @DP_D5_PM_E ,[DP_D6_AM_S] = @DP_D6_AM_S ,[DP_D6_AM_E] = @DP_D6_AM_E ,[DP_D6_PM_S] = @DP_D6_PM_S ,[DP_D6_PM_E] = @DP_D6_PM_E ,[DP_D7_AM_S] = @DP_D7_AM_S ,[DP_D7_AM_E] = @DP_D7_AM_E ,[DP_D7_PM_S] = @DP_D7_PM_S ,[DP_D7_PM_E] = @DP_D7_PM_E ,[DP_Update_dt] = @DP_Update_dt WHERE [DP_UType] = @DP_UType AND [DP_AU_AD_Code] = @DP_AU_AD_Code" , daily); } else { daily.Insert(); } }