/// <summary> /// 新增或修改预约 /// </summary> /// <param name="App"></param> /// <returns></returns> public int Modify_Appt(CT_Appt_Service App) { #region 参数 SqlParameter[] parameters = { new SqlParameter("@AP_Code", SqlDbType.Int), new SqlParameter("@AP_AU_Code", SqlDbType.BigInt), new SqlParameter("@AP_CI_Code", SqlDbType.Int), new SqlParameter("@AP_AD_Code", SqlDbType.Int), new SqlParameter("@AP_Time", SqlDbType.SmallDateTime), new SqlParameter("@AP_SA_Selected", SqlDbType.Int), new SqlParameter("@AP_SC_Code", SqlDbType.Int), new SqlParameter("@AP_ST_Code", SqlDbType.Int), new SqlParameter("@AP_MP_Code", SqlDbType.Int), new SqlParameter("@AP_PAM_Code", SqlDbType.Int), new SqlParameter("@AP_Notification", SqlDbType.Int), new SqlParameter("@AP_Transportation", SqlDbType.Int), new SqlParameter("@AP_Notes", SqlDbType.NVarChar,100), }; parameters[0].Value = App.AP_Code; parameters[1].Value = App.AP_AU_Code; parameters[2].Value = App.AP_CI_Code; parameters[3].Value = App.AP_AD_Code; parameters[4].Value = App.AP_Time; parameters[5].Value = App.AP_SA_Selected; parameters[6].Value = App.AP_SC_Code; parameters[7].Value = App.AP_ST_Code; parameters[8].Value = App.AP_MP_Code; parameters[9].Value = App.AP_PAM_Code; parameters[10].Value = App.AP_Notification; parameters[11].Value = App.AP_Transportation; parameters[12].Value = App.AP_Notes; #endregion return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "02_Modify_Appt_All_W", parameters)); }
/// <summary> /// 添加APP /// </summary> /// <param name="App"></param> /// <returns></returns> public CT_Appt_Service InsertApp(CT_Appt_Service App) { #region 参数 SqlParameter[] parameters = { new SqlParameter("@AP_AU_CODE", SqlDbType.Int), new SqlParameter("@AP_CI_Code", SqlDbType.Int), new SqlParameter("@AP_AD_Code", SqlDbType.Int), new SqlParameter("@AP_Time", SqlDbType.SmallDateTime), new SqlParameter("@AP_SA_Selected", SqlDbType.Int), new SqlParameter("@AP_ST_Code", SqlDbType.Int), new SqlParameter("@AP_MP_Code", SqlDbType.Int), new SqlParameter("@AP_Transportation", SqlDbType.Int), }; parameters[0].Value = App.AP_AU_Code; parameters[1].Value = App.AP_CI_Code; parameters[2].Value = App.AP_AD_Code; parameters[3].Value = App.AP_Time; parameters[4].Value = App.AP_SA_Selected; parameters[5].Value = App.AP_ST_Code; parameters[6].Value = App.AP_MP_Code; parameters[7].Value = App.AP_Transportation; #endregion SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "02_Modify_Appt_All_W", parameters); return(App); }
private void Key_01_Modify_Appt(dynamic data) { CT_Appt_Service _app_m = new CT_Appt_Service(); _app_m.AP_Code = -1; if (data.AP_Code != null) { _app_m.AP_Code = (int)_app_m.AP_Code; } _app_m.AP_AU_Code = (long)data.AU_Code; _app_m.AP_CI_Code = (int)data.CI_Code; _app_m.AP_AD_Code = (int)data.AD_Code; _app_m.AP_Time = Convert.ToDateTime(data.AP_Time); _app_m.AP_SA_Selected = (int)data.SA_Selected; _app_m.AP_SC_Code = (int)data.SC_Code; _app_m.AP_ST_Code = (int)data.ST_Code; _app_m.AP_MP_Code = -1; if (data.MP_Code != null) { _app_m.AP_MP_Code = (int)data.MP_Code; } _app_m.AP_PAM_Code = 3; _app_m.AP_Notification = true; _app_m.AP_Transportation = (byte)data.AP_Tran; _app_m.AP_Notes = null; if (data.AP_Note != null) { _app_m.AP_Notes = data.AP_Note; } _object = _b_app.Modify_Appt(_app_m); SendWechatInfo_01(data); }
private void Remove_App(dynamic data) { var s_o = JsonConvert.SerializeObject(data.o); CT_Appt_Service ap = JsonConvert.DeserializeObject <CT_Appt_Service>(s_o); ap.AP_Updated_by = UserSession.User.AU_Code; ap.AP_Update_Dt = DateTime.Now; ap.AP_Canceled = true; var rows = ap.Update(new string[] { "AP_Canceled", "AP_Updated_by", "AP_Update_Dt" }); Response.Write(JsonConvert.SerializeObject(new { isOK = rows > 0 })); }
/// <summary> /// 获得预约信息 /// </summary> /// <param name="data"></param> private void Get_Appointment(dynamic data) { int AP_Code = (int)data.AP_Code; dynamic d = new ExpandoObject(); var o = CT_Appt_Service.SingleOrDefault(AP_Code); if (null != o.AP_Time && o.AP_Time.HasValue) { o.EX_AP_Date = o.AP_Time.Value.ToString(Interna ? "MM/dd/yyyy" : "yyyy-MM-dd"); o.EX_AP_Time = o.AP_Time.Value.ToString("HH:mm"); } var db = DBCRMTree.GetInstance(); int PTP_Code = (int)o.AP_Transportation; int AD_Code = (int)o.AP_AD_Code; o.AU_Name = db.ExecuteScalar <string>(string.Format(@" SELECT au.AU_Name FROM CT_Appt_Service [ap] INNER JOIN CT_All_Users [au] ON ap.AP_AU_Code = au.AU_Code WHERE AP_Code = @0", Interna ? "_en":"_cn"), AP_Code); o.SN_Note = db.ExecuteScalar <string>(@" SELECT SN_Note FROM CT_Service_Notes [sn] WHERE SN_AP_Code = @0 and isnull(SN_Cat,0)=0", AP_Code); o.AP_SA_Selected_text = db.ExecuteScalar <string>(@" SELECT au.AU_Name FROM CT_Appt_Service [ap] left join CT_Dealer_Empl [de] on ap.AP_SA_Selected=de.DE_Code INNER JOIN CT_All_Users [au] ON de.DE_AU_Code = au.AU_Code WHERE AP_Code = @0", AP_Code); o.AP_AD_Code_text = db.ExecuteScalar <string>(string.Format(@" SELECT AD_Name{0} FROM CT_Auto_Dealers where AD_Code=@0", Interna ? "_en" : "_cn"), AD_Code); o.AP_Transportation_text = db.ExecuteScalar <string>(string.Format(@" SELECT PTP_Desc{0} FROM CT_Transportation where PTP_Code=@0", Interna ? "_en":"_cn"), PTP_Code); o.EX_GeneralNote = db.ExecuteScalar <string>(@" SELECT SN_Note FROM CT_Service_Notes [sn] WHERE SN_AP_Code = @0 and SN_Cat = 1", AP_Code); o.AP_PL_ML_Code_Text = db.ExecuteScalar <string>(string.Format(@" SELECT CASE WHEN AP_Cont_Type = 1 AND AP_PL_ML_Code > 0 THEN ( SELECT w.text{0} + ' : ' + pl.PL_Number FROM CT_Phone_List pl INNER JOIN words w ON isnull(pl.PL_Type,'') = isnull(w.value,'') AND pl.PL_Code = ap.AP_PL_ML_Code AND w.p_id = 47 ) WHEN AP_Cont_Type = 2 AND AP_PL_ML_Code > 0 THEN ( SELECT mc.MC_Name{0} + ' : ' + ml.ML_Handle FROM CT_Messaging_List ml INNER JOIN CT_Messaging_Carriers mc ON isnull(mc.MC_Code,'') = isnull(ml.ML_MC_Code,'') AND ml.ML_Code = ap.AP_PL_ML_Code ) WHEN AP_Cont_Type = 3 AND AP_PL_ML_Code > 0 THEN ( SELECT w.text{0} + ' : ' + el.EL_Address FROM CT_Email_List el INNER JOIN words w ON isnull(el.EL_Type,'')= isnull(w.value,'') AND el.EL_Code = ap.AP_PL_ML_Code AND w.p_id = 44 ) END AS AP_PL_ML_Code_Text FROM CT_Appt_Service [ap] INNER JOIN CT_All_Users [au] ON ap.AP_AU_Code = au.AU_Code WHERE AP_Code = @0", Interna ? "_en" : "_cn"), AP_Code); d.o = o; d.service = Get_CT_Service_Dep(data); Response.Write(JsonConvert.SerializeObject(d)); }
/// <summary> /// 保存预约信息 /// </summary> /// <param name="data"></param> private void Save_Appointment(dynamic data) { var db = DBCRMTree.GetInstance(); try { var _AP_Code = -1; using (var tran = db.GetTransaction()) { var s = JsonConvert.SerializeObject(data.o); CT_Appt_Service ap = JsonConvert.DeserializeObject <CT_Appt_Service>(s); var ap_code = ap.AP_Code; if (ap.AP_SC_Code == -1) { ap.AP_SC_Code = null; } if (ap.AP_ST_Code == -1) { ap.AP_ST_Code = null; } if (UserSession.User.UG_UType == 1) { ap.AP_AD_Code = UserSession.DealerEmpl.DE_AD_OM_Code; } else { ap.AP_AD_Code = ap.AP_AD_Code.HasValue && ap.AP_AD_Code.Value > 0 ? ap.AP_AD_Code : UserSession.DealerEmpl.DE_AD_OM_Code; } if (ap.AP_Code > 0) { ap.AP_Updated_by = UserSession.User.AU_Code; ap.AP_Update_Dt = DateTime.Now; ap.Update(new string[] { //"AP_CI_Code" , "AP_AD_Code", //"AP_Cont_Type" , //"AP_PL_ML_Code" , //"AP_SC_Code", //"AP_ST_Code" , //"AP_MP_Code" , //"AP_PAM_Code" , "AP_Notification", "AP_Time", "AP_SA_Selected", "AP_Transportation", "AP_Updated_by", "AP_Update_Dt" }); } else { var ug_code = UserSession.User.AU_UG_Code; if (ug_code >= 10) { ap.AP_PAM_Code = 1; } else if (ug_code == 1) { ap.AP_PAM_Code = 2; } else if (ug_code == 3) { ap.AP_PAM_Code = 3; } else if (ug_code == 4) { ap.AP_PAM_Code = 4; } else if (ug_code == 5) { ap.AP_PAM_Code = 5; } if (ap.AP_SC_Code == 1) { ap.AP_MP_Code = ap.AP_ST_Code; } ap.AP_Created_by = UserSession.User.AU_Code; ap.AP_Update_Dt = DateTime.Now; ap_code = (int)ap.Insert(); } if (ap_code > 0) { string note = data.o.SN_Note; CT_Service_Note n = new CT_Service_Note(); n.SN_AP_Code = ap_code; n.SN_Note = note; if (CT_Service_Note.Exists("SN_AP_Code = @0 AND ISNULL(SN_Cat,0) = 0", ap_code)) { db.Update <CT_Service_Note>("SET [SN_Note] = @SN_Note WHERE SN_AP_Code=@SN_AP_Code AND ISNULL(SN_Cat,0) = 0", n); //db.Update(@"UPDATE [CT_Service_Notes] set [SN_Note] = @SN_Note WHERE SN_AP_Code=@SN_AP_Code", n); } else if (!string.IsNullOrWhiteSpace(n.SN_Note)) { n.Insert(); } string generalNote = data.o.EX_GeneralNote; CT_Service_Note gn = new CT_Service_Note(); gn.SN_AP_Code = ap_code; gn.SN_Note = generalNote; gn.SN_Cat = 1; if (CT_Service_Note.Exists("SN_AP_Code = @0 AND SN_Cat = 1", ap_code)) { db.Update <CT_Service_Note>("SET [SN_Note] = @SN_Note,SN_Cat=1 WHERE SN_AP_Code=@SN_AP_Code AND SN_Cat = 1", gn); } else if (!string.IsNullOrWhiteSpace(gn.SN_Note)) { gn.Insert(); } } tran.Complete(); _AP_Code = ap_code; } Response.Write(JsonConvert.SerializeObject(new { isOK = true, AP_Code = _AP_Code })); } catch (Exception ex) { db.AbortTransaction(); Response.Write(JsonConvert.SerializeObject(new { isOK = false, msg = ex.Message })); } }
/// <summary> /// 新增预约信息 /// </summary> /// <param name="App"></param> /// <returns></returns> public CT_Appt_Service InsertApp(CT_Appt_Service App) { return(o.InsertApp(App)); }
/// <summary> /// 预约更改 /// </summary> /// <param name="App"></param> /// <returns></returns> public int Modify_Appt(CT_Appt_Service App) { return(o.Modify_Appt(App)); }