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