/// <summary> /// 开始煎药 插入命令表 /// </summary> /// <param name="now">开始煎药时间</param> /// <param name="db">db层</param> /// <param name="bmNum">煎药单号</param> public static void Insert_TisaneCmd(DateTime now, DataBaseLayer db, string bmNum) { //开始煎药指令 string sql12 = "select macaddress from machine where id = (select machineid from tisaneunit where pid ='" + bmNum + "')"; SqlDataReader sr12 = db.get_Reader(sql12); string mac = ""; if (sr12.Read()) { mac = sr12["macaddress"].ToString(); } string sql10 = "select * from prescription where id = '" + bmNum + "'"; SqlDataReader sr10 = db.get_Reader(sql10); string content = ""; if (sr10.Read()) { content = (Convert.ToInt32(sr10["dose"].ToString()) * Convert.ToInt32(sr10["takenum"].ToString())).ToString().PadLeft(2, '0') + sr10["decscheme"].ToString().PadLeft(2, '0') + bmNum.PadLeft(10, '0') + sr10["oncetime"].ToString().PadLeft(2, '0') + sr10["twicetime"].ToString().PadLeft(2, '0'); } string sql11 = "insert into cmdtable(cmd,bmip,time) values('" + content + "','" + mac + "','" + now + "');"; db.cmd_Execute(sql11); }
/// <summary> /// 开始包装 插入命令表 /// </summary> /// <param name="now">时间</param> /// <param name="db">DB层</param> /// <param name="bmNum">煎药单号</param> public static void Insert_PackCmd(DateTime now, DataBaseLayer db, string bmNum) { //开始包装指令 string strtime = now.ToString("yyyy-MM-dd HH:mm:ss");// string sql12 = "select macaddress from machine where id = (select machineid from tisaneunit where pid ='" + bmNum + "')"; SqlDataReader sr12 = db.get_Reader(sql12); string mac = ""; if (sr12.Read()) { mac = sr12["macaddress"].ToString(); } string sql10 = "select *, RIGHT(CAST('000000000' + RTRIM(id) AS varchar(20)), 10) as bNum from prescription where id = '" + bmNum + "'"; SqlDataReader sr10 = db.get_Reader(sql10); // var strzero = "0000000000"; // string tid = strzero.substring(0, 10 - Convert.ToInt32(DecoctingNum).length) + DecoctingNum; // String str = String.format("%04d", youNumber); string content = ""; if (sr10.Read()) { content = (Convert.ToInt32(sr10["dose"].ToString()) * Convert.ToInt32(sr10["takenum"].ToString())).ToString().PadLeft(2, '0') + bmNum.PadLeft(10, '0') + sr10["packagenum"].ToString().PadLeft(4, '0'); } string sql11 = "insert into cmdtable(cmd,bmip,time) values('" + content + "','" + mac + "','" + strtime + "');"; db.cmd_Execute(sql11); }
public bool AddDrug_1(DrugInfo dinfo) { DataBaseLayer db = new DataBaseLayer(); int n = 0; //string stateSql = "select prescriptionId from PrescriptionCheckState where checkStatus = 1 and prescriptionId = (select id from prescription as p where p.Pspnum = '" + dinfo.strPspnum + "' and p.hospitalid = '" + dinfo.nHospitalNum + "')"; string stateSql = "select prescriptionId from PrescriptionCheckState where checkStatus = 0 and prescriptionId in(select id from prescription as p where p.Pspnum = '" + dinfo.strPspnum + "' and p.hospitalid = '" + dinfo.nHospitalNum + "')"; db.write_log_txt("insert drug_2:" + stateSql); SqlDataReader srd = db.get_Reader(stateSql); //string q = srd["Pspnum"].ToString(); // if (srd.Read()) // { // n = 0; // } // else // { string stateSql1 = "select id from prescription as p where p.Pspnum = '" + dinfo.strPspnum + "' and p.hospitalid = '" + dinfo.nHospitalNum + "'"; SqlDataReader srd1 = db.get_Reader(stateSql1); string pid = ""; if (srd1.Read()) { pid = srd1["id"].ToString(); } string str = "select * from drug where pid='" + pid + "' and drugnum ='" + dinfo.strDrugNum + "' and drugname ='" + dinfo.strDrugName + "'"; SqlDataReader srd4 = db.get_Reader(str); if (srd4.Read()) { n = -1; } else { string strSql = "insert into drug(customid,Hospitalid,Pspnum,drugnum,drugname,drugdescription,"; strSql += "drugposition,drugallnum,drugweight,tienum,description,pid) "; strSql += "values(" + dinfo.nCustomId + "," + dinfo.nHospitalNum + ",'" + dinfo.strPspnum + "',"; strSql += "'" + dinfo.strDrugNum + "','" + dinfo.strDrugName + "','" + dinfo.strDrugDsp + "','" + dinfo.strDrugPosition + "',"; strSql += "" + dinfo.nAllNum + "," + dinfo.dWeight + "," + dinfo.nTieNum + ",'" + dinfo.strDsp + "'," + "'" + pid + "')"; db.write_log_txt("药品录入:" + strSql); n = db.cmd_Execute(strSql); } // } if (n > 0) { return(true); } else if (n == 0) { // Response.Write("<script>alert('录入药品重复');window.parent.loginview();</script>"); return(true); } else { return(true); } }
//添加匹配列表信息 public int Adddrugmatchinginfo(string hospitalname, string DrugName12, string DrugCode1, string ypcdrugname, string ypcdrugcode) { int end = 0; string strSql = ""; string str1 = "select * from drugadmin where drugname ='" + ypcdrugname + "' and drugcode ='" + ypcdrugcode + "'"; SqlDataReader sdr1 = db.get_Reader(str1); if (sdr1.Read()) { string str2 = "select * from ypcdrug where drugNum ='" + DrugCode1 + "' and hospitalid ='" + hospitalname + "'"; SqlDataReader sdr2 = db.get_Reader(str2); if (sdr2.Read()) { } else { strSql = "insert into ypcdrug(drugName, drugNum, drugDetailedName, drugAlias,hospitalid) "; strSql += "values ('" + DrugName12 + "','" + DrugCode1 + "','" + ypcdrugname + "','" + ypcdrugcode + "','" + hospitalname + "')"; end = db.cmd_Execute(strSql); } } else { } return(end); }
public SqlDataReader findWarehouseNum(string Warehouse) { string sql = "select WareNum from Warehousepharmacy where WName = '" + Warehouse + "'"; SqlDataReader sdr = db.get_Reader(sql); return(sdr); }
public int AddAudit(int DecoctingNum, string ReviewPer) { System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now;//获取当前时间 String sql = ""; int end = 0; string per = ReviewPer.Substring(6); string employeeid = ""; string str3 = "select id from employee where EmNumAName ='" + ReviewPer + "'"; SqlDataReader sr3 = db.get_Reader(str3); if (sr3.Read()) { employeeid = sr3["id"].ToString(); } string str = "select id from prescription where id in (select prescriptionId from adjust where status = 1 ) and id not in (select pid from InvalidPrescription) and id = '" + DecoctingNum + "'"; SqlDataReader sr = db.get_Reader(str); if (sr.Read()) { string result = sr["id"].ToString(); int a = Convert.ToInt32(result); string str1 = "select * from Audit where pid = '" + a + "'"; SqlDataReader sr1 = db.get_Reader(str1); if (sr1.Read()) { sql = ""; } else { sql = "INSERT INTO [Audit](AuditTime,pid,ReviewPer,AuditStatus,employeeId) VALUES('" + currentTime + "','" + a + "','" + per + "',1,'" + employeeid + "')"; if (db.cmd_Execute(sql) == 1) { sql = "update prescription set doperson ='" + per + "', curstate = '复核' where id = '" + a + "'"; } } } else { sql = ""; } if (sql == "") { end = 0; } else { end = db.cmd_Execute(sql); } return(end);; }
public bool AddRecipe(RecipeInfo rinfo) { int n = 0; string stateSql = "select Pspnum from prescription where Hospitalid =" + rinfo.nHospitalID + "and Pspnum ='" + rinfo.strPspnum + "'"; SqlDataReader srd = db.get_Reader(stateSql); //string q = srd["Pspnum"].ToString(); if (srd.Read()) { n = 0; } else { System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now;//当前时间 string strSql = "insert into prescription(delnum,Hospitalid,Pspnum,name,sex,age,phone,address,department,inpatientarea,ward,sickbed,"; strSql += "diagresult,dose,takenum,getdrugtime,getdrugnum,decscheme,oncetime,twicetime,packagenum,dotime,doperson,"; strSql += "dtbcompany,dtbaddress,dtbphone,dtbtype,soakwater,soaktime,labelnum,remark,doctor,footnote,ordertime,curstate,decmothed,takeway,takemethod,RemarksA,RemarksB)"; strSql += " values('" + rinfo.strDelnum + "','" + rinfo.nHospitalID + "','" + rinfo.strPspnum + "',"; strSql += "'" + rinfo.strName + "','" + rinfo.nSex + "','" + rinfo.nAge + "','" + rinfo.strPhone + "','" + rinfo.strAddress + "',"; strSql += "'" + rinfo.strDepartment + "','" + rinfo.strInpatientAreaNum + "','" + rinfo.strWard + "','" + rinfo.strSickBed + "',"; strSql += "'" + rinfo.strDiagResult + "','" + rinfo.strDose + "','" + rinfo.nNum + "','" + rinfo.strDrugGetTime + "','" + rinfo.strDrugGetNum + "',"; strSql += "'" + rinfo.strScheme + "','" + rinfo.strTimeOne + "','" + rinfo.strTimeTwo + "','" + rinfo.nPackageNum + "','" + currentTime + "',"; strSql += "'" + rinfo.strDoPerson + "','" + rinfo.strDtbCompany + "','" + rinfo.strDtbAddress + "','" + rinfo.strDtbPhone + "','" + rinfo.strDtbStyle + "',"; strSql += "'" + rinfo.nSoakWater + "','" + rinfo.nSoakTime + "','" + rinfo.nLabelNum + "','" + rinfo.strRemark + "','" + rinfo.strDoctor + "','" + rinfo.strFootNote + "','" + rinfo.strOrderTime + "','未匹配','" + rinfo.strDecMothed + "','" + rinfo.strTakeWay + "','" + rinfo.strTakeMethod + "','" + rinfo.strRemarksA + "','" + rinfo.strRemarksB + "')"; n = db.cmd_Execute(strSql); if (n == 1) { string str2 = "select id from prescription where hospitalid ='" + rinfo.nHospitalID + "' and Pspnum='" + rinfo.strPspnum + "'"; SqlDataReader srd2 = db.get_Reader(str2); if (srd2.Read()) { string pid = srd2["id"].ToString(); string str3 = "insert into jfInfo(pid,jiefangman,jiefangtime)values('" + pid + "','" + rinfo.strDoPerson + "','" + rinfo.strDoTime + "')"; db.cmd_Execute(str3); } } } if (n > 0) { return(true); } else { return(false); } }
public bool AddDrug(DrugInfo dinfo) { DataBaseLayer db = new DataBaseLayer(); int n = 0; string stateSql = "select prescriptionId from PrescriptionCheckState where checkStatus = 1 and prescriptionId = (select id from prescription as p where p.Pspnum = '" + dinfo.strPspnum + "' and p.hospitalid = '" + dinfo.nHospitalNum + "')"; SqlDataReader srd = db.get_Reader(stateSql); //string q = srd["Pspnum"].ToString(); if (srd.Read()) { n = 0; } else { string stateSql1 = "select id from prescription as p where p.Pspnum = '" + dinfo.strPspnum + "' and p.hospitalid = '" + dinfo.nHospitalNum + "'"; SqlDataReader srd1 = db.get_Reader(stateSql1); string pid = ""; if (srd1.Read()) { pid = srd1["id"].ToString(); } string str = "select * from drug where pid='" + pid + "' and drugnum ='" + dinfo.strDrugNum + "' and drugname ='" + dinfo.strDrugName + "'"; SqlDataReader srd4 = db.get_Reader(str); if (srd4.Read()) { n = 0; } else { string strSql = "insert into drug(customid,Hospitalid,Pspnum,drugnum,drugname,drugdescription,"; strSql += "drugposition,drugallnum,drugweight,tienum,description,wholesaleprice,retailprice,pid) "; strSql += "values(" + dinfo.nCustomId + "," + dinfo.nHospitalNum + ",'" + dinfo.strPspnum + "',"; strSql += "'" + dinfo.strDrugNum + "','" + dinfo.strDrugName + "','" + dinfo.strDrugDsp + "','" + dinfo.strDrugPosition + "',"; strSql += "" + dinfo.nAllNum + "," + dinfo.dWeight + "," + dinfo.nTieNum + ",'" + dinfo.strDsp + "'," + dinfo.dWholeSalePrice + ","; strSql += "" + dinfo.dRetailPrice + ",'" + pid + "')"; n = db.cmd_Execute(strSql); } } if (n > 0) { return(true); } else { return(false); } }
//大屏显示发药信息 public string getdeliveryinfo() { DataBaseLayer db = new DataBaseLayer(); System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now;//当前时间 string strS = currentTime.ToString("yyyy/MM/dd 00:00:00"); string strS2 = currentTime.ToString("yyyy/MM/dd 23:59:59"); string str = "select count(*) as ct from prescription where dotime between '" + strS + "' and '" + strS2 + "'"; SqlDataReader sdr = db.get_Reader(str); string ct = ""; if (sdr.Read()) { ct = sdr["ct"].ToString(); } // string str2 = "select count(*) as ct from prescription where dotime between '" + strS + "' and '" + strS2 + "' and id in (select decoctingnum from delivery where sendstate =0)"; string str2 = "select count(*) as ct from prescription where dotime between '" + strS + "' and '" + strS2 + "' and id in (select decoctingnum from delivery where sendstate =0) AND (Hospitalid IN (SELECT ID FROM Hospital WHERE (DrugSendDisplayState = '0')))"; SqlDataReader sdr2 = db.get_Reader(str2); string ct2 = ""; if (sdr2.Read()) { ct2 = sdr2["ct"].ToString(); } string str3 = "select count(*) as ct from prescription where dotime between '" + strS + "' and '" + strS2 + "' and id in (select decoctingnum from delivery where sendstate =1)"; SqlDataReader sdr3 = db.get_Reader(str3); string ct3 = ""; if (sdr3.Read()) { ct3 = sdr3["ct"].ToString(); } string result = ""; result = "当日接单数:" + ct + " " + " 待发货:" + ct2 + "" + "已发货:" + ct3; return(result); }
/// <summary> /// 综合大屏累计数量显示 /// </summary> /// <returns></returns> public string getCompositeInfo() { DataBaseLayer db = new DataBaseLayer(); System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now;//当前时间 string strS = currentTime.ToString("yyyy/MM/dd 00:00:00"); string strS2 = currentTime.ToString("yyyy/MM/dd 23:59:59"); string str = "select count(*) as ct from prescription where dotime between '" + strS + "' and '" + strS2 + "'"; SqlDataReader sdr = db.get_Reader(str); string OrderNum = ""; if (sdr.Read()) { OrderNum = sdr["ct"].ToString(); } sdr.Close(); string str1 = "select count(*) as ct from prescription where id in (select pid from bubble where starttime between '" + strS + "' and '" + strS2 + "' )"; SqlDataReader sdr1 = db.get_Reader(str1); string displayNum = ""; if (sdr1.Read()) { displayNum = sdr1["ct"].ToString(); } sdr1.Close(); string str2 = "select count(*) as ct from prescription as a right join tisaneinfo as b on b.Pid=a.ID where b.starttime between '" + strS + "' and '" + strS2 + "' "; SqlDataReader sdr2 = db.get_Reader(str2); string bmNum = ""; if (sdr2.Read()) { bmNum = sdr2["ct"].ToString(); } sdr2.Close(); string str3 = "select count(*) as ct from prescription as a right join packing as b on b.DecoctingNum=a.ID where b.starttime between '" + strS + "' and '" + strS2 + "' "; SqlDataReader sdr3 = db.get_Reader(str3); string packNum = ""; if (sdr3.Read()) { packNum = sdr3["ct"].ToString(); } sdr3.Close(); return(OrderNum + "," + displayNum + "," + bmNum + "," + packNum); }
public int AddReconciliation1(string Clearing, string ReconciliaT, string ReconciliaPer, string Remarks, string nPId, string now, string Retime) { String strSql = ""; int end = 0; string sum = ""; //处方下药品的零售价之和 string cheng = ""; //处方(次数*贴数)之积 //计算处方下药品的零售价之和 // string sq3 = " SELECT SUM(cast(retailprice as float(2))) AS a FROM drug AS d WHERE (pid ='" + nPId + "')"; //计算处方下匹配药品的零售价之和 string sq3 = "SELECT SUM(CAST(ad.Univalent AS float(2))) AS a FROM drug AS d INNER JOIN " + " ypcDrug AS ypc ON ypc.drugName = d.drugname AND ypc.drugNum = d.drugnum INNER JOIN " + " DrugAdmin AS ad ON ad.DrugName = ypc.drugDetailedName AND ad.DrugCode = ypc.drugAlias " + " WHERE (d.pid = '" + nPId + "')"; SqlDataReader srd = db.get_Reader(sq3); if (srd.Read()) { sum = srd["a"].ToString(); //计算处方(次数*贴数)之积 string sq4 = " SELECT dose * takenum AS m FROM prescription AS p WHERE (ID = '" + nPId + "')"; SqlDataReader srd1 = db.get_Reader(sq4); if (srd1.Read()) { cheng = srd1["m"].ToString(); } } strSql = "select pid from Reconciliation where pid=" + nPId; DataTable dt = db.get_DataTable(strSql); if (dt.Rows.Count == 0) { // Clearing:结算方 CheckNum:对账单号 ReconciliaPer:对账人 ReconciliaT:对账时间 now:生成对账单时间 State:对账单状态 0 未结算 1结算 drugMonSum:处方下药品的零售价之和 shengRe:处方(次数*贴数)之积 strSql = "insert into Reconciliation(Clearing,CheckNum,ReconciliaPer,ReconciliaT,now,State,Remarks,pid,drugMonSum,shengRe) "; strSql += "values ('" + Clearing + "','" + Retime + "','" + ReconciliaPer + "','" + ReconciliaT + "','" + now + "','0','" + Remarks + "','" + nPId + "','" + sum + "','" + cheng + "')"; if (strSql == "") { end = 0; } else { end = db.cmd_Execute(strSql); // string sq3 = "SELECT CheckNum, (SELECT SUM(retailprice) AS Expr1 FROM drug AS d WHERE (pid ='" + nPId + "')) AS b, (SELECT dose * takenum AS m" // + " FROM prescription AS p WHERE (ID = '" + nPId + "')) AS a FROM Reconciliation AS r"; } } return(end); }
public static String AddReconciliation(string strRowIds, string Clearing, string ReconciliaT, string ReconciliaPer, string Remarks) { int sdr = 0; string[] strRows1Id = strRowIds.Split(','); DataBaseLayer db = new DataBaseLayer(); // now:生成对账单时间 System.DateTime now = new System.DateTime(); now = System.DateTime.Now; string n = now.ToString(); // ReconciliaT:对账时间 string current = now.ToString("yyyyMMddhhmmss"); string str = "select id from Clearingparty where ClearPName = '" + Clearing + "'"; SqlDataReader sr = db.get_Reader(str); if (sr.Read()) { string Retime = sr["id"].ToString() + current; ClearingpartyHandler ch = new ClearingpartyHandler(); for (int i = 0; i < strRows1Id.Length; i++) { sdr = ch.AddReconciliation(Clearing, ReconciliaT, ReconciliaPer, Remarks, strRows1Id[i], n, Retime); } } return(""); }
public int AddWarehousepharmacy(string WName, string WareNum, string Type) { String strSql = ""; int end = 0; DataBaseLayer db = new DataBaseLayer(); string tate = "select WareNum from Warehousepharmacy where WareNum = '" + WareNum + "'"; SqlDataReader tate1 = db.get_Reader(tate); if (tate1.Read()) { strSql = ""; } else { strSql = "insert into Warehousepharmacy(WName,WareNum,Type) "; strSql += "values ('" + WName + "','" + WareNum + "','" + Type + "')"; } if (strSql == "") { end = 0; } else { end = db.cmd_Execute(strSql); } return(end); }
/// <summary> /// 添加员工信息 /// </summary> /// <param name="einfo"></param> /// <returns></returns> public int AddEmployee(string JobNum, string EName, string Role, string Age, string Sex, string Nation, string Phone, string Address, string Origin, string password, string room) { String strSql = ""; int end = 0; string EmNumAName = JobNum + " " + EName; DataBaseLayer db = new DataBaseLayer(); string tate = "select JobNum from Employee where JobNum = '" + JobNum + "'"; SqlDataReader tate1 = db.get_Reader(tate); if (tate1.Read()) { strSql = ""; } else { strSql = "insert into Employee(JobNum,EName,Role,Sex,Age,Phone,Address,Nation,Origin,pwd,EmNumAName,room) "; strSql += "values ('" + JobNum + "','" + EName + "','" + Role + "','" + Sex + "',"; strSql += "'" + Age + "','" + Phone + "','" + Address + "','" + Nation + "','" + Origin + "','" + password + "','" + EmNumAName + "','" + room + "')"; } if (strSql == "") { end = 0; } else { string[] rolelist = Role.Split(','); for (int i = 0; i < rolelist.Length; i++) { string userRole = "insert into tbUserRole(UserId,RoleId)values('" + JobNum + "','" + rolelist[i] + "')"; db.cmd_Execute(userRole); } end = db.cmd_Execute(strSql); } return(end); }
/// <summary> /// 添加员工信息 /// </summary> /// <param name="einfo"></param> /// <returns></returns> public int AddEmployee(string JobNum, string EName, string Role, string Age, string Sex, string Nation, string Phone, string Address, string Origin, string password) { String strSql = ""; int end = 0; string EmNumAName = JobNum + " " + EName; DataBaseLayer db = new DataBaseLayer(); string tate = "select JobNum from Employee where JobNum = '" + JobNum + "'"; SqlDataReader tate1 = db.get_Reader(tate); if (tate1.Read()) { strSql = ""; } else { strSql = "insert into Employee(JobNum,EName,Role,Sex,Age,Phone,Address,Nation,Origin,pwd,EmNumAName) "; strSql += "values ('" + JobNum + "','" + EName + "','" + Role + "','" + Sex + "',"; strSql += "'" + Age + "','" + Phone + "','" + Address + "','" + Nation + "','" + Origin + "','" + password + "','" + EmNumAName + "')"; } if (strSql == "") { end = 0; } else { end = db.cmd_Execute(strSql); } return(end); }
public int updateHospitalInfo(int id, string hname, string hshortname, string hnum, string contacter, string phone, string address, string pricetype) { //string strSql = "select id,JobNum,EName,Role,Sex,Age,Phone,Address,Nation,Origin from Employee where id = " + id; int end = 0; DataBaseLayer db = new DataBaseLayer(); string tate = "select hnum from hospital where hnum = '" + hnum + "' and id != '" + id + "'"; SqlDataReader tate1 = db.get_Reader(tate); if (tate1.Read()) { end = 0; } else { /* string tate2 = "select settler from hospital where settler = '" + settler + "' and id != '" + id + "'"; * SqlDataReader tatea = db.get_Reader(tate2); * if (tatea.Read()) * { * end = 0; * } * else * {*/ string sql = "update hospital set hname='" + hname + "',hshortname='" + hshortname + "',hnum='" + hnum + "',contacter='" + contacter + "',phone='" + phone + "',address='" + address + "',pricetype='" + pricetype + "' where id = " + id + ""; end = db.cmd_Execute(sql); // } } return(end); }
///// <summary> ///// 更新复核信息 ///// </summary> ///// <param name="id">id</param> ///// <returns>int对象</returns> public int addRechecked(int userid, string wordDate, string barcode, string wordcontent, string tisaneNum, string imgname, string userName) { string sql_is_tiaoji = "select count(id) as num from adjust where status='0' and enddate is null and prescriptionId = '" + tisaneNum.Trim() + "'"; SqlDataReader sr_is_tiaoji = db.get_Reader(sql_is_tiaoji); if (sr_is_tiaoji.Read()) { string result_num = sr_is_tiaoji["num"].ToString(); int flag_t = Convert.ToInt32(result_num); //状态为开始调剂 if (flag_t > 0) { string u_sql = "update adjust set status='1',enddate=dateadd(MINUTE,-1,GETDATE()) where prescriptionId = '" + tisaneNum.Trim() + "'"; db.cmd_Execute(u_sql); } //调剂完成状态,不做操作 } string sql = "insert into Audit(ReviewPer,AuditTime,barcode,pid,imgname,AuditStatus,employeeId) values('" + userName + "','" + wordDate + "','" + barcode + "','" + tisaneNum + "','" + imgname + "','1','" + userid + "')"; string sql2 = "update prescription set doperson ='" + userName + "', curstate = '复核' where id = '" + tisaneNum + "'"; db.cmd_Execute(sql2); return(db.cmd_Execute(sql)); }
public int AddHospital(string hname, string hshortname, string hnum, string contacter, string phone, string address, string pricetype) { int end = 0; DataBaseLayer db = new DataBaseLayer(); string tate = "select hnum from hospital where hnum = '" + hnum + "' "; SqlDataReader tate1 = db.get_Reader(tate); if (tate1.Read()) { end = 0; } else { /*string tate2 = "select settler from hospital where settler = '" + settler + "' "; * SqlDataReader tatea = db.get_Reader(tate2); * if (tatea.Read()) * { * end = 0; * } * else * {*/ //泡药显示 DrugDisplayState 煎药显示 ChineseDisplayState 发药显示 DrugSendDisplayState string strSql = "insert into hospital(hnum,hname,hshortname,contacter,phone,address,pricetype, DrugDisplayState,ChineseDisplayState,DrugSendDisplayState) "; strSql += "values ('" + hnum + "','" + hname + "','" + hshortname + "','" + contacter + "',"; strSql += "'" + phone + "','" + address + "','" + pricetype + "','0','0','0')"; end = db.cmd_Execute(strSql); // } } return(end); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PackingHandler phandler = new PackingHandler(); SqlDataReader sdr = phandler.findNameAll(); if (sdr != null) { while (sdr.Read()) { this.PackPer.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()) { PackPer.Value = sr["EmNumAName"].ToString(); } } else { Response.Write("<script>alert('用户名已失效');window.parent.loginview();</script>"); } } }
//重写煎药指令 public static void Insert_TisaneCmd_orerride_pda(string bmNum, string mahineid) { //开始煎药指令 DataBaseLayer db = new DataBaseLayer(); string sql12 = "select top 1 macaddress from machine where id = mahineid"; SqlDataReader sr12 = db.get_Reader(sql12); string mac = ""; if (sr12.Read()) { mac = sr12["macaddress"].ToString(); } string sql10 = "select * from prescription where id = '" + bmNum + "'"; SqlDataReader sr10 = db.get_Reader(sql10); string content = ""; if (sr10.Read()) { //添加30分钟煎药方案 /* string str_m = "03"; * string str_w = "00"; * if (sr10["decscheme"].ToString().PadLeft(2, '0') == "02") * { * str_m = "81"; * str_w = "30"; * } * else * { * str_m = sr10["decscheme"].ToString().PadLeft(2, '0'); * str_w = sr10["oncetime"].ToString().PadLeft(2, '0'); * } * */ content = (Convert.ToInt32(sr10["dose"].ToString()) * Convert.ToInt32(sr10["takenum"].ToString())).ToString().PadLeft(2, '0') + sr10["decscheme"].ToString().PadLeft(2, '0') + bmNum.PadLeft(10, '0') + sr10["oncetime"].ToString().PadLeft(2, '0') + sr10["twicetime"].ToString().PadLeft(2, '0'); // content = (Convert.ToInt32(sr10["dose"].ToString()) * Convert.ToInt32(sr10["takenum"].ToString())).ToString().PadLeft(2, '0') + str_m + bmNum.PadLeft(10, '0') + str_w + sr10["twicetime"].ToString().PadLeft(2, '0'); } string sql11 = "insert into cmdtable(cmd,bmip,time) values('" + content + "','" + mac + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')"; sr10.Close(); db.write_log_txt("煎药指令:" + sql11); db.cmd_Execute(sql11); }
public int AddHospital(string hname, string hshortname, string hnum, string contacter, string phone, string address, string pricetype, string relation_name) { int end = 0; DataBaseLayer db = new DataBaseLayer(); string tate = "select top 1 hnum from hospital where hnum = '" + hnum + "' "; SqlDataReader tate1 = db.get_Reader(tate); if (tate1.Read()) { end = 0; } else { /*string tate2 = "select settler from hospital where settler = '" + settler + "' "; * SqlDataReader tatea = db.get_Reader(tate2); * if (tatea.Read()) * { * end = 0; * } * else * {*/ //泡药显示 DrugDisplayState 煎药显示 ChineseDisplayState 发药显示 DrugSendDisplayState string r_sql = "select top 1 relation_id from tb_hospital_drug_type where relation_name='" + relation_name.Trim() + "'"; SqlDataReader r_2 = db.get_Reader(r_sql); string strSql = ""; if (r_2.Read()) { strSql = "insert into hospital(hnum,hname,hshortname,contacter,phone,address,pricetype, DrugDisplayState,ChineseDisplayState,DrugSendDisplayState,relation_drug_type_id) "; strSql += "values ('" + hnum + "','" + hname + "','" + hshortname + "','" + contacter + "',"; strSql += "'" + phone + "','" + address + "','" + pricetype + "','0','0','0'," + "'" + r_2["relation_id"].ToString().Trim() + "'" + ")"; end = db.cmd_Execute(strSql); strSql = ""; } // } } return(end); }
///// <summary> ///// 查询所有调剂信息 ///// </summary> ///// <param name="text">根据药品编号-药品名称-产地-货位号模糊查询</param> public SqlDataReader findYpcDrugInfo(String text) { string sql = "select da.id,da.DrugName drugName,da.DrugCode drugNum,da.DrugSpecificat drugSpec,da.DrugName drugDetailedName,da.PositionNum positionNum,da.DrugName drugAlias,da.ProducingArea drugOrigin from DrugAdmin da where 1=1"; if (text != null && text.Length > 0) { sql += " and da.DrugName like '%" + text + "%' or da.DrugCode like '%" + text + "%' or da.ProducingArea like '%" + text + "%' or da.PositionNum like '%" + text + "%'"; //sql += "and da.DrugName like '%" + text + "%'"; } return(db.get_Reader(sql)); }
public int updateWarehouseInvenInfo(int id, string Warehouse, string InventoryPer, string ActualCapacity, string InventoryStatus, string StorageCondition, string remark) { int end = 0; string sql = ""; string str = "select Warehouse from WarehouseInven where id = " + id + " "; SqlDataReader sr = db.get_Reader(str); if (!sr.Read()) { end = 0; } else { sql = "update WarehouseInven set Warehouse='" + Warehouse + "',InventoryPer='" + InventoryPer + "',ActualCapacity='" + ActualCapacity + "',InventoryStatus='" + InventoryStatus + "',StorageCondition='" + StorageCondition + "',remark='" + remark + "'where id = " + id + ""; end = db.cmd_Execute(sql); } return(end); }
//大屏显示煎药信息 public string gettisaneinfo() { DataBaseLayer db = new DataBaseLayer(); System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now;//当前时间 string strS = currentTime.ToString("yyyy/MM/dd 00:00:00"); string strS2 = currentTime.ToString("yyyy/MM/dd 23:59:59"); string str = "select count(*) as ct from prescription where dotime between '" + strS + "' and '" + strS2 + "'"; SqlDataReader sdr = db.get_Reader(str); string ct = ""; if (sdr.Read()) { ct = sdr["ct"].ToString(); } string str2 = "select count(*) as ct from prescription where dotime between '" + strS + "' and '" + strS2 + "' and id in (select pid from tisaneinfo)"; SqlDataReader sdr2 = db.get_Reader(str2); string ct2 = ""; if (sdr2.Read()) { ct2 = sdr2["ct"].ToString(); } string result = ""; result = "当日接单数:" + ct + " " + " 已煎药:" + ct2; return(result); }
//导出数据 protected void Button1_Click(object sender, EventArgs e) { string strRowIds = ""; if (Request.QueryString["id"] != null) { string id = Request.QueryString["id"]; strRowIds = Request.QueryString["id"].ToString(); } int sdr = 0; string Clearing = Clearing1.Value; string ReconciliaT = ReconciliaT1.Value; string ReconciliaPer = ReconciliaPer1.Value; string Remarks = RemarksA.Value; string[] strRows1Id = strRowIds.Split(','); DataBaseLayer db = new DataBaseLayer(); // now:生成对账单时间 System.DateTime now = new System.DateTime(); now = System.DateTime.Now; string n = now.ToString(); // ReconciliaT:对账时间 string current = now.ToString("yyyyMMddhhmmss"); string str = "select id from Clearingparty where ClearPName = '" + Clearing + "'"; SqlDataReader sr = db.get_Reader(str); if (sr.Read()) { string Retime = sr["id"].ToString() + current; ClearingpartyHandler ch = new ClearingpartyHandler(); for (int i = 0; i < strRows1Id.Length; i++) { sdr = ch.AddReconciliation(Clearing, ReconciliaT, ReconciliaPer, Remarks, strRows1Id[i], n, Retime); } } /* DataTable dt = null; * * ClearingpartyHandler ch2 = new ClearingpartyHandler(); * * dt = ch2.SearchInfo(strRowIds); * * CreateExcel(dt, "application/ms-excel", "excel");*/ //Response.Write("<script language='javascript'>closeDiv();</script>"); }
public int AddClearingparty(string ClearPName, string ConPerson, string Address, string ConPhone, string Remarks, string GenDecoct) { /// <summary> /// 添加结算方信息 /// </summary> /// <param name="einfo"></param> /// <returns></returns> int end = 0; DataBaseLayer db = new DataBaseLayer(); string str = "select ClearPName from Clearingparty where ClearPName = '" + ClearPName + "'"; SqlDataReader sr = db.get_Reader(str); if (sr.Read()) { end = 0; } else { string str1 = "select ClearPName from Clearingparty where ConPerson = '" + ConPerson + "'"; SqlDataReader sr1 = db.get_Reader(str1); if (sr1.Read()) { end = 0; } else { string strSql = "insert into Clearingparty(ClearPName,ConPerson,ConPhone,Address,Remarks,GenDecoct) "; strSql += "values ('" + ClearPName + "','" + ConPerson + "','" + ConPhone + "',"; strSql += "'" + Address + "','" + Remarks + "','" + GenDecoct + "')"; end = db.cmd_Execute(strSql); } } return(end); }
//开始包装指令 重写 public static void Insert_PackCmd_override(string bmNum) { DataBaseLayer db = new DataBaseLayer(); //开始包装指令 string strtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");// string sql12 = "select macaddress from machine where mark=1 and unitnum = (select top 1 unitnum from machine where id =(select top 1 machineid from tisaneunit where pid ='" + bmNum + "'))"; db.write_log_txt("重发包装指令:" + sql12); SqlDataReader sr12 = db.get_Reader(sql12); string mac = ""; if (sr12.Read()) { mac = sr12["macaddress"].ToString(); } string sql10 = "select *, RIGHT(CAST('000000000' + RTRIM(id) AS varchar(20)), 10) as bNum from prescription where id = '" + bmNum + "'"; SqlDataReader sr10 = db.get_Reader(sql10); string content = ""; if (sr10.Read()) { string sql = "select package_machine_nums from tb_sys_add_setting"; SqlDataReader pack = db.get_Reader(sql); int PackNum = 2; if (pack.Read()) { PackNum = Convert.ToInt32(pack["package_machine_nums"].ToString()); } content = (Convert.ToInt32(sr10["dose"].ToString()) * Convert.ToInt32(sr10["takenum"].ToString()) + PackNum).ToString().PadLeft(2, '0') + bmNum.PadLeft(10, '0') + sr10["packagenum"].ToString().PadLeft(4, '0'); } sr10.Close(); string sql11 = "insert into cmdtable(cmd,bmip,time) values('" + content + "','" + mac + "','" + strtime + "');"; db.cmd_Execute(sql11); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { int id = Convert.ToInt16(Request.QueryString["id"]); idnum.Value = Request.QueryString["id"].ToString(); DeliveryHandler dhandler = new DeliveryHandler(); string dt = dhandler.finDecotingBarbyId(id); DecoctingBar.Value = dt; } if (!IsPostBack) { DeliveryHandler dhandler = new DeliveryHandler(); SqlDataReader sdr = dhandler.findNameAll(); if (sdr != null) { while (sdr.Read()) { this.Sendper.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()) { Sendper.Value = sr["EmNumAName"].ToString(); } } else { Response.Write("<script>alert('用户名已失效');window.parent.loginview();</script>"); } } }
public static String AddReconciliation(string Clearing, string ReconciliaT, string ReconciliaPer, string Remarks , string Pspnum, string hospitalSelect1, string STime, string ETime) { string[] arr = null; RecipeModel rm = new RecipeModel(); DataTable sdr1 = rm.AccountStatementInfo(Pspnum, STime, ETime, Convert.ToInt32(hospitalSelect1)); arr = new string[sdr1.Rows.Count]; for (var i = 0; i < sdr1.Rows.Count; i++) { arr[i] = sdr1.Rows[i]["id"].ToString(); } int sdr = 0; // string[] strRows1Id = strRowIDs.Split(','); DataBaseLayer db = new DataBaseLayer(); // now:生成对账单时间 System.DateTime now = new System.DateTime(); now = System.DateTime.Now; string n = now.ToString(); // ReconciliaT:对账时间 string current = now.ToString("yyyyMMddhhmmss"); string str = "select id from Clearingparty where ClearPName = '" + Clearing + "'"; SqlDataReader sr = db.get_Reader(str); if (sr.Read()) { for (int i = 0; i < arr.Length; i++) { string Retime = sr["id"].ToString() + current; ClearingpartyHandler ch = new ClearingpartyHandler(); sdr = ch.AddReconciliation1(Clearing, ReconciliaT, ReconciliaPer, Remarks, arr[i], n, Retime); } } return(""); }
///// <summary> ///// 根据处方号查询药品信息 ///// </summary> ///// <param name="pspnum">处方号</param> ///// <returns>DataTable对象</returns> public DataTable findDrugInfo(string pspnum, string Hospitalid) { string str = "select id from hospital where hnum ='" + Hospitalid + "'"; SqlDataReader sdr2 = db.get_Reader(str); string hid = ""; if (sdr2.Read()) { hid = sdr2["id"].ToString(); } string sql = "select ROW_NUMBER() OVER(ORDER BY id desc) as ID,delnum,(select hnum from hospital as h where h.id = d.hospitalid) as hnum,(select hname from hospital as h where h.id = d.hospitalid) as hname," + "Pspnum,Drugnum,Drugname,DrugDescription,DrugPosition,DrugAllNum,DrugWeight,TieNum,Description,WholeSalePrice,RetailPrice,WholeSaleCost,retailpricecost," + "money,Fee from drug as d where d.Pspnum='" + pspnum + "' and Hospitalid='" + hid + "'"; DataTable dt = db.get_DataTable(sql); return(dt); }