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