| | |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | string sql = "select HErrMsgBackInterID,HErrMsgBackEntryID,HSendMan,HDescription,HReceiveMan from OA_ErrMsgBackHandleBillMain where HInterID=" + HInterID; |
|---|
| | | string sql = "select HErrMsgBackInterID,HErrMsgBackEntryID,HSendMan,HDescription,HReceiveMan from OA_ErrMsgBackHandleBillMain where HErrMsgBackInterID=" + HInterID; |
|---|
| | | //更新异常反馈处理单作废 |
|---|
| | | oCN.RunProc("update OA_ErrMsgBackHandleBillMain set HBillStatus=4, HDeleteDate=GETDATE(),HDeleteMan='" + user + "' where HInterID="+ HInterID); |
|---|
| | | oCN.RunProc("update OA_ErrMsgBackHandleBillMain set HBillStatus=4, HDeleteDate=GETDATE(),HDeleteMan='" + user + "' where HErrMsgBackInterID=" + HInterID); |
|---|
| | | DataSet dt = oCN.RunProcReturn(sql, "OA_ErrMsgBackHandleBillMain"); |
|---|
| | | |
|---|
| | | //反馈处理单保存后,更新异常反馈单的状态 |
|---|
| | | string sql1 = "update OA_ErrMsgBackBillMain set HBillStatus='9' where HInterID='" + dt.Tables[0].Rows[0]["HErrMsgBackInterID"].ToString() + "' "; |
|---|
| | | //反馈处理单驳回后,更新异常反馈单的状态 |
|---|
| | | string sql1 = "update OA_ErrMsgBackBillMain set HBillStatus='13' where HInterID='" + dt.Tables[0].Rows[0]["HErrMsgBackInterID"].ToString() + "' "; |
|---|
| | | oCN.RunProc(sql1); |
|---|
| | | _ = SendDingDingAsync(dt.Tables[0].Rows[0]["HSendMan"].ToString(), 4, dt.Tables[0].Rows[0]["HDescription"].ToString(), dt.Tables[0].Rows[0]["HReceiveMan"].ToString()); |
|---|
| | | |
|---|
