public void AddSupplierGrade() { int Supplier_Grade_ID = tools.CheckInt(Request.Form["Supplier_Grade_ID"]); string Supplier_Grade_Name = tools.CheckStr(Request.Form["Supplier_Grade_Name"]); int Supplier_Grade_Percent = tools.CheckInt(Request.Form["Supplier_Grade_Percent"]); int Supplier_Grade_Default = tools.CheckInt(Request.Form["Supplier_Grade_Default"]); int Supplier_Grade_RequiredCoin = tools.CheckInt(Request.Form["Supplier_Grade_RequiredCoin"]); double Supplier_Grade_CoinRate = tools.CheckFloat(Request.Form["Supplier_Grade_CoinRate"]); if (Supplier_Grade_Name.Length == 0) { Public.Msg("info", "提示信息", "请填写供应商等级名称", false, "{back}"); } SupplierGradeInfo entity = new SupplierGradeInfo(); entity.Supplier_Grade_ID = Supplier_Grade_ID; entity.Supplier_Grade_Name = Supplier_Grade_Name; entity.Supplier_Grade_Percent = Supplier_Grade_Percent; entity.Supplier_Grade_Default = Supplier_Grade_Default; entity.Supplier_Grade_RequiredCoin = Supplier_Grade_RequiredCoin; entity.Supplier_Grade_Site = Public.GetCurrentSite(); if (MyBLL.AddSupplierGrade(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "Supplier_grade_list.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public void AddOrdersPayment() { int Orders_Payment_ID = tools.CheckInt(Request.Form["Orders_Payment_ID"]); int Orders_Payment_OrdersID = tools.CheckInt(Request.Form["Orders_Payment_OrdersID"]); int Orders_Payment_PaymentStatus = tools.CheckInt(Request.Form["Orders_Payment_PaymentStatus"]); int Orders_Payment_SysUserID = tools.CheckInt(Request.Form["Orders_Payment_SysUserID"]); string Orders_Payment_DocNo = tools.CheckStr(Request.Form["Orders_Payment_DocNo"]); string Orders_Payment_Name = tools.CheckStr(Request.Form["Orders_Payment_Name"]); double Orders_Payment_Amount = tools.CheckFloat(Request.Form["Orders_Payment_Amount"]); string Orders_Payment_Note = tools.CheckStr(Request.Form["Orders_Payment_Note"]); OrdersPaymentInfo entity = new OrdersPaymentInfo(); entity.Orders_Payment_ID = Orders_Payment_ID; entity.Orders_Payment_OrdersID = Orders_Payment_OrdersID; entity.Orders_Payment_PaymentStatus = Orders_Payment_PaymentStatus; entity.Orders_Payment_SysUserID = Orders_Payment_SysUserID; entity.Orders_Payment_DocNo = Orders_Payment_DocNo; entity.Orders_Payment_Name = Orders_Payment_Name; entity.Orders_Payment_Amount = Orders_Payment_Amount; entity.Orders_Payment_Note = Orders_Payment_Note; entity.Orders_Payment_Addtime = DateTime.Now; entity.Orders_Payment_Site = Public.GetCurrentSite(); if (MyBLL.AddOrdersPayment(entity)) { Public.Msg("positive", "操作成功", "操作成功", true, "orders_payment_list.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public void AddOrdersDelivery() { int Orders_Delivery_ID = tools.CheckInt(Request.Form["Orders_Delivery_ID"]); int Orders_Delivery_OrdersID = tools.CheckInt(Request.Form["Orders_Delivery_OrdersID"]); int Orders_Delivery_DeliveryStatus = tools.CheckInt(Request.Form["Orders_Delivery_DeliveryStatus"]); int Orders_Delivery_SysUserID = tools.CheckInt(Request.Form["Orders_Delivery_SysUserID"]); string Orders_Delivery_DocNo = tools.CheckStr(Request.Form["Orders_Delivery_DocNo"]); string Orders_Delivery_Name = tools.CheckStr(Request.Form["Orders_Delivery_Name"]); double Orders_Delivery_Amount = tools.CheckFloat(Request.Form["Orders_Delivery_Amount"]); string Orders_Delivery_Note = tools.CheckStr(Request.Form["Orders_Delivery_Note"]); OrdersDeliveryInfo entity = new OrdersDeliveryInfo(); entity.Orders_Delivery_ID = Orders_Delivery_ID; entity.Orders_Delivery_OrdersID = Orders_Delivery_OrdersID; entity.Orders_Delivery_DeliveryStatus = Orders_Delivery_DeliveryStatus; entity.Orders_Delivery_SysUserID = Orders_Delivery_SysUserID; entity.Orders_Delivery_DocNo = Orders_Delivery_DocNo; entity.Orders_Delivery_Name = Orders_Delivery_Name; entity.Orders_Delivery_Amount = Orders_Delivery_Amount; entity.Orders_Delivery_Note = Orders_Delivery_Note; entity.Orders_Delivery_Addtime = DateTime.Now; entity.Orders_Delivery_Site = Public.GetCurrentSite(); if (MyBLL.AddOrdersDelivery(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "Orders_Delivery_add.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public void AddPackage() { int Package_ID = tools.CheckInt(Request.Form["Package_ID"]); string Package_Name = tools.CheckStr(Request.Form["Package_Name"]); int Package_IsInsale = tools.CheckInt(Request.Form["Package_IsInsale"]); int Package_StockAmount = tools.CheckInt(Request.Form["Package_StockAmount"]); int Package_Weight = tools.CheckInt(Request.Form["Package_Weight"]); double Package_Price = tools.CheckFloat(Request.Form["Package_Price"]); int Package_Sort = tools.CheckInt(Request.Form["Package_Sort"]); PackageInfo entity = new PackageInfo(); entity.Package_ID = Package_ID; entity.Package_Name = Package_Name; entity.Package_IsInsale = Package_IsInsale; entity.Package_StockAmount = Package_StockAmount; entity.Package_Weight = Package_Weight; entity.Package_Price = Package_Price; entity.Package_Sort = Package_Sort; entity.Package_Addtime = DateTime.Now; entity.Package_Site = pub.GetCurrentSite(); entity.PackageProductInfos = ReadPackageProduct(); entity.Package_SupplierID = tools.NullInt(Session["supplier_id"]); if (MyBLL.AddPackage(entity, pub.CreateUserPrivilege("573393a4-573e-4872-ad7b-b77d75e0f611"))) { pub.Msg("positive", "操作成功", "操作成功", true, "Package_add.aspx"); } else { pub.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public void AddMemberGrade() { int Member_Grade_ID = tools.CheckInt(Request.Form["Member_Grade_ID"]); string Member_Grade_Name = tools.CheckStr(Request.Form["Member_Grade_Name"]); int Member_Grade_Percent = tools.CheckInt(Request.Form["Member_Grade_Percent"]); int Member_Grade_Default = tools.CheckInt(Request.Form["Member_Grade_Default"]); int Member_Grade_RequiredCoin = tools.CheckInt(Request.Form["Member_Grade_RequiredCoin"]); double Member_Grade_CoinRate = tools.CheckFloat(Request.Form["Member_Grade_CoinRate"]); MemberGradeInfo entity = new MemberGradeInfo(); entity.Member_Grade_ID = Member_Grade_ID; entity.Member_Grade_Name = Member_Grade_Name; entity.Member_Grade_Percent = Member_Grade_Percent; entity.Member_Grade_Default = Member_Grade_Default; entity.Member_Grade_RequiredCoin = Member_Grade_RequiredCoin; entity.Member_Grade_CoinRate = Member_Grade_CoinRate; entity.Member_Grade_Addtime = DateTime.Now; entity.Member_Grade_Site = Public.GetCurrentSite(); if (MyBLL.AddMemberGrade(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "member_grade_list.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
//获取会员获取积分 public int Get_Member_Coin(int member_id, double Product_Price) { int coin_amount = 0; coin_amount = (int)(Product_Price * tools.CheckFloat(Application["Coin_Rate"].ToString())); int member_grade; if (member_id > 0) { MemberInfo member = MyMem.GetMemberByID(member_id, Public.GetUserPrivilege()); if (member != null) { member_grade = member.Member_Grade; //检查会员等级优惠 IList <MemberGradeInfo> membergrade = GetMemberGrades(); if (membergrade != null) { foreach (MemberGradeInfo entity in membergrade) { if (member_grade == entity.Member_Grade_ID) { coin_amount = (int)(Product_Price * entity.Member_Grade_CoinRate); } } } } } return(coin_amount); }
/// <summary> /// 提现 /// </summary> /// <param name="WithdrawAccountID"></param> /// <param name="tranAmt"></param> /// <param name="Notes"></param> /// <returns></returns> public void Withdraw() { decimal tranAmt = (decimal)tools.CheckFloat(Request.Form["Withdraw"]); string Notes = "自助提交出金申请"; ZhongXinInfo PayAccountInfo = GetZhongXinBySuppleir(tools.NullInt(Session["supplier_id"])); if (PayAccountInfo == null) { pub.Msg("error", "错误信息", "您尚未绑定中信支付", false, "{back}"); } decimal accountAmount = GetAmount(PayAccountInfo.SubAccount); decimal withdrawFee = WithdrawFee(tranAmt, PayAccountInfo.ReceiptBank); if (accountAmount < (withdrawFee + tranAmt)) { pub.Msg("error", "错误信息", "本次出金金额应小于账户剩余金额", false, "{back}"); } string strResult = string.Empty; if (sendmessages.Withdraw(PayAccountInfo.SubAccount, PayAccountInfo.ReceiptAccount, PayAccountInfo.OpenAccountName, PayAccountInfo.BankCode, PayAccountInfo.BankName, tranAmt, PayAccountInfo.ReceiptBank, Notes, ref strResult)) { pub.Msg("positive", "操作成功", "您的出金申请已经提交,具体银行到账时间可能会有延迟,下午16点以后的出金申请将于次日处理,请耐心等待,不要重复提交出金。", true, "/supplier/zhongxin.aspx"); } else { pub.Msg("error", "错误信息", "您的出金申请提交失败,请核实您的出金收款银行账号、联行号、出金银行名称是否正确。", false, "{back}"); //pub.Msg("error", "错误信息", strResult, false, "{back}"); } }
public void EditKeywordBidding_Keyword() { int Keyword_ID = tools.CheckInt(Request.Form["Keyword_ID"]); double Keyword_MinPrice = tools.CheckFloat(Request.Form["Keyword_MinPrice"]); if (Keyword_MinPrice == 0) { Public.Msg("error", "错误信息", "请填写起步价", false, "{back}"); return; } KeywordBiddingKeywordInfo entity = GetKeywordBiddingKeywordID(Keyword_ID); if (entity != null) { entity.Keyword_MinPrice = Keyword_MinPrice; if (MyBLL.EditKeywordBiddingKeyword(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "keyword_list.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
//添加广告位置 public void AddAD_Position() { int Ad_Position_ID = tools.CheckInt(Request.Form["Ad_Position_ID"]); string Ad_Position_Name = tools.CheckStr(Request.Form["Ad_Position_Name"]); int Ad_Position_ChannelID = tools.CheckInt(Request.Form["Ad_Position_ChannelID"]); string Ad_Position_Value = tools.CheckStr(Request.Form["Ad_Position_Value"]); int Ad_Position_Width = tools.CheckInt(Request.Form["Ad_Position_Width"]); int Ad_Position_Height = tools.CheckInt(Request.Form["Ad_Position_Height"]); int Ad_Position_IsActive = tools.CheckInt(Request.Form["Ad_Position_IsActive"]); string Ad_Position_Site = Public.GetCurrentSite(); int U_Ad_Position_Marketing = tools.CheckInt(Request.Form["U_Ad_Position_Marketing"]); double U_Ad_Position_Price = tools.CheckFloat(Request.Form["U_Ad_Position_Price"]); if (Ad_Position_Name == "") { Public.Msg("error", "错误信息", "请填写位置名称", false, "{back}"); } if (Ad_Position_Value == "") { Public.Msg("error", "错误信息", "请填写位置代号", false, "{back}"); } ADPositionInfo entity = new ADPositionInfo(); entity.Ad_Position_ID = Ad_Position_ID; entity.Ad_Position_Name = Ad_Position_Name; entity.Ad_Position_ChannelID = Ad_Position_ChannelID; entity.Ad_Position_Value = Ad_Position_Value; entity.Ad_Position_Width = Ad_Position_Width; entity.Ad_Position_Height = Ad_Position_Height; entity.Ad_Position_IsActive = Ad_Position_IsActive; entity.Ad_Position_Site = Ad_Position_Site; entity.U_Ad_Position_Marketing = U_Ad_Position_Marketing; entity.U_Ad_Position_Price = U_Ad_Position_Price; if (Myposition.AddAD_Position(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "ad_position_add.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public void AddPackage() { int Package_ID = tools.CheckInt(Request.Form["Package_ID"]); string Package_Name = tools.CheckStr(Request.Form["Package_Name"]); int Package_IsInsale = tools.CheckInt(Request.Form["Package_IsInsale"]); int Package_StockAmount = tools.CheckInt(Request.Form["Package_StockAmount"]); int Package_Weight = tools.CheckInt(Request.Form["Package_Weight"]); double Package_Price = tools.CheckFloat(Request.Form["Package_Price"]); int Package_Sort = tools.CheckInt(Request.Form["Package_Sort"]); if (Package_Name.Length == 0) { Public.Msg("error", "错误信息", "请填写套装名称", false, "{back}"); } PackageInfo entity = new PackageInfo(); entity.Package_ID = Package_ID; entity.Package_Name = Package_Name; entity.Package_IsInsale = Package_IsInsale; entity.Package_StockAmount = Package_StockAmount; entity.Package_Weight = Package_Weight; entity.Package_Price = Package_Price; entity.Package_Sort = Package_Sort; entity.Package_Addtime = DateTime.Now; entity.Package_Site = Public.GetCurrentSite(); entity.PackageProductInfos = ReadPackageProduct(); if (MyBLL.AddPackage(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "Package_add.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public void AddDeliveryWay() { int Delivery_Way_ID = tools.CheckInt(Request.Form["Delivery_Way_ID"]); string Delivery_Way_Name = tools.CheckStr(Request.Form["Delivery_Way_Name"]); int Delivery_Way_Sort = tools.CheckInt(Request.Form["Delivery_Way_Sort"]); int Delivery_Way_InitialWeight = tools.CheckInt(Request.Form["Delivery_Way_InitialWeight"]); int Delivery_Way_UpWeight = tools.CheckInt(Request.Form["Delivery_Way_UpWeight"]); int Delivery_Way_FeeType = tools.CheckInt(Request.Form["Delivery_Way_FeeType"]); double Delivery_Way_Fee = tools.CheckFloat(Request.Form["Delivery_Way_Fee"]); double Delivery_Way_InitialFee = tools.CheckFloat(Request.Form["Delivery_Way_InitialFee"]); double Delivery_Way_UpFee = tools.CheckFloat(Request.Form["Delivery_Way_UpFee"]); int Delivery_Way_Status = tools.CheckInt(Request.Form["Delivery_Way_Status"]); int Delivery_Way_Cod = tools.CheckInt(Request.Form["Delivery_Way_Cod"]); string Delivery_Way_Img = tools.CheckStr(Request.Form["Delivery_Way_Img"]); string Delivery_Way_Url = tools.CheckStr(Request.Form["Delivery_Way_Url"]); string Delivery_Way_Intro = Request.Form["Delivery_Way_Intro"]; if (Delivery_Way_Name.Length == 0) { Public.Msg("error", "错误信息", "请填写配送方式名称", false, "{back}"); return; } DeliveryWayInfo entity = new DeliveryWayInfo(); entity.Delivery_Way_ID = Delivery_Way_ID; entity.Delivery_Way_Name = Delivery_Way_Name; entity.Delivery_Way_Sort = Delivery_Way_Sort; entity.Delivery_Way_InitialWeight = Delivery_Way_InitialWeight; entity.Delivery_Way_UpWeight = Delivery_Way_UpWeight; entity.Delivery_Way_FeeType = Delivery_Way_FeeType; entity.Delivery_Way_Fee = Delivery_Way_Fee; entity.Delivery_Way_InitialFee = Delivery_Way_InitialFee; entity.Delivery_Way_UpFee = Delivery_Way_UpFee; entity.Delivery_Way_Status = Delivery_Way_Status; entity.Delivery_Way_Cod = Delivery_Way_Cod; entity.Delivery_Way_Img = Delivery_Way_Img; entity.Delivery_Way_Url = Delivery_Way_Url; entity.Delivery_Way_Intro = Delivery_Way_Intro; entity.Delivery_Way_Site = Public.GetCurrentSite(); if (MyBLL.AddDeliveryWay(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "delivery_way_list.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public void AddPurchasing() { int Purchasing_ID = tools.CheckInt(Request.Form["Purchasing_ID"]); int Purchasing_Type = tools.CheckInt(Request.Form["Purchasing_Type"]); int Purchasing_DepotID = tools.CheckInt(Request.Form["Purchasing_DepotID"]); int Purchasing_SupplierID = tools.CheckInt(Request.Form["Purchasing_SupplierID"]); string Purchasing_ProductCode = tools.CheckStr(Request.Form["Purchasing_ProductCode"]); double Purchasing_Price = tools.CheckFloat(Request.Form["Purchasing_Price"]); int Purchasing_Amount = tools.CheckInt(Request.Form["Purchasing_Amount"]); double Purchasing_TotalPrice = tools.CheckFloat(Request.Form["Purchasing_TotalPrice"]); string Purchasing_BatchNumber = tools.CheckStr(Request.Form["Purchasing_BatchNumber"]); string Purchasing_Operator = Session["User_Name"].ToString(); int Purchasing_Checkout = tools.CheckInt(Request.Form["Purchasing_Checkout"]); int Purchasing_IsNoStock = 0; DateTime Purchasing_Tradetime = Public.ChangeToDate(tools.CheckStr(Request.Form["Purchasing_Tradetime"])); string Purchasing_Note = tools.CheckStr(Request.Form["Purchasing_Note"]); if (Purchasing_ProductCode.Length == 0) { Public.Msg("error", "错误信息", "请填写商品编码", false, "{back}"); return; } if (Purchasing_Type == 2 || Purchasing_Type == 4) { Purchasing_Amount = 0 - Purchasing_Amount; } ProductInfo productinfo = PROBLL.GetProductByCode(Purchasing_ProductCode, Public.GetCurrentSite(), Public.GetUserPrivilege()); if (productinfo != null) { Purchasing_IsNoStock = productinfo.Product_IsNoStock; if (productinfo.Product_SupplierID > 0) { productinfo = null; } } if (productinfo == null) { Public.Msg("error", "错误信息", "无效的商品编码", false, "{back}"); return; } string SqlAdd = "INSERT INTO SCM_Purchasing (" + "Purchasing_Type, Purchasing_DepotID, Purchasing_SupplierID, Purchasing_ProductCode, Purchasing_Price, Purchasing_Amount" + ", Purchasing_TotalPrice, Purchasing_BatchNumber, Purchasing_Operator, Purchasing_Checkout,Purchasing_IsNoStock, Purchasing_Tradetime, Purchasing_Note) " + "VALUES (" + Purchasing_Type + ", " + Purchasing_DepotID + ", " + Purchasing_SupplierID + ", '" + Purchasing_ProductCode + "'" + ", " + Purchasing_Price + ", " + Purchasing_Amount + ", " + Purchasing_TotalPrice + ", '" + Purchasing_BatchNumber + "'" + ", '" + Purchasing_Operator + "'" + ", " + Purchasing_Checkout + "" + ", " + Purchasing_IsNoStock + "" + ", '" + Purchasing_Tradetime + "'" + ", '" + Purchasing_Note + "')"; try { DBHelper.ExecuteNonQuery(SqlAdd); //更新商品库存 PROBLL.UpdateProductStock(Purchasing_ProductCode, Purchasing_Amount, Purchasing_Amount); } catch (Exception ex) { throw ex; } Public.Msg("positive", "操作成功", "操作成功", true, "purchasing_list.aspx?Purchasing_Type=" + Purchasing_Type); }
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); } }