/// <summary>
/// get chaxun
/// </summary>
/// <returns></returns>
EyouSoft.Model.MYongHuJueSeChaXunInfo GetChaXunInfo()
{
var info = new EyouSoft.Model.MYongHuJueSeChaXunInfo();
info.GongSiId = YongHuInfo.GongSiId;
info.Name = Utils.GetQueryStringValue("txtName");
return(info);
}
/// <summary>
/// init juese
/// </summary>
void InitJueSe()
{
var chaXun = new EyouSoft.Model.MYongHuJueSeChaXunInfo();
chaXun.GongSiId = YongHuInfo.GongSiId;
StringBuilder s = new StringBuilder();
var items = new EyouSoft.BLL.BYongHuJueSe().GetJueSes(chaXun);
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
s.AppendFormat("<option value=\"{0}\">{1}</option>", item.JueSeId, item.Name);
}
}
ltrJueSe.Text = s.ToString();
}
/// <summary>
/// 获取角色信息集合
/// </summary>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MYongHuJueSeInfo> GetJueSes(EyouSoft.Model.MYongHuJueSeChaXunInfo chaXun)
{
int recordCount = 0;
return(GetJueSes(1000, 1, ref recordCount, chaXun));
}
/// <summary>
/// 获取角色信息集合
/// </summary>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MYongHuJueSeInfo> GetJueSes(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MYongHuJueSeChaXunInfo chaXun)
{
IList <EyouSoft.Model.MYongHuJueSeInfo> items = new List <EyouSoft.Model.MYongHuJueSeInfo>();
string fields = "*";
StringBuilder sql = new StringBuilder();
string tableName = "tbl_YongHuJueSe";
string orderByString = " IssueTime DESC ";
string heJiString = "";
#region sql
sql.Append(" 1=1 ");
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.Name))
{
sql.AppendFormat(" AND Name LIKE '%{0}%' ", chaXun.Name);
}
if (!string.IsNullOrEmpty(chaXun.GongSiId))
{
sql.AppendFormat(" AND GongSiId='{0}' ", chaXun.GongSiId);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, sql.ToString(), orderByString, heJiString))
{
while (rdr.Read())
{
var info = new EyouSoft.Model.MYongHuJueSeInfo();
info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString();
info.GongSiId = rdr["GongSiId"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.JueSeId = rdr["JueSeId"].ToString();
info.MiaoShu = rdr["MiaoShu"].ToString();
info.Name = rdr["Name"].ToString();
info.Privs = Utils.Split2(rdr["Privs"].ToString(), ",");
info.Status = (EyouSoft.Model.YongHuJueSeStatus)rdr.GetInt32(rdr.GetOrdinal("Status"));
items.Add(info);
}
}
return(items);
}
/// <summary>
/// 获取角色信息集合
/// </summary>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MYongHuJueSeInfo> GetJueSes(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MYongHuJueSeChaXunInfo chaXun)
{
if (pageSize <= 0)
{
pageSize = 1;
}
if (pageIndex <= 0)
{
pageIndex = 1;
}
var items = dal.GetJueSes(pageSize, pageIndex, ref recordCount, chaXun);
return(items);
}
