public int Update(PMPOAmtRestrictInfo oParam)
{
string sql = @"UPDATE PM_POAmtRestrict SET
PMUserSysNo=@PMUserSysNo, PMGroupNo=@PMGroupNo,
IsPMD=@IsPMD, DailyPOAmtMax=@DailyPOAmtMax,
EachPOAmtMax=@EachPOAmtMax
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPMUserSysNo = new SqlParameter("@PMUserSysNo", SqlDbType.Int, 4);
SqlParameter paramPMGroupNo = new SqlParameter("@PMGroupNo", SqlDbType.Int, 4);
SqlParameter paramIsPMD = new SqlParameter("@IsPMD", SqlDbType.Bit, 1);
SqlParameter paramDailyPOAmtMax = new SqlParameter("@DailyPOAmtMax", SqlDbType.Decimal, 9);
SqlParameter paramEachPOAmtMax = new SqlParameter("@EachPOAmtMax", SqlDbType.Decimal, 9);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.PMUserSysNo != AppConst.IntNull)
paramPMUserSysNo.Value = oParam.PMUserSysNo;
else
paramPMUserSysNo.Value = System.DBNull.Value;
if (oParam.PMGroupNo != AppConst.IntNull)
paramPMGroupNo.Value = oParam.PMGroupNo;
else
paramPMGroupNo.Value = System.DBNull.Value;
if (oParam.IsPMD != AppConst.IntNull)
paramIsPMD.Value = oParam.IsPMD;
else
paramIsPMD.Value = System.DBNull.Value;
if (oParam.DailyPOAmtMax != AppConst.DecimalNull)
paramDailyPOAmtMax.Value = oParam.DailyPOAmtMax;
else
paramDailyPOAmtMax.Value = System.DBNull.Value;
if (oParam.EachPOAmtMax != AppConst.DecimalNull)
paramEachPOAmtMax.Value = oParam.EachPOAmtMax;
else
paramEachPOAmtMax.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPMUserSysNo);
cmd.Parameters.Add(paramPMGroupNo);
cmd.Parameters.Add(paramIsPMD);
cmd.Parameters.Add(paramDailyPOAmtMax);
cmd.Parameters.Add(paramEachPOAmtMax);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(PMPOAmtRestrictInfo oParam)
{
string sql = @"INSERT INTO PM_POAmtRestrict
(
PMUserSysNo, PMGroupNo, IsPMD, DailyPOAmtMax,
EachPOAmtMax
)
VALUES (
@PMUserSysNo, @PMGroupNo, @IsPMD, @DailyPOAmtMax,
@EachPOAmtMax
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPMUserSysNo = new SqlParameter("@PMUserSysNo", SqlDbType.Int, 4);
SqlParameter paramPMGroupNo = new SqlParameter("@PMGroupNo", SqlDbType.Int, 4);
SqlParameter paramIsPMD = new SqlParameter("@IsPMD", SqlDbType.Bit, 1);
SqlParameter paramDailyPOAmtMax = new SqlParameter("@DailyPOAmtMax", SqlDbType.Decimal, 9);
SqlParameter paramEachPOAmtMax = new SqlParameter("@EachPOAmtMax", SqlDbType.Decimal, 9);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.PMUserSysNo != AppConst.IntNull)
paramPMUserSysNo.Value = oParam.PMUserSysNo;
else
paramPMUserSysNo.Value = System.DBNull.Value;
if (oParam.PMGroupNo != AppConst.IntNull)
paramPMGroupNo.Value = oParam.PMGroupNo;
else
paramPMGroupNo.Value = System.DBNull.Value;
if (oParam.IsPMD != AppConst.IntNull)
paramIsPMD.Value = oParam.IsPMD;
else
paramIsPMD.Value = System.DBNull.Value;
if (oParam.DailyPOAmtMax != AppConst.DecimalNull)
paramDailyPOAmtMax.Value = oParam.DailyPOAmtMax;
else
paramDailyPOAmtMax.Value = System.DBNull.Value;
if (oParam.EachPOAmtMax != AppConst.DecimalNull)
paramEachPOAmtMax.Value = oParam.EachPOAmtMax;
else
paramEachPOAmtMax.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPMUserSysNo);
cmd.Parameters.Add(paramPMGroupNo);
cmd.Parameters.Add(paramIsPMD);
cmd.Parameters.Add(paramDailyPOAmtMax);
cmd.Parameters.Add(paramEachPOAmtMax);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
private void map(PMPOAmtRestrictInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.PMUserSysNo = Util.TrimIntNull(tempdr["PMUserSysNo"]);
oParam.PMGroupNo = Util.TrimIntNull(tempdr["PMGroupNo"]);
oParam.IsPMD = Util.TrimIntNull(tempdr["IsPMD"]);
oParam.DailyPOAmtMax = Util.TrimDecimalNull(tempdr["DailyPOAmtMax"]);
oParam.EachPOAmtMax = Util.TrimDecimalNull(tempdr["EachPOAmtMax"]);
}
public void UpdatePMPOAmtRestrict(PMPOAmtRestrictInfo oParam)
{
string sql = "select top 1 * from PM_POAmtRestrict where PMUserSysNo =" + oParam.PMUserSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
{
throw new BizException("�����ڸ�PM����زɹ�������ƣ�����ʧ��");
}
if (1 != new PMPOAmtRestrictDac().Update(oParam))
{
throw new BizException("����PM�ɹ��������ʧ��");
}
}
/// <summary>
/// ��ȡPM�ɹ��������(��֪��SysNoʱ,ʹ��AppConst.IntNull,��������Ҫһ������)
/// </summary>
/// <param name="SysNo">��ˮ��</param>
/// <param name="PMUserSysNo">PMUserSysNo</param>
/// <returns></returns>
public PMPOAmtRestrictInfo LoadPMPOAmtRestrict(int SysNo, int PMUserSysNo)
{
if (SysNo == AppConst.IntNull && PMUserSysNo == AppConst.IntNull)
{
throw new BizException("ȱ�ٲ���");
}
string sql = "select top 1 * from PM_POAmtRestrict Where 1=1 ";
if (SysNo != AppConst.IntNull)
{
sql += " and SysNo = " + SysNo;
}
else if (PMUserSysNo != AppConst.IntNull)
{
sql += " and PMUserSysNo = " + PMUserSysNo;
}
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
return null;
else
{
PMPOAmtRestrictInfo oInfo = new PMPOAmtRestrictInfo();
map(oInfo, ds.Tables[0].Rows[0]);
return oInfo;
}
}
