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