/// <summary>
/// 获取区域（实验室、单位）数据
/// 作者：章建国
/// </summary>
/// <param name="id"></param>
/// <param name="firstItem"></param>
/// <returns></returns>
public static List <SelectListItem> GetAreaList(string firstItem, int _areaid)
{
BLL.RoleManage.T_tb_Area _area = new BLL.RoleManage.T_tb_Area();
List <SelectListItem> list = new List <SelectListItem>();
try
{
list.Add(new SelectListItem()
{
Text = firstItem, Value = "-1", Selected = false
});
foreach (var item in _area.GetModelList(""))
{
SelectListItem sli = new SelectListItem()
{
Text = item.AreaName, Value = item.AreaID.ToString(), Selected = false
};
if (_areaid == item.AreaID)
{
sli.Selected = true;
}
list.Add(sli);
}
}
catch
{
}
return(list);
}
public System.Collections.ArrayList GetDrugNameChar(DateTime _datetime, string _dateType, string _cids, string _rid, string _drugid)
{
try
{
System.Collections.ArrayList al = new System.Collections.ArrayList();
DataSet ds = dal.GetDrugOutForReport(_datetime, _dateType, _cids, _rid, _drugid);
if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
BLL.RoleManage.T_tb_Area _areaDAL = new BLL.RoleManage.T_tb_Area();
var __laboratoryList = _areaDAL.GetModelList(" AreaID in (" + _cids + ")");
var _list = (from dt1 in ds.Tables[0].AsEnumerable()
select new
{
drugName = dt1.Field <string>("drugName")
}).ToList();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
al.Add(dr["drugName"].ToString());
}
}
return(al);
}
catch
{
return(new System.Collections.ArrayList());
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 获取未选择权限的用户列表
/// 作者：章建国
/// </summary>
/// <param name="_fid"></param>
/// <returns></returns>
public DataTable GetUNSelectList(string _fid, int _userid)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("userORgroup"));
dt.Columns.Add(new DataColumn("id"));
dt.Columns.Add(new DataColumn("limittype"));
dt.Columns.Add(new DataColumn("areaid"));
var limitList = GetModelList(" fileId = " + _fid);
if (limitList != null && limitList.Count > 0)
{
string userids = "";
string areaids = "";
foreach (var item in limitList)
{
switch (item.limitType)
{
case "用户":
userids += item.limitId + ",";
break;
case "用户组":
areaids += item.limitId + ",";
break;
}
}
userids = !string.IsNullOrEmpty(userids) ? " PersonnelID not in (" + userids.Substring(0, userids.Length - 1) + "," + _userid + ")" : "PersonnelID <> " + _userid;
areaids = !string.IsNullOrEmpty(areaids) ? " AreaID not in (" + areaids.Substring(0, areaids.Length - 1) + ")" : "";
var inpersonlist = new BLL.PersonnelManage.T_tb_InPersonnel().GetModelList(userids);
var areaList = new BLL.RoleManage.T_tb_Area().GetModelList(areaids);
dt = GetUNSelectResultDataTable(dt, inpersonlist, areaList);
}
else
{
var inpersonlist = new BLL.PersonnelManage.T_tb_InPersonnel().GetModelList(" PersonnelID <> " + _userid);
var areaList = new BLL.RoleManage.T_tb_Area().GetModelList("");
dt = GetUNSelectResultDataTable(dt, inpersonlist, areaList);
}
return(dt);
}
catch
{
return(new DataTable());
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
#endregion ExtensionMethod
#region 药品统计
/// <summary>
/// 药品统计
/// </summary>
/// <param name="_date">日期</param>
/// <param name="_datetype">日期类型（年或月）</param>
/// <param name="_compayid">单位ID</param>
/// <param name="_riskid">危险性等级</param>
/// <returns></returns>
public Dictionary <string, decimal[]> GetDrugOutForCharReport(DateTime _date, string _datetype, string _compayid, string _riskid, string _drugid)
{
try
{
Dictionary <string, decimal[]> retVal = new Dictionary <string, decimal[]>();
DataSet ds = dal.GetDrugOutForReport(_date, _datetype, _compayid, _riskid, _drugid);
if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
BLL.RoleManage.T_tb_Area _areaDAL = new BLL.RoleManage.T_tb_Area();
var __laboratoryList = _areaDAL.GetModelList(" AreaID in (" + _compayid + ")");
var _list = (from dt1 in ds.Tables[0].AsEnumerable()
select new
{
amount = dt1.Field <decimal>("amount"),
drugName = dt1.Field <string>("drugName"),
ruku = dt1.Field <decimal>("ruku"),
chuku = dt1.Field <decimal>("chuku"),
LaboratoryName = dt1.Field <string>("AreaName")
}).ToList();
decimal[] total = new decimal[_list.Count];
decimal[] ruku = new decimal[_list.Count];
decimal[] chuku = new decimal[_list.Count];
for (int i = 0; i < _list.Count; i++)
{
var item = _list[i];
total[i] = item.amount;
ruku[i] = item.ruku;
chuku[i] = item.chuku;
}
retVal.Add("库存", total);
retVal.Add("出库", chuku);
retVal.Add("入库", ruku);
}
return(retVal);
}
catch
{
return(new Dictionary <string, decimal[]>());
}
}
/// <summary>
/// 获取区域（实验室、单位）数据
/// 作者：章建国
/// </summary>
/// <param name="id"></param>
/// <param name="firstItem"></param>
/// <returns></returns>
public static SelectList GetAreaList(string firstItem)
{
BLL.RoleManage.T_tb_Area _area = new BLL.RoleManage.T_tb_Area();
List <SelectListItem> list = new List <SelectListItem>();
try
{
list.Add(new SelectListItem()
{
Text = firstItem, Value = "-1", Selected = true
});
foreach (var item in _area.GetModelList(""))
{
list.Add(new SelectListItem()
{
Text = item.AreaName, Value = item.AreaID.ToString()
});
}
}
catch
{
}
return(new SelectList(list, "Value", "Text"));
}
/// <summary>
/// 跳转页面
/// 作者：章建国
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult doSampleInfo(int id)
{
ViewBag._PersonnelName = CurrentUserInfo.PersonnelName;
BLL.RoleManage.T_tb_Area _area = new BLL.RoleManage.T_tb_Area();
String _areaname = _area.GetModel(CurrentUserInfo.AreaID.Value).AreaName;
switch (_areaname)
{
case "食品检测中心":
{
_areaname = "JC";
break;
}
case "葫芦岛实验室":
{
_areaname = "HL";
break;
}
case "深圳实验室":
{
_areaname = "SZ";
break;
}
case "湛江实验室":
{
_areaname = "ZJ";
break;
}
case "龙口实验室":
{
_areaname = "LK";
break;
}
case "烹饪加工营养项目":
{
_areaname = "PR";
break;
}
case "原料食品安全项目":
{
_areaname = "YL";
break;
}
default:
{
_areaname = "";
break;
}
}
tb_Sample model = new tb_Sample();
if (id == 0)
{
model.sampleNum = DateTime.Now.ToShortDateString();
var list = _samplebll.GetModelList("DATEDIFF(day , createDate, '" + DateTime.Now.ToShortDateString() + "')=0 and createUser in (select PersonnelID from tb_InPersonnel where AreaID = " + CurrentUserInfo.AreaID + ")");
if (list != null && list.Count > 0)
{
int count = list.Count + 1;
model.sampleNum = _areaname + DateTime.Now.ToString("yyyyMMdd") + "—" + count.ToString("D3");
}
else
{
model.sampleNum = _areaname + DateTime.Now.ToString("yyyyMMdd") + "—001";
}
return(View(model));
}
model = _samplebll.GetModel(id);
return(View(model));
}
