Пример #1
0
        /// <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;
            }
        }
Пример #2
0
 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;
     }
 }