protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { HospitalModel hm = new HospitalModel(); SqlDataReader sdr = hm.findHospitalAll(); if (sdr != null) { while (sdr.Read()) { this.hospitalSelect.Items.Add(new ListItem(sdr["Hname"].ToString(), sdr["ID"].ToString())); } } } if (Request.QueryString["id"] != null) { int id = Convert.ToInt16(Request.QueryString["id"]); idnum.Value = Request.QueryString["id"].ToString(); ReviewAddInfo rm = new ReviewAddInfo(); DataTable dt = rm.getAuditInfo(id); AuditTime.Value = dt.Rows[0]["AuT"].ToString(); hospitalSelect.Value = dt.Rows[0]["hospitalid"].ToString(); pspnum.Value = dt.Rows[0]["pspnum"].ToString(); } }
public static string updateRecipeInfo(int id, string AuditTime, string hospitalSelect, string pspnum) { ReviewAddInfo binfo = new ReviewAddInfo(); int result = binfo.updateAuditInfo(id, AuditTime, Convert.ToInt32(hospitalSelect), pspnum); string str = null; if (result == 0) { str = "0"; } else { str = "1"; } return(str); }
public static string addReviewinfo(String DecoctingNum, string ReviewPer) { string result = ""; ReviewAddInfo rinfo = new ReviewAddInfo(); string str1 = DecoctingNum.Substring(4, 10); string str2 = str1.TrimStart('0'); int sdr = rinfo.AddAudit(Convert.ToInt32(str2), ReviewPer); if (sdr == 0) { result = "0"; } else { result = "1"; } return(result); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ReviewAddInfo rinfo = new ReviewAddInfo(); SqlDataReader sdr = rinfo.findNameAll(); if (sdr != null) { while (sdr.Read()) { this.ReviewPer.Items.Add(new ListItem(sdr["EmNumAName"].ToString())); // this.SwapPer.Items.Add(new ListItem(sdr["JobNum"].ToString())); } } DataBaseLayer db = new DataBaseLayer(); if (Session["userNamebar"] != null) { string name = Session["userNamebar"].ToString(); string sq1 = "select EmNumAName from Employee where jobnum ='" + name + "' "; SqlDataReader sr = db.get_Reader(sq1); if (sr.Read()) { ReviewPer.Value = sr["EmNumAName"].ToString(); } } else { Response.Write("<script>alert('用户名已失效');window.parent.loginview();</script>"); } } }
public static bool deleteReviewqueryById(string strRowIds) { int a = 0; bool result; string[] strRows1Id = strRowIds.Split(','); for (int i = 0; i < strRows1Id.Length; i++) { ReviewAddInfo rinfo = new ReviewAddInfo(); a = rinfo.deleteRRecipeInfo(Convert.ToInt32(strRows1Id[i])); } if (a == 0) { result = false; } else { result = true; } return(result); }