/// <summary>
/// 保存个人信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
private long Save_Personal(dynamic data)
{
var s_personal = JsonConvert.SerializeObject(data.personal);
CT_All_User personal = JsonConvert.DeserializeObject <CT_All_User>(s_personal);
if (!string.IsNullOrWhiteSpace(personal.AU_Username))
{
if (CT_All_User.Exists("AU_Code != @0 and AU_Username = @1", personal.AU_Code, personal.AU_Username))
{
throw new Exception(Interna ? "User account already exists!" : "用户账号已存在！");
}
}
long au_code = personal.AU_Code;
personal.AU_Update_dt = DateTime.Now;
if (!string.IsNullOrWhiteSpace(personal.AU_Password))
{
personal.AU_Password = ShInfoTech.Common.Security.Md5(personal.AU_Password);
}
if (personal.AU_Code > 0)
{
var cols = new string[] {
"AU_Update_dt",
"AU_Name",
"AU_Username",
"AU_Married",
"AU_Dr_Lic",
"AU_Gender",
"AU_ID_Type",
"AU_ID_No",
"AU_Education",
"AU_Type",
"AU_UG_Code",
"AU_Active_tag",
//"AU_Occupation",
//"AU_Industry",
"AU_B_date"
};
var listCols = cols.ToList <string>();
if (!string.IsNullOrWhiteSpace(personal.AU_Password))
{
listCols.Add("AU_Password");
}
personal.Update(listCols);
}
else
{
au_code = (long)personal.Insert();
}
return(au_code);
}
/// <summary>
/// 保存个人信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
private long Save_Personal(dynamic data)
{
var s_personal = JsonConvert.SerializeObject(data.personal);
CRMTree.Model.CT_All_Users personal = JsonConvert.DeserializeObject <CRMTree.Model.CT_All_Users>(s_personal);
CRMTree.Model.CT_Drivers_List_New drivermodel = JsonConvert.DeserializeObject <CRMTree.Model.CT_Drivers_List_New>(s_personal);
if (!string.IsNullOrWhiteSpace(personal.AU_Username))
{
if (CT_All_User.Exists("AU_Code != @0 and AU_Username = @1", personal.AU_Code, personal.AU_Username))
{
throw new Exception(Interna ? "User account already exists!" : "用户账号已存在！");
}
}
if (string.IsNullOrWhiteSpace(personal.AU_Name))
{
throw new Exception(Interna ? "NOT NULL!" : "姓名不能为空！");
}
long?au_code = data.AU_Code;
personal.AU_Update_dt = DateTime.Now;
//更新个人资料
CRMTree.BLL.BL_UserEntity bll = new CRMTree.BLL.BL_UserEntity();
if (!string.IsNullOrWhiteSpace(personal.AU_Password))
{
if (!bll.ExistsPwd(personal.AU_Password, personal.AU_Username))
{
personal.AU_Password = ShInfoTech.Common.Security.Md5(personal.AU_Password);
}
}
int isSuccess = 0;
if (au_code != null) //添加
{
bll.Update_CT_All_Users(personal);
drivermodel.MAU_Code = data.MAU_Code;
}
isSuccess = bll.add_personal(drivermodel);
if (isSuccess > 0)
{
if (au_code == null)
{
au_code = bll.getMaxAU_Code();
}
return((long)au_code);
}
else
{
return(isSuccess);
}
}
private void Save_CustomerByName(dynamic data)
{
CT_All_User user = new CT_All_User();
user.AU_Name = (string)data.AU_Name;
user.AU_Update_dt = DateTime.Now;
user.AU_Active_tag = 1;
var au_code = (long)user.Insert();
Response.Write(JsonConvert.SerializeObject(new { AU_Code = au_code, AU_Name = user.AU_Name }));
}
/// <summary>
/// 获得员工信息
/// </summary>
/// <param name="data"></param>
private void Get_EmployeeInfo(dynamic data)
{
dynamic o = new ExpandoObject();
int Empl_Code = (int)data.Empl_Code;
if (Empl_Code > 0)
{
//var empl = CT_Dealer_Empl.SingleOrDefault(Empl_Code);
//o.dealerEmpl = new {
// DE_Code = empl.DE_Code,
// DE_ID = empl.DE_ID,
// DE_Type = empl.DE_Type,
// DE_Picture_FN_Temp = empl.DE_Picture_FN,
// DE_Picture_FN = empl.DE_Picture_FN
//};
var empl = CT_Dealer_Empl.SingleOrDefault(Empl_Code);
empl.EX_DE_Activate_dt = empl.DE_Activate_dt.HasValue ? empl.DE_Activate_dt.Value.ToString(Interna ? "MM/dd/yyyy" : "yyyy-MM-dd") : "";
empl.EX_DE_Vacation_St = empl.DE_Vacation_St.HasValue ? empl.DE_Vacation_St.Value.ToString(Interna ? "MM/dd/yyyy" : "yyyy-MM-dd") : "";
empl.EX_DE_Vacation_En = empl.DE_Vacation_En.HasValue ? empl.DE_Vacation_En.Value.ToString(Interna ? "MM/dd/yyyy" : "yyyy-MM-dd") : "";
o.dealerEmpl = empl;
var AU_Code = empl.DE_AU_Code;
if (AU_Code > 0)
{
#region personal
o.personal = CT_All_User.SingleOrDefault(@"select
AU_Code,
AU_Active_tag,
AU_Name,
AU_Username,
AU_Dr_Lic,
AU_Gender,
AU_ID_Type,
AU_ID_No,
AU_Education,
AU_Married,
AU_Type,
AU_UG_Code,
--AU_Occupation,
--AU_Industry,
AU_B_date
from CT_All_Users
where AU_Code=@0", AU_Code);
#endregion
#region contacts
o.contacts = new ExpandoObject();
var db = DBCRMTree.GetInstance();
var sql_text_part = Interna ? "[text_en]" : "[text_cn]";
var sql = string.Format(@"Select AL_Code,AL_Type,AL_Add1,AL_Add2,AL_District,AL_City
,AL_State,AL_Zip,AL_Pref as [pref]
,(select {0} from words where p_id = 55 and [value] = al_type) as AL_Type_Text
FROM CT_Address_List
WHERE AL_AU_AD_Code=@0 and isnull(AL_Active,1) = 1
", sql_text_part);
o.contacts.address = db.Query <dynamic>(sql, AU_Code);
sql = string.Format(@"Select PL_Code,PL_Type,PL_Number,PL_pref as [pref]
,(select {0} from words where p_id = 47 and [value] = pl_type) as PL_Type_Text
from CT_Phone_List
WHERE PL_AU_AD_Code=@0 and isnull(PL_Active,1) = 1
", sql_text_part);
o.contacts.phone = db.Query <dynamic>(sql, AU_Code);
sql = string.Format(@"Select EL_Code,EL_Type,EL_Address,EL_Pref as [pref]
,(select {0} from words where p_id = 44 and [value] = el_type) as EL_Type_Text
from CT_eMail_List
WHERE EL_AU_AD_Code=@0 and isnull(EL_Active,1) = 1
", sql_text_part);
o.contacts.email = db.Query <dynamic>(sql, AU_Code);
sql_text_part = Interna ? "[MC_Name_EN]" : "[MC_Name_CN]";
sql = string.Format(@"Select ML_MC_Code,ML_Code,ML_Handle,ML_Pref as [pref]
,(SELECT {0} FROM [CT_Messaging_Carriers] where MC_Code=[ML_MC_Code]) as ML_MC_Code_Text
from CT_Messaging_List
WHERE ML_AU_AD_Code=@0 and isnull(ML_Active,1) = 1
", sql_text_part);
o.contacts.messaging = db.Query <dynamic>(sql, AU_Code);
#endregion
#region summary
var dealer_code = 0;
var user = HttpContext.Current.Session["PublicUser"] as MD_UserEntity;
if (null != user && user.User.UG_UType == 1)
{
dealer_code = user.DealerEmpl.DE_AD_OM_Code;
}
if (dealer_code > 0)
{
db.EnableAutoSelect = false;
o.summary = db.SingleOrDefault <dynamic>(
"exec [CT_GetCustomerSummary] @Dealer_code,@User_code,@IsEn"
, new { Dealer_code = dealer_code, User_code = AU_Code, IsEn = Interna }
);
}
#endregion
o.schedule = Get_Schedule((int)data.DP_UType, (int)AU_Code);
}
}
Response.Write(JsonConvert.SerializeObject(o));
}
/// <summary>
/// 保存经销商员工信息
/// </summary>
/// <param name="data"></param>
/// <param name="au_code"></param>
private void Save_Dealer_Emp(dynamic data, long au_code)
{
var s_personal = JsonConvert.SerializeObject(data.personal);
if (string.IsNullOrWhiteSpace(s_personal))
{
return;
}
CT_All_User empl = JsonConvert.DeserializeObject <CT_All_User>(s_personal);
CT_Dealer_Empl dealer_empl = JsonConvert.DeserializeObject <CT_Dealer_Empl>(s_personal);
dealer_empl.DE_AU_Code = au_code;
if (empl.AU_Active_tag == 1)
{
dealer_empl.DE_Activate_dt = DateTime.Now;
}
else
{
dealer_empl.DE_DActivate_dt = DateTime.Now;
}
if (!dealer_empl.DE_Ignore.Value)
{
dealer_empl.DE_Ignore = null;
}
dealer_empl.DE_Update_dt = DateTime.Now;
if (dealer_empl.DE_Code > 0)
{
dealer_empl.Update(new string[] {
//"DE_Type",
"DE_ID"
, "DE_Ignore"
, "DE_Picture_FN"
, "DE_Vacation_St"
, "DE_Vacation_En"
, "DE_Activate_dt"
, "DE_DActivate_dt"
, "DE_Update_dt"
});
}
else
{
if (!dealer_empl.DE_UType.HasValue)
{
dealer_empl.DE_UType = (byte)UserSession.User.UG_UType;
}
if (!dealer_empl.DE_AD_OM_Code.HasValue)
{
dealer_empl.DE_AD_OM_Code = UserSession.DealerEmpl.DE_AD_OM_Code;
}
//switch (dealer_empl.DE_UType)
//{
// case 1:
// dealer_empl.DE_AD_OM_Code = UserSession.Dealer.AD_Code;
// break;
// case 2:
// dealer_empl.DE_AD_OM_Code = UserSession.DealerGroup.DG_Code;
// break;
// case 3:
// dealer_empl.DE_AD_OM_Code = UserSession.OEM.OM_Code;
// break;
//}
dealer_empl.Insert();
}
if (dealer_empl.DE_Picture_FN != dealer_empl.DE_Picture_FN_Temp)
{
var path_save = Server.MapPath("~/images/Adviser/");
//添加或更换图片
if (!string.IsNullOrWhiteSpace(dealer_empl.DE_Picture_FN))
{
var path = System.Configuration.ConfigurationManager.AppSettings["PLUploadPath"];
if (string.IsNullOrWhiteSpace(path))
{
path = "~/plupload/";
}
path = Server.MapPath(path);
var path_temp = path + "employee_temp/";
if (!Directory.Exists(path_save))
{
Directory.CreateDirectory(path_save);
}
if (File.Exists(path_temp + dealer_empl.DE_Picture_FN))
{
File.Move(path_temp + dealer_empl.DE_Picture_FN, path_save + dealer_empl.DE_Picture_FN);
}
}
if (!string.IsNullOrWhiteSpace(dealer_empl.DE_Picture_FN_Temp))
{
//删除图片
var imgPath = path_save + dealer_empl.DE_Picture_FN_Temp;
if (File.Exists(imgPath))
{
File.Delete(imgPath);
}
}
}
}
private void Get_CustomerName(int AU_Code)
{
var au = CT_All_User.SingleOrDefault(AU_Code);
Response.Write(au.AU_Name);
}
/// <summary>
/// 获得员工信息
/// </summary>
/// <param name="data"></param>
private void Get_AsscInfo(dynamic data)
{
dynamic o = new ExpandoObject();
// int Empl_Code = (int)data.AU_Code;
// if (Empl_Code > 0)
// {
// var empl = CT_Dealer_Empl.SingleOrDefault(Empl_Code);
// empl.EX_DE_Activate_dt = empl.DE_Activate_dt.HasValue ? empl.DE_Activate_dt.Value.ToString(Interna ? "MM/dd/yyyy" : "yyyy-MM-dd") : "";
// o.dealerEmpl = empl;
var AU_Code = (int)data.AU_Code;
var MAU_Code = (int)data.MAU_Code;
if (AU_Code > 0)
{
#region personal
o.personal = CT_All_User.SingleOrDefault(@"select
AU_Code,
AU_Active_tag,
AU_Name,
AU_Username,
AU_Password,
AU_Dr_Lic,
AU_Gender,
AU_ID_Type,
AU_ID_No,
AU_Education,
AU_Married,
AU_Type,
AU_UG_Code,
AU_Occupation,
AU_Industry,
AU_B_date
from CT_All_Users
where AU_Code=@0", AU_Code);
#endregion
#region Categories
o.Categories = CT_Drivers_ListNew.SingleOrDefault(@"select distinct DL_Access as DL_Acc,DL_Relation as DL_Rel,DL_type,[dbo].[f_GetDL_CI_CodesByMAUCodeANDAU_Code](@1,@0) AS DL_CI_Codes from CT_Drivers_List
where DL_AU_Code=@0 and DL_M_AU_Code=@1", AU_Code, MAU_Code);
// o.Categories = new ExpandoObject();
var db = DBCRMTree.GetInstance();
// var sql = string.Format(@"select DL_Access,DL_Relation,DL_type, DL_CI_Code from CT_Drivers_List
// where DL_AU_Code=@0 and DL_M_AU_Code=@1");
// o.Categories = db.Query<dynamic>(sql, AU_Code, MAU_Code);
#endregion
#region contacts
o.contacts = new ExpandoObject();
var sql_text_part = Interna ? "[text_en]" : "[text_cn]";
var sql = string.Format(@"Select AL_Code,AL_Type,AL_Add1,AL_Add2,AL_District,AL_City
,AL_State,AL_Zip,AL_Pref as [pref]
,(select {0} from words where p_id = 55 and [value] = al_type) as AL_Type_Text
FROM CT_Address_List
WHERE AL_AU_AD_Code=@0 and isnull(AL_Active,1) = 1
", sql_text_part);
o.contacts.address = db.Query <dynamic>(sql, AU_Code);
sql = string.Format(@"Select PL_Code,PL_Type,PL_Number,PL_pref as [pref]
,(select {0} from words where p_id = 47 and [value] = pl_type) as PL_Type_Text
from CT_Phone_List
WHERE PL_AU_AD_Code=@0 and isnull(PL_Active,1) = 1
", sql_text_part);
o.contacts.phone = db.Query <dynamic>(sql, AU_Code);
sql = string.Format(@"Select EL_Code,EL_Type,EL_Address,EL_Pref as [pref]
,(select {0} from words where p_id = 44 and [value] = el_type) as EL_Type_Text
from CT_eMail_List
WHERE EL_AU_AD_Code=@0 and isnull(EL_Active,1) = 1
", sql_text_part);
o.contacts.email = db.Query <dynamic>(sql, AU_Code);
sql_text_part = Interna ? "[MC_Name_EN]" : "[MC_Name_CN]";
sql = string.Format(@"Select ML_Type as ML_MC_Code,ML_Code,ML_Handle,ML_Pref as [pref]
,ISNULL((SELECT {0} FROM [CT_Messaging_Carriers] where MC_Code=[ML_Type]),'') as ML_MC_Code_Text
from CT_Messaging_List
WHERE ML_AU_AD_Code=@0 and isnull(ML_Active,1) = 1
", sql_text_part);
o.contacts.messaging = db.Query <dynamic>(sql, AU_Code);
#endregion
}
// }
Response.Write(JsonConvert.SerializeObject(o));
}
