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