| | |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using WebAPI.Models; |
| | | using WebAPI.Service; |
| | | |
| | | namespace WebAPI.Controllers |
| | | { |
| | | public class Sc_ProcessMangementController : ApiController |
| | |
| | | return GetObjectJson(ds); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// PDA工序汇报单保存 |
| | | /// </summary> |
| | | /// <param name="msg"></param> |
| | | /// <returns></returns> |
| | | [Route("SaveProcessReport")] |
| | | [HttpPost] |
| | | public object SaveProcessReport([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | | DAL.ClsSc_ProcessReport ReportModel = new DAL.ClsSc_ProcessReport(); |
| | | List<WebAPI.Models.Sc_ProcessReportViewModel> ls = new List<WebAPI.Models.Sc_ProcessReportViewModel>(); |
| | | ls = oListModels.getObjectByJson_Report(msg1); |
| | | int i = 0; |
| | | Model.ClsSc_ProcessReportMain ReportMain = new Model.ClsSc_ProcessReportMain(); |
| | | Model.ClsSc_ProcessReportSub ReportSub = new Model.ClsSc_ProcessReportSub(); |
| | | foreach (Models.Sc_ProcessReportViewModel ItemView in ls) |
| | | { |
| | | i++; |
| | | //工序汇报单主表保存 |
| | | ReportMain.HBillType = "3714"; |
| | | ReportMain.HBillNo = ItemView.HBillNo; |
| | | ReportMain.HMakeDate=DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | ReportMain.HYear=DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | ReportMain.HDate = DateTime.Now; |
| | | ReportMain.HInterID = ItemView.HInterID; |
| | | ReportMain.HMaker = ItemView.HEmp; |
| | | ReportMain.HCloseType = false; |
| | | ReportMain.HPlanQty = (double)ItemView.HQty; |
| | | //保存到汇报单主表 |
| | | ReportModel.omodel = ReportMain; |
| | | |
| | | |
| | | ReportSub.HEmpID = (long)ItemView.HEmpID; |
| | | ReportSub.HICMOBillNo = ItemView.HICMOBillNo; |
| | | ReportSub.HICMOInterID = (long)ItemView.HICMOInterID; |
| | | ReportSub.HEntryID = i; |
| | | ReportSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | ReportSub.HRemark = ""; |
| | | ReportSub.HCloseMan = ""; |
| | | ReportSub.HCloseType = false; |
| | | ReportSub.HSourceBillType = "3712"; |
| | | ReportSub.HQty = (double)ItemView.HQty; |
| | | //保存到汇报单子表 |
| | | ReportModel.DetailColl.Add(ReportSub); |
| | | } |
| | | //保存 |
| | | //保存完毕后处理 |
| | | bool bResult; |
| | | if (ReportModel.omodel.HInterID == 0) |
| | | { |
| | | // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | bResult = ReportModel.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else |
| | | { |
| | | bResult = ReportModel.ModifyBill(ReportModel.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | if (bResult) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "保存成功!"; |
| | | //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单"); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "保存失败!" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "保存失败!" + e.ToString(); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 派工单号获取信息 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Sc_ProcessMangement/getHbarCodeDetail")] |
| | | [HttpGet] |
| | | public ApiResult<DataSet> GetHbarCodeDetail(string sBillBarCode) |
| | | { |
| | | var model = LuBaoSevice.GetHbarCodeDetail(sBillBarCode); |
| | | return model; |
| | | } |
| | | |
| | | /// <summary> |
| | | ///工序号获得信息 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Sc_ProcessMangement/getProcDetail")] |
| | | [HttpGet] |
| | | public ApiResult<DataSet> GetProcDetail(string sBillNo, string sProcNo) |
| | | { |
| | | var model = LuBaoSevice.GetProcDetail(sBillNo, sProcNo); |
| | | return model; |
| | | } |
| | | |
| | | |
| | | // |
| | | } |