/// <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;
}
}
