/// <summary> /// 得到一个对象实体 /// </summary> public RuRo.Model.SurgeryInfo DataRowToModel(DataRow row) { RuRo.Model.SurgeryInfo model=new RuRo.Model.SurgeryInfo(); if (row != null) { if(row["id"]!=null && row["id"].ToString()!="") { model.id=int.Parse(row["id"].ToString()); } if(row["SurgeryRequestID"]!=null && row["SurgeryRequestID"].ToString()!="") { model.SurgeryRequestID=int.Parse(row["SurgeryRequestID"].ToString()); } if(row["ICDCode"]!=null) { model.ICDCode=row["ICDCode"].ToString(); } if(row["SurgeryName"]!=null) { model.SurgeryName=row["SurgeryName"].ToString(); } if(row["RequestExecutiveDateTime"]!=null && row["RequestExecutiveDateTime"].ToString()!="") { model.RequestExecutiveDateTime=DateTime.Parse(row["RequestExecutiveDateTime"].ToString()); } if(row["RequestDoctorEmployeeID"]!=null && row["RequestDoctorEmployeeID"].ToString()!="") { model.RequestDoctorEmployeeID=int.Parse(row["RequestDoctorEmployeeID"].ToString()); } } return model; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtid.Text)) { strErr+="id格式错误!\\n"; } if(!PageValidate.IsNumber(txtSurgeryRequestID.Text)) { strErr+="SurgeryRequestID格式错误!\\n"; } if(this.txtICDCode.Text.Trim().Length==0) { strErr+="ICDCode不能为空!\\n"; } if(this.txtSurgeryName.Text.Trim().Length==0) { strErr+="SurgeryName不能为空!\\n"; } if(!PageValidate.IsDateTime(txtRequestExecutiveDateTime.Text)) { strErr+="RequestExecutiveDateTime格式错误!\\n"; } if(!PageValidate.IsNumber(txtRequestDoctorEmployeeID.Text)) { strErr+="RequestDoctorEmployeeID格式错误!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int id=int.Parse(this.txtid.Text); int SurgeryRequestID=int.Parse(this.txtSurgeryRequestID.Text); string ICDCode=this.txtICDCode.Text; string SurgeryName=this.txtSurgeryName.Text; DateTime RequestExecutiveDateTime=DateTime.Parse(this.txtRequestExecutiveDateTime.Text); int RequestDoctorEmployeeID=int.Parse(this.txtRequestDoctorEmployeeID.Text); RuRo.Model.SurgeryInfo model=new RuRo.Model.SurgeryInfo(); model.id=id; model.SurgeryRequestID=SurgeryRequestID; model.ICDCode=ICDCode; model.SurgeryName=SurgeryName; model.RequestExecutiveDateTime=RequestExecutiveDateTime; model.RequestDoctorEmployeeID=RequestDoctorEmployeeID; RuRo.BLL.SurgeryInfo bll=new RuRo.BLL.SurgeryInfo(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public RuRo.Model.SurgeryInfo GetModel(int id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 id,SurgeryRequestID,ICDCode,SurgeryName,RequestExecutiveDateTime,RequestDoctorEmployeeID from SurgeryInfo "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4) }; parameters[0].Value = id; RuRo.Model.SurgeryInfo model=new RuRo.Model.SurgeryInfo(); DataSet ds=DbHelperSQL_SY.QuerySY(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }