/// <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();
}
}
