public int Update(WHUserWorkRatioInfo oParam)
{
string sql = @"UPDATE WH_User_WorkRatio SET
UserSysNo=@UserSysNo, Ratio=@Ratio,
WorkType=@WorkType, BillType=@BillType,
WorkTimeSpan=@WorkTimeSpan
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 paramWorkType = new SqlParameter("@WorkType", SqlDbType.Int, 4);
SqlParameter paramBillType = new SqlParameter("@BillType", SqlDbType.Int, 4);
SqlParameter paramWorkTimeSpan = new SqlParameter("@WorkTimeSpan", 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.WorkType != AppConst.IntNull)
paramWorkType.Value = oParam.WorkType;
else
paramWorkType.Value = System.DBNull.Value;
if (oParam.BillType != AppConst.IntNull)
paramBillType.Value = oParam.BillType;
else
paramBillType.Value = System.DBNull.Value;
if (oParam.WorkTimeSpan != AppConst.IntNull)
paramWorkTimeSpan.Value = oParam.WorkTimeSpan;
else
paramWorkTimeSpan.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramUserSysNo);
cmd.Parameters.Add(paramRatio);
cmd.Parameters.Add(paramWorkType);
cmd.Parameters.Add(paramBillType);
cmd.Parameters.Add(paramWorkTimeSpan);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(WHUserWorkRatioInfo oParam)
{
string sql = @"INSERT INTO WH_User_WorkRatio
(
UserSysNo, Ratio, WorkType, BillType,
WorkTimeSpan
)
VALUES (
@UserSysNo, @Ratio, @WorkType, @BillType,
@WorkTimeSpan
);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 paramWorkType = new SqlParameter("@WorkType", SqlDbType.Int, 4);
SqlParameter paramBillType = new SqlParameter("@BillType", SqlDbType.Int, 4);
SqlParameter paramWorkTimeSpan = new SqlParameter("@WorkTimeSpan", 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.WorkType != AppConst.IntNull)
paramWorkType.Value = oParam.WorkType;
else
paramWorkType.Value = System.DBNull.Value;
if (oParam.BillType != AppConst.IntNull)
paramBillType.Value = oParam.BillType;
else
paramBillType.Value = System.DBNull.Value;
if (oParam.WorkTimeSpan != AppConst.IntNull)
paramWorkTimeSpan.Value = oParam.WorkTimeSpan;
else
paramWorkTimeSpan.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramUserSysNo);
cmd.Parameters.Add(paramRatio);
cmd.Parameters.Add(paramWorkType);
cmd.Parameters.Add(paramBillType);
cmd.Parameters.Add(paramWorkTimeSpan);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
public void DeleteWhUserWorkRatio(WHUserWorkRatioInfo oInfo)
{
string sql = "delete from WH_User_WorkRatio where sysno=" + oInfo.SysNo;
SqlHelper.ExecuteDataSet(sql);
}
private void map(WHUserWorkRatioInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.UserSysNo = Util.TrimIntNull(tempdr["UserSysNo"]);
oParam.Ratio = Util.TrimIntNull(tempdr["Ratio"]);
oParam.WorkType = Util.TrimIntNull(tempdr["WorkType"]);
oParam.BillType = Util.TrimIntNull(tempdr["BillType"]);
oParam.WorkTimeSpan = Util.TrimIntNull(tempdr["WorkTimeSpan"]);
}
public void UpdateWhUserWorkRatio(WHUserWorkRatioInfo oInfo)
{
new WHUserWorkRatioDac().Update(oInfo);
}
public WHUserWorkRatioInfo LoadWhUserWorkRatio(int sysNo)
{
string sql = "select * from WH_User_WorkRatio where sysno=" + sysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
WHUserWorkRatioInfo oInfo = new WHUserWorkRatioInfo();
map(oInfo, ds.Tables[0].Rows[0]);
return oInfo;
}
else
return null;
}
public void InspectionInit()
{
lock (ratioLock)
{
int ratioTotal = 0;
if (InspectionratioHash != null)
InspectionratioHash.Clear();
if (allocatedInspectionMenHash != null)
allocatedInspectionMenHash.Clear();
string sql = "select * from WH_User_WorkRatio where WorkType=" + (int)AppEnum.WhWorkType.ProductInspection + "and BillType=" + (int)AppEnum.WhWorkBillType.SO;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
return;
foreach (DataRow dr in ds.Tables[0].Rows)
{
ratioTotal += Util.TrimIntNull(dr["Ratio"]);
if (!allocatedInspectionMenHash.ContainsKey(Util.TrimIntNull(dr["UserSysNo"])))
{
UserInfo user = SysManager.GetInstance().LoadUser(Util.TrimIntNull(dr["UserSysNo"]));
allocatedInspectionMenHash.Add(Util.TrimIntNull(dr["UserSysno"]), user);
}
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
WHUserWorkRatioInfo item = new WHUserWorkRatioInfo();
map(item, dr);
if (InspectionratioHash == null)
{
InspectionratioHash = 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 (!InspectionratioHash.ContainsKey(tempkey))
{
found = true;
InspectionratioHash.Add(tempkey, item.UserSysNo);
}
} while (!found);
}
}
}
}
public void InsertWhUserWorkRatio(WHUserWorkRatioInfo oInfo)
{
new WHUserWorkRatioDac().Insert(oInfo);
}
