private void map(SOUserAuditRatioInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.UserSysNo = Util.TrimIntNull(tempdr["UserSysNo"]); oParam.Ratio = Util.TrimIntNull(tempdr["Ratio"]); oParam.AuditTimeSpan = Util.TrimIntNull(tempdr["AuditTimeSpan"]); }
public void InsertSOUserAuditRatio(SOUserAuditRatioInfo oInfo) { new SOUserAuditRatioDac().Insert(oInfo); SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.UserRatio); ratioHash.Add(oInfo.UserSysNo, oInfo); }
public void DeleteSOUserAudit(SOUserAuditRatioInfo oInfo) { string sql = "delete from SO_User_AuditRatio where UserSysNo=" + oInfo.UserSysNo; SqlHelper.ExecuteDataSet(sql); SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.UserRatio); ratioHash.Remove(oInfo.UserSysNo); }
public void DeleteSOUserAudit(SOUserAuditRatioInfo oInfo) { string sql = "delete from SO_User_AuditRatio where UserSysNo=" + oInfo.UserSysNo; SqlHelper.ExecuteDataSet(sql); SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.UserRatio); ratioHash.Remove(oInfo.UserSysNo); }
public void Init() { lock (ratioLock) { int ratioTotal = 0; if (ratioHash != null) { ratioHash.Clear(); } if (allocatedMenHash != null) { allocatedMenHash.Clear(); } string sql = "select * from SO_User_AuditRatio"; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) { return; } foreach (DataRow dr in ds.Tables[0].Rows) { ratioTotal += Util.TrimIntNull(dr["Ratio"]); if (!allocatedMenHash.ContainsKey(Util.TrimIntNull(dr["UserSysNo"]))) { UserInfo user = SysManager.GetInstance().LoadUser(Util.TrimIntNull(dr["UserSysNo"])); allocatedMenHash.Add(Util.TrimIntNull(dr["UserSysno"]), user); } } foreach (DataRow dr in ds.Tables[0].Rows) { SOUserAuditRatioInfo item = new SOUserAuditRatioInfo(); map(item, dr); if (ratioHash == null) { ratioHash = new Hashtable(5); } for (int i = 0; i < item.Ratio; i++) { bool found = false; do { System.Random oRandom = new System.Random(RandomString.GetNewSeed()); int tempkey = oRandom.Next(ratioTotal); if (!ratioHash.ContainsKey(tempkey)) { found = true; ratioHash.Add(tempkey, item.UserSysNo); } } while (!found); } } } }
public int Update(SOUserAuditRatioInfo oParam) { string sql = @"UPDATE SO_User_AuditRatio SET UserSysNo=@UserSysNo, Ratio=@Ratio, AuditTimeSpan=@AuditTimeSpan WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramUserSysNo = new SqlParameter("@UserSysNo", SqlDbType.Int, 4); SqlParameter paramRatio = new SqlParameter("@Ratio", SqlDbType.Int, 4); SqlParameter paramAuditTimeSpan = new SqlParameter("@AuditTimeSpan", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) { paramSysNo.Value = oParam.SysNo; } else { paramSysNo.Value = System.DBNull.Value; } if (oParam.UserSysNo != AppConst.IntNull) { paramUserSysNo.Value = oParam.UserSysNo; } else { paramUserSysNo.Value = System.DBNull.Value; } if (oParam.Ratio != AppConst.IntNull) { paramRatio.Value = oParam.Ratio; } else { paramRatio.Value = System.DBNull.Value; } if (oParam.AuditTimeSpan != AppConst.IntNull) { paramAuditTimeSpan.Value = oParam.AuditTimeSpan; } else { paramAuditTimeSpan.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramUserSysNo); cmd.Parameters.Add(paramRatio); cmd.Parameters.Add(paramAuditTimeSpan); return(SqlHelper.ExecuteNonQuery(cmd)); }
public int Insert(SOUserAuditRatioInfo oParam) { string sql = @"INSERT INTO SO_User_AuditRatio ( UserSysNo, Ratio, AuditTimeSpan ) VALUES ( @UserSysNo, @Ratio, @AuditTimeSpan );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramUserSysNo = new SqlParameter("@UserSysNo", SqlDbType.Int, 4); SqlParameter paramRatio = new SqlParameter("@Ratio", SqlDbType.Int, 4); SqlParameter paramAuditTimeSpan = new SqlParameter("@AuditTimeSpan", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.UserSysNo != AppConst.IntNull) { paramUserSysNo.Value = oParam.UserSysNo; } else { paramUserSysNo.Value = System.DBNull.Value; } if (oParam.Ratio != AppConst.IntNull) { paramRatio.Value = oParam.Ratio; } else { paramRatio.Value = System.DBNull.Value; } if (oParam.AuditTimeSpan != AppConst.IntNull) { paramAuditTimeSpan.Value = oParam.AuditTimeSpan; } else { paramAuditTimeSpan.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramUserSysNo); cmd.Parameters.Add(paramRatio); cmd.Parameters.Add(paramAuditTimeSpan); return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo)); }
public SOUserAuditRatioInfo LoadSOUserAuditRatio(int userSysNo) { string sql = "select * from SO_User_AuditRatio where usersysno=" + userSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { SOUserAuditRatioInfo oInfo = new SOUserAuditRatioInfo(); map(oInfo, ds.Tables[0].Rows[0]); return(oInfo); } else { return(null); } }
public int Update(SOUserAuditRatioInfo oParam) { string sql = @"UPDATE SO_User_AuditRatio SET UserSysNo=@UserSysNo, Ratio=@Ratio, AuditTimeSpan=@AuditTimeSpan WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramUserSysNo = new SqlParameter("@UserSysNo", SqlDbType.Int, 4); SqlParameter paramRatio = new SqlParameter("@Ratio", SqlDbType.Int, 4); SqlParameter paramAuditTimeSpan = new SqlParameter("@AuditTimeSpan", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.UserSysNo != AppConst.IntNull) paramUserSysNo.Value = oParam.UserSysNo; else paramUserSysNo.Value = System.DBNull.Value; if (oParam.Ratio != AppConst.IntNull) paramRatio.Value = oParam.Ratio; else paramRatio.Value = System.DBNull.Value; if (oParam.AuditTimeSpan != AppConst.IntNull) paramAuditTimeSpan.Value = oParam.AuditTimeSpan; else paramAuditTimeSpan.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramUserSysNo); cmd.Parameters.Add(paramRatio); cmd.Parameters.Add(paramAuditTimeSpan); return SqlHelper.ExecuteNonQuery(cmd); }
public int Insert(SOUserAuditRatioInfo oParam) { string sql = @"INSERT INTO SO_User_AuditRatio ( UserSysNo, Ratio, AuditTimeSpan ) VALUES ( @UserSysNo, @Ratio, @AuditTimeSpan );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramUserSysNo = new SqlParameter("@UserSysNo", SqlDbType.Int, 4); SqlParameter paramRatio = new SqlParameter("@Ratio", SqlDbType.Int, 4); SqlParameter paramAuditTimeSpan = new SqlParameter("@AuditTimeSpan", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.UserSysNo != AppConst.IntNull) paramUserSysNo.Value = oParam.UserSysNo; else paramUserSysNo.Value = System.DBNull.Value; if (oParam.Ratio != AppConst.IntNull) paramRatio.Value = oParam.Ratio; else paramRatio.Value = System.DBNull.Value; if (oParam.AuditTimeSpan != AppConst.IntNull) paramAuditTimeSpan.Value = oParam.AuditTimeSpan; else paramAuditTimeSpan.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramUserSysNo); cmd.Parameters.Add(paramRatio); cmd.Parameters.Add(paramAuditTimeSpan); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
private void map(SOUserAuditRatioInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.UserSysNo = Util.TrimIntNull(tempdr["UserSysNo"]); oParam.Ratio = Util.TrimIntNull(tempdr["Ratio"]); oParam.AuditTimeSpan = Util.TrimIntNull(tempdr["AuditTimeSpan"]); }
public void InsertSoUserAuditRatio(SOUserAuditRatioInfo oInfo) { new SOUserAuditRatioDac().Insert(oInfo); }
public void UpdateSoUserAuditRatio(SOUserAuditRatioInfo oInfo) { new SOUserAuditRatioDac().Update(oInfo); }
public void DeleteSoUserAudit(SOUserAuditRatioInfo oInfo) { string sql = "delete from SO_User_AuditRatio where usersysno=" + oInfo.UserSysNo; SqlHelper.ExecuteDataSet(sql); }
public void Init() { lock (ratioLock) { int ratioTotal = 0; if (ratioHash != null) ratioHash.Clear(); if (allocatedMenHash != null) allocatedMenHash.Clear(); string sql = "select * from SO_User_AuditRatio"; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return; foreach (DataRow dr in ds.Tables[0].Rows) { ratioTotal += Util.TrimIntNull(dr["Ratio"]); if (!allocatedMenHash.ContainsKey(Util.TrimIntNull(dr["UserSysNo"]))) { UserInfo user = SysManager.GetInstance().LoadUser(Util.TrimIntNull(dr["UserSysNo"])); allocatedMenHash.Add(Util.TrimIntNull(dr["UserSysno"]), user); } } foreach (DataRow dr in ds.Tables[0].Rows) { SOUserAuditRatioInfo item = new SOUserAuditRatioInfo(); map(item, dr); if (ratioHash == null) { ratioHash = new Hashtable(5); } for (int i = 0; i < item.Ratio; i++) { bool found = false; do { System.Random oRandom = new System.Random(RandomString.GetNewSeed()); int tempkey = oRandom.Next(ratioTotal); if (!ratioHash.ContainsKey(tempkey)) { found = true; ratioHash.Add(tempkey, item.UserSysNo); } } while (!found); } } } }
public SOUserAuditRatioInfo LoadSOUserAuditRatio(int userSysNo) { string sql = "select * from SO_User_AuditRatio where usersysno=" + userSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { SOUserAuditRatioInfo oInfo = new SOUserAuditRatioInfo(); map(oInfo, ds.Tables[0].Rows[0]); return oInfo; } else return null; }
public void UpdateSOUserAuditRatio(SOUserAuditRatioInfo oInfo) { new SOUserAuditRatioDac().Update(oInfo); SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.UserRatio); ratioHash.Remove(oInfo.UserSysNo); ratioHash.Add(oInfo.UserSysNo, oInfo); }