public string getBindInfo(VODrugInfo drugInfoVO) { string bindinfo = ""; //MySqlPool pool = MySqlPool.getInstance(); MySqlConnection conn = null; try { conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["strCon"].ToString()); conn.Open(); string sql = "select count(1),count(1)*floor(" + Paramters.G_CHN_LEN + "/" + drugInfoVO.PackageLength + ") from stock_list where eqp_id='" + Paramters.G_EQP_ID + "' and drug_code='" + drugInfoVO.DrugCode + "'"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { bindinfo = (dr.IsDBNull(0) ? "0" : dr.GetString(0)) + ";" + (dr.IsDBNull(1) ? "0" : dr.GetString(1)); } else { bindinfo = "0;0"; } dr.Close(); } catch (System.Exception ex) { return("Error"); } finally { //pool.releaseConnection(conn); conn.Close(); } return(bindinfo); }
public bool saveDrugInfo(VODrugInfo drugInfo) { string sql = "update drug_list set Drug_Barcode='" + drugInfo.DrugBarCode + "',package_length='" + drugInfo.PackageLength + "',package_width='" + drugInfo.PackageWidth + "',package_height='" + drugInfo.PackageHeight + "',time1='" + drugInfo.AlarmStock.ToUpper() + "',time2='" + drugInfo.AlarmStock2.ToUpper() + "',out_limit='" + drugInfo.OutLimit + "',stock_limit='" + drugInfo.StockLimit + "',stock_holdquantity='" + drugInfo.StockHoldquantity + "',storageLoc='" + drugInfo.StorageLoc + "' where drug_code='" + drugInfo.DrugCode + "'"; MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["strCon"].ToString()); try { con.Open(); MySqlCommand cmd = new MySqlCommand(sql, con); cmd.ExecuteNonQuery(); } catch (Exception ex) { new LogInfo().info("保存失败" + ex.Message); return(false); } finally { con.Close(); } return(true); }
//private SpeechSynthesizer speech = new SpeechSynthesizer(); public FillForm(VODrugInfo drugInfo) { InitializeComponent(); this.drugInfo = drugInfo; }
public FormHandFill(VODrugInfo druginfo) { InitializeComponent(); this.druginfo = druginfo; }
public DrugInfoForm(VODrugInfo drugInfo) { InitializeComponent(); this.drugInfoVO = drugInfo; }
public BindForm(VODrugInfo drugInfoVO) { InitializeComponent(); this.drugInfoVO = drugInfoVO; }
/// <summary> /// 通过药品包装尺寸检索合适的药槽 /// </summary> /// <param name="code">药品编码</param> /// <returns></returns> public DataTable getStockByPackage(bool used, VODrugInfo drugInfoVO) { DataTable table = new DataTable(); table.Columns.Add("库位编码"); table.Columns.Add("设备编号"); table.Columns.Add("行号"); table.Columns.Add("列号"); table.Columns.Add("库位宽度"); table.Columns.Add("药品宽度"); table.Columns.Add("宽度差"); table.Columns.Add("库位高度"); table.Columns.Add("药品高度"); table.Columns.Add("高度差"); table.Columns.Add("药品名称"); table.Columns.Add("规格"); table.Columns.Add("厂家"); //MySqlPool pool = MySqlPool.getInstance(); //MySqlConnection conn = null; MySqlConnection conn = null; try { //conn = pool.getConnection(); conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["strCon"].ToString()); conn.Open(); string sql = ""; if (used) { sql = @"select Stock_ID,Eqp_ID,Row_NO,Col_NO,Stock_Width,Stock_Height,Drug_Name,Drug_Spec,Manufactory from Stock_list a left join drug_list b on a.Drug_Code=b.Drug_Code where ((Stock_width>=(" + drugInfoVO.PackageWidth + "+" + NEIni.ReadValue("./config.ini", "params", "packagewidthlow", "2") + ") and " + " Stock_width<=(" + drugInfoVO.PackageWidth + "+" + NEIni.ReadValue("./config.ini", "params", "packagewidthupp", "10") + ") and " + " Stock_height>=(" + drugInfoVO.PackageHeight + "+" + NEIni.ReadValue("./config.ini", "params", "packageheightlow", "30") + ") and " + " Stock_height<=(" + drugInfoVO.PackageHeight + "+" + NEIni.ReadValue("./config.ini", "params", "packageheightupp", "100") + ") and " + "Drug_Name is null) or a.Drug_Code='" + drugInfoVO.DrugCode + "') and Eqp_ID='" + Paramters.G_EQP_ID + "' "; } else { sql = @"select Stock_ID,Eqp_ID,Row_NO,Col_NO,Stock_Width,Stock_Height,Drug_Name,Drug_Spec,Manufactory from Stock_list a left join drug_list b on a.Drug_Code=b.Drug_Code where ((Stock_width>=(" + drugInfoVO.PackageWidth + "+" + NEIni.ReadValue("./config.ini", "params", "packagewidthlow", "2") + ") and " + " Stock_width<=(" + drugInfoVO.PackageWidth + "+" + NEIni.ReadValue("./config.ini", "params", "packagewidthupp", "10") + ") and " + " Stock_height>=(" + drugInfoVO.PackageHeight + "+" + NEIni.ReadValue("./config.ini", "params", "packageheightlow", "30") + ") and " + " Stock_height<=(" + drugInfoVO.PackageHeight + "+" + NEIni.ReadValue("./config.ini", "params", "packageheightupp", "100") + ")) " + " or a.Drug_Code='" + drugInfoVO.DrugCode + "') and Eqp_ID='" + Paramters.G_EQP_ID + "' "; } MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { DataRow row = table.NewRow(); row["库位编码"] = dr.IsDBNull(0) ? "" : dr.GetString(0); row["设备编号"] = dr.IsDBNull(1) ? "" : dr.GetString(1); row["行号"] = dr.IsDBNull(2) ? "" : dr.GetString(2); row["列号"] = dr.IsDBNull(3) ? "" : dr.GetString(3); row["库位宽度"] = dr.IsDBNull(4) ? "" : dr.GetString(4); row["药品宽度"] = drugInfoVO.PackageWidth; row["宽度差"] = (dr.IsDBNull(4) ? 0 : dr.GetInt32(4)) - int.Parse(drugInfoVO.PackageWidth); row["库位高度"] = dr.IsDBNull(5) ? "" : dr.GetString(5); row["药品高度"] = drugInfoVO.PackageHeight; row["高度差"] = (dr.IsDBNull(5) ? 0 : dr.GetInt32(5)) - int.Parse(drugInfoVO.PackageHeight); row["药品名称"] = dr.IsDBNull(6) ? "" : dr.GetString(6); row["规格"] = dr.IsDBNull(7) ? "" : dr.GetString(7); row["厂家"] = dr.IsDBNull(8) ? "" : dr.GetString(8); table.Rows.Add(row); } dr.Close(); } catch (System.Exception ex) { // } finally { //pool.releaseConnection(conn); conn.Close(); } return(table); }
public DataTable getWaitingList(VODrugInfo drugInfo) { DataTable table = new DataTable(); table.Columns.Add("药品名称"); table.Columns.Add("规格"); table.Columns.Add("厂家"); table.Columns.Add("可补量"); table.Columns.Add("库位码"); table.Columns.Add("当前量"); table.Columns.Add("最大库存"); MySqlPool pool = MySqlPool.getInstance(); MySqlConnection conn = null; try { conn = pool.getConnection(); string sql = "select Drug_Name,Drug_Spec,Manufactory,StockFillQty,storageloc,stockqty,stockmaxqty,drug_code,Stock_Limit,StockCount from v_f_stock2 where StockFillQty>0 order by StockFillQty desc"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { try { if (drugInfo.DrugCode.Equals(dr.GetString(7))) { continue; } } catch (System.Exception ex) { // } DataRow row = table.NewRow(); row["药品名称"] = dr.IsDBNull(0) ? "" : dr.GetString(0); row["规格"] = dr.IsDBNull(1) ? "" : dr.GetString(1); row["厂家"] = dr.IsDBNull(2) ? "" : dr.GetString(2); //添加单库位限制量 //if (!dr.GetString(8).Equals("0")) //{ // row[" 可补量"] = dr.GetString(9) + ""; //} //else //{ row[" 可补量"] = dr.IsDBNull(3) ? "" : dr.GetString(3); //} row["库位码"] = dr.IsDBNull(4) ? "" : dr.GetString(4); row["当前量"] = dr.IsDBNull(5) ? "" : dr.GetString(5); row["最大库存"] = dr.IsDBNull(6) ? "" : dr.GetString(6); table.Rows.Add(row); } dr.Close(); } catch (System.Exception ex) { // } finally { pool.releaseConnection(conn); } return(table); }