/// <summary> /// 得到一个对象实体 /// </summary> public la.Model.user_tb DataRowToModel(DataRow row) { la.Model.user_tb model=new la.Model.user_tb(); if (row != null) { if(row["user_telphone"]!=null) { model.user_telphone=row["user_telphone"].ToString(); } if(row["user_sex"]!=null && row["user_sex"].ToString()!="") { if((row["user_sex"].ToString()=="1")||(row["user_sex"].ToString().ToLower()=="true")) { model.user_sex=true; } else { model.user_sex=false; } } if(row["user_nikeName"]!=null) { model.user_nikeName=row["user_nikeName"].ToString(); } if(row["user_photo"]!=null) { model.user_photo=row["user_photo"].ToString(); } if(row["user_birthday"]!=null && row["user_birthday"].ToString()!="") { model.user_birthday=DateTime.Parse(row["user_birthday"].ToString()); } if(row["user_height"]!=null) { model.user_height=row["user_height"].ToString(); } if(row["user_weight"]!=null) { model.user_weight=row["user_weight"].ToString(); } if(row["user_address"]!=null) { model.user_address=row["user_address"].ToString(); } if(row["user_job"]!=null) { model.user_job=row["user_job"].ToString(); } if(row["user_income"]!=null) { model.user_income=row["user_income"].ToString(); } if(row["user_pwd"]!=null) { model.user_pwd=row["user_pwd"].ToString(); } if(row["user_marrystate"]!=null) { model.user_marrystate=row["user_marrystate"].ToString(); } if(row["user_edu"]!=null) { model.user_edu=row["user_edu"].ToString(); } if(row["personcenter_bg"]!=null) { model.personcenter_bg=row["personcenter_bg"].ToString(); } if(row["user_photo_state"]!=null) { model.user_photo_state=row["user_photo_state"].ToString(); } if(row["user_state"]!=null) { model.user_state=row["user_state"].ToString(); } } return model; }
public void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtuser_nikeName.Text.Trim().Length==0) { strErr+="用户昵称不能为空!\\n"; } if(this.txtuser_photo.Text.Trim().Length==0) { strErr+="用户头像不能为空!\\n"; } if(!PageValidate.IsDateTime(txtuser_birthday.Text)) { strErr+="出生年月格式错误!\\n"; } if(this.txtuser_height.Text.Trim().Length==0) { strErr+="身高不能为空!\\n"; } if(this.txtuser_weight.Text.Trim().Length==0) { strErr+="体重不能为空!\\n"; } if(this.txtuser_address.Text.Trim().Length==0) { strErr+="常住地不能为空!\\n"; } if(this.txtuser_job.Text.Trim().Length==0) { strErr+="职业不能为空!\\n"; } if(this.txtuser_income.Text.Trim().Length==0) { strErr+="年收入不能为空!\\n"; } if(this.txtuser_pwd.Text.Trim().Length==0) { strErr+="用户密码不能为空!\\n"; } if(this.txtuser_marrystate.Text.Trim().Length==0) { strErr+="感情状况不能为空!\\n"; } if(this.txtuser_edu.Text.Trim().Length==0) { strErr+="学历不能为空!\\n"; } if(this.txtpersoncenter_bg.Text.Trim().Length==0) { strErr+="个人中心背景不能为空!\\n"; } if(this.txtuser_photo_state.Text.Trim().Length==0) { strErr+="头像审核状态不能为空!\\n"; } if(this.txtuser_state.Text.Trim().Length==0) { strErr+="用户状态不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string user_telphone=this.lbluser_telphone.Text; bool user_sex=this.chkuser_sex.Checked; string user_nikeName=this.txtuser_nikeName.Text; string user_photo=this.txtuser_photo.Text; DateTime user_birthday=DateTime.Parse(this.txtuser_birthday.Text); string user_height=this.txtuser_height.Text; string user_weight=this.txtuser_weight.Text; string user_address=this.txtuser_address.Text; string user_job=this.txtuser_job.Text; string user_income=this.txtuser_income.Text; string user_pwd=this.txtuser_pwd.Text; string user_marrystate=this.txtuser_marrystate.Text; string user_edu=this.txtuser_edu.Text; string personcenter_bg=this.txtpersoncenter_bg.Text; string user_photo_state=this.txtuser_photo_state.Text; string user_state=this.txtuser_state.Text; la.Model.user_tb model=new la.Model.user_tb(); model.user_telphone=user_telphone; model.user_sex=user_sex; model.user_nikeName=user_nikeName; model.user_photo=user_photo; model.user_birthday=user_birthday; model.user_height=user_height; model.user_weight=user_weight; model.user_address=user_address; model.user_job=user_job; model.user_income=user_income; model.user_pwd=user_pwd; model.user_marrystate=user_marrystate; model.user_edu=user_edu; model.personcenter_bg=personcenter_bg; model.user_photo_state=user_photo_state; model.user_state=user_state; la.BLL.user_tb bll=new la.BLL.user_tb(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public la.Model.user_tb GetModel(string user_telphone) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 user_telphone,user_sex,user_nikeName,user_photo,user_birthday,user_height,user_weight,user_address,user_job,user_income,user_pwd,user_marrystate,user_edu,personcenter_bg,user_photo_state,user_state from user_tb "); strSql.Append(" where user_telphone=@user_telphone "); SqlParameter[] parameters = { new SqlParameter("@user_telphone", SqlDbType.VarChar,20) }; parameters[0].Value = user_telphone; la.Model.user_tb model=new la.Model.user_tb(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }