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);
}
}
