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