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