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