/// <summary>
/// 获取下拉框数据
/// 作者：章建国
/// </summary>
/// <returns></returns>
public static SelectList GetDropDownList(int id, string firstItem)
{
tb_BaseBLL _basebll = new tb_BaseBLL();
List <SelectListItem> list = new List <SelectListItem>();
try
{
list.Add(new SelectListItem()
{
Text = firstItem, Value = "-1", Selected = true
});
foreach (var item in _basebll.GetModelList(" pId = " + id))
{
list.Add(new SelectListItem()
{
Text = item.baseName, Value = item.id.ToString()
});
}
}
catch
{
}
return(new SelectList(list, "Value", "Text"));
}
/// <summary>
/// 获取所有数据列表
/// 作者：章建国
/// </summary>
/// <returns>将DataTable转换为Json数据格式通过string类型返回</returns>
public string GetBorrwList(int pageNumber, int pageSize, string _search, string _searchtype, int _cid)
{
DataTable dt = new DataTable();
int total = 0;
try
{
string where = " 1 = 1";
if (!string.IsNullOrEmpty(_search))
{
switch (_searchtype)
{
case "bianhao":
where = " code like '%%" + _search + "%%'";
break;
case "mingchen":
where = " bookName like '%%" + _search + "%%'";
break;
case "zhongshu":
var zhongshujihe = _basebll.GetModelList(" where pId = 10");
if (zhongshujihe != null && zhongshujihe.Count > 0)
{
zhongshujihe = zhongshujihe.Where(w => w.baseName.Contains(_search)).ToList();
where = " type1 = " + zhongshujihe.First().id;
}
break;
case "leibie":
var leibiejihe = _basebll.GetModelList(" where pId = 13");
if (leibiejihe != null && leibiejihe.Count > 0)
{
leibiejihe = leibiejihe.Where(w => w.baseName.Contains(_search)).ToList();
where = " type2 = " + leibiejihe.First().id;
}
break;
case "zuozhe":
where = " author like '%%" + _search + "%%'";
break;
case "zhuangtai":
var zhuangtaijihe = _basebll.GetModelList(" where pId = 13");
if (zhuangtaijihe != null && zhuangtaijihe.Count > 0)
{
zhuangtaijihe = zhuangtaijihe.Where(w => w.baseName.Contains(_search)).ToList();
where = " status = " + zhuangtaijihe.First().id;
}
break;
case "chubanshe":
where = " press like '%%" + _search + "%%'";
break;
case "jieyueren":
where = " name like '%%" + _search + "%%'";
break;
case "jieyueriqi":
where = string.Format(" and convert(char(8), borrowDate, 112) like '%%{0}%%'", _search);
break;
case "guihuanriqi":
where = string.Format(" and convert(char(8), backDate, 112) like '%%{0}%%'", _search);
break;
}
}
if (_cid > 0 && CurrentUserInfo.DataRange == 3)
{
int _userid = CurrentUserInfo.PersonnelID;
where += string.Format(" and CreateUser = (select PersonnelID from tb_InPersonnel where AreaID = {0} and PersonnelID = {1}) ", _cid, _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);
}
dt = _bookborrowbll.GetListByPage(where, "updateDate", pageNumber * pageSize - (pageSize - 1), pageNumber * pageSize).Tables[0];
total = dt.Rows.Count;
total = _bookborrowbll.GetModelList(where).Count;
}
catch { }
return(PublicClass.ToJson(dt, total));
}