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