public ActionResult AddRequestion()
{
try
{
UserEntity uInfo = ViewData["Account"] as UserEntity;
RequestionEntity requestionAdd = new RequestionEntity();
requestionAdd.ftitle = Request["FTitle"];
requestionAdd.ftypeid = int.Parse(Request["FTypeId"]);
requestionAdd.fcontent = Request["FContent"];
requestionAdd.CreateBy = uInfo.AccountName;
requestionAdd.CreateTime = DateTime.Now;
requestionAdd.UpdateBy = uInfo.AccountName;
requestionAdd.UpdateTime = DateTime.Now;
int id = new RequestionBLL().Add(requestionAdd);
if (id > 0)
{
return(Content("{\"msg\":\"添加成功！\",\"success\":true}"));
}
else
{
return(Content("{\"msg\":\"添加失败！\",\"success\":false}"));
}
}
catch (Exception ex)
{
return(Content("{\"msg\":\"修改失败," + ex.Message + "\",\"success\":false}"));
}
}
public ActionResult EditRequestion()
{
try
{
UserEntity uInfo = ViewData["Account"] as UserEntity;
int id = Convert.ToInt32(Request["id"]);
RequestionEntity requestionEdit = new RequestionBLL().GetModel(id);
requestionEdit.ftitle = Request["FTitle"];
requestionEdit.ftypeid = int.Parse(Request["FTypeId"]);
requestionEdit.fcontent = Request["FContent"];
requestionEdit.UpdateBy = uInfo.AccountName;
requestionEdit.UpdateTime = DateTime.Now;
int result = new RequestionBLL().Update(requestionEdit);
if (result > 0)
{
return(Content("{\"msg\":\"修改成功！\",\"success\":true}"));
}
else
{
return(Content("{\"msg\":\"修改失败！\",\"success\":false}"));
}
}
catch (Exception ex)
{
return(Content("{\"msg\":\"修改失败," + ex.Message + "\",\"success\":false}"));
}
}
/// <summary>
/// 编辑页面展示
/// </summary>
/// <returns></returns>
public ActionResult RequestionEdit()
{
int id = 0;
if (!string.IsNullOrEmpty(Request["id"]))
{
id = int.Parse(Request["id"]);
RequestionEntity requestionEdit = new RequestionBLL().GetModel(id);
return(View(requestionEdit));
}
return(new EmptyResult());
}
public ActionResult GetAllRequestionInfo()
{
string strWhere = "1=1";
string sort = Request["sort"] == null ? "id" : Request["sort"];
string order = Request["order"] == null ? "asc" : Request["order"];
if (!string.IsNullOrEmpty(Request["ftitle"]) && !SqlInjection.GetString(Request["ftitle"]))
{
strWhere += " and ftitle like '%" + Request["ftitle"] + "%'";
}
if (!string.IsNullOrEmpty(Request["frequstid"]) && !SqlInjection.GetString(Request["frequstid"]))
{
strWhere += " and ftypeid =" + Request["frequstid"];
}
//首先获取前台传递过来的参数
int pageindex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]);
int pagesize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]);
int totalCount = 0; //输出参数
string strJson = ""; //输出结果
if (order.IndexOf(',') != -1) //如果有","就是多列排序（不能拿列判断，列名中间可能有","符号）
{
//多列排序：
//sort：ParentId,Sort,AddDate
//order：asc,desc,asc
string sortMulti = ""; //拼接排序条件，例：ParentId desc,Sort asc
string[] sortArray = sort.Split(','); //列名中间有","符号，这里也要出错。正常不会有
string[] orderArray = order.Split(',');
for (int i = 0; i < sortArray.Length; i++)
{
sortMulti += sortArray[i] + " " + orderArray[i] + ",";
}
strJson = new RequestionBLL().GetPager("vw_requestion", "id,ftypeid,ftitle,fcontent,ftypename,fsort,CreateTime,CreateBy,UpdateTime,UpdateBy", sortMulti.Trim(','), pagesize, pageindex, strWhere, out totalCount);
}
else
{
strJson = new RequestionBLL().GetPager("vw_requestion", "id,ftypeid,ftitle,fcontent,ftypename,fsort,CreateTime,CreateBy,UpdateTime,UpdateBy", sort + " " + order, pagesize, pageindex, strWhere, out totalCount);
}
var jsonResult = new { total = totalCount.ToString(), rows = strJson };
return(Content("{\"total\": " + totalCount.ToString() + ",\"rows\":" + strJson + "}"));
}
