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