private void map(POPayItemErrRequestInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.POPayItemSysNo = Util.TrimIntNull(tempdr["POPayItemSysNo"]); oParam.RequestUserSysNo = Util.TrimIntNull(tempdr["RequestUserSysNo"]); oParam.RequestTime = Util.TrimDateNull(tempdr["RequestTime"]); oParam.RequestUserNote = Util.TrimNull(tempdr["RequestUserNote"]); oParam.ErrMsgNote = Util.TrimNull(tempdr["ErrMsgNote"]); oParam.TLAuditUserSysNo = Util.TrimIntNull(tempdr["TLAuditUserSysNo"]); oParam.TLAuditTime = Util.TrimDateNull(tempdr["TLAuditTime"]); oParam.TLNote = Util.TrimNull(tempdr["TLNote"]); oParam.LastAuditUserSysNo = Util.TrimIntNull(tempdr["LastAuditUserSysNo"]); oParam.LastAuditTime = Util.TrimDateNull(tempdr["LastAuditTime"]); oParam.LastAuditNote = Util.TrimNull(tempdr["LastAuditNote"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); }
/// <summary> /// ���������ύ /// </summary> /// <param name="paramHash">����POPayItem�IJ���</param> /// <param name="errRequest">�쳣�����¼</param> public void RequestPay(Hashtable paramHash, POPayItemErrRequestInfo errRequest) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { if (paramHash != null && paramHash.Count > 0) UpdatePOPayItem(paramHash); else throw new BizException("ȱ�ٲ���"); if (errRequest != null) new POPayDac().UpdatePOPayItemErrRequest(errRequest); scope.Complete(); } }
/// <summary> /// �����쳣������� /// </summary> /// <param name="errRequest"></param> public void ReturnErrRequest(POPayItemErrRequestInfo errRequest) { if (1 != new POPayDac().UpdatePOPayItemErrRequest(errRequest)) throw new BizException("���ز���ʧ��"); }
/// <summary> /// PM�쳣��������¼ /// </summary> /// <param name="errRequestInfo"></param> public void RequestErrPayItem(POPayItemErrRequestInfo errRequestInfo) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { string sql = @" SELECT TOP 1 * FROM dbo.Fin_POPay_Item_ErrRequest WHERE POPayItemSysNo = " + errRequestInfo.POPayItemSysNo + @" AND Status>" + (int)AppEnum.POPayItemErrRequestStatus.PMCancelRequest; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { throw new BizException("�����ظ��ύ�쳣����"); } //else //{ // #region ����Ǹ��ɹ������жϣ����ɹ����ܴ������ɹ����ĺ� // POPayItemInfo oPayItem = LoadPayItem(errRequestInfo.POPayItemSysNo); // POPayInfo oPay = LoadPay(oPayItem.POSysNo); // if (oPay.POAmt < 0) // { // POInfo poInfo = PurchaseManager.GetInstance().LoadPO(oPayItem.POSysNo); // if (poInfo != null) // { // if (IsPayTotalAmtLessThanZero(poInfo.VendorSysNo)) // { // throw new BizException("���ɹ����ܴ������ɹ����ĺͣ����ܸ���"); // } // } // } //#endregion if (1 != new POPayDac().InsertPOPayItemErrRequest(errRequestInfo)) { throw new BizException("�ύ�쳣����ʧ��"); } scope.Complete(); } }
/// <summary> /// ���ݸ���ż���PO����쳣���� /// </summary> /// <param name="POPayItemSysNo">������</param> /// <param name="IsOnlyLoadValid">�Ƿ�ֻ������Ч��¼</param> /// <returns></returns> public POPayItemErrRequestInfo LoadPOPayItemErrRequest(int POPayItemSysNo, bool IsOnlyLoadValid) { string sql = @" SELECT * FROM dbo.Fin_POPay_Item_ErrRequest Where POPayItemSysNo =" + POPayItemSysNo; if (IsOnlyLoadValid) sql += " AND Status >" + (int)AppEnum.POPayItemErrRequestStatus.PMCancelRequest; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return null; else { POPayItemErrRequestInfo newInfo = new POPayItemErrRequestInfo(); map(newInfo, ds.Tables[0].Rows[0]); return newInfo; } }
/// <summary> /// ����ϵͳ��ż���PO����쳣���� /// </summary> /// <param name="SysNo"></param> /// <returns></returns> public POPayItemErrRequestInfo LoadPOPayItemErrRequest(int SysNo) { string sql = @" SELECT * FROM dbo.Fin_POPay_Item_ErrRequest Where SysNo =" + SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) return null; else { POPayItemErrRequestInfo newInfo = new POPayItemErrRequestInfo(); map(newInfo, ds.Tables[0].Rows[0]); return newInfo; } }
/// <summary> /// �쳣�����¼�� /// </summary> /// <param name="oParam"></param> /// <returns></returns> public int UpdatePOPayItemErrRequest(POPayItemErrRequestInfo oParam) { string sql = @"UPDATE Fin_POPay_Item_ErrRequest SET POPayItemSysNo=@POPayItemSysNo, RequestUserSysNo=@RequestUserSysNo, RequestTime=@RequestTime, RequestUserNote=@RequestUserNote, ErrMsgNote=@ErrMsgNote, TLAuditUserSysNo=@TLAuditUserSysNo, TLAuditTime=@TLAuditTime, TLNote=@TLNote, LastAuditUserSysNo=@LastAuditUserSysNo, LastAuditTime=@LastAuditTime, LastAuditNote=@LastAuditNote, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramPOPayItemSysNo = new SqlParameter("@POPayItemSysNo", SqlDbType.Int, 4); SqlParameter paramRequestUserSysNo = new SqlParameter("@RequestUserSysNo", SqlDbType.Int, 4); SqlParameter paramRequestTime = new SqlParameter("@RequestTime", SqlDbType.DateTime); SqlParameter paramRequestUserNote = new SqlParameter("@RequestUserNote", SqlDbType.NVarChar, 200); SqlParameter paramErrMsgNote = new SqlParameter("@ErrMsgNote", SqlDbType.Text, 0); SqlParameter paramTLAuditUserSysNo = new SqlParameter("@TLAuditUserSysNo", SqlDbType.Int, 4); SqlParameter paramTLAuditTime = new SqlParameter("@TLAuditTime", SqlDbType.DateTime); SqlParameter paramTLNote = new SqlParameter("@TLNote", SqlDbType.NVarChar, 200); SqlParameter paramLastAuditUserSysNo = new SqlParameter("@LastAuditUserSysNo", SqlDbType.Int, 4); SqlParameter paramLastAuditTime = new SqlParameter("@LastAuditTime", SqlDbType.DateTime); SqlParameter paramLastAuditNote = new SqlParameter("@LastAuditNote", SqlDbType.NVarChar, 200); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.POPayItemSysNo != AppConst.IntNull) paramPOPayItemSysNo.Value = oParam.POPayItemSysNo; else paramPOPayItemSysNo.Value = System.DBNull.Value; if (oParam.RequestUserSysNo != AppConst.IntNull) paramRequestUserSysNo.Value = oParam.RequestUserSysNo; else paramRequestUserSysNo.Value = System.DBNull.Value; if (oParam.RequestTime != AppConst.DateTimeNull) paramRequestTime.Value = oParam.RequestTime; else paramRequestTime.Value = System.DBNull.Value; if (oParam.RequestUserNote != AppConst.StringNull) paramRequestUserNote.Value = oParam.RequestUserNote; else paramRequestUserNote.Value = System.DBNull.Value; if (oParam.ErrMsgNote != AppConst.StringNull) paramErrMsgNote.Value = oParam.ErrMsgNote; else paramErrMsgNote.Value = System.DBNull.Value; if (oParam.TLAuditUserSysNo != AppConst.IntNull) paramTLAuditUserSysNo.Value = oParam.TLAuditUserSysNo; else paramTLAuditUserSysNo.Value = System.DBNull.Value; if (oParam.TLAuditTime != AppConst.DateTimeNull) paramTLAuditTime.Value = oParam.TLAuditTime; else paramTLAuditTime.Value = System.DBNull.Value; if (oParam.TLNote != AppConst.StringNull) paramTLNote.Value = oParam.TLNote; else paramTLNote.Value = System.DBNull.Value; if (oParam.LastAuditUserSysNo != AppConst.IntNull) paramLastAuditUserSysNo.Value = oParam.LastAuditUserSysNo; else paramLastAuditUserSysNo.Value = System.DBNull.Value; if (oParam.LastAuditTime != AppConst.DateTimeNull) paramLastAuditTime.Value = oParam.LastAuditTime; else paramLastAuditTime.Value = System.DBNull.Value; if (oParam.LastAuditNote != AppConst.StringNull) paramLastAuditNote.Value = oParam.LastAuditNote; else paramLastAuditNote.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramPOPayItemSysNo); cmd.Parameters.Add(paramRequestUserSysNo); cmd.Parameters.Add(paramRequestTime); cmd.Parameters.Add(paramRequestUserNote); cmd.Parameters.Add(paramErrMsgNote); cmd.Parameters.Add(paramTLAuditUserSysNo); cmd.Parameters.Add(paramTLAuditTime); cmd.Parameters.Add(paramTLNote); cmd.Parameters.Add(paramLastAuditUserSysNo); cmd.Parameters.Add(paramLastAuditTime); cmd.Parameters.Add(paramLastAuditNote); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd); }
/// <summary> /// �쳣�����¼���� /// </summary> /// <param name="oParam"></param> /// <returns></returns> public int InsertPOPayItemErrRequest(POPayItemErrRequestInfo oParam) { string sql = @"INSERT INTO Fin_POPay_Item_ErrRequest ( POPayItemSysNo, RequestUserSysNo, RequestTime, RequestUserNote, ErrMsgNote, TLAuditUserSysNo, TLAuditTime, TLNote, LastAuditUserSysNo, LastAuditTime, LastAuditNote, Status ) VALUES ( @POPayItemSysNo, @RequestUserSysNo, @RequestTime, @RequestUserNote, @ErrMsgNote, @TLAuditUserSysNo, @TLAuditTime, @TLNote, @LastAuditUserSysNo, @LastAuditTime, @LastAuditNote, @Status );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramPOPayItemSysNo = new SqlParameter("@POPayItemSysNo", SqlDbType.Int, 4); SqlParameter paramRequestUserSysNo = new SqlParameter("@RequestUserSysNo", SqlDbType.Int, 4); SqlParameter paramRequestTime = new SqlParameter("@RequestTime", SqlDbType.DateTime); SqlParameter paramRequestUserNote = new SqlParameter("@RequestUserNote", SqlDbType.NVarChar, 200); SqlParameter paramErrMsgNote = new SqlParameter("@ErrMsgNote", SqlDbType.Text, 0); SqlParameter paramTLAuditUserSysNo = new SqlParameter("@TLAuditUserSysNo", SqlDbType.Int, 4); SqlParameter paramTLAuditTime = new SqlParameter("@TLAuditTime", SqlDbType.DateTime); SqlParameter paramTLNote = new SqlParameter("@TLNote", SqlDbType.NVarChar, 200); SqlParameter paramLastAuditUserSysNo = new SqlParameter("@LastAuditUserSysNo", SqlDbType.Int, 4); SqlParameter paramLastAuditTime = new SqlParameter("@LastAuditTime", SqlDbType.DateTime); SqlParameter paramLastAuditNote = new SqlParameter("@LastAuditNote", SqlDbType.NVarChar, 200); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.POPayItemSysNo != AppConst.IntNull) paramPOPayItemSysNo.Value = oParam.POPayItemSysNo; else paramPOPayItemSysNo.Value = System.DBNull.Value; if (oParam.RequestUserSysNo != AppConst.IntNull) paramRequestUserSysNo.Value = oParam.RequestUserSysNo; else paramRequestUserSysNo.Value = System.DBNull.Value; if (oParam.RequestTime != AppConst.DateTimeNull) paramRequestTime.Value = oParam.RequestTime; else paramRequestTime.Value = System.DBNull.Value; if (oParam.RequestUserNote != AppConst.StringNull) paramRequestUserNote.Value = oParam.RequestUserNote; else paramRequestUserNote.Value = System.DBNull.Value; if (oParam.ErrMsgNote != AppConst.StringNull) paramErrMsgNote.Value = oParam.ErrMsgNote; else paramErrMsgNote.Value = System.DBNull.Value; if (oParam.TLAuditUserSysNo != AppConst.IntNull) paramTLAuditUserSysNo.Value = oParam.TLAuditUserSysNo; else paramTLAuditUserSysNo.Value = System.DBNull.Value; if (oParam.TLAuditTime != AppConst.DateTimeNull) paramTLAuditTime.Value = oParam.TLAuditTime; else paramTLAuditTime.Value = System.DBNull.Value; if (oParam.TLNote != AppConst.StringNull) paramTLNote.Value = oParam.TLNote; else paramTLNote.Value = System.DBNull.Value; if (oParam.LastAuditUserSysNo != AppConst.IntNull) paramLastAuditUserSysNo.Value = oParam.LastAuditUserSysNo; else paramLastAuditUserSysNo.Value = System.DBNull.Value; if (oParam.LastAuditTime != AppConst.DateTimeNull) paramLastAuditTime.Value = oParam.LastAuditTime; else paramLastAuditTime.Value = System.DBNull.Value; if (oParam.LastAuditNote != AppConst.StringNull) paramLastAuditNote.Value = oParam.LastAuditNote; else paramLastAuditNote.Value = System.DBNull.Value; if (oParam.Status != AppConst.IntNull) paramStatus.Value = oParam.Status; else paramStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramPOPayItemSysNo); cmd.Parameters.Add(paramRequestUserSysNo); cmd.Parameters.Add(paramRequestTime); cmd.Parameters.Add(paramRequestUserNote); cmd.Parameters.Add(paramErrMsgNote); cmd.Parameters.Add(paramTLAuditUserSysNo); cmd.Parameters.Add(paramTLAuditTime); cmd.Parameters.Add(paramTLNote); cmd.Parameters.Add(paramLastAuditUserSysNo); cmd.Parameters.Add(paramLastAuditTime); cmd.Parameters.Add(paramLastAuditNote); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }