/// <summary>
/// 编辑一条数据
/// </summary>
/// <returns>"true"/"false"</returns>
private string doUpdate()
{
try
{
//int newsid = IRequest.GetQueryInt("newsid", 0);
int guestbookid = IRequest.GetFormInt("GuestBook_Id", 0);
if (guestbookid > 0)
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_GuestBook guestbook = new SqlDb.Dcms_GuestBook();
IQuery query = session.GetQuery(guestbook).Where(SqlDb.Dcms_GuestBook._GUESTBOOK_ID_.EqulesExp(guestbookid));
IList <SqlDb.Dcms_GuestBook> guestbooklist = query.GetList <SqlDb.Dcms_GuestBook>();
if (guestbooklist.Count > 0)
{
guestbook = guestbooklist[0];
UpdateModelByForm(guestbook, Request.Form);
session.Update(guestbook);
return("true");
}
}
}
return("false");
}
catch
{
return("false");
}
}
protected void Page_Load(object sender, EventArgs e)
{
iframeid = IRequest.GetQueryString("iframeid");
int CateId = IRequest.GetQueryInt("cateid", 0);
int Id = IRequest.GetQueryInt("id", -1);
string cateName = IRequest.GetQueryString("catename");
if (CateId > 0)
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_Cate cate = new SqlDb.Dcms_Cate();
cate.Cate_Id = CateId;
IQuery query = session.GetQuery(cate).Where(SqlDb.Dcms_Cate._CATE_ID_.EqulesExp());
List <SqlDb.Dcms_Cate> cateList = query.GetList <SqlDb.Dcms_Cate>();
if (cateList.Count > 0)
{
cateName = cateList[0].Cate_Title;
GuestBook_CateName.Value = cateName;
GuestBook_CateId.Value = CateId.ToString();
GuestBook_CateName.Value = cateName;
}
}
}
if (Id == 0)
{
this.Page.Title = "新建" + cateName;
this.lit_Title.Text = "新建" + cateName;
GuestBook_Id.Value = "0";
}
else if (Id > 0)
{
this.Page.Title = "编辑" + cateName;
this.lit_Title.Text = "编辑" + cateName;
lit_id.Text = Id.ToString();
GuestBook_Id.Value = Id.ToString();
}
else
{
int thisId = 0;
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_GuestBook modle = new SqlDb.Dcms_GuestBook();
modle.GuestBook_CateId = CateId;
IQuery query = session.GetQuery(modle).Where(SqlDb.Dcms_GuestBook._GUESTBOOK_CATEID_.EqulesExp());
IList <SqlDb.Dcms_GuestBook> datalist = query.GetList <SqlDb.Dcms_GuestBook>();
if (datalist.Count > 0)
{
thisId = datalist[0].GuestBook_Id;
}
}
this.Page.Title = "编辑" + cateName;
this.lit_Title.Text = "编辑" + cateName;
lit_id.Text = thisId.ToString();
GuestBook_Id.Value = thisId.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
iframeid = IRequest.GetQueryString("iframeid");
int CateId = IRequest.GetQueryInt("cateid", 0);
int Id = IRequest.GetQueryInt("id", -1);
string cateName = IRequest.GetQueryString("catename");
if (CateId > 0)
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_Cate cate = new SqlDb.Dcms_Cate();
cate.Cate_Id = CateId;
IQuery query = session.GetQuery(cate).Where(SqlDb.Dcms_Cate._CATE_ID_.EqulesExp());
List<SqlDb.Dcms_Cate> cateList = query.GetList<SqlDb.Dcms_Cate>();
if (cateList.Count > 0)
{
cateName = cateList[0].Cate_Title;
GuestBook_CateName.Value = cateName;
GuestBook_CateId.Value = CateId.ToString();
GuestBook_CateName.Value = cateName;
}
}
}
if (Id == 0)
{
this.Page.Title = "新建" + cateName;
this.lit_Title.Text = "新建" + cateName;
GuestBook_Id.Value = "0";
}
else if (Id > 0)
{
this.Page.Title = "编辑" + cateName;
this.lit_Title.Text = "编辑" + cateName;
lit_id.Text = Id.ToString();
GuestBook_Id.Value = Id.ToString();
}
else
{
int thisId = 0;
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_GuestBook modle = new SqlDb.Dcms_GuestBook();
modle.GuestBook_CateId = CateId;
IQuery query = session.GetQuery(modle).Where(SqlDb.Dcms_GuestBook._GUESTBOOK_CATEID_.EqulesExp());
IList<SqlDb.Dcms_GuestBook> datalist = query.GetList<SqlDb.Dcms_GuestBook>();
if (datalist.Count > 0)
{
thisId = datalist[0].GuestBook_Id;
}
}
this.Page.Title = "编辑" + cateName;
this.lit_Title.Text = "编辑" + cateName;
lit_id.Text = thisId.ToString();
GuestBook_Id.Value = thisId.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string successMessage = IRequest.GetFormString("successMessage");
string successUrl = IRequest.GetFormString("successUrl");
string errorMessage = IRequest.GetFormString("errorMessage");
string errorCodeMessage = IRequest.GetFormString("errorCodeMessage");
bool hasValidCode = false;
string ValidCode = string.Empty;
for (int i = 0; i < Request.Form.Keys.Count; i++)
{
if (Request.Form.Keys[i].ToLower() == "validcode")
{
hasValidCode = true;
ValidCode = IRequest.GetFormString("ValidCode");
break;
}
}
if ((hasValidCode) && (ValidCode != Convert.ToString(SessionHelper.Get("ValidCode"))))
{
Jscript.AlertAndBack(errorCodeMessage);
Response.End();
}
if ((IRequest.GetFormString("GuestBook_UserName").Length <= 1) || (IRequest.GetFormString("GuestBook_Title").Length <= 1))
{
Jscript.AlertAndBack(errorMessage);
}
else
{
try
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_GuestBook guestbook = new SqlDb.Dcms_GuestBook();
guestbook.GuestBook_AddTime = DateTime.Now;
guestbook.GuestBook_State = "0";
UpdateModelByForm(guestbook, Request.Form);
guestbook.GuestBook_UserIp = Utils.GetRealIP();
//StringBuilder sb = new StringBuilder();
//sb.Append(string.Format("标题：{0}<br />", guestbook.GuestBook_Title));
//sb.Append(string.Format("用户名：{0}<br />", guestbook.GuestBook_UserName));
//sb.Append(string.Format("邮箱：{0}<br />", guestbook.GuestBook_UserEmail));
//sb.Append(string.Format("电话：{0}<br />", guestbook.GuestBook_UserTel));
//sb.Append(string.Format("QQ/MSN：{0}<br />", guestbook.GuestBook_UserIM));
//sb.Append(string.Format("内容：{0}<br />", guestbook.GuestBook_Content));
//sendMail("***@35.cn", title, sb.ToString(), "***@35.cn","***@35.cn","******","mail.35.cn");
session.Create(guestbook);
}
Jscript.AlertAndRedirect(successMessage, successUrl);
}
catch
{
Jscript.AlertAndBack(errorMessage);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string successMessage = IRequest.GetFormString("successMessage");
string successUrl = IRequest.GetFormString("successUrl");
string errorMessage = IRequest.GetFormString("errorMessage");
string errorCodeMessage = IRequest.GetFormString("errorCodeMessage");
bool hasValidCode = false;
string ValidCode = string.Empty;
for (int i = 0; i < Request.Form.Keys.Count; i++)
{
if (Request.Form.Keys[i].ToLower() == "validcode")
{
hasValidCode = true;
ValidCode = IRequest.GetFormString("ValidCode");
break;
}
}
if ((hasValidCode)&&(ValidCode != Convert.ToString(SessionHelper.Get("ValidCode"))))
{
Jscript.AlertAndBack(errorCodeMessage);
Response.End();
}
if ((IRequest.GetFormString("GuestBook_UserName").Length <= 1) || (IRequest.GetFormString("GuestBook_Title").Length <= 1))
{
Jscript.AlertAndBack(errorMessage);
}
else
{
try
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_GuestBook guestbook = new SqlDb.Dcms_GuestBook();
guestbook.GuestBook_AddTime = DateTime.Now;
guestbook.GuestBook_State = "0";
UpdateModelByForm(guestbook, Request.Form);
guestbook.GuestBook_UserIp = Utils.GetRealIP();
//StringBuilder sb = new StringBuilder();
//sb.Append(string.Format("标题：{0}<br />", guestbook.GuestBook_Title));
//sb.Append(string.Format("用户名：{0}<br />", guestbook.GuestBook_UserName));
//sb.Append(string.Format("邮箱：{0}<br />", guestbook.GuestBook_UserEmail));
//sb.Append(string.Format("电话：{0}<br />", guestbook.GuestBook_UserTel));
//sb.Append(string.Format("QQ/MSN：{0}<br />", guestbook.GuestBook_UserIM));
//sb.Append(string.Format("内容：{0}<br />", guestbook.GuestBook_Content));
//sendMail("***@35.cn", title, sb.ToString(), "***@35.cn","***@35.cn","******","mail.35.cn");
session.Create(guestbook);
}
Jscript.AlertAndRedirect(successMessage, successUrl);
}
catch
{
Jscript.AlertAndBack(errorMessage);
}
}
}
/// <summary>
/// 插入一条数据
/// </summary>
/// <returns>"true"/"false"</returns>
private string doInsert()
{
try
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_GuestBook guestbook = new SqlDb.Dcms_GuestBook();
guestbook.GuestBook_AddTime = DateTime.Now;
UpdateModelByForm(guestbook, Request.Form);
session.Create(guestbook);
}
return("true");
}
catch
{
return("false");
}
}
/// <summary>
/// 按页取数据
/// </summary>
/// <returns>json</returns>
private string doSelect()
{
StringBuilder sb = new StringBuilder();
//取Grid提交来的数据开始
//int uploadId = IRequest.GetQueryInt("id", 0);
int rp = IRequest.GetFormInt("rp", 10);
int page = IRequest.GetFormInt("page", 1);
string keyword = Utils.chkSQL(IRequest.GetFormString("query"));
string qtype = IRequest.GetFormString("qtype");
int cateid = IRequest.GetQueryInt("cateid", 0);
//string path = getUploadPathByUploadId(uploadId).Replace("\\", "/");
//取Grid提交来的数据结束
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_GuestBook guestbook = new SqlDb.Dcms_GuestBook();
//创建查询
if (keyword.Length > 0)
{
guestbook.GuestBook_Title = keyword;
}
IQuery query = session.GetQuery(guestbook);
if (keyword.Length > 0)
{
if (cateid > 0)
{
query.Where(SqlDb.Dcms_GuestBook._GUESTBOOK_TITLE_.Like('%', keyword, '%').AND(SqlDb.Dcms_GuestBook._GUESTBOOK_CATEID_.EqulesExp(cateid)));
}
else
{
query.Where(SqlDb.Dcms_GuestBook._GUESTBOOK_TITLE_.Like('%', keyword, '%'));
}
}
else
{
if (cateid > 0)
{
query.Where(SqlDb.Dcms_GuestBook._GUESTBOOK_CATEID_.EqulesExp(cateid));
}
}
query.OrderBy(SqlDb.Dcms_GuestBook._GUESTBOOK_ID_, Direction.DESC);
//取总记录
int totalCount = query.Count();
List <SqlDb.Dcms_GuestBook> guestbookList = query.GetList <SqlDb.Dcms_GuestBook>(page, rp);
//Json格式
sb.Append("{\n");
sb.Append("\"page\":" + page.ToString() + ",\n");
sb.Append("\"total\":" + totalCount.ToString() + ",\n");
sb.Append("\"rows\": [\n");
for (int i = 0; i < guestbookList.Count; i++)
{
string state = (guestbookList[i].GuestBook_State == "1") ? "显示" : "关闭";
sb.Append("{");
sb.Append(string.Format("\"id\":\"{0}\",\"cell\":[\"{1}\",\"{2}\",\"{3}\",\"{4}\"]", guestbookList[i].GuestBook_Id.ToString(), guestbookList[i].GuestBook_Id.ToString(), FormatJsonData(guestbookList[i].GuestBook_Title.ToString()), state, guestbookList[i].GuestBook_AddTime.ToString("yyyy/MM/dd")));
if ((i + 1) == guestbookList.Count)
{
sb.Append("}\n");
}
else
{
sb.Append("},\n");
}
}
sb.Append("]\n");
sb.Append("}");
}
return(sb.ToString());
}
/// <summary>
/// 编辑一条数据
/// </summary>
/// <returns>"true"/"false"</returns>
private string doUpdate()
{
try
{
//int newsid = IRequest.GetQueryInt("newsid", 0);
int guestbookid = IRequest.GetFormInt("GuestBook_Id", 0);
if (guestbookid > 0)
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_GuestBook guestbook = new SqlDb.Dcms_GuestBook();
IQuery query = session.GetQuery(guestbook).Where(SqlDb.Dcms_GuestBook._GUESTBOOK_ID_.EqulesExp(guestbookid));
IList<SqlDb.Dcms_GuestBook> guestbooklist = query.GetList<SqlDb.Dcms_GuestBook>();
if (guestbooklist.Count > 0)
{
guestbook = guestbooklist[0];
UpdateModelByForm(guestbook, Request.Form);
session.Update(guestbook);
return "true";
}
}
}
return "false";
}
catch
{
return "false";
}
}
/// <summary>
/// 按页取数据
/// </summary>
/// <returns>json</returns>
private string doSelect()
{
StringBuilder sb = new StringBuilder();
//取Grid提交来的数据开始
//int uploadId = IRequest.GetQueryInt("id", 0);
int rp = IRequest.GetFormInt("rp", 10);
int page = IRequest.GetFormInt("page", 1);
string keyword = Utils.chkSQL(IRequest.GetFormString("query"));
string qtype = IRequest.GetFormString("qtype");
int cateid = IRequest.GetQueryInt("cateid", 0);
//string path = getUploadPathByUploadId(uploadId).Replace("\\", "/");
//取Grid提交来的数据结束
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_GuestBook guestbook = new SqlDb.Dcms_GuestBook();
//创建查询
if (keyword.Length > 0)
{
guestbook.GuestBook_Title = keyword;
}
IQuery query = session.GetQuery(guestbook);
if (keyword.Length > 0)
{
if (cateid > 0)
{
query.Where(SqlDb.Dcms_GuestBook._GUESTBOOK_TITLE_.Like('%', keyword, '%').AND(SqlDb.Dcms_GuestBook._GUESTBOOK_CATEID_.EqulesExp(cateid)));
}
else
{
query.Where(SqlDb.Dcms_GuestBook._GUESTBOOK_TITLE_.Like('%', keyword, '%'));
}
}
else
{
if (cateid > 0)
{
query.Where(SqlDb.Dcms_GuestBook._GUESTBOOK_CATEID_.EqulesExp(cateid));
}
}
query.OrderBy(SqlDb.Dcms_GuestBook._GUESTBOOK_ID_, Direction.DESC);
//取总记录
int totalCount = query.Count();
List<SqlDb.Dcms_GuestBook> guestbookList = query.GetList<SqlDb.Dcms_GuestBook>(page, rp);
//Json格式
sb.Append("{\n");
sb.Append("\"page\":" + page.ToString() + ",\n");
sb.Append("\"total\":" + totalCount.ToString() + ",\n");
sb.Append("\"rows\": [\n");
for (int i = 0; i < guestbookList.Count; i++)
{
string state = (guestbookList[i].GuestBook_State == "1") ? "显示" : "关闭";
sb.Append("{");
sb.Append(string.Format("\"id\":\"{0}\",\"cell\":[\"{1}\",\"{2}\",\"{3}\",\"{4}\"]", guestbookList[i].GuestBook_Id.ToString(), guestbookList[i].GuestBook_Id.ToString(), FormatJsonData(guestbookList[i].GuestBook_Title.ToString()), state, guestbookList[i].GuestBook_AddTime.ToString("yyyy/MM/dd")));
if ((i + 1) == guestbookList.Count)
{
sb.Append("}\n");
}
else
{
sb.Append("},\n");
}
}
sb.Append("]\n");
sb.Append("}");
}
return sb.ToString();
}
/// <summary>
/// 插入一条数据
/// </summary>
/// <returns>"true"/"false"</returns>
private string doInsert()
{
try
{
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
SqlDb.Dcms_GuestBook guestbook = new SqlDb.Dcms_GuestBook();
guestbook.GuestBook_AddTime = DateTime.Now;
UpdateModelByForm(guestbook, Request.Form);
session.Create(guestbook);
}
return "true";
}
catch
{
return "false";
}
}
