public static ZhuyuanModel GetZhuyuanInfoById(int t_zhuyuan_id)
{
string sqlString = "select * from [t_zhuyuan] where t_zhuyuan_id=" + t_zhuyuan_id;
DataBase db = new DataBase();
DataSet ds = db.GetDataSet(sqlString);
ZhuyuanModel zhuyuanModel = null;
if (ds.Tables[0].Rows.Count > 0)
{
zhuyuanModel = new ZhuyuanModel();
DataRow dr = ds.Tables[0].Rows[0];
zhuyuanModel.setT_zhuyuan_id(t_zhuyuan_id);
zhuyuanModel.setName(dr["name"].ToString());
zhuyuanModel.setSex(dr["sex"].ToString());
zhuyuanModel.setAge(Convert.ToInt32(dr["age"]));
zhuyuanModel.setRoomNo(dr["roomNo"].ToString());
zhuyuanModel.setArriveTime(Convert.ToDateTime(dr["arriveTime"]));
zhuyuanModel.setIsLeave(Convert.ToInt32(dr["isLeave"]));
zhuyuanModel.setLeaveTime(Convert.ToDateTime(dr["leaveTime"]));
zhuyuanModel.setMoney(Convert.ToSingle(dr["money"]));
zhuyuanModel.setCheckinOperator(dr["checkinOperator"].ToString());
zhuyuanModel.setCheckoutOperator(dr["checkoutOperator"].ToString());
}
return(zhuyuanModel);
}
public void InitView()
{
int t_zhuyuan_id = Int32.Parse(Request.QueryString["t_zhuyuan_id"]);
ZhuyuanModel zhuyuanModel = ZhuyuanLogic.GetZhuyuanInfoById(t_zhuyuan_id);
this.Name.Text = zhuyuanModel.getName();
this.Sex.Text = zhuyuanModel.getSex();
this.Age.Text = zhuyuanModel.getAge().ToString();
this.RoomNo.Text = zhuyuanModel.getRoomNo();
this.ArriveTime.Text = zhuyuanModel.getArriveTime().ToString();
}
protected void Btn_GuaHao_Click(object sender, EventArgs e)
{
string name = this.Name.Text;
string sex = this.Sex.SelectedValue;
int age = Int32.Parse(this.Age.Text);
string roomNo = this.RoomNo.Text;
ZhuyuanModel zhuyuanModel = new ZhuyuanModel();
zhuyuanModel.setName(name);
zhuyuanModel.setSex(sex);
zhuyuanModel.setAge(age);
zhuyuanModel.setRoomNo(roomNo);
zhuyuanModel.setCheckinOperator(Session["username"].ToString());
ZhuyuanLogic zhuyuanLogic = new ZhuyuanLogic();
if (zhuyuanLogic.AddZhuyuanInfo(zhuyuanModel))
{
Response.Write("<script>alert('病人住院信息登记成功！');location.href='PatientSignIn.aspx';</script>");
}
}
public bool AddZhuyuanInfo(ZhuyuanModel zhuyuanModel)
{
string sqlString = "insert into [t_zhuyuan] (name,sex,age,roomNo,arriveTime,isLeave,leaveTime,money,checkinOperator,checkoutOperator) values (";
sqlString += SqlString.GetQuotedString(zhuyuanModel.getName()) + ",";
sqlString += SqlString.GetQuotedString(zhuyuanModel.getSex()) + ",";
sqlString += zhuyuanModel.getAge() + ",";
sqlString += SqlString.GetQuotedString(zhuyuanModel.getRoomNo()) + ",";
sqlString += "'" + zhuyuanModel.getArriveTime() + "',";
sqlString += zhuyuanModel.getIsLeave() + ",";
sqlString += "'" + zhuyuanModel.getLeaveTime() + "',";
sqlString += zhuyuanModel.getMoney() + ",";
sqlString += SqlString.GetQuotedString(zhuyuanModel.getCheckinOperator()) + ",";
sqlString += SqlString.GetQuotedString(zhuyuanModel.getCheckoutOperator()) + ")";
DataBase db = new DataBase();
if (db.InsertOrUpdate(sqlString) < 0)
{
this.errMessage = "登记病人住院信息发生了错误！";
return(false);
}
return(true);
}
