/// <summary> /// 得到一个对象实体 /// </summary> public RuRo.Model.FP_Users DataRowToModel(DataRow row) { RuRo.Model.FP_Users model=new RuRo.Model.FP_Users(); if (row != null) { if(row["userID"]!=null && row["userID"].ToString()!="") { model.userID=int.Parse(row["userID"].ToString()); } if(row["id"]!=null && row["id"].ToString()!="") { model.id=int.Parse(row["id"].ToString()); } if(row["obj_id"]!=null && row["obj_id"].ToString()!="") { model.obj_id=int.Parse(row["obj_id"].ToString()); } if(row["username"]!=null) { model.username=row["username"].ToString(); } if(row["fullname"]!=null) { model.fullname=row["fullname"].ToString(); } if(row["email"]!=null) { model.email=row["email"].ToString(); } if(row["created_at"]!=null) { model.created_at=row["created_at"].ToString(); } if(row["disabled"]!=null) { model.disabled=row["disabled"].ToString(); } if(row["active"]!=null) { model.active=row["active"].ToString(); } if(row["role"]!=null) { model.role=row["role"].ToString(); } if(row["samples"]!=null) { model.samples=row["samples"].ToString(); } } return model; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtuserID.Text)) { strErr+="userID格式错误!\\n"; } if(!PageValidate.IsNumber(txtid.Text)) { strErr+="id格式错误!\\n"; } if(!PageValidate.IsNumber(txtobj_id.Text)) { strErr+="obj_id格式错误!\\n"; } if(this.txtusername.Text.Trim().Length==0) { strErr+="username不能为空!\\n"; } if(this.txtfullname.Text.Trim().Length==0) { strErr+="fullname不能为空!\\n"; } if(this.txtemail.Text.Trim().Length==0) { strErr+="email不能为空!\\n"; } if(this.txtcreated_at.Text.Trim().Length==0) { strErr+="created_at不能为空!\\n"; } if(this.txtdisabled.Text.Trim().Length==0) { strErr+="disabled不能为空!\\n"; } if(this.txtactive.Text.Trim().Length==0) { strErr+="active不能为空!\\n"; } if(this.txtrole.Text.Trim().Length==0) { strErr+="role不能为空!\\n"; } if(this.txtsamples.Text.Trim().Length==0) { strErr+="samples不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int userID=int.Parse(this.txtuserID.Text); int id=int.Parse(this.txtid.Text); int obj_id=int.Parse(this.txtobj_id.Text); string username=this.txtusername.Text; string fullname=this.txtfullname.Text; string email=this.txtemail.Text; string created_at=this.txtcreated_at.Text; string disabled=this.txtdisabled.Text; string active=this.txtactive.Text; string role=this.txtrole.Text; string samples=this.txtsamples.Text; RuRo.Model.FP_Users model=new RuRo.Model.FP_Users(); model.userID=userID; model.id=id; model.obj_id=obj_id; model.username=username; model.fullname=fullname; model.email=email; model.created_at=created_at; model.disabled=disabled; model.active=active; model.role=role; model.samples=samples; RuRo.BLL.FP_Users bll=new RuRo.BLL.FP_Users(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public RuRo.Model.FP_Users GetModel(int userID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 userID,id,obj_id,username,fullname,email,created_at,disabled,active,role,samples from FP_Users "); strSql.Append(" where userID=@userID "); SqlParameter[] parameters = { new SqlParameter("@userID", SqlDbType.Int,4) }; parameters[0].Value = userID; RuRo.Model.FP_Users model=new RuRo.Model.FP_Users(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }