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