/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
public DataTable GetEasyConsumeLogListByPage(Model.PersonnelManage.E_tb_InPersonnel CurrentUserInfo, int _cid, string _searchtext, string orderby, int startIndex, int endIndex, string _searchtext2)
{
String where2 = "";
if (!String.IsNullOrEmpty(_searchtext2))
{
where2 = " name like '%%" + _searchtext2 + "%%'";
}
DataTable dt = dal.GetListByPage(where2, orderby, startIndex, endIndex).Tables[0];
tb_EasyConsumeOUTBLL _outbll = new tb_EasyConsumeOUTBLL();
tb_EasyConsumeINBLL _inbll = new tb_EasyConsumeINBLL();
dt.Columns.Add("ruku");
dt.Columns.Add("chuku");
for (int i = 0; i < dt.Rows.Count; i++)
{
int eid = Convert.ToInt32(dt.Rows[i]["id"]);
string where = " 1 = 1 ";
if (!string.IsNullOrEmpty(_searchtext))
{
where += string.Format(" and (cast(OutDate as datetime)) = '{0}' ", _searchtext);
}
if (CurrentUserInfo.DataRange == 3)
{
int _userid = CurrentUserInfo.PersonnelID;
where += string.Format(" and createUser = (select PersonnelID from tb_InPersonnel where AreaID = {0} and PersonnelID = {1}) ", CurrentUserInfo.AreaID.Value, _userid);
}
else if (_cid > 0 || CurrentUserInfo.DataRange == 2)
{
int _userid = CurrentUserInfo.PersonnelID;
where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", _cid);
}
where += " and eid=" + eid;
DataTable dtout = _outbll.GetEasyCOnsumeOUTSUMForLog(where);
if (dtout != null && dtout.Rows.Count > 0)
{
int inid = Convert.ToInt32(dtout.Rows[0]["temp2"]);
tb_EasyConsumeIN inmodel = _inbll.GetModel(inid);
dt.Rows[i]["chuku"] = dtout.Rows[0]["chuku"];
dt.Rows[i]["ruku"] = inmodel.amount;
dt.Rows[i]["amount"] = inmodel.temp2;
}
}
return(dt);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
public DataTable GetDrugForCheckByInAndOut(DateTime _sDate, DateTime _eDate, int _cid, string _auditstatus, string whereInPersonnel, Model.PersonnelManage.E_tb_InPersonnel _user, string _searchtext2)
{
try
{
string sql = "";
sql += string.Format(@" outDate BETWEEN '{0}' and '{1}' and temp1='通过' ", _sDate.ToShortDateString(), _eDate.ToShortDateString());
int _userid = _user.PersonnelID;
if (_user.DataRange == 3)
{
sql += string.Format(" and createUser = (select PersonnelID from tb_InPersonnel where AreaID = {0} and PersonnelID = {1}) ", _cid, _userid);
}
else if (_cid > 0 || _user.DataRange == 2)
{
sql += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", _cid);
}
var outlist = new tb_DrugOUTBLL().GetModelList(sql);
//DataSet ds = dal.GetDrugForCheckByInAndOut(_sDate, _eDate, _cid, _auditstatus, whereInPersonnel);
string where = string.Format(" outDate BETWEEN '{0}' and '{1}' ", _sDate.ToShortDateString(), _eDate.ToShortDateString());
where += whereInPersonnel;
if (outlist != null && outlist.Count > 0)
{
tb_DrugINBLL _druginbll = new tb_DrugINBLL();
tb_DrugBLL _drugbll = new tb_DrugBLL();
tb_BaseBLL _basebll = new tb_BaseBLL();
List <tb_DrugCheck> listcheck = GetModelList(where);
for (int i = 0; i < outlist.Count; i++)
{
tb_DrugOUT drugout = outlist[i];
int druginid = Convert.ToInt32(drugout.temp2);
var templist = listcheck.Where(w => w.drugId.Value == drugout.drugId && w.drugInId.Value == druginid && w.drugOutId.Value == drugout.id);
if (templist == null || templist.Count() == 0)
{
try
{
tb_DrugIN drugin = _druginbll.GetModel(druginid);
tb_DrugCheck model = new tb_DrugCheck();
model.amount = Convert.ToInt32(drugin.temp2);
model.amountIN = Convert.ToInt32(drugin.amount);
model.amountOUT = Convert.ToInt32(drugout.amount);
model.auditstatus = "未审核";
model.drugCode = drugout.drugCode;
model.drugId = drugout.drugId;
model.drugInId = drugin.id;
tb_Drug drug = _drugbll.GetModel(drugout.drugId.Value);
model.drugName = drug.drugName;
model.drugOutId = drugout.id;
model.isDelete = false;
model.outDate = drugout.outDate;
model.riskLevel = _basebll.GetModel(Convert.ToInt32(drug.riskLevel)).baseName;
model.unit = _basebll.GetModel(drug.unit.Value).baseName;
model.createUser = _user.PersonnelID;
model.createDate = DateTime.Now;
model.updateUser = _user.PersonnelID;
model.updateDate = DateTime.Now;
Add(model);
}
catch
{
continue;
}
}
}
}
where += "and auditstatus = '" + _auditstatus + "' ";
if (!String.IsNullOrEmpty(_searchtext2))
{
where += "and drugName like '%%" + _searchtext2 + "%%' ";
}
return(GetList(where).Tables[0]);
}
catch
{
return(new DataTable());
}
}
