public IActionResult Index()
{
var res = feedBack.GetFeedBacks();
return View(res);
}
public string GetFeedBacks()
{
string nickname = "";
string type_name = "";
int Feedback_Type = 0;
string keyword = tools.CheckStr(Request["keyword"]);
int isreply = tools.CheckInt(Request["isreply"]);
string date_start = tools.CheckStr(Request.QueryString["date_start"]);
string date_end = tools.CheckStr(Request.QueryString["date_end"]);
QueryInfo Query = new QueryInfo();
Query.PageSize = tools.CheckInt(Request["rows"]);
Query.CurrentPage = tools.CheckInt(Request["page"]);
Query.ParamInfos.Add(new ParamInfo("AND", "str", "FeedBackInfo.Feedback_Site", "=", Public.GetCurrentSite()));
string listtype = tools.CheckStr(Request.QueryString["listtype"]);
switch (listtype)
{
case "message":
Query.ParamInfos.Add(new ParamInfo("AND", "int", "FeedBackInfo.Feedback_Type", "=", "1"));
break;
case "idea":
Query.ParamInfos.Add(new ParamInfo("AND", "int", "FeedBackInfo.Feedback_Type", "!=", "1"));
break;
case "suggest":
Query.ParamInfos.Add(new ParamInfo("AND(", "int", "FeedBackInfo.Feedback_Type", "=", "3"));
Query.ParamInfos.Add(new ParamInfo("OR)", "int", "FeedBackInfo.Feedback_Type", "=", "4"));
break;
case "complain":
Query.ParamInfos.Add(new ParamInfo("AND(", "int", "FeedBackInfo.Feedback_Type", "=", "5"));
Query.ParamInfos.Add(new ParamInfo("OR)", "int", "FeedBackInfo.Feedback_Type", "=", "6"));
break;
default:
Query.ParamInfos.Add(new ParamInfo("AND", "int", "FeedBackInfo.Feedback_Type", "=", "1"));
break;
}
if (isreply == 1)
{
Query.ParamInfos.Add(new ParamInfo("AND", "str", "FeedBackInfo.Feedback_Reply_Content", "<>", ""));
}
else if (isreply == 2)
{
Query.ParamInfos.Add(new ParamInfo("AND", "str", "FeedBackInfo.Feedback_Reply_Content", "=", ""));
}
if (keyword.Length > 0)
{
Query.ParamInfos.Add(new ParamInfo("AND(", "str", "FeedBackInfo.Feedback_Name", "like", keyword));
Query.ParamInfos.Add(new ParamInfo("OR", "str", "FeedBackInfo.Feedback_CompanyName", "like", keyword));
Query.ParamInfos.Add(new ParamInfo("OR", "str", "FeedBackInfo.Feedback_Tel", "like", keyword));
Query.ParamInfos.Add(new ParamInfo("OR)", "str", "FeedBackInfo.Feedback_Email", "like", keyword));
}
if (date_start != "")
{
Query.ParamInfos.Add(new ParamInfo("AND", "funint", "DATEDIFF(d, '" + date_start + "',{FeedBackInfo.Feedback_Addtime})", ">=", "0"));
}
if (date_end != "")
{
Query.ParamInfos.Add(new ParamInfo("AND", "funint", "DATEDIFF(d, '" + date_end + "',{FeedBackInfo.Feedback_Addtime})", "<=", "0"));
}
Query.OrderInfos.Add(new OrderInfo(tools.CheckStr(Request["sidx"]), tools.CheckStr(Request["sord"])));
PageInfo pageinfo = MyFeedback.GetPageInfo(Query, Public.GetUserPrivilege());
IList <FeedBackInfo> entitys = MyFeedback.GetFeedBacks(Query, Public.GetUserPrivilege());
if (entitys != null)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{\"page\":" + pageinfo.CurrentPage + ",\"total\":" + pageinfo.PageCount + ",\"records\":" + pageinfo.RecordCount + ",\"rows\"");
jsonBuilder.Append(":[");
foreach (FeedBackInfo entity in entitys)
{
nickname = "游客";
MemberInfo member = new MemberInfo();
if (entity.Feedback_MemberID > 0)
{
member = MyBLL.GetMemberByID(entity.Feedback_MemberID, Public.GetUserPrivilege());
if (member != null)
{
nickname = member.Member_NickName;
}
}
SupplierInfo supplierinfo = new SupplierInfo();
if (entity.Feedback_SupplierID > 0)
{
supplierinfo = MySupplier.GetSupplierByID(entity.Feedback_SupplierID, Public.GetUserPrivilege());
if (supplierinfo != null)
{
nickname = supplierinfo.Supplier_Nickname;
}
}
switch (entity.Feedback_Type)
{
//case 1:
// type_name = "简单的留言";
// break;
//case 2:
// type_name = "对网站的意见";
// break;
//case 3:
// type_name = "对公司的建议";
// break;
//case 4:
// type_name = "具有合作意向";
// break;
//case 5:
// type_name = "产品投诉";
// break;
//case 6:
// type_name = "服务投诉";
// break;
case 1:
type_name = "网站留言";
break;
case 2:
type_name = "商业承兑融资";
break;
case 3:
type_name = "应收账款融资";
break;
case 4:
type_name = "货押融资";
break;
//case 3:
// type_name = "对公司的建议";
// break;
//case 4:
// type_name = "具有合作意向";
// break;
//case 5:
// type_name = "产品投诉";
// break;
//case 6:
// type_name = "服务投诉";
//break;
}
jsonBuilder.Append("{\"id\":" + entity.Feedback_ID + ",\"cell\":[");
//各字段
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.Feedback_ID);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(Public.JsonStr(entity.Feedback_Name));
jsonBuilder.Append("\",");
//jsonBuilder.Append("\"");
//jsonBuilder.Append(Public.JsonStr(entity.Feedback_CompanyName));
//jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(Public.JsonStr(type_name));
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(Public.JsonStr(entity.Feedback_Tel));
jsonBuilder.Append("\",");
if (Feedback_Type == 1)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(Public.JsonStr(entity.Feedback_Email));
jsonBuilder.Append("\",");
}
else
{
jsonBuilder.Append("\"");
jsonBuilder.Append(tools.CheckFloat(entity.Feedback_Amount.ToString()));
jsonBuilder.Append("\",");
}
jsonBuilder.Append("\"");
if (entity.Feedback_Reply_Content != "")
{
jsonBuilder.Append("已回复");
}
else
{
jsonBuilder.Append("未回复");
}
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.Feedback_Addtime.ToString("yy-MM-dd"));
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append("<img src=\\\"/images/icon_view.gif\\\" alt=\\\"查看\\\" align=\\\"absmiddle\\\"> <a href=\\\"feedback_view.aspx?feedback_id=" + entity.Feedback_ID + "\\\" title=\\\"查看\\\">查看</a> ");
if (Public.CheckPrivilege("cc567804-3e2e-4c6c-aa22-c9a353508074"))
{
jsonBuilder.Append("<img src=\\\"/images/icon_del.gif\\\" alt=\\\"删除\\\" align=\\\"absmiddle\\\"> <a href=\\\"javascript:void(0);\\\" onclick=\\\"confirmdelete('supplier_do.aspx?action=feedbackmove&listtype=" + listtype + "&feedback_id=" + entity.Feedback_ID + "')\\\" title=\\\"删除\\\">删除</a>");
//jsonBuilder.Append(" <img src=\\\"/images/icon_del.gif\\\" alt=\\\"删除\\\"> <a href=\\\"javascript:void(0);\\\" onclick=\\\"confirmdelete('depot_do.aspx?action=move&depot_id=" + Depot_ID + "')\\\" title=\\\"删除\\\">删除</a>");
}
jsonBuilder.Append("\",");
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]},");
supplierinfo = null;
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
else
{
return(null);
}
}