private List <SqlParameter> Set_Values_In_ContactPersonMaster(ContactPersonInfo ContPerInfo) { List <SqlParameter> sqlParams = new List <SqlParameter>(); if (ContPerInfo.ContactPersonId != 0) { sqlParams.Add(new SqlParameter("@ContactPersonId", ContPerInfo.ContactPersonId)); } else { sqlParams.Add(new SqlParameter("@CreatedBy", ContPerInfo.CreatedBy)); } sqlParams.Add(new SqlParameter("@ObjectFor", ContPerInfo.ContactPersonFor)); sqlParams.Add(new SqlParameter("@FirstName", ContPerInfo.FirstName)); sqlParams.Add(new SqlParameter("@LastName", ContPerInfo.LastName)); sqlParams.Add(new SqlParameter("@MiddleName", ContPerInfo.MiddleName)); sqlParams.Add(new SqlParameter("@EmailId", ContPerInfo.EmailId)); sqlParams.Add(new SqlParameter("@IsDefault", ContPerInfo.IsDefault)); sqlParams.Add(new SqlParameter("@Active", ContPerInfo.Active)); sqlParams.Add(new SqlParameter("@UpdatedBy", ContPerInfo.UpdatedBy)); return(sqlParams); }
protected void btnUpdate_Click(object sender, EventArgs e) { CompanyUser modelUser = new CompanyUser(); modelUser = EyouSoft.BLL.CompanyStructure.CompanyUser.CreateInstance().GetModel(userid); if (modelUser != null) { string password = Utils.GetFormValue(txt_Password.UniqueID); if (!string.IsNullOrEmpty(password)) { modelUser.PassWordInfo.NoEncryptPassword = password; } modelUser.UserName = Utils.GetFormValue(txt_UserName.UniqueID); modelUser.MqNickName = Utils.GetFormValue(txt_MQNickname.UniqueID); modelUser.Job = Utils.GetFormValue(txt_Post.UniqueID); modelUser.DepartId = Utils.GetFormValue(dropDepartment.UniqueID); #region 个人会员联系信息 ContactPersonInfo ContactInfo = new ContactPersonInfo(); ContactInfo.ContactName = Utils.GetFormValue(txt_RealName.UniqueID); ContactInfo.ContactSex = (Sex)Enum.Parse(typeof(Sex), Utils.GetFormValue(dropSex.UniqueID)); ContactInfo.Email = Utils.GetFormValue(txt_Email.UniqueID); ContactInfo.Fax = Utils.GetFormValue(txt_Fax.UniqueID); ContactInfo.Mobile = Utils.GetFormValue(txt_Mobile.UniqueID); ContactInfo.MQ = Utils.GetFormValue(txt_MQ.UniqueID); ContactInfo.MSN = Utils.GetFormValue(txt_MSN.UniqueID); ContactInfo.QQ = Utils.GetFormValue(txt_QQ.UniqueID); ContactInfo.Tel = Utils.GetFormValue(txt_tel.UniqueID); #endregion #region 线路区域 List <AreaBase> listArea = new List <AreaBase>(); foreach (string AreaId in Utils.GetFormValues("chbArea")) { AreaBase modelAreaBase = new AreaBase(); if (!string.IsNullOrEmpty(AreaId)) { modelAreaBase.AreaId = Utils.GetInt(AreaId); listArea.Add(modelAreaBase); } modelAreaBase = null; } modelUser.Area = listArea; modelUser.RoleID = dropPermissions.SelectedValue; #endregion modelUser.ContactInfo = ContactInfo; if (EyouSoft.BLL.CompanyStructure.CompanyUser.CreateInstance().UpdateChild(modelUser)) { MessageBox.ShowAndRedirect(Page, "修改成功", "PersonalMemberList.aspx"); } else { MessageBox.Show(Page, "修改失败"); } } }
public ContactPersonInfo Get_ContactPersonMaster_By_Id(int ContactPersonMasterId) { List <SqlParameter> sqlParams = new List <SqlParameter>(); ContactPersonInfo ContPerInfo = new ContactPersonInfo(); sqlParams.Add(new SqlParameter("@ContactPersonId", ContactPersonMasterId)); DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedureEnum.sp_Get_ContactPersonMaster_By_Id.ToString(), CommandType.StoredProcedure); List <DataRow> drList = new List <DataRow>(); drList = dt.AsEnumerable().ToList(); foreach (DataRow dr in drList) { ContPerInfo = Get_ContactPersonMaster_Values(dr); } return(ContPerInfo); }
public DataTable Get_ContactPersonMaster_By_Type_For_Id(ContactPersonInfo ContactPersonMasterInfo, ref PaginationInfo pager) { List <SqlParameter> sqlParams = new List <SqlParameter>(); ContactPersonInfo ContPerInfo = new ContactPersonInfo(); //sqlParams.Add(new SqlParameter("@ContactType", ContactPersonMasterInfo.ContactType)); sqlParams.Add(new SqlParameter("@ObjectFor", ContactPersonMasterInfo.ContactPersonFor)); sqlParams.Add(new SqlParameter("@ObjectId", ContactPersonMasterInfo.ObjectId)); DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedureEnum.sp_Get_ContactPersMast_By_Type_For_ObjectId.ToString(), CommandType.StoredProcedure); //List<DataRow> drList = new List<DataRow>(); //drList = dt.AsEnumerable().ToList(); //foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager)) //{ // ContPerInfo = Get_ContactPersonMaster_Values(dr); //} return(dt); }
private ContactPersonInfo Get_ContactPersonMaster_Values(DataRow dr) { ContactPersonInfo ContPerInfo = new ContactPersonInfo(); ContPerInfo.ContactPersonId = Convert.ToInt32(dr["ContactPersonId"]); ContPerInfo.ContactPersonFor = Convert.ToString(dr["ObjectFor"]); ContPerInfo.ObjectId = Convert.ToInt32(dr["ObjectId"]); ContPerInfo.FirstName = Convert.ToString(dr["FirstName"]); ContPerInfo.MiddleName = Convert.ToString(dr["MiddleName"]); ContPerInfo.LastName = Convert.ToString(dr["LastName"]); ContPerInfo.EmailId = Convert.ToString(dr["EmailId"]); ContPerInfo.IsDefault = Convert.ToBoolean(dr["IsDefault"]); ContPerInfo.Active = Convert.ToBoolean(dr["Active"]); ContPerInfo.CreatedBy = Convert.ToInt32(dr["CreatedBy"]); ContPerInfo.CreatedDate = Convert.ToDateTime(dr["CreatedOn"]); ContPerInfo.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]); ContPerInfo.UpdatedDate = Convert.ToDateTime(dr["UpdatedOn"]); return(ContPerInfo); }
public void Update_ContactPersonMaster(ContactPersonInfo ContPerInfo) { _sqlRepo.ExecuteNonQuery(Set_Values_In_ContactPersonMaster(ContPerInfo), StoredProcedureEnum.sp_Update_ContactPersonMaster.ToString(), CommandType.StoredProcedure); }
public Int32 Insert_ContactPersonMaster(ContactPersonInfo ContPerInfo) { return(Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_ContactPersonMaster(ContPerInfo), StoredProcedureEnum.sp_Insert_ContactPersonMaster.ToString(), CommandType.StoredProcedure))); }
public DataTable Get_Contact_By_Type_For(ContactPersonInfo AddInfo, ref PaginationInfo pager) { return(_ContactPersonRepo.Get_ContactPersonMaster_By_Type_For_Id(AddInfo, ref pager)); }
public void Update_ContactPerson(ContactPersonInfo AddInfo) { _ContactPersonRepo.Update_ContactPersonMaster(AddInfo); }
public Int32 Insert_ContactPerson(ContactPersonInfo AddInfo) { return(_ContactPersonRepo.Insert_ContactPersonMaster(AddInfo)); }
public ContactPersonViewModel() { ContactPersonDetails = new ContactPersonInfo(); ContactPersonDetailslist = new List <ContactPersonInfo>(); }