protected void ExportMedicinelossiInfor_Click(object sender, EventArgs e)
{
string type = Type.Value;
LossiModel hm1 = new LossiModel();
// DataBaseLayer db = new DataBaseLayer();
// string str = "select * from lossiInfor where type ='" + type + "'";
DataTable dt = hm1.finMedicineLossiInfor(type);
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string now = currentTime.ToString("yyyyMMdd");
CreateExcel(dt, "application/ms-excel", "药方报损信息" + now);
}
public static string getNumByDeugName(string DeugName)
{
string result = "";
LossiModel whm = new LossiModel();
SqlDataReader sdr = whm.findDeugNameNum(DeugName);
if (sdr.Read())
{
result = sdr["DrugCode"].ToString();
}
return(result);
}
public static string getNumByWarehouse(string Warehouse)
{
string result = "";
LossiModel whm = new LossiModel();
SqlDataReader sdr = whm.findWarehouseNum(Warehouse);
//SqlDataReader sdr1 = whm.findDeugName(Warehouse);
if (sdr.Read())
{
result = sdr["WareNum"].ToString();
}
return(result);
}
public static string MedicineLossiInforGet(string fromid, string drugnum, string losstype, string Per, string Reason, string Rmarkes, string lossnum)
{
LossiModel wr = new LossiModel();
int result = wr.GetMedicineLossiInfo(fromid, drugnum, losstype, Per, Reason, Rmarkes, lossnum);
string str = null;
if (result == 0)
{
str = "0";
}
else
{
str = "1";
}
return(str);
}
public static string addLossiInfor(string fromid, string drugnum, string losstype, string Per, string Reason, string Rmarkes, string lossnum)
{
string result = "";
LossiModel hm1 = new LossiModel();
int sdr = hm1.LossiInforAdd(fromid, drugnum, losstype, Per, Reason, Rmarkes, lossnum);
if (sdr == 0)
{
result = "0";
}
else
{
result = "1";
}
return(result);
}
} //提供数据的方法
public dotNetFlexGrid.DataHandlerResult DotNetFlexGrid1DataHandler(dotNetFlexGrid.DataHandlerParams p)
{
dotNetFlexGrid.DataHandlerResult result = new dotNetFlexGrid.DataHandlerResult();
result.page = p.page; //设定当前返回的页号
result.total = 100; //总计的数据条数，此处用100进行模拟，查询和筛选时需要根据实际
LossiModel hm1 = new LossiModel();
var Type = "";
if (p.extParam.ContainsKey("Type"))
{
Type = p.extParam["Type"];
}
int pageSize = p.rp;
result.table = hm1.finMedicineLossiInfor(Type);
return(result);
}
