/// <summary>
/// 编辑一条数据
/// </summary>
/// <returns>"true"/"false"</returns>
private string doUpdate()
{
try
{
int id = IRequest.GetFormInt("QM_Id", 0);
string du = IRequest.GetFormString("du").ToLower();
int adminId = adminInfo.Admin_Id;
if (id > 0 && adminId > 0)
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_QMenu qmenu = new SqlDb.Dcms_QMenu();
qmenu.QMenu_AdminId = adminId;
IQuery query = session.GetQuery(qmenu).Where(SqlDb.Dcms_QMenu._QMENU_ADMINID_.EqulesExp()).OrderBy(SqlDb.Dcms_QMenu._QMENU_ORDER_, Direction.ASC);
List <SqlDb.Dcms_QMenu> qmenuList = query.GetList <SqlDb.Dcms_QMenu>();
int currentI = 0;
if (qmenuList.Count > 0)
{
for (int i = 0; i < qmenuList.Count; i++)
{
if (qmenuList[i].QMenu_Id == id)
{
currentI = i;
break;
}
}
}
if (du == "up")
{
qmenu = qmenuList[currentI - 1];
int currentOrder = qmenu.QMenu_Order;
qmenu.QMenu_Order = qmenuList[currentI].QMenu_Order;
//编辑上一条的记录
session.Update(qmenu);
qmenu = qmenuList[currentI];
qmenu.QMenu_Order = currentOrder;
//编辑当前的记录
session.Update(qmenu);
}
else
{
qmenu = qmenuList[currentI + 1];
int currentOrder = qmenu.QMenu_Order;
qmenu.QMenu_Order = qmenuList[currentI].QMenu_Order;
//编辑上一条的记录
session.Update(qmenu);
qmenu = qmenuList[currentI];
qmenu.QMenu_Order = currentOrder;
//编辑当前的记录
session.Update(qmenu);
}
}
}
return("true");
}
catch
{
return("false");
}
}
private string doSelect()
{
try
{
StringBuilder sb = new StringBuilder();
sb.Append("<table width=\"100%\" border=\"0\" cellspacing=\"0\" id=\"QMenuListTable\" cellpadding=\"0\">\n");
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_QMenu QMenu = new SqlDb.Dcms_QMenu();
QMenu.QMenu_AdminId = adminInfo.Admin_Id;
IQuery query = session.GetQuery(QMenu).Where(SqlDb.Dcms_QMenu._QMENU_ADMINID_.EqulesExp()).OrderBy(SqlDb.Dcms_QMenu._QMENU_ORDER_, Direction.ASC);
List <SqlDb.Dcms_QMenu> QMenuList = query.GetList <SqlDb.Dcms_QMenu>();
if (QMenuList.Count > 0)
{
for (int i = 0; i < QMenuList.Count; i++)
{
string bgstr = string.Empty;
if ((i + 1) % 2 == 0)
{
bgstr = "style=\"background-color:#F8FEF5;\"";
}
if ((i == 0) && (QMenuList.Count > 1))
{
sb.Append(string.Format("<tr {0}><td height=\"25\"> {1}</td>", bgstr, QMenuList[i].QMenu_Title));
sb.Append(string.Format("<td width=\"70\" ><div class=\"toporder\"></div><div class=\"downorder\" onclick=\"ajaxSubmi({0},'update','down')\"></div></td>", QMenuList[i].QMenu_Id));
sb.Append(string.Format("<td width=\"70\" ><div class=\"delqmenu\" onclick=\"ajaxSubmi({0},'delete','ud')\"></div></td></tr>\n", QMenuList[i].QMenu_Id));
}
else if ((i == (QMenuList.Count - 1)) && (QMenuList.Count > 1))
{
sb.Append(string.Format("<tr {0}><td height=\"25\"> {1}</td>", bgstr, QMenuList[i].QMenu_Title));
sb.Append(string.Format("<td width=\"70\" ><div class=\"uporder\" onclick=\"ajaxSubmi({0},'update','up')\"></div><div class=\"bottomorder\"></div></td>", QMenuList[i].QMenu_Id));
sb.Append(string.Format("<td width=\"70\" ><div class=\"delqmenu\" onclick=\"ajaxSubmi({0},'delete','ud')\"></div></td></tr>\n", QMenuList[i].QMenu_Id));
}
else if ((i == 0) && (i == (QMenuList.Count - 1)))
{
sb.Append(string.Format("<tr {0}><td height=\"25\"> {1}</td>", bgstr, QMenuList[i].QMenu_Title));
sb.Append(string.Format("<td width=\"70\" ><div class=\"toporder\"></div><div class=\"bottomorder\"></div></td>", QMenuList[i].QMenu_Id));
sb.Append(string.Format("<td width=\"70\" ><div class=\"delqmenu\" onclick=\"ajaxSubmi({0},'delete','ud')\"></div></td></tr>\n", QMenuList[i].QMenu_Id));
}
else
{
sb.Append(string.Format("<tr {0}><td height=\"25\"> {1}</td>", bgstr, QMenuList[i].QMenu_Title));
sb.Append(string.Format("<td width=\"70\" ><div class=\"uporder\" onclick=\"ajaxSubmi({0},'update','up')\"></div><div class=\"downorder\" onclick=\"ajaxSubmi({0},'update','down')\"></div></td>", QMenuList[i].QMenu_Id));
sb.Append(string.Format("<td width=\"70\" ><div class=\"delqmenu\" onclick=\"ajaxSubmi({0},'delete','ud')\"></div></td></tr>\n", QMenuList[i].QMenu_Id));
}
}
}
}
sb.Append("</table>\n");
return(sb.ToString());
}
catch
{
return("false");
}
}
private string getQMenu()
{
StringBuilder QMenuStr = new StringBuilder();
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_QMenu qmenu = new SqlDb.Dcms_QMenu();
qmenu.QMenu_AdminId = adminInfo.Admin_Id;
IQuery query = session.GetQuery(qmenu).Where(SqlDb.Dcms_QMenu._QMENU_ADMINID_.EqulesExp()).OrderBy(SqlDb.Dcms_QMenu._QMENU_ORDER_, Direction.ASC);
List <SqlDb.Dcms_QMenu> QMenuList = query.GetList <SqlDb.Dcms_QMenu>();
QMenuStr.Append(string.Format("<li onclick='javascript:changeViewClass();'> 切换栏目视图 </li>\n"));
for (int i = 0; i < QMenuList.Count; i++)
{
QMenuStr.Append(string.Format("<li onclick='javascript:checkState(this);'> <span dataType='iframe' dataLink='{0}'>{1}</span> </li>\n", QMenuList[i].QMenu_Url, QMenuList[i].QMenu_Title));
}
}
return(QMenuStr.ToString());
}
/// <summary>
/// 插入一条数据
/// </summary>
/// <returns>"true"/"false"</returns>
private string doInsert()
{
try
{
int adminId = adminInfo.Admin_Id;
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_QMenu qmenu = new SqlDb.Dcms_QMenu();
qmenu.QMenu_AdminId = adminId;
string qmenuUrl = IRequest.GetFormString("QMenu_Url").Replace("|", "&");
qmenu.QMenu_Url = Regex.Replace(qmenuUrl, @"\:(\d)+\/", "/", RegexOptions.IgnoreCase);
qmenu.QMenu_Title = IRequest.GetFormString("QMenu_Title");
DataTable existdt = session.GetTable("select * from dcms_qmenu where qmenu_adminid=" + adminId + " and qmenu_url='" + qmenu.QMenu_Url + "'");
//IQuery query = session.GetQuery(qmenu).Where(SqlDb.Dcms_QMenu._QMENU_ADMINID_.EqulesExp().AND(SqlDb.Dcms_QMenu._QMENU_URL_.EqulesExp()));
// List<SqlDb.Dcms_QMenu> list = query.GetList<SqlDb.Dcms_QMenu>();
if (existdt.Rows.Count > 0)
{
existdt.Dispose();
return("false");
}
DataTable dt = session.GetTable("select * from dcms_qmenu where Qmenu_adminid=" + adminId + " order by qmenu_order desc");
if (dt.Rows.Count > 0)
{
qmenu.QMenu_Order = Utils.StrToInt(dt.Rows[0]["QMenu_Order"], 1) + 1;
}
else
{
qmenu.QMenu_Order = 1;
}
dt.Dispose();
//提交插入
session.Create(qmenu);
}
return("true");
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 删除操作
/// </summary>
/// <returns></returns>
private string doDelete()
{
try
{
int id = IRequest.GetFormInt("QM_Id", 0);
if (id > 0)
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_QMenu qmenu = new SqlDb.Dcms_QMenu();
qmenu.QMenu_Id = id;
IQuery query = session.GetQuery(qmenu).Where(SqlDb.Dcms_QMenu._QMENU_ID_.EqulesExp());
query.Delete();
}
}
return("true");
}
catch
{
return("false");
}
}
/// <summary>
/// 删除操作
/// </summary>
/// <returns></returns>
private string doDelete()
{
try
{
int id = IRequest.GetFormInt("QM_Id", 0);
if (id > 0)
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_QMenu qmenu = new SqlDb.Dcms_QMenu();
qmenu.QMenu_Id = id;
IQuery query = session.GetQuery(qmenu).Where(SqlDb.Dcms_QMenu._QMENU_ID_.EqulesExp());
query.Delete();
}
}
return "true";
}
catch
{
return "false";
}
}
private string getQMenu()
{
StringBuilder QMenuStr = new StringBuilder();
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_QMenu qmenu = new SqlDb.Dcms_QMenu();
qmenu.QMenu_AdminId = adminInfo.Admin_Id;
IQuery query = session.GetQuery(qmenu).Where(SqlDb.Dcms_QMenu._QMENU_ADMINID_.EqulesExp()).OrderBy(SqlDb.Dcms_QMenu._QMENU_ORDER_, Direction.ASC);
List<SqlDb.Dcms_QMenu> QMenuList = query.GetList<SqlDb.Dcms_QMenu>();
QMenuStr.Append(string.Format("<li onclick='javascript:changeViewClass();'> 切换栏目视图 </li>\n"));
for (int i = 0; i < QMenuList.Count; i++)
{
QMenuStr.Append(string.Format("<li onclick='javascript:checkState(this);'> <span dataType='iframe' dataLink='{0}'>{1}</span> </li>\n", QMenuList[i].QMenu_Url, QMenuList[i].QMenu_Title));
}
}
return QMenuStr.ToString();
}
/// <summary>
/// 插入一条数据
/// </summary>
/// <returns>"true"/"false"</returns>
private string doInsert()
{
try
{
int adminId = adminInfo.Admin_Id;
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_QMenu qmenu = new SqlDb.Dcms_QMenu();
qmenu.QMenu_AdminId = adminId;
string qmenuUrl = IRequest.GetFormString("QMenu_Url").Replace("|", "&");
qmenu.QMenu_Url = Regex.Replace(qmenuUrl, @"\:(\d)+\/", "/", RegexOptions.IgnoreCase);
qmenu.QMenu_Title = IRequest.GetFormString("QMenu_Title");
DataTable existdt = session.GetTable("select * from dcms_qmenu where qmenu_adminid=" + adminId + " and qmenu_url='" + qmenu.QMenu_Url + "'");
//IQuery query = session.GetQuery(qmenu).Where(SqlDb.Dcms_QMenu._QMENU_ADMINID_.EqulesExp().AND(SqlDb.Dcms_QMenu._QMENU_URL_.EqulesExp()));
// List<SqlDb.Dcms_QMenu> list = query.GetList<SqlDb.Dcms_QMenu>();
if (existdt.Rows.Count > 0)
{
existdt.Dispose();
return "false";
}
DataTable dt=session.GetTable("select * from dcms_qmenu where Qmenu_adminid="+adminId+" order by qmenu_order desc");
if (dt.Rows.Count > 0)
{
qmenu.QMenu_Order = Utils.StrToInt(dt.Rows[0]["QMenu_Order"], 1) + 1;
}
else
{
qmenu.QMenu_Order = 1;
}
dt.Dispose();
//提交插入
session.Create(qmenu);
}
return "true";
}
catch(Exception ex)
{
return ex.Message;
}
}
/// <summary>
/// 编辑一条数据
/// </summary>
/// <returns>"true"/"false"</returns>
private string doUpdate()
{
try
{
int id = IRequest.GetFormInt("QM_Id", 0);
string du = IRequest.GetFormString("du").ToLower();
int adminId = adminInfo.Admin_Id;
if (id > 0 && adminId > 0)
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_QMenu qmenu = new SqlDb.Dcms_QMenu();
qmenu.QMenu_AdminId = adminId;
IQuery query = session.GetQuery(qmenu).Where(SqlDb.Dcms_QMenu._QMENU_ADMINID_.EqulesExp()).OrderBy(SqlDb.Dcms_QMenu._QMENU_ORDER_, Direction.ASC);
List<SqlDb.Dcms_QMenu> qmenuList = query.GetList<SqlDb.Dcms_QMenu>();
int currentI = 0;
if (qmenuList.Count > 0)
{
for (int i = 0; i < qmenuList.Count; i++)
{
if (qmenuList[i].QMenu_Id == id)
{
currentI = i;
break;
}
}
}
if (du == "up")
{
qmenu = qmenuList[currentI - 1];
int currentOrder = qmenu.QMenu_Order;
qmenu.QMenu_Order = qmenuList[currentI].QMenu_Order;
//编辑上一条的记录
session.Update(qmenu);
qmenu = qmenuList[currentI];
qmenu.QMenu_Order = currentOrder;
//编辑当前的记录
session.Update(qmenu);
}
else
{
qmenu = qmenuList[currentI + 1];
int currentOrder = qmenu.QMenu_Order;
qmenu.QMenu_Order = qmenuList[currentI].QMenu_Order;
//编辑上一条的记录
session.Update(qmenu);
qmenu = qmenuList[currentI];
qmenu.QMenu_Order = currentOrder;
//编辑当前的记录
session.Update(qmenu);
}
}
}
return "true";
}
catch
{
return "false";
}
}
private string doSelect()
{
try
{
StringBuilder sb = new StringBuilder();
sb.Append("<table width=\"100%\" border=\"0\" cellspacing=\"0\" id=\"QMenuListTable\" cellpadding=\"0\">\n");
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_QMenu QMenu = new SqlDb.Dcms_QMenu();
QMenu.QMenu_AdminId = adminInfo.Admin_Id;
IQuery query = session.GetQuery(QMenu).Where(SqlDb.Dcms_QMenu._QMENU_ADMINID_.EqulesExp()).OrderBy(SqlDb.Dcms_QMenu._QMENU_ORDER_, Direction.ASC);
List<SqlDb.Dcms_QMenu> QMenuList = query.GetList<SqlDb.Dcms_QMenu>();
if (QMenuList.Count > 0)
{
for (int i = 0; i < QMenuList.Count; i++)
{
string bgstr = string.Empty;
if ((i + 1) % 2 == 0)
{
bgstr = "style=\"background-color:#F8FEF5;\"";
}
if ((i == 0) && (QMenuList.Count > 1))
{
sb.Append(string.Format("<tr {0}><td height=\"25\"> {1}</td>", bgstr, QMenuList[i].QMenu_Title));
sb.Append(string.Format("<td width=\"70\" ><div class=\"toporder\"></div><div class=\"downorder\" onclick=\"ajaxSubmi({0},'update','down')\"></div></td>", QMenuList[i].QMenu_Id));
sb.Append(string.Format("<td width=\"70\" ><div class=\"delqmenu\" onclick=\"ajaxSubmi({0},'delete','ud')\"></div></td></tr>\n", QMenuList[i].QMenu_Id));
}
else if ((i == (QMenuList.Count - 1)) && (QMenuList.Count > 1))
{
sb.Append(string.Format("<tr {0}><td height=\"25\"> {1}</td>", bgstr, QMenuList[i].QMenu_Title));
sb.Append(string.Format("<td width=\"70\" ><div class=\"uporder\" onclick=\"ajaxSubmi({0},'update','up')\"></div><div class=\"bottomorder\"></div></td>", QMenuList[i].QMenu_Id));
sb.Append(string.Format("<td width=\"70\" ><div class=\"delqmenu\" onclick=\"ajaxSubmi({0},'delete','ud')\"></div></td></tr>\n", QMenuList[i].QMenu_Id));
}
else if ((i == 0) && (i == (QMenuList.Count - 1)))
{
sb.Append(string.Format("<tr {0}><td height=\"25\"> {1}</td>", bgstr, QMenuList[i].QMenu_Title));
sb.Append(string.Format("<td width=\"70\" ><div class=\"toporder\"></div><div class=\"bottomorder\"></div></td>", QMenuList[i].QMenu_Id));
sb.Append(string.Format("<td width=\"70\" ><div class=\"delqmenu\" onclick=\"ajaxSubmi({0},'delete','ud')\"></div></td></tr>\n", QMenuList[i].QMenu_Id));
}
else
{
sb.Append(string.Format("<tr {0}><td height=\"25\"> {1}</td>", bgstr, QMenuList[i].QMenu_Title));
sb.Append(string.Format("<td width=\"70\" ><div class=\"uporder\" onclick=\"ajaxSubmi({0},'update','up')\"></div><div class=\"downorder\" onclick=\"ajaxSubmi({0},'update','down')\"></div></td>", QMenuList[i].QMenu_Id));
sb.Append(string.Format("<td width=\"70\" ><div class=\"delqmenu\" onclick=\"ajaxSubmi({0},'delete','ud')\"></div></td></tr>\n", QMenuList[i].QMenu_Id));
}
}
}
}
sb.Append("</table>\n");
return sb.ToString();
}
catch
{
return "false";
}
}
