/// <summary> /// 得到一个对象实体 /// </summary> public ShowShop.Model.Member.MemberInfo GetModel(int UID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UID,PrivacySettings,TrueName,Title,Photo,Birthday,PapersType,PapersNumber,Origin,Nation,Sex,Marriage,Education,GraduateSchool,Province,City,Borough,Address,Zip,OfficePhone,HomePhone,MobilePhone,HandPhone,Fax,PersonWebSite,QQ,MSN,ICQ,UC,LifeHobbies,CultureHobbies,Entertainment,SportsHobbies,OtherHobbies,IncName,Department,Positions,WorkRange,IncAddress,MonthlyInCome from yxs_memberinfo "); strSql.Append(" where UID=@UID "); SqlParameter[] parameters = { new SqlParameter("@UID", SqlDbType.Int,4)}; parameters[0].Value = UID; ShowShop.Model.Member.MemberInfo model = new ShowShop.Model.Member.MemberInfo(); DataSet ds = ChangeHope.DataBase.SQLServerHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["UID"].ToString() != "") { model.UID = int.Parse(ds.Tables[0].Rows[0]["UID"].ToString()); } if (ds.Tables[0].Rows[0]["PrivacySettings"].ToString() != "") { model.PrivacySettings = int.Parse(ds.Tables[0].Rows[0]["PrivacySettings"].ToString()); } model.TrueName = ds.Tables[0].Rows[0]["TrueName"].ToString(); model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); model.Photo = ds.Tables[0].Rows[0]["Photo"].ToString(); if (ds.Tables[0].Rows[0]["Birthday"].ToString() != "") { model.Birthday = DateTime.Parse(ds.Tables[0].Rows[0]["Birthday"].ToString()); } model.PapersType = ds.Tables[0].Rows[0]["PapersType"].ToString(); model.PapersNumber = ds.Tables[0].Rows[0]["PapersNumber"].ToString(); model.Origin = ds.Tables[0].Rows[0]["Origin"].ToString(); model.Nation = ds.Tables[0].Rows[0]["Nation"].ToString(); if (ds.Tables[0].Rows[0]["Sex"].ToString() != "") { model.Sex = int.Parse(ds.Tables[0].Rows[0]["Sex"].ToString()); } if (ds.Tables[0].Rows[0]["Marriage"].ToString() != "") { model.Marriage = int.Parse(ds.Tables[0].Rows[0]["Marriage"].ToString()); } model.Education = ds.Tables[0].Rows[0]["Education"].ToString(); model.GraduateSchool = ds.Tables[0].Rows[0]["GraduateSchool"].ToString(); model.Province = ds.Tables[0].Rows[0]["Province"].ToString(); model.City = ds.Tables[0].Rows[0]["City"].ToString(); model.Borough = ds.Tables[0].Rows[0]["Borough"].ToString(); model.Address = ds.Tables[0].Rows[0]["Address"].ToString(); model.Zip = ds.Tables[0].Rows[0]["Zip"].ToString(); model.OfficePhone = ds.Tables[0].Rows[0]["OfficePhone"].ToString(); model.HomePhone = ds.Tables[0].Rows[0]["HomePhone"].ToString(); model.MobilePhone = ds.Tables[0].Rows[0]["MobilePhone"].ToString(); model.HandPhone = ds.Tables[0].Rows[0]["HandPhone"].ToString(); model.Fax = ds.Tables[0].Rows[0]["Fax"].ToString(); model.PersonWebSite = ds.Tables[0].Rows[0]["PersonWebSite"].ToString(); model.QQ = ds.Tables[0].Rows[0]["QQ"].ToString(); model.MSN = ds.Tables[0].Rows[0]["MSN"].ToString(); model.ICQ = ds.Tables[0].Rows[0]["ICQ"].ToString(); model.UC = ds.Tables[0].Rows[0]["UC"].ToString(); model.LifeHobbies = ds.Tables[0].Rows[0]["LifeHobbies"].ToString(); model.CultureHobbies = ds.Tables[0].Rows[0]["CultureHobbies"].ToString(); model.Entertainment = ds.Tables[0].Rows[0]["Entertainment"].ToString(); model.SportsHobbies = ds.Tables[0].Rows[0]["SportsHobbies"].ToString(); model.OtherHobbies = ds.Tables[0].Rows[0]["OtherHobbies"].ToString(); model.IncName = ds.Tables[0].Rows[0]["IncName"].ToString(); model.Department = ds.Tables[0].Rows[0]["Department"].ToString(); model.Positions = ds.Tables[0].Rows[0]["Positions"].ToString(); model.WorkRange = ds.Tables[0].Rows[0]["WorkRange"].ToString(); model.IncAddress = ds.Tables[0].Rows[0]["IncAddress"].ToString(); model.MonthlyInCome = ds.Tables[0].Rows[0]["MonthlyInCome"].ToString(); return model; } else { return null; } }
private void SaveInfo() { ShowShop.BLL.Member.MemberAccount abll = new ShowShop.BLL.Member.MemberAccount(); ShowShop.BLL.Member.MemberInfo bll = new ShowShop.BLL.Member.MemberInfo(); Model.Member.MemberInfo model = new ShowShop.Model.Member.MemberInfo(); try { model.PrivacySettings = ckbPrivacySettings.Checked?1:0; model.TrueName = txtTrueName.Text; model.Title = txtTitle.Text; model.Photo = "";//txtPhoto.Text; model.Birthday = ChangeHope.Common.StringHelper.StringToDateTime(txtBirthday.Text); model.PapersType = ddlPapersType.SelectedValue; model.PapersNumber = txtPapersNumber.Text; model.Origin = txtOrigin.Text; model.Nation = txtNation.Text; model.Sex = ChangeHope.Common.StringHelper.StringToInt(ddlSex.SelectedValue); model.Marriage = ChangeHope.Common.StringHelper.StringToInt(ddlMarriage.SelectedValue); model.Education = ddlEducation.SelectedValue; model.GraduateSchool = txtGraduateSchool.Text; model.Province = ChangeHope.WebPage.PageRequest.GetFormString("ctl00$workspace$ddlProvince"); model.City = ChangeHope.WebPage.PageRequest.GetFormString("ctl00$workspace$ddlCity"); model.Borough = ChangeHope.WebPage.PageRequest.GetFormString("ctl00$workspace$ddlBorough"); model.Address = txtAddress.Text; /*kevin 12.12 修改*/ if (txtZip.Text != "") { if (!ChangeHope.Common.ValidateHelper.IsSend(txtZip.Text.Trim())) { this.ltlMsg.Text = "请输入正确的邮政编码"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } if (txtOfficePhone.Text != "") { if (!ChangeHope.Common.ValidateHelper.IsPhone(txtOfficePhone.Text)) { this.ltlMsg.Text = "请输入正确的电话号码"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } if (txtMobilePhone.Text != "") { if (!ChangeHope.Common.ValidateHelper.IsMobilePhone(txtMobilePhone.Text)) { this.ltlMsg.Text = "请输入正确的手机号码"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } if (txtHomePhone.Text != "") { if (!ChangeHope.Common.ValidateHelper.IsPhone(txtHomePhone.Text)) { this.ltlMsg.Text = "请输入正确的住宅电话号码"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } if (txtHandPhone.Text != "") { if (!ChangeHope.Common.ValidateHelper.IsPhone(txtHandPhone.Text)) { this.ltlMsg.Text = "请输入正确的小灵通号码"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } if (txtFax.Text != "") { if (!ChangeHope.Common.ValidateHelper.IsPhone(txtFax.Text)) { this.ltlMsg.Text = "请输入正确的传真号码"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } if (txtQQ.Text != "") { if (!ChangeHope.Common.ValidateHelper.IsNumber(txtQQ.Text) || txtQQ.Text.Length < 5 || txtQQ.Text.Length > 13) { this.ltlMsg.Text = "请输入正确的QQ号码"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } if (txtUC.Text != "") { if (!ChangeHope.Common.ValidateHelper.IsNumber(txtUC.Text) || txtUC.Text.Length < 5 || txtUC.Text.Length > 13) { this.ltlMsg.Text = "请输入正确的UC号码"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } model.Zip = txtZip.Text; model.OfficePhone = txtOfficePhone.Text; model.HomePhone = txtHomePhone.Text; model.MobilePhone = txtMobilePhone.Text; model.HandPhone = txtHandPhone.Text; model.Fax = txtFax.Text; model.PersonWebSite = txtPersonWebSite.Text; model.QQ = txtQQ.Text; model.MSN = txtMSN.Text; model.ICQ = txtICQ.Text; model.UC = txtUC.Text; model.LifeHobbies = txtLifeHobbies.Text; model.CultureHobbies = txtCultureHobbies.Text; model.Entertainment = txtEntertainment.Text; model.SportsHobbies = txtSportsHobbies.Text; model.OtherHobbies = txtOtherHobbies.Text; model.IncName = txtIncName.Text; model.Department = txtDepartment.Text; model.Positions = txtPositions.Text; model.WorkRange = txtWorkRange.Text; model.IncAddress = txtIncAddress.Text; model.MonthlyInCome = txtMonthlyInCome.Text; if (bll.Exists(Convert.ToInt32(ViewState["uid"].ToString())) && ViewState["uid"] != null) { model.UID = Convert.ToInt32(ViewState["uid"].ToString()); bll.Update(model); } else { model.UID = GetIdByUserId(this.txtUserId.Text.Trim()); bll.Add(model); } this.ltlMsg.Text = "编辑信息成功"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; } catch { } finally { model = null; bll = null; } }