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