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