/// <summary>
/// 读取人事列表
/// </summary>
/// <param name="prmWhere">SQL条件</param>
/// <returns></returns>
public List<StaffInfo> listUserInfo(string prmWhere)
{
List<StaffInfo> lists = new List<StaffInfo>();
NBear.Common.WhereClip _where = new NBear.Common.WhereClip(prmWhere, null, null, null);
where = StaffInfo._.Id > 0 & _where;
lists.AddRange(db.FindArray<StaffInfo>(where));
return lists;
}
public List<AccessoriesList> listAcces(string prmWhere)
{
List<AccessoriesList> lists = new List<AccessoriesList>();
NBear.Common.WhereClip _where = new NBear.Common.WhereClip(prmWhere, null, null, null);
where = AccessoriesList._.AccessoriesCD > 0 & _where;
orderby = AccessoriesList._.AccessoriesCD.Desc;
lists.AddRange(db.FindArray<AccessoriesList>(where, orderby));
return lists;
}
/// <summary>
/// 分页列表--带条件
/// </summary>
/// <param name="prmPageindex"></param>
/// <param name="prmPagesize"></param>
/// <param name="prmPagecount"></param>
/// <param name="prmRecordcount"></param>
/// <param name="prmWhere"></param>
/// <returns></returns>
public List<FlowLog> listFlowLog(int prmPageindex, int prmPagesize, out int prmPagecount, out int prmRecordcount, string prmWhere)
{
List<FlowLog> lists = new List<FlowLog>();
NBear.Common.WhereClip _where = new NBear.Common.WhereClip(prmWhere, null, null, null);
where = FlowLog._.fgID > 0 & _where;
orderby = FlowLog._.fgOrder.Asc;
PageSelector<FlowLog> pages = db.GetPageSelector<FlowLog>(where, orderby, prmPagesize);
prmPagecount = pages.PageCount;
prmRecordcount = pages.RowCount;
lists.AddRange(db.From<FlowLog>().Where(where).OrderBy(orderby).ToArray<FlowLog>(prmPagesize, prmPagesize * (prmPageindex - 1)));
return lists;
}
/// <summary>
/// 按条件获取最大编号ID
/// </summary>
/// <param name="prmWhere"></param>
/// <returns></returns>
public int getMaxFlow(string prmWhere)
{
int iMax = 0;
NBear.Common.WhereClip _where = new NBear.Common.WhereClip(prmWhere, null, null, null);
where = FlowLog._.fgID > 0 & _where;
object oMax = db.Max<FlowLog>(where, FlowLog._.fgOrder);
if (oMax != null)
{
int.TryParse(oMax.ToString(), out iMax);
}
return iMax;
}
/// <summary>
/// ��ҳ�б�--������
/// </summary>
/// <param name="prmPageindex"></param>
/// <param name="prmPagesize"></param>
/// <param name="prmPagecount"></param>
/// <param name="prmRecordcount"></param>
/// <param name="prmWhere"></param>
/// <returns></returns>
public List<AccessoriesList> listAcces(int prmPageindex, int prmPagesize, out int prmPagecount, out int prmRecordcount, string prmWhere)
{
List<AccessoriesList> lists = new List<AccessoriesList>();
NBear.Common.WhereClip _where = new NBear.Common.WhereClip(prmWhere, null, null, null);
where = AccessoriesList._.AccessoriesCD > 0 & _where;
orderby = AccessoriesList._.AccessoriesCD.Desc;
PageSelector<AccessoriesList> pages = db.GetPageSelector<AccessoriesList>(where, orderby, prmPagesize);
prmPagecount = pages.PageCount;
prmRecordcount = pages.RowCount;
lists.AddRange(db.From<AccessoriesList>().Where(where).OrderBy(orderby).ToArray<AccessoriesList>(prmPagesize, prmPagesize * (prmPageindex - 1)));
return lists;
}
/// <summary>
/// 分页列表--带条件
/// </summary>
/// <param name="prmPageindex"></param>
/// <param name="prmPagesize"></param>
/// <param name="prmPagecount"></param>
/// <param name="prmRecordcount"></param>
/// <param name="prmWhere"></param>
/// <returns></returns>
public List<meetingnotice> listMeetingNotice(int prmPageindex, int prmPagesize, out int prmPagecount, out int prmRecordcount, string prmWhere)
{
List<meetingnotice> lists = new List<meetingnotice>();
NBear.Common.WhereClip _where = new NBear.Common.WhereClip(prmWhere, null, null, null);
where = meetingnotice._.mnID > 0 & _where;
orderby = meetingnotice._.mnID.Desc;
PageSelector<meetingnotice> pages = db.GetPageSelector<meetingnotice>(where, orderby, prmPagesize);
prmPagecount = pages.PageCount;
prmRecordcount = pages.RowCount;
lists.AddRange(db.From<meetingnotice>().Where(where).OrderBy(orderby).ToArray<meetingnotice>(prmPagesize, prmPagesize * (prmPageindex - 1)));
return lists;
}
/// <summary>
/// 分页列表--带条件
/// </summary>
/// <param name="prmPageindex"></param>
/// <param name="prmPagesize"></param>
/// <param name="prmPagecount"></param>
/// <param name="prmRecordcount"></param>
/// <param name="prmWhere"></param>
/// <returns></returns>
public List<InceptDoc> listIncept(int prmPageindex, int prmPagesize, out int prmPagecount, out int prmRecordcount, string prmWhere)
{
List<InceptDoc> lists = new List<InceptDoc>();
NBear.Common.WhereClip _where = new NBear.Common.WhereClip(prmWhere, null, null, null);
where = InceptDoc._.idID > 0 & _where;
orderby = InceptDoc._.idID.Desc;
PageSelector<InceptDoc> pages = db.GetPageSelector<InceptDoc>(where, orderby, prmPagesize);
prmPagecount = pages.PageCount;
prmRecordcount = pages.RowCount;
lists.AddRange(db.From<InceptDoc>().Where(where).OrderBy(orderby).ToArray<InceptDoc>(prmPagesize, prmPagesize * (prmPageindex - 1)));
return lists;
}
/// <summary>
/// 按条件获取最大编号ID
/// </summary>
/// <param name="prmWhere"></param>
/// <returns></returns>
public int getMaxFlow(string prmWhere)
{
int iMax = 0;
NBear.Common.WhereClip _where = new NBear.Common.WhereClip(prmWhere, null, null, null);
where = flowlist._.flID > 0 & _where;
object oMax = db.Max<flowlist>(where, flowlist._.flNum);
if (oMax != null)
{
int.TryParse(oMax.ToString(), out iMax);
}
return iMax;
}
/// <summary>
/// 条件查找
/// </summary>
/// <param name="prmWhere">SQL条件</param>
/// <returns></returns>
public flowlist getFlowbyWhere(string prmWhere)
{
NBear.Common.WhereClip _where = new NBear.Common.WhereClip(prmWhere, null, null, null);
where = flowlist._.flID > 0 & _where;
return db.Find<flowlist>(where);
}
