private string getsysCate(int typeId)
{
StringBuilder sb = new StringBuilder();
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_SysCate scate = new SqlDb.Dcms_SysCate();
List <int> rangeId = new List <int>(new int[] { 1, 4, 7, 8 });
IQuery Query = session.GetQuery(scate).Where(SqlDb.Dcms_SysCate._SYSCATE_TYPE_.EqulesExp(typeId).AND(SqlDb.Dcms_SysCate._SYSCATE_ID_.NotIn(rangeId))).OrderBy(SqlDb.Dcms_SysCate._SYSCATE_ORDER_, Direction.ASC);
List <SqlDb.Dcms_SysCate> scateList = Query.GetList <SqlDb.Dcms_SysCate>();
for (int i = 0; i < scateList.Count; i++)
{
sb.Append("<tr class='trlinebg'>\n<td height='25'> </td>\n");
sb.Append(string.Format("<td>{0}</td>\n", scateList[i].SysCate_Name));
sb.Append("<td> </td>\n");
sb.Append(string.Format("<td><input type='checkbox' value='-{0}' class='chkbox' name='select' /></td>\n", scateList[i].SysCate_Id));
sb.Append(string.Format("<td><input type='checkbox' value='-{0}' class='chkbox' name='insert' /></td>\n", scateList[i].SysCate_Id));
sb.Append(string.Format("<td><input type='checkbox' value='-{0}' class='chkbox' name='update' /></td>\n", scateList[i].SysCate_Id));
sb.Append(string.Format("<td><input type='checkbox' value='-{0}' class='chkbox' name='delete' /></td>\n", scateList[i].SysCate_Id));
sb.Append("<td> </td>\n</tr>\n");
}
}
return(sb.ToString());
}
private string getsysCate(int typeId)
{
StringBuilder sb = new StringBuilder();
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_SysCate scate = new SqlDb.Dcms_SysCate();
List<int> rangeId = new List<int>(new int[] { 1, 4, 7, 8 });
IQuery Query = session.GetQuery(scate).Where(SqlDb.Dcms_SysCate._SYSCATE_TYPE_.EqulesExp(typeId).AND(SqlDb.Dcms_SysCate._SYSCATE_ID_.NotIn(rangeId))).OrderBy(SqlDb.Dcms_SysCate._SYSCATE_ORDER_, Direction.ASC);
List<SqlDb.Dcms_SysCate> scateList = Query.GetList<SqlDb.Dcms_SysCate>();
for (int i = 0; i < scateList.Count; i++)
{
sb.Append("<tr class='trlinebg'>\n<td height='25'> </td>\n");
sb.Append(string.Format("<td>{0}</td>\n", scateList[i].SysCate_Name));
sb.Append("<td> </td>\n");
sb.Append(string.Format("<td><input type='checkbox' value='-{0}' class='chkbox' name='select' /></td>\n", scateList[i].SysCate_Id));
sb.Append(string.Format("<td><input type='checkbox' value='-{0}' class='chkbox' name='insert' /></td>\n", scateList[i].SysCate_Id));
sb.Append(string.Format("<td><input type='checkbox' value='-{0}' class='chkbox' name='update' /></td>\n", scateList[i].SysCate_Id));
sb.Append(string.Format("<td><input type='checkbox' value='-{0}' class='chkbox' name='delete' /></td>\n", scateList[i].SysCate_Id));
sb.Append("<td> </td>\n</tr>\n");
}
}
return sb.ToString();
}
