/// <summary>
/// 添加一条来源变更信息
/// </summary>
/// <param name="sc">来源变更</param>
/// <returns>返回是否添加成功</returns>
public Boolean AddSourceChange(SourceChange sc)
{
try
{
string sql = "insert into sourceChange(username,source,source_change,date_change,operator)"
+ "values (@UserName,@Source,@SourceChange,@Date_change,@Operators)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@UserName",sc.UserName),
new SqlParameter("@Source",sc.Source),
new SqlParameter("@SourceChange",sc.SourceChanged),
new SqlParameter("@Date_change", sc.DateChange),
new SqlParameter("@Operators",sc.Operator)
};
return db.ExecuteNonQuery(sql, sp);
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
/// <summary>
/// 添加一条来源变更信息
/// </summary>
/// <param name="sc">来源变更</param>
/// <returns>返回是否添加成功</returns>
public Boolean AddSourceChange(SourceChange sc)
{
return scs.AddSourceChange(sc);
}
public Boolean UpdateGameUser()
{
if (Session[Keys.SESSION_ADMIN_INFO] == null)
{
return false;
}
else
{
Master master = Session[Keys.SESSION_ADMIN_INFO] as Master;
if (rcm.GetRoleCompetence(master.RoleId, 1311))
{
string Type = Request["Type"];
int UserId = int.Parse(Request["UserId"]);
GameUser gu = gum.GetGameUser(UserId);
int OldSouce = gu.Source;
if (Type == "Save")
{
int IsSpread = int.Parse(Request["IsSpread"]);
string Source = Request["Source"];
int RegGame = int.Parse(Request["RegGame"]);
int IsLock = int.Parse(Request["IsLock"]);
if (!string.IsNullOrEmpty(Source))
{
if (Source != "用户注册")
{
GameUser spread = gum.GetGameUser(Source);
if (spread.IsSpreader > IsSpread)
{
gu.Source = spread.Id;
gu.RegGame = RegGame;
}
else
{
return false;
}
}
else
{
gu.Source = 0;
gu.RegGame = 0;
}
SourceChange sc = new SourceChange(0, gu.UserName, OldSouce, gu.Source, DateTime.Now, master.UserName);
scm.AddSourceChange(sc);
}
gu.IsSpreader = IsSpread;
gu.IsLock = IsLock;
}
else
{
gu.Sex = "0";
gu.Phone = "";
gu.RealName = "";
gu.Email = "";
gu.QQ = "";
gu.Cards = "";
gu.BirthDay = "";
gu.UserDesc = "";
gu.PWD = DESEncrypt.Md5("111111", 32);
}
return gum.UpdateUser(gu);
}
else
{
return false;
}
}
}
