protected void Page_Load(object sender, EventArgs e)
{
id = RequestTool.RequestInt("id", 0);
if (id == 0)
{
if (!EX_Admin.Power("supplier_money_add", "添加商家资金"))
{
WindowNoPower();
}
}
else
{
if (!EX_Admin.Power("supplier_money_edit", "编辑商家资金"))
{
WindowNoPower();
}
}
int user_id = RequestTool.RequestInt("user_id", 0);
model = B_Lebi_Supplier_Money.GetModel(id);
if (model == null)
{
model = new Lebi_Supplier_Money();
model.Type_id_MoneyStatus = 181; //有效资金
model.Type_id_SupplierMoneyType = 344; //人工调整
Money = "";
}
else
{
Money = FormatMoney(model.Money, "Number");
user_id = model.Supplier_id;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Power("supplier_usermoney_list", "资金明细"))
{
PageReturnMsg = PageNoPowerMsg();
}
PageSize = RequestTool.getpageSize(25);
int user_id = RequestTool.RequestInt("user_id", 0);
key = RequestTool.RequestString("key");
dateFrom = RequestTool.RequestString("dateFrom");
dateTo = RequestTool.RequestString("dateTo");
status = RequestTool.RequestInt("status", 0);
DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom");
DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo");
string where = "Supplier_id = " + CurrentSupplier.id + "";
if (status > 0)
{
where += " and Type_id_PointStatus=" + status + "";
}
if (key != "")
{
where += " and Remark like lbsql{'%" + key + "%'}";
}
if (dateFrom != "" && dateTo != "")
{
where += " and (datediff(d,Time_Add,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Add,'" + FormatDate(lbsql_dateTo) + "')>=0)";
}
models = B_Lebi_Supplier_Money.GetList(where, "id desc", PageSize, page);
int recordCount = B_Lebi_Supplier_Money.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationString("?page={0}&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&status = " + status, page, PageSize, recordCount);
//string money_ = Common.GetValue("select sum(Money) from Lebi_Supplier_Money where Supplier_id=" + CurrentSupplier.id + " and Type_id_MoneyStatus = 181 and datediff(d,Time_add,'" + System.DateTime.Now + "')>=" + CurrentSupplier.BillingDays + "");
string zmoney_ = Common.GetValue("select sum(Money) from Lebi_Supplier_Money where Supplier_id=" + CurrentSupplier.id + " and Type_id_MoneyStatus = 181");
string money_fu_ = B_Lebi_Supplier_Money.GetValue("sum(Money)", "Supplier_id=" + CurrentSupplier.id + " and Type_id_MoneyStatus=181 and Type_id_SupplierMoneyType in (342,343)");
string money_ = B_Lebi_Supplier_Money.GetValue("sum(Money)", "Supplier_id=" + CurrentSupplier.id + " and Type_id_MoneyStatus=181 and Type_id_SupplierMoneyType in (341,344) and datediff(d,Time_add,'" + System.DateTime.Now + "')>=" + CurrentSupplier.BillingDays + "");
decimal money_fu = 0;
decimal.TryParse(money_, out money);
decimal.TryParse(zmoney_, out zmoney);
decimal.TryParse(money_fu_, out money_fu);
money = money + money_fu;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("supplier_money_list", "资金明细"))
{
PageReturnMsg = PageNoPowerMsg();
}
PageSize = RequestTool.getpageSize(25);
user_id = RequestTool.RequestInt("user_id", 0);
key = RequestTool.RequestString("key");
dateFrom = RequestTool.RequestString("dateFrom");
dateTo = RequestTool.RequestString("dateTo");
status = RequestTool.RequestInt("status", 0);
DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom");
DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo");
string where = "1=1";
if (status > 0)
{
where += " and Type_id_MoneyStatus=" + status + "";
}
if (user_id > 0)
{
where += " and Supplier_id=" + user_id + "";
}
if (key != "")
{
where += " and (Supplier_id in (select id from [Lebi_Supplier] where UserName like lbsql{'%" + key + "%'} or RealName like lbsql{'%" + key + "%'}) or Remark like lbsql{'%" + key + "%'})";
}
if (dateFrom != "" && dateTo != "")
{
where += " and (datediff(d,Time_Add,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Add,'" + FormatDate(lbsql_dateTo) + "')>=0)";
}
models = B_Lebi_Supplier_Money.GetList(where, "id desc", PageSize, page);
int recordCount = B_Lebi_Supplier_Money.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationString("?page={0}&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&status = " + status + "&user_id = " + user_id, page, PageSize, recordCount);
user = B_Lebi_Supplier.GetModel(user_id);
if (user == null)
{
user = new Lebi_Supplier();
}
}
/// <summary>
/// 删除商家
/// </summary>
public void User_Del()
{
if (!EX_Admin.Power("supplier_user_del", "删除商家"))
{
AjaxNoPower();
return;
}
string id = RequestTool.RequestString("ids");
if (id == "")
{
Response.Write("{\"msg\":\"" + Tag("请选择要删除的信息") + "\"}");
return;
}
B_Lebi_Supplier.Delete("id in (lbsql{" + id + "})");
List <Lebi_Order> modellist = B_Lebi_Order.GetList("Supplier_id in (lbsql{" + id + "})", "");
foreach (Lebi_Order model in modellist)
{
B_Lebi_Order.Delete("id = " + model.id + "");
B_Lebi_Order_Log.Delete("Order_id = " + model.id + "");
B_Lebi_Order_Product.Delete("Order_id = " + model.id + "");
}
B_Lebi_Brand.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_ProPerty.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_ProPerty_Tag.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_Cash.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_Message.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_Supplier_Money.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_Supplier_Bank.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_Supplier_BillType.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_Supplier_ProductType.Delete("Supplier_id in (lbsql{" + id + "})");
//B_Lebi_Supplier_Verified.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_Supplier_Verified_Log.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_Log.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_ServicePanel.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_ServicePanel_Group.Delete("Supplier_id in (lbsql{" + id + "})");
Log.Add("删除商家", "Supplier_User", id.ToString(), CurrentAdmin, id.ToString());
Response.Write("{\"msg\":\"OK\"}");
}
/// <summary>
/// 编辑商家资金
/// </summary>
public void Money_Edit()
{
int id = RequestTool.RequestInt("id", 0);
SearchUser su = new SearchUser(CurrentAdmin, CurrentLanguage.Code);
if (id > 0)
{
if (!EX_Admin.Power("supplier_money_edit", "编辑商家资金"))
{
AjaxNoPower();
return;
}
Lebi_Supplier_Money model = B_Lebi_Supplier_Money.GetModel(id);
Lebi_Supplier user = B_Lebi_Supplier.GetModel(model.Supplier_id);
if (user == null)
{
Response.Write("{\"msg\":\"" + Tag("商家账号不存在") + "\"}");
return;
}
model.Type_id_MoneyStatus = RequestTool.RequestInt("Type_id_MoneyStatus", 0);
model.Type_id_SupplierMoneyType = RequestTool.RequestInt("Type_id_SupplierMoneyType", 0);
model.Admin_UserName = CurrentAdmin.UserName;
model.Admin_id = CurrentAdmin.id;
model.Remark = RequestTool.RequestString("Remark");
model.Time_Update = DateTime.Now;
B_Lebi_Supplier_Money.Update(model);
EX_Supplier.UpdateUserMoney(user);
Log.Add("编辑商家资金", "Supplier_Money", id.ToString(), CurrentAdmin, user.UserName);
}
else
{
if (!EX_Admin.Power("supplier_money_add", "添加商家资金"))
{
AjaxNoPower();
return;
}
string Mode = RequestTool.RequestString("mode");
string User_Name_To = RequestTool.RequestString("User_Name_To");
string UserLevel_ids = RequestTool.RequestString("UserLevel_ids");
string User_ids = RequestTool.RequestString("User_ids");
string UserName_ids = RequestTool.RequestString("UserName_ids");
Lebi_Supplier user = B_Lebi_Supplier.GetModel("UserName = lbsql{'" + User_Name_To + "'}");
if (user == null)
{
Response.Write("{\"msg\":\"" + Tag("商家账号不存在") + "\"}");
return;
}
Lebi_Supplier_Money model = new Lebi_Supplier_Money();
Log.Add("添加商家资金", "Supplier_Money", id.ToString(), CurrentAdmin, User_Name_To + " ->" + RequestTool.RequestDecimal("Money", 0));
model.Money = RequestTool.RequestDecimal("Money", 0);
model.Type_id_MoneyStatus = RequestTool.RequestInt("Type_id_MoneyStatus", 0);
model.Type_id_SupplierMoneyType = RequestTool.RequestInt("Type_id_SupplierMoneyType", 0);
model.Admin_UserName = CurrentAdmin.UserName;
model.Admin_id = CurrentAdmin.id;
model.Remark = RequestTool.RequestString("Remark");
model.Time_Update = DateTime.Now;
model.Supplier_id = user.id;
model.User_UserName = user.UserName;
model.Supplier_SubName = user.SubName;
B_Lebi_Supplier_Money.Add(model);
EX_Supplier.UpdateUserMoney(user);
}
string result = "{\"msg\":\"OK\"}";
Response.Write(result);
}
