public static string getproductbatch(string dataname, string fromid)
{
StorageManageModel smm = new StorageManageModel();
string sdr = smm.getproductbatchbydrugnamemedical(dataname, fromid);
return(sdr);
}
protected void ExportMedicineInventoryInfor_Click(object sender, EventArgs e)
{
string DrugName1 = DrugName.Value;
string Warehouse1 = Warehouse.Value;
if (DrugName1 == "" || DrugName1 == "0")
{
DrugName1 = "0";
}
if (Warehouse1 == "" || Warehouse1 == "0")
{
Warehouse1 = "0";
}
StorageManageModel rm = new StorageManageModel();
// DataBaseLayer db = new DataBaseLayer();
// string str = "select * from lossiInfor where type ='" + type + "'";
DataTable dt = rm.druginventory(DrugName1, Warehouse1);
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string now = currentTime.ToString("yyyyMMdd");
CreateExcel(dt, "application/ms-excel", "药房库存信息" + now);
}
public static string serchDrugInfo(string text)
{
StorageManageModel smm = new StorageManageModel();
string sdr = smm.getdrugname(text);
return(sdr);
}
public static string serchDrugInfo(string text, string fromid)
{
StorageManageModel smm = new StorageManageModel();
string sdr = smm.getdrugnamemedical(text, fromid);
return(sdr);
}
public static string getproductbatch(string dataname)
{
StorageManageModel smm = new StorageManageModel();
string sdr = smm.getproductbatchbydrugname(dataname);
return(sdr);
}
public static int enterStorage(string strRowIds, string Warehouse1, string intoman, string OSingle1, string OSTime1)
{
int result = 0;
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now; //获取当前时间
// string currentTime1 = currentTime.ToString();
//单号
string now = currentTime.ToString("yyyyMMddhhmmss");
string Num = "RK" + now; //单号
string[] strRowsId = strRowIds.Split(',');
for (int i = 0; i < strRowsId.Length; i++)
{
StorageManageModel smm = new StorageManageModel();
result = smm.AddStorage(strRowsId[i].ToString(), Warehouse1, intoman, OSingle1, OSTime1, currentTime, Num);
}
return(result);
}
public static string getdrugnum(string dataname)
{
StorageManageModel smm = new StorageManageModel();
string sdr = smm.getdrugnumbydrugname(dataname);
return(sdr);
}
public static string getdruginfobydrugnum(string drugnum, string fromid)
{
string result = "";
//string str2 = str1.TrimStart('0');
WarehousepharmacyModel whm = new WarehousepharmacyModel();
SqlDataReader sdr = whm.findgrudinfobydrugnumsecond(drugnum);
SqlDataReader sdr2 = whm.findgrudinfobydrugnumfromstoragedrug(drugnum);
StorageManageModel smm = new StorageManageModel();
int remainingnum = smm.remainingnummedical(fromid, drugnum);
if (sdr.Read())
{
if (sdr2.Read())
{
result = sdr["DrugType"].ToString() + "," + sdr["DrugCode"] + "," + sdr["PurUnits"] + "," + sdr["DrugName"] + "," + sdr["DrugSpecificat"]
+ "," + sdr["PositionNum"] + "," + sdr["Univalent"] + "," + sdr["Mnemonic"] + "," + sdr["Rmarkes"]
+ "," + sdr["Producer"] + "," + sdr["ProducingArea"] + "," + sdr["StorageTime"] + "," + sdr["LowerLimit"]
+ "," + sdr["UpperLimit"] + "," + sdr["Rmarkes2"] + "," + sdr["Rmarkes3"] + "," + remainingnum + "," + sdr2["ProDate"] + "," + sdr2["ExpiryDate"] + "," + sdr2["Quality"] + "," + sdr2["LicenseNum"] + "," + sdr2["Rmarkes"];
}
}
return(result);
}
//提供数据的方法
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
string fromid = "0";
if (p.extParam.ContainsKey("fromid"))
{
fromid = p.extParam["fromid"];
}
if (fromid == "" || fromid == "0")
{
fromid = "0";
}
StorageManageModel smm = new StorageManageModel();
result.table = smm.findStoragebyfromid(fromid);
return(result);
}
//提供数据的方法
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
string medicalname = "0";
if (p.extParam.ContainsKey("medicalname"))
{
medicalname = p.extParam["medicalname"];
}
if (medicalname == "" || medicalname == "0")
{
medicalname = "0";
}
string hospitalname = "0";
if (p.extParam.ContainsKey("hospitalname"))
{
hospitalname = p.extParam["hospitalname"];
}
if (hospitalname == "" || hospitalname == "0")
{
hospitalname = "0";
}
string hospitaldrugname = "";
if (p.extParam.ContainsKey("hospitaldrugname"))
{
hospitaldrugname = p.extParam["hospitaldrugname"];
}
if (hospitaldrugname == "" || hospitaldrugname == "0")
{
hospitaldrugname = "0";
}
StorageManageModel smm = new StorageManageModel();
result.table = smm.finddrugmatchdone(medicalname, hospitalname, hospitaldrugname);
return(result);
}
public static int ischeckoutnum(string num, string fromid, string drugnum)
{
StorageManageModel smm = new StorageManageModel();
int result = smm.ischeckoutnummedical(num, fromid, drugnum);
return(result);
}
public static int enterMedicineStorage(string strRowIds, string Warehouse1, string intoman, string OSingle1, string OSTime1)
{
int result = 0;
string[] strRowsId = strRowIds.Split(',');
for (int i = 0; i < strRowsId.Length; i++)
{
StorageManageModel smm = new StorageManageModel();
result = smm.AddMedicineStorage(strRowsId[i].ToString(), Warehouse1, intoman, OSingle1, OSTime1);
}
return(result);
}
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
StorageManageModel rm = new StorageManageModel();
result.table = rm.searchStorageInfochange();
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt16(Request.QueryString["id"]);
idnum1.Value = Request.QueryString["id"].ToString();
StorageManageModel wr = new StorageManageModel();
DataTable dt = wr.LossiInforInfo(id);
Type1.Value = dt.Rows[0]["Type"].ToString();
Per1.Value = dt.Rows[0]["Per"].ToString();
Reason1.Value = dt.Rows[0]["Reason"].ToString();
lossnum1.Value = dt.Rows[0]["lossnum"].ToString();
Rmarkes1.Value = dt.Rows[0]["remark"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt16(Request.QueryString["id"]);
idnum1.Value = Request.QueryString["id"].ToString();
StorageManageModel wr = new StorageManageModel();
DataTable dt = wr.fdrugtoroomInfo(id);
Amount1.Value = dt.Rows[0]["num"].ToString();
Rmarkes1.Value = dt.Rows[0]["remark"].ToString();
ProDate1.Value = dt.Rows[0]["productdate"].ToString();
ExpiryDate1.Value = dt.Rows[0]["validedate"].ToString();
Quality1.Value = dt.Rows[0]["quality"].ToString();
LicenseNum1.Value = dt.Rows[0]["permitNo"].ToString();
}
}
public static string lossiInforInfo(int id, string Type, string Per, string Reason, string lossnum, string Rmarkes)
{
StorageManageModel wr = new StorageManageModel();
int result = wr.LossiInforInfo(id, Type, Per, Reason, lossnum, Rmarkes);
string str = null;
if (result == 0)
{
str = "0";
}
else
{
str = "1";
}
return(str);
}
public static string StorageInfo(int id, string Warehouse, string Amount, string Rmarkes, string ProDate, string ExpiryDate, string Quality, string LicenseNum, string OSingle, string OSTime, string Warehousing)
{
StorageManageModel wr = new StorageManageModel();
int result = wr.StoragequeryInfo(id, Warehouse, Amount, Rmarkes, ProDate, ExpiryDate, Quality, LicenseNum, OSingle, OSTime, Warehousing);
string str = null;
if (result == 0)
{
str = "0";
}
else
{
str = "1";
}
return(str);
}
protected void ExportStoreHouse_Click(object sender, EventArgs e)
{
string STime = STimeL.Value;
string ETime = ETimeL.Value;
string Warehousing = Warehousing1.Value;
string DrugName = DrugName1.Value;
StorageManageModel rm = new StorageManageModel();
DataTable dt = rm.findStorageListInfo1(STime, ETime, Warehousing, DrugName);
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string now = currentTime.ToString("yyyyMMdd");
CreateExcel(dt, "application/ms-excel", "调拨列表信息" + now);
}
public static string StorageListInfo(int id, string Amount, string Rmarkes, string ProDate, string ExpiryDate, string Quality, string LicenseNum)
{
StorageManageModel wr = new StorageManageModel();
int result = wr.StorageInfo(id, Amount, Rmarkes, ProDate, ExpiryDate, Quality, LicenseNum);
string str = null;
if (result == 0)
{
str = "0";
}
else
{
str = "1";
}
return(str);
}
public static string getproductbatchbyid(string fromid)
{
/* int result = 0;
* string[] strRowsId = strRowIds.Split(',');
*
* for (int i = 0; i < strRowsId.Length; i++)
* {
*
* StorageManageModel smm = new StorageManageModel();
* result = smm.AddStorage(strRowsId[i].ToString(), Warehouse1, intoman, OSingle1, OSTime1);
*
* }
*/
StorageManageModel smm = new StorageManageModel();
string sr = smm.findproductbatchbyfromiddrug(fromid);
return(sr);
}
public static string deleteStorageById(string strRowIds)
{
string result = "";
int sdr = 0;
string[] strRowsId = strRowIds.Split(',');
for (int i = 0; i < strRowsId.Length; i++)
{
StorageManageModel rm = new StorageManageModel();
sdr = rm.deleteStoragequeryInfor(Convert.ToInt16(strRowsId[i]));
}
if (sdr == 0)
{
result = "0";
}
else
{
result = "1";
}
return(result);
}
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid3DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
StorageManageModel rm = new StorageManageModel();
string operatenum = "";
if (p.extParam.ContainsKey("operatenum"))
{
operatenum = p.extParam["operatenum"];
}
result.table = rm.findstoragefromdruginfobyopertatenum(operatenum);
return(result);
}
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid2DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
StorageManageModel rm = new StorageManageModel();
string LSTime = "";
if (p.extParam.ContainsKey("LSTime"))
{
LSTime = p.extParam["LSTime"];
}
string LETime = "";
if (p.extParam.ContainsKey("LETime"))
{
LETime = p.extParam["LETime"];
}
string Warehousing = "";
if (p.extParam.ContainsKey("Warehousing"))
{
Warehousing = p.extParam["Warehousing"];
}
string DrugName = "";
if (p.extParam.ContainsKey("DrugName"))
{
DrugName = p.extParam["DrugName"];
}
result.table = rm.findStorageListInfo1(LSTime, LETime, Warehousing, DrugName);
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
WarehousepharmacyModel hm = new WarehousepharmacyModel();
SqlDataReader sdr = hm.findWarehouseInfo();
if (sdr != null)
{
while (sdr.Read())
{
this.Warehouse12.Items.Add(new ListItem(sdr["WName"].ToString()));
}
}
}
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt16(Request.QueryString["id"]);
idnum1.Value = Request.QueryString["id"].ToString();
StorageManageModel wr = new StorageManageModel();
DataTable dt = wr.findStorageListInfo(id);
Warehouse12.Value = dt.Rows[0]["Warehouse"].ToString();
Amount1.Value = dt.Rows[0]["Amount"].ToString();
Rmarkes1.Value = dt.Rows[0]["Rmarkes"].ToString();
ProDate1.Value = dt.Rows[0]["ProDate"].ToString();
ExpiryDate1.Value = dt.Rows[0]["ExpiryDate"].ToString();
Quality1.Value = dt.Rows[0]["Quality"].ToString();
LicenseNum1.Value = dt.Rows[0]["LicenseNum"].ToString();
OSingle12.Value = dt.Rows[0]["OSingle"].ToString();
OSTime1.Value = dt.Rows[0]["OSTime"].ToString();
Warehousing12.Value = dt.Rows[0]["Warehousing"].ToString();
}
}
} //提供数据的方法
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
StorageManageModel rm = new StorageManageModel();
var DrugName = "";
if (p.extParam.ContainsKey("DrugName"))
{
DrugName = p.extParam["DrugName"];
}
string Warehouse = "";
if (p.extParam.ContainsKey("Warehouse"))
{
Warehouse = p.extParam["Warehouse"];
}
//int pageSize = p.rp;
// result.table = rm.finInventoryInfor(DrugName, Warehouse);
//result.table = dotNetFlexGrid.DemoMemoryTable(p.page * 100, p.rp);//调用演示的数据生成函数产生模拟数据
if (DrugName == "" || DrugName == "0")
{
DrugName = "0";
}
if (Warehouse == "" || Warehouse == "0")
{
Warehouse = "0";
}
result.table = rm.druginventory(DrugName, Warehouse);
dotNetFlexGrid.FieldFormatorHandle proc3 = delegate(DataRow dr)
{
string ActualCapacity = "";
if (dr["ActualCapacity"].ToString() == "0")
{
return(ActualCapacity = dr["kucun"].ToString());
}
else
{
return(dr["ActualCapacity"].ToString());
}
};
dotNetFlexGrid.FieldFormatorHandle proc4 = delegate(DataRow dr)
{
if (dr["ActualCapacity"].ToString() == "0")
{
return("0");
}
else
{
int a = Convert.ToInt32(dr["kucun"].ToString()) - Convert.ToInt32(dr["ActualCapacity"].ToString());
if (a < 0)
{
a = -a;
}
return(a.ToString());
}
};
//result.FieldFormator.Register("famount", proc6);
//result.FieldFormator.Register("iamount", proc5);
result.FieldFormator.Register("ActualCapacity", proc3);
result.FieldFormator.Register("chazhi", proc4);
return(result);
}
