/// <summary> /// 获取登陆用户的员工信息 /// </summary> /// <param name="DE_AU_Code"></param> /// <returns></returns> public CT_Dealer_Empl getEmpl(long DE_AU_Code) { string strSql = string.Format("select * from CT_Dealer_Empl with(nolock) where DE_AU_Code={0};", DE_AU_Code); CT_Dealer_Empl Empl = DataHelper.ConvertToObject <CT_Dealer_Empl>(strSql); return(Empl); }
public string GetAdviserName(string DE_Code) { CT_Dealer_Empl _de = GetAdviser(DE_Code); if (_de == null) { return(""); } return(_de.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); } } } }