/// <summary> /// 实体转换 /// <summary> private static Model.ActiveCode TranEntity(DataRow dr) { if (dr != null) { Model.ActiveCode model = new Model.ActiveCode(); if (!string.IsNullOrEmpty(dr["Id"].ToString())) { model.Id = int.Parse(dr["Id"].ToString()); } model.Code = dr["Code"].ToString(); model.MID = dr["MID"].ToString(); if (!string.IsNullOrEmpty(dr["UseState"].ToString())) { model.UseState = int.Parse(dr["UseState"].ToString()); } if (!string.IsNullOrEmpty(dr["CreateTime"].ToString())) { model.CreateTime = DateTime.Parse(dr["CreateTime"].ToString()); } model.UseMID = dr["UseMID"].ToString(); if (!string.IsNullOrEmpty(dr["UseTime"].ToString())) { model.UseTime = DateTime.Parse(dr["UseTime"].ToString()); } model.SwitchType = dr["SwitchType"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(Model.ActiveCode model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ActiveCode("); strSql.Append("Code,MID,UseState,CreateTime,UseMID,UseTime,SwitchType"); strSql.Append(") values ("); strSql.Append("@Code,@MID,@UseState,@CreateTime,@UseMID,@UseTime,@SwitchType"); strSql.Append(") "); strSql.AppendFormat(";select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@Code", SqlDbType.VarChar, 20), new SqlParameter("@MID", SqlDbType.VarChar, 40), new SqlParameter("@UseState", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UseMID", SqlDbType.VarChar, 40), new SqlParameter("@UseTime", SqlDbType.DateTime), new SqlParameter("@SwitchType", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Code; parameters[1].Value = model.MID; parameters[2].Value = model.UseState; parameters[3].Value = model.CreateTime; parameters[4].Value = model.UseMID; parameters[5].Value = model.UseTime; parameters[6].Value = model.SwitchType; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
protected override string btnAdd_Click() { if (!TModel.Role.Super) { return("0"); } int count = int.Parse(Request.Form["txtCodeNum"]); Hashtable hs = new Hashtable(); for (int i = 0; i < count; i++) { Model.ActiveCode code = new Model.ActiveCode(); string guid = Guid.NewGuid().ToString().Replace("-", "").Replace(" ", "").ToUpper(); code.Code = guid.Substring(0, 10); code.CreateTime = DateTime.Now; code.UseState = 0; code.MID = BLL.Member.ManageMember.TModel.MID; code.SwitchType = "生成"; if (BLL.CommonBase.GetSingle("select id from ActiveCode where Code='" + code.Code + "'") == null) { BLL.ActiveCode.Insert(code, hs); BLL.CommonBase.RunHashtable(hs); hs.Clear(); } } return("1"); }
protected override string btnModify_Click() { //判断是否信息完整 if (string.IsNullOrEmpty(TModel.BankCardName) || (string.IsNullOrEmpty(TModel.BankNumber) && string.IsNullOrEmpty(TModel.NumID))) { return("请先完善资料"); } //校验激活码 string activeCode = Request.Form["txtActiveCode"]; Model.ActiveCode list = BLL.ActiveCode.GetList("Code='" + activeCode + "' and UseState not in (2,4)").FirstOrDefault(); if (list == null) { return("激活码无效"); } Model.SHMoney shmoney = BLL.Configuration.Model.SHMoneyList["002"];//默认002 //if (BLL.ChangeMoney.EnoughChange(TModel.MID, BLL.Configuration.Model.YLMoney, "MHB")) //{ try { if (BLL.Member.upmidlist.Contains(TModel.MID)) { return("2"); } else { BLL.Member.upmidlist.Add(TModel.MID); } Hashtable MyHs = new Hashtable(); list.UseMID = TModel.MID; list.UseState = 2; list.UseTime = DateTime.Now; BLL.ActiveCode.Update(list, MyHs); return(BllModel.UpMAgencyType(shmoney, TModel.MID, TModel, 0, MyHs)); } finally { if (BLL.Member.upmidlist.Contains(TModel.MID)) { BLL.Member.upmidlist.Remove(TModel.MID); } } //} //else //{ // return "您的激活币账号余额不足"; //} }
/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(Model.ActiveCode model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update ActiveCode set "); strSql.Append(" Code = @Code , "); strSql.Append(" MID = @MID , "); strSql.Append(" UseState = @UseState , "); strSql.Append(" CreateTime = @CreateTime , "); strSql.Append(" UseMID = @UseMID , "); strSql.Append(" SwitchType = @SwitchType , "); strSql.Append(" UseTime = @UseTime "); strSql.Append(" where Id=@Id "); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Code", SqlDbType.VarChar, 20), new SqlParameter("@MID", SqlDbType.VarChar, 40), new SqlParameter("@UseState", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UseMID", SqlDbType.VarChar, 40), new SqlParameter("@UseTime", SqlDbType.DateTime), new SqlParameter("@SwitchType", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Id; parameters[1].Value = model.Code; parameters[2].Value = model.MID; parameters[3].Value = model.UseState; parameters[4].Value = model.CreateTime; parameters[5].Value = model.UseMID; parameters[6].Value = model.UseTime; parameters[7].Value = model.SwitchType; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Insert(Model.ActiveCode model) { return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable()))); }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Model.ActiveCode model) { return(DAL.CommonBase.RunHashtable(Update(model, new Hashtable()))); }
public static bool Update(Model.ActiveCode model) { return(WE_Project.DAL.ActiveCode.Update(model)); }
public static Hashtable Update(Model.ActiveCode model, Hashtable MyHs) { return(WE_Project.DAL.ActiveCode.Update(model, MyHs)); }
public static bool Insert(Model.ActiveCode model) { return(WE_Project.DAL.ActiveCode.Insert(model)); }
public static Hashtable Insert(Model.ActiveCode model, Hashtable MyHs) { return(WE_Project.DAL.ActiveCode.Insert(model, MyHs)); }