| | |
|---|
| | | { |
|---|
| | | // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | //反写维修记录单关闭 |
|---|
| | | string sql = "Update Sb_EquipRepairWorkBillMain set HCloseMan='关联验收单自动关闭',HCloseDate=GETDATE(),HBillStatus=3,HCloseType = 1 Where HInterID=" + oBill.omodel.HMainSourceInterID.ToString(); |
|---|
| | | ds = oCN.RunProcReturn(sql, "Sb_EquipRepairWorkBillMain"); |
|---|
| | | //部门,发现人,负责人,设备 |
|---|
| | | _ = SendDingDingAsync(oBill.omodel.HDeptID, oBill.omodel.HEmpID, oBill.omodel.HManagerID, oBill.omodel.HEquipID, 3); |
|---|
| | | } |
|---|
| | |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | //得到信息 |
|---|
| | | ds = oCN.RunProcReturn("select top 1 * from h_v_Gy_EquipFileBillList where HBarCode= '" + HBarCode + "'", "Gy_EquipFileBillMain"); |
|---|
| | | //得到信息最新的 |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_EquipFileBillList where HBarCode= '" + HBarCode + "' order by 故障登记单ID desc", "Gy_EquipFileBillMain"); |
|---|
| | | //写入信息 |
|---|
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | if ( ds.Tables[0].Rows.Count > 1) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "该设备出现多个故障登记单,请手动选着"; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "Sucess！"; |
|---|
