public void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtAreaID.Text)) { strErr+="AreaID格式错误!\\n"; } if(this.txtAreaName.Text.Trim().Length==0) { strErr+="AreaName不能为空!\\n"; } if(!PageValidate.IsNumber(txtSort.Text)) { strErr+="Sort格式错误!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int AreaID=int.Parse(this.txtAreaID.Text); string AreaName=this.txtAreaName.Text; int Sort=int.Parse(this.txtSort.Text); Maticsoft.Model.A_Area model=new Maticsoft.Model.A_Area(); model.AreaID=AreaID; model.AreaName=AreaName; model.Sort=Sort; Maticsoft.BLL.A_Area bll=new Maticsoft.BLL.A_Area(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.A_Area DataRowToModel(DataRow row) { Maticsoft.Model.A_Area model=new Maticsoft.Model.A_Area(); if (row != null) { if(row["AreaID"]!=null && row["AreaID"].ToString()!="") { model.AreaID=int.Parse(row["AreaID"].ToString()); } if(row["AreaName"]!=null) { model.AreaName=row["AreaName"].ToString(); } if(row["Sort"]!=null && row["Sort"].ToString()!="") { model.Sort=int.Parse(row["Sort"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.A_Area GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 AreaID,AreaName,Sort from A_Area "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.A_Area model=new Maticsoft.Model.A_Area(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }