public static Hashtable Insert(Model.BankModel model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder sb = new StringBuilder("insert into BankModel (BankCode,Bank,Branch,BankNumber,BankCardName,MID,IsPrimary,BankCreateDate) ");
sb.Append("values");
sb.Append("(@BankCode,@Bank,@Branch,@BankNumber,@BankCardName,@MID,@IsPrimary,@BankCreateDate);");
sb.AppendFormat("select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@BankCode", SqlDbType.VarChar, 36),
new SqlParameter("@Bank", SqlDbType.VarChar, 50),
new SqlParameter("@Branch", SqlDbType.VarChar, 50),
new SqlParameter("@BankNumber", SqlDbType.VarChar, 30),
new SqlParameter("@BankCardName", SqlDbType.VarChar, 20),
new SqlParameter("@MID", SqlDbType.VarChar, 20),
new SqlParameter("@IsPrimary", SqlDbType.Bit, 1),
new SqlParameter("@BankCreateDate", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.BankCode;
parameters[1].Value = model.Bank;
parameters[2].Value = model.Branch;
parameters[3].Value = model.BankNumber;
parameters[4].Value = model.BankCardName;
parameters[5].Value = model.MID;
parameters[6].Value = model.IsPrimary;
parameters[7].Value = model.BankCreateDate;
MyHs.Add(sb.ToString(), parameters);
return(MyHs);
}
protected override void SetValue()
{
EPCONFIG = BLL.EPConfig.EPConfigModel;
Model.BankModel ban = BLL.BankModel.GetList("MID='" + TModel.MID + "' and IsPrimary=1").FirstOrDefault();
if (ban != null)
{
BankInfo = new CommonBLL.Sys_BankInfoBLL().GetModel(ban.Bank);
}
//300的倍数
for (int i = 1; i <= 10; i++)
{
rdMoney += "<input name='rdMoney' id='rdMoney" + i.ToString() + "' value='" + (i * 300).ToString() + "' type='radio' />" + (i * 300).ToString() + " ";
}
}
protected override string btnAdd_Click()
{
Hashtable hs = new Hashtable();
Model.BankModel bank = BankInfo;
BLL.BankModel.Insert(bank, hs);
bank.Bank = "3";
bank.BankCardName = "支付宝";
bank.BankNumber = Request.Form["txtAlPay"];
bank.Branch = "支付宝";
BLL.BankModel.Insert(bank, hs);
if (BLL.CommonBase.RunHashtable(hs))
{
return("操作成功");
}
return("操作失败");
}
public static bool Update(Model.BankModel model)
{
Hashtable MyHs = new Hashtable();
DAL.BankModel.Update(model, MyHs);
List <Model.BankModel> list = BLL.BankModel.GetList(" MID='" + model.MID + "' order by IsPrimary desc,BankCreateDate asc ");
list = list.Where(emp => emp.BankCode != model.BankCode).ToList();
if (model.IsPrimary)
{
Model.Member member = DAL.Member.GetModel(model.MID);
member.Bank = model.Bank;
member.Branch = model.Branch;
member.BankNumber = model.BankNumber;
member.BankCardName = model.BankCardName;
DAL.Member.UpdateBankInfo(member, MyHs);
foreach (Model.BankModel item in list)
{
item.IsPrimary = false;
Update(item, MyHs);
}
}
else
{
if (list.Where(emp => emp.IsPrimary).Count() <= 0)
{
list[0].IsPrimary = true;
Update(list[0], MyHs);
Model.Member member = DAL.Member.GetModel(list[0].MID);
member.Bank = list[0].Bank;
member.Branch = list[0].Branch;
member.BankNumber = list[0].BankNumber;
member.BankCardName = list[0].BankCardName;
DAL.Member.UpdateBankInfo(member, MyHs);
}
}
return(DAL.CommonBase.RunHashtable(MyHs));
}
private static Model.BankModel TranEntity(DataRow dr)
{
Model.BankModel model = new Model.BankModel();
if (!string.IsNullOrEmpty(dr["BankCreateDate"].ToString()))
{
model.BankCreateDate = DateTime.Parse(dr["BankCreateDate"].ToString());
}
if (!string.IsNullOrEmpty(dr["Bank"].ToString()))
{
model.Bank = dr["Bank"].ToString();
model.BankInfo = Sys_BankInfoDAL.GetModel(dr["Bank"]);
}
if (!string.IsNullOrEmpty(dr["BankCardName"].ToString()))
{
model.BankCardName = dr["BankCardName"].ToString();
}
if (!string.IsNullOrEmpty(dr["BankCode"].ToString()))
{
model.BankCode = dr["BankCode"].ToString();
}
if (!string.IsNullOrEmpty(dr["BankNumber"].ToString()))
{
model.BankNumber = dr["BankNumber"].ToString();
}
if (!string.IsNullOrEmpty(dr["Branch"].ToString()))
{
model.Branch = dr["Branch"].ToString();
}
if (!string.IsNullOrEmpty(dr["MID"].ToString()))
{
model.MID = dr["MID"].ToString();
}
if (!string.IsNullOrEmpty(dr["IsPrimary"].ToString()))
{
model.IsPrimary = bool.Parse(dr["IsPrimary"].ToString());
}
return(model);
}
public static Hashtable Update(Model.BankModel model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder sb = new StringBuilder("update BankModel set ");
sb.Append("Bank=@Bank,");
sb.Append("Branch=@Branch,");
sb.Append("BankNumber=@BankNumber,");
sb.Append("BankCardName=@BankCardName,");
sb.Append("MID=@MID,");
sb.Append("IsPrimary=@IsPrimary,");
sb.Append("BankCreateDate=@BankCreateDate");
sb.Append(" where ");
sb.AppendFormat("BankCode=@BankCode and '{0}'='{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@BankCode", SqlDbType.VarChar, 36),
new SqlParameter("@Bank", SqlDbType.VarChar, 50),
new SqlParameter("@Branch", SqlDbType.VarChar, 50),
new SqlParameter("@BankNumber", SqlDbType.VarChar, 30),
new SqlParameter("@BankCardName", SqlDbType.VarChar, 20),
new SqlParameter("@MID", SqlDbType.VarChar, 20),
new SqlParameter("@IsPrimary", SqlDbType.Bit, 1),
new SqlParameter("@BankCreateDate", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.BankCode;
parameters[1].Value = model.Bank;
parameters[2].Value = model.Branch;
parameters[3].Value = model.BankNumber;
parameters[4].Value = model.BankCardName;
parameters[5].Value = model.MID;
parameters[6].Value = model.IsPrimary;
parameters[7].Value = model.BankCreateDate;
MyHs.Add(sb.ToString(), parameters);
return(MyHs);
}
public static Hashtable Update(Model.BankModel model, Hashtable MyHs)
{
DAL.BankModel.Update(model, MyHs);
return(MyHs);
}
public static Hashtable Insert(Model.BankModel model, Hashtable MyHs)
{
DAL.BankModel.Insert(model, MyHs);
return(MyHs);
}
public override void ProcessRequest(HttpContext context)
{
base.ProcessRequest(context);
string strWhere = " 1=1 ";
if (!string.IsNullOrEmpty(context.Request["tState"]))
{
strWhere += " and SellState = " + context.Request["tState"] + " ";
}
if (!string.IsNullOrEmpty(context.Request["mKey"]))
{
strWhere += " and SellMID='" + context.Request["mKey"] + "' ";
}
if (!string.IsNullOrEmpty(context.Request["startDate"]))
{
strWhere += " and SellDate>'" + context.Request["startDate"] + " 00:00:00' ";
}
if (!string.IsNullOrEmpty(context.Request["endDate"]))
{
strWhere += " and SellDate<'" + context.Request["endDate"] + " 23:59:59' ";
}
if (TModel.MID != "admin")
{
strWhere += " and SellMID = '" + TModel.MID + "'";
}
int count;
List <Model.EPList> EPList = BLL.EPList.GetList(strWhere, pageIndex, pageSize, out count);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < EPList.Count; i++)
{
Model.Member member = BllModel.GetModel(EPList[i].SellMID);
sb.Append(EPList[i].EPID + "~");
sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~");
sb.Append(Math.Round(EPList[i].Money, 2) + EPList[i].TakeOffMoney + "~");
sb.Append(WE_Project.BLL.Reward.List[EPList[i].MoneyType].RewardName + "~");
sb.Append(Math.Round(EPList[i].Money * BLL.Configuration.Model.OutFloat, 2) + "~");
sb.Append(EPList[i].SellMID + "~");
sb.Append(member.MConfig.EPXingJiStr + "~");
//卖家银行信息
string bank = member.Bank, bankBranch = member.Branch, bankNum = member.BankNumber, bankName = member.BankCardName;
Model.BankModel ban = BLL.BankModel.GetList("MID='" + member.MID + "' and IsPrimary=1").FirstOrDefault();
if (ban != null)
{
bank = new CommonBLL.Sys_BankInfoBLL().GetModel(ban.Bank).Name;
bankBranch = ban.Branch;
bankNum = ban.BankNumber;
bankName = ban.BankCardName;
}
sb.Append(bank + "~");
sb.Append(bankBranch + "~");
sb.Append(bankNum + "~");
sb.Append(bankName + "~");
//end
sb.Append(EPList[i].SellDate + "~");
sb.Append(EPList[i].BuyMID + "~");
sb.Append(EPList[i].BuyDate + "~");
if (EPList[i].SellState == 0)
{
sb.Append("<a href='javascript:void(0)' onclick=\"RunAjaxByList11('false','EPDelete','" + EPList[i].EPID + "')\">[取消]</a>");
}
else if (EPList[i].SellState == 1)
{
sb.Append("等待买家付款");
}
else if (EPList[i].SellState == 2)
{
//sb.Append("<a href='javascript:void(0)' onclick=\"RunAjaxByList11('false','EPsellLast','" + EPList[i].EPID + "')\">[确认收款]</a>|<a href='javascript:void(0)' onclick=\"RunAjaxByList11('false','EPClose','" + EPList[i].EPID + "')\">[关闭交易]</a>");
sb.Append("<a href='javascript:void(0)' onclick=\"RunAjaxByList11('false','EPsellLast','" + EPList[i].EPID + "')\">[确认收款]</a>");
}
else if (EPList[i].SellState == 3)
{
sb.Append("已完成");
}
else if (EPList[i].SellState == 4)
{
sb.Append("已关闭");
}
sb.Append("≌");
sb.Append("@");
//数量
sb.Append("8");
sb.Append("@");
//内容(买家信息)
var buyModel = BLL.Member.GetModelByMID(EPList[i].BuyMID);
if (buyModel != null)
{
sb.AppendFormat("信用等级:" + buyModel.MConfig.EPXingJiStr);
sb.AppendFormat("<br />提现方式:" + buyModel.Bank);
sb.AppendFormat("<br />开户支行:" + buyModel.Branch);
sb.AppendFormat("<br />开户姓名:" + buyModel.BankCardName);
sb.AppendFormat("<br />开户帐号:" + buyModel.BankNumber);
sb.AppendFormat("<br />手机号码:" + buyModel.Tel);
sb.AppendFormat("<br />QQ:" + buyModel.QQ);
}
sb.Append("≌");
}
var info = new { PageData = Traditionalized(sb), TotalCount = count };
context.Response.Write(JavaScriptConvert.SerializeObject(info));
}
public override void ProcessRequest(HttpContext context)
{
base.ProcessRequest(context);
string strWhere = " 1=1 ";
Model.Member memberModel = (TModel == null ? BllModel.TModel : TModel);
if (!string.IsNullOrEmpty(context.Request["tState"]))
{
string[] fanwei = context.Request["tState"].Split('-');
if (fanwei.Length > 1)
{
strWhere += " and Money between " + fanwei[0] + " and " + fanwei[1] + " ";
}
else
{
strWhere += " and Money>" + fanwei[0] + " ";
}
}
if (!string.IsNullOrEmpty(context.Request["mKey"]))
{
strWhere += " and SellMID='" + context.Request["mKey"] + "' ";
}
if (!string.IsNullOrEmpty(context.Request["startDate"]))
{
strWhere += " and SellDate>'" + context.Request["startDate"] + " 00:00:00' ";
}
if (!string.IsNullOrEmpty(context.Request["endDate"]))
{
strWhere += " and SellDate<'" + context.Request["endDate"] + " 23:59:59' ";
}
strWhere += " and SellState = 0 and SellMID<>'" + TModel.MID + "'";
int count;
List <Model.EPList> EPList = new List <Model.EPList>();
if (memberModel.Role.IsAdmin)
{
EPList = BLL.EPList.GetList(strWhere, pageIndex, pageSize, out count);
}
else
{
count = 10;
EPList = BLL.EPList.GetTopList(10, strWhere, "EPID desc");
}
StringBuilder sb = new StringBuilder();
for (int i = 0; i < EPList.Count; i++)
{
Model.Member member = BllModel.GetModel(EPList[i].SellMID);
sb.Append(EPList[i].EPID + "~");
sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~");
sb.Append(EPList[i].SellMID + "~");
sb.Append(member.MConfig.EPXingJiStr + "~");
sb.Append(Math.Round(EPList[i].Money, 2) + "~");
//sb.Append(Math.Round(EPList[i].Money * BLL.Configuration.Model.OutFloat, 2) + "~");
//卖家银行信息
string bank = member.Bank, bankBranch = member.Branch, bankNum = member.BankNumber, bankName = member.BankCardName;
Model.BankModel ban = BLL.BankModel.GetList("MID='" + member.MID + "' and IsPrimary=1").FirstOrDefault();
if (ban != null)
{
bank = new CommonBLL.Sys_BankInfoBLL().GetModel(ban.Bank).Name;
bankBranch = ban.Branch;
bankNum = ban.BankNumber;
bankName = ban.BankCardName;
}
sb.Append(bank + "~");
sb.Append(bankBranch + "~");
sb.Append(bankNum + "~");
sb.Append(bankName + "~");
//end
sb.Append(EPList[i].SellDate.ToString("yyyy-MM-dd HH:mm") + "~");
if (EPList[i].SellState == 0)
{
sb.Append("<a href='javascript:void(0)' onclick=\"RunAjaxByList11('false','EPbuy','" + EPList[i].EPID + "')\">[购买]</a>");
}
else if (EPList[i].SellState == 3)
{
sb.Append("已完成");
}
else if (EPList[i].SellState == 4)
{
sb.Append("已关闭");
}
else
{
sb.Append("已锁定");
}
sb.Append("≌");
}
//sb.Append("@");
////数量
//sb.Append("9");
//sb.Append("@");
////内容(买家信息)
//var buyModel = BLL.Member.GetModelByMID(EPList[i].SellMID);
//if (buyModel != null)
//{
// sb.AppendFormat("信用等级:" + buyModel.MConfig.EPXingJiStr);
// sb.AppendFormat("<br />提现方式:" + buyModel.Bank);
// sb.AppendFormat("<br />开户支行:" + buyModel.Branch);
// sb.AppendFormat("<br />开户姓名:" + buyModel.BankCardName);
// sb.AppendFormat("<br />开户帐号:" + buyModel.BankNumber);
// sb.AppendFormat("<br />手机号码:" + buyModel.Tel);
// sb.AppendFormat("<br />QQ:" + buyModel.QQ);
//}
//sb.Append("≌");
var info = new { PageData = Traditionalized(sb), TotalCount = count };
context.Response.Write(JavaScriptConvert.SerializeObject(info));
}
