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