| | |
| | | using System.Net.Http; |
| | | using System.Web.Http; |
| | | using WebAPI.Models; |
| | | |
| | | using System.Windows.Forms; |
| | | namespace WebAPI.Controllers |
| | | { |
| | | // 投料防错 |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region 投料放错单写入日志 |
| | | [Route("Sc_FeedingErrorProofingController/WriteErrlog")] |
| | | [HttpGet] |
| | | public object WriteErrlog(string user,string HRemark) |
| | | { |
| | | oCN.BeginTran(); |
| | | string HComputerName = SystemInformation.ComputerName; //设备名称 |
| | | try |
| | | { |
| | | LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",扫描错误日志:" + HRemark); |
| | | oCN.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + |
| | | "(getdate(),'" + user + "','" + HComputerName + "','" + "Sc_FeedingError投料防错单扫描失败记录:"+HRemark + "','APP','','扫码')" |
| | | ); |
| | | |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Success!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exception!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region 投料放错单 保存单据 |
| | | [Route("Sc_FeedingErrorProofingController/saveBill")] |
| | | [HttpPost] |
| | |
| | | { |
| | | oCN.RunProc($@"insert into Sc_FeedingErrorProofingBillSub (HInterID,HBillNo_bak, HEntryID, HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, |
| | | HRelationQty, HRelationMoney, HMaterID, HUnitID, HQty, HScanDate, HBarCode) |
| | | values('{HMainBill["HInterID"]}','{HMainBill["HBillNo"]}', {i++}, '', 0, 0, '', '', 0, 0, {HSubItem["HMaterID"]}, {HSubItem["HUnitID"]}, {HSubItem["HQty"]}, '{HSubItem["HScanDate"]}', |
| | | {HSubItem["HBarCode"]})"); |
| | | values('{HMainBill["HInterID"]}','{HMainBill["HBillNo"]}', {i++}, '', 0, 0, '', '', 0, 0, {HSubItem["HMaterID"]}, {HSubItem["HUnitID"]}, {HSubItem["HQty"]}, '{HSubItem["HScanDate"]}',' |
| | | {HSubItem["HBarCode"]}')"); |
| | | |
| | | // 通过系统参数判断是否需要 反写条码主档单据状态 |
| | | if(oSystemParameter.ShowBill(ref DBUtility.ClsPub.sErrInfo)) |