public static Hashtable Insert(Model.ConfigDictionary model, Hashtable MyHs) { StringBuilder sb = new StringBuilder(); string guid = Guid.NewGuid().ToString(); sb.Append("insert into ConfigDictionary(StartLevel,EndLevel,DValue,DType,DKey,Remark)"); sb.Append("values"); sb.Append("(@StartLevel,@EndLevel,@DValue,@DType,@DKey,@Remark)"); sb.AppendFormat("; select '{0}';", guid); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@StartLevel", SqlDbType.Int, 4), new SqlParameter("@EndLevel", SqlDbType.Int, 4), new SqlParameter("@DValue", SqlDbType.VarChar, 10), new SqlParameter("@DType", SqlDbType.VarChar, 10), new SqlParameter("@DKey", SqlDbType.VarChar, 10), new SqlParameter("@Remark", SqlDbType.VarChar, 10) }; para[0].Value = model.StartLevel; para[1].Value = model.EndLevel; para[2].Value = model.DValue; para[3].Value = model.DType; para[4].Value = model.DKey; para[5].Value = model.Remark; MyHs.Add(sb.ToString(), para); return(MyHs); }
protected override string btnAdd_Click() { lock (obj) { string moneyStr = Request.Form["txtCount"]; decimal money = 0; try { money = Convert.ToDecimal(moneyStr); if (money < 0) { return("复投金额必须大于0"); } } catch { return("请输入正确的复投金额"); } int cdday = 0; try { cdday = Convert.ToInt32(Request.Form["TranDate"]); } catch (Exception e) { return(e.Message); } Model.ConfigDictionary cd = BLL.Configuration.GetConfigDictionary(cdday, "TranConfig", ""); if (cd == null) { return("请选择正确的投资天数"); } //剩余可复投钱数 string MoneyType = "MHB"; if (Request.Form["rdo"] == "MHB") { MoneyType = "MHB"; } else if (Request.Form["rdo"] == "MJB") { MoneyType = "MJB"; } decimal HelpBase = 0; decimal HelpMax = 0; if (MoneyType == "MJB")//许愿池派单 { HelpBase = BLL.MMMConfig.Model.GetHelpDayTotalMoney; HelpMax = BLL.MMMConfig.Model.OfferHelpDayTotalMoney * TModel.MConfig.MJB; var lastmodel = BLL.MGetHelp.GetList(" SQMID='" + TModel.MID + "' order by SQDate desc ").FirstOrDefault(); if (lastmodel != null) { if (lastmodel.SQMoney > money) { return("您的转入额度不能比上一单小"); } } if (money % HelpBase != 0) { return("转入金额应为" + HelpBase + "的倍数"); } if (money > HelpMax || money < BLL.MMMConfig.Model.GetHelpMin) { return("转入失败,转入范围应在" + BLL.MMMConfig.Model.GetHelpMin + "-" + HelpMax); } } if (BLL.ChangeMoney.EnoughChange(TModel.MID, money, MoneyType)) { Model.BMember model = new Model.BMember(); model.AMID = TModel.MID; model.BMID = TModel.MID + DateTime.Now.ToString("yyyyMMddHHmmssfff"); model.BMCreateDate = DateTime.Now; model.BMDate = DateTime.MaxValue; model.BMBD = MoneyType; model.FHDays = 0; model.YJMoney = Convert.ToDecimal(cd.DKey); model.YJCount = money; model.BOutMoney = cd.StartLevel; model.BMState = false; model.BCount = Convert.ToDecimal(cd.DValue); Hashtable MyHs = new Hashtable(); BLL.ChangeMoney.HBChangeTran(money, TModel.MID, BLL.Member.ManageMember.TModel.MID, "Tran", TModel, MoneyType, BLL.Reward.List[MoneyType].RewardName + "转入许愿台", MyHs); BLL.BMember.Insert(model, MyHs); if (BLL.CommonBase.RunHashtable(MyHs)) { return("转入成功"); } else { return("转入失败"); } } else { return("您的" + BLL.Reward.List[MoneyType].RewardName + "不足"); } } }