protected override string btnAdd_Click() { int count = int.Parse(Request.Form["txtCount"]); DateTime payDate = DateTime.Now; string msg = Request.Form["txtRemark"]; string picurl = Request.Form["hduploadPic1"]; if (string.IsNullOrEmpty(picurl)) { return("请上传打款凭证"); } Model.BuyActiveCode buy = new Model.BuyActiveCode(); buy.CodeCount = count; buy.CreateTime = DateTime.Now; buy.FromMID = TModel.MID; buy.ToMID = BLL.Member.ManageMember.TModel.MID; buy.State = 0; buy.PicUrl = picurl; buy.Remark = msg; buy.PayTime = payDate; if (BLL.BuyActiveCode.Insert(buy)) { return("1"); } return("申请失败"); }
protected override void SetValue(string id) { BuyActiveCodeModel = BLL.BuyActiveCode.GetModel(id); if (BuyActiveCodeModel.State == 1) { btnOK.Visible = false; } hidId.Value = id; string picUrl = BuyActiveCodeModel.PicUrl; string[] array = picUrl.Split(','); foreach (string str in array) { picImgs += "<div class='appDiv'><img class='appImg' src='" + str + "' style='max-width: 700px;'/></div>"; } }
/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(Model.BuyActiveCode model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update BuyActiveCode set "); strSql.Append(" CodeCount = @CodeCount , "); strSql.Append(" FromMID = @FromMID , "); strSql.Append(" ToMID = @ToMID , "); strSql.Append(" PayTime = @PayTime , "); strSql.Append(" ConfirmTime = @ConfirmTime , "); strSql.Append(" PicUrl = @PicUrl , "); strSql.Append(" Remark = @Remark , "); strSql.Append(" State = @State , "); strSql.Append(" CreateTime = @CreateTime "); strSql.Append(" where Id=@Id "); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@CodeCount", SqlDbType.Int, 4), new SqlParameter("@FromMID", SqlDbType.VarChar, 50), new SqlParameter("@ToMID", SqlDbType.VarChar, 50), new SqlParameter("@PayTime", SqlDbType.DateTime), new SqlParameter("@ConfirmTime", SqlDbType.DateTime), new SqlParameter("@PicUrl", SqlDbType.VarChar, 500), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.Id; parameters[1].Value = model.CodeCount; parameters[2].Value = model.FromMID; parameters[3].Value = model.ToMID; parameters[4].Value = model.PayTime; parameters[5].Value = model.ConfirmTime; parameters[6].Value = model.PicUrl; parameters[7].Value = model.Remark; parameters[8].Value = model.State; parameters[9].Value = model.CreateTime; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
protected override string btnAdd_Click() { if (!TModel.Role.IsAdmin) { return("失败"); } BuyActiveCodeModel = BLL.BuyActiveCode.GetModel(Request.Form["hidId"]); if (BuyActiveCodeModel != null) { Hashtable hs = new Hashtable(); BuyActiveCodeModel.ConfirmTime = DateTime.Now; BuyActiveCodeModel.State = 1; BLL.BuyActiveCode.Update(BuyActiveCodeModel, hs); //发送校验码 lock (new object()) { //List<Model.ActiveCode> codeList = BLL.ActiveCode.GetTopList("UseState=0", BuyActiveCodeModel.CodeCount); List <Model.ActiveCode> codeList = BLL.ActiveCode.GetTopList("UseState=0 and MID='" + BuyActiveCodeModel.ToMID + "'", BuyActiveCodeModel.CodeCount); int i = 0; foreach (Model.ActiveCode ac in codeList) { i++; ac.MID = BuyActiveCodeModel.FromMID; //ac.UseState = 1; BLL.ChangeMoney.InsertTran(new Model.ChangeMoney { FromMID = BuyActiveCodeModel.ToMID, ToMID = BuyActiveCodeModel.FromMID, CompleteTime = DateTime.Now, ChangeType = "Active", MoneyType = "Active", CRemarks = ac.Code, ChangeDate = DateTime.Now, CState = true }, hs); BLL.ActiveCode.Update(ac, hs); } if (i == BuyActiveCodeModel.CodeCount) { if (BLL.CommonBase.RunHashtable(hs)) { return("1"); } } else { return("0"); } } } return("0"); }
/// <summary> /// 实体转换 /// <summary> private static Model.BuyActiveCode TranEntity(DataRow dr) { if (dr != null) { Model.BuyActiveCode model = new Model.BuyActiveCode(); if (!string.IsNullOrEmpty(dr["Id"].ToString())) { model.Id = int.Parse(dr["Id"].ToString()); } if (!string.IsNullOrEmpty(dr["CodeCount"].ToString())) { model.CodeCount = int.Parse(dr["CodeCount"].ToString()); } model.FromMID = dr["FromMID"].ToString(); model.ToMID = dr["ToMID"].ToString(); if (!string.IsNullOrEmpty(dr["PayTime"].ToString())) { model.PayTime = DateTime.Parse(dr["PayTime"].ToString()); } if (!string.IsNullOrEmpty(dr["ConfirmTime"].ToString())) { model.ConfirmTime = DateTime.Parse(dr["ConfirmTime"].ToString()); } model.PicUrl = dr["PicUrl"].ToString(); model.Remark = dr["Remark"].ToString(); if (!string.IsNullOrEmpty(dr["State"].ToString())) { model.State = int.Parse(dr["State"].ToString()); } if (!string.IsNullOrEmpty(dr["CreateTime"].ToString())) { model.CreateTime = DateTime.Parse(dr["CreateTime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(Model.BuyActiveCode model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BuyActiveCode("); strSql.Append("CodeCount,FromMID,ToMID,PayTime,ConfirmTime,PicUrl,Remark,State,CreateTime"); strSql.Append(") values ("); strSql.Append("@CodeCount,@FromMID,@ToMID,@PayTime,@ConfirmTime,@PicUrl,@Remark,@State,@CreateTime"); strSql.Append(") "); strSql.AppendFormat(";select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@CodeCount", SqlDbType.Int, 4), new SqlParameter("@FromMID", SqlDbType.VarChar, 50), new SqlParameter("@ToMID", SqlDbType.VarChar, 50), new SqlParameter("@PayTime", SqlDbType.DateTime), new SqlParameter("@ConfirmTime", SqlDbType.DateTime), new SqlParameter("@PicUrl", SqlDbType.VarChar, 500), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.CodeCount; parameters[1].Value = model.FromMID; parameters[2].Value = model.ToMID; parameters[3].Value = model.PayTime; parameters[4].Value = model.ConfirmTime; parameters[5].Value = model.PicUrl; parameters[6].Value = model.Remark; parameters[7].Value = model.State; parameters[8].Value = model.CreateTime; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Insert(Model.BuyActiveCode model) { return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable()))); }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Model.BuyActiveCode model) { return(DAL.CommonBase.RunHashtable(Update(model, new Hashtable()))); }
public static bool Update(Model.BuyActiveCode model) { return(WE_Project.DAL.BuyActiveCode.Update(model)); }
public static Hashtable Update(Model.BuyActiveCode model, Hashtable MyHs) { return(WE_Project.DAL.BuyActiveCode.Update(model, MyHs)); }
public static bool Insert(Model.BuyActiveCode model) { return(WE_Project.DAL.BuyActiveCode.Insert(model)); }
public static Hashtable Insert(Model.BuyActiveCode model, Hashtable MyHs) { return(WE_Project.DAL.BuyActiveCode.Insert(model, MyHs)); }