收料通知单主表添加同步字段

yusijie

2023-03-20 ee9e9a2cf7c405637ad7c8f1e262ae39fff8a88a

 WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs

@@ -1,4 +1,5 @@
using Newtonsoft.Json;
using Model;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
@@ -1639,7 +1640,137 @@
        }
        #endregion

        #region 返回工序出站汇报单明细列表
        [Route("Cj_StationOutBill_Detail/get_Display2")]
        [HttpGet]
        public object get_Display2(string HMaterID, string HWorkProcID, string HProcExchBillNo)
        {
            try
            {
                ds = oCN.RunProcReturn("select * from h_v_GetStationOutBill_Detail where 工序ID = " + HWorkProcID + " and 物料ID = " + HMaterID + " and 流转卡号 = '" + HProcExchBillNo + "'" , "h_v_GetStationOutBill_Detail");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "工序出站汇报单明细信息获取失败！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        
        #region 明细 保存/编辑功能
        //[Route("Cj_StationOutBill/AddBill_Detail")]
        //[HttpPost]
        //public object AddBill_Detail([FromBody] JObject sMain)
        //{
        //    try
        //    {
        //        var _value = sMain["sMainSub"].ToString();
        //        string msg1 = _value.ToString();
        //        oCN.BeginTran();
        //        //保存主表
        //        objJsonResult = Add_Detail(msg1);
        //        if (objJsonResult.code == "0")
        //        {
        //            oCN.RollBack();
        //            objJsonResult.code = "0";
        //            objJsonResult.count = 0;
        //            objJsonResult.Message = objJsonResult.Message;
        //            objJsonResult.data = null;
        //            return objJsonResult;
        //        }
        //        oCN.Commit();
        //        objJsonResult.code = "1";
        //        objJsonResult.count = 1;
        //        objJsonResult.Message = "单据保存成功！";
        //        objJsonResult.data = null;
        //        return objJsonResult;

        //    }
        //    catch (Exception e)
        //    {
        //        oCN.RollBack();
        //        objJsonResult.code = "0";
        //        objJsonResult.count = 0;
        //        objJsonResult.Message = "保存失败！" + e.ToString();
        //        objJsonResult.data = null;
        //        return objJsonResult;
        //    }
        //}

        //public json Add_Detail(string msg1)
        //{
        //    string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
        //    string msg2 = sArray[0].ToString(); //表头数据
        //    string msg3 = sArray[1].ToString(); //表体数据
        //    int OperationType = int.Parse(sArray[2].ToString()); // 数据类型 1添加 3修改
        //    string user = sArray[3].ToString(); //用户名
        //    try
        //    {                              
        //        List<ClsSc_StationOutBillSub_Emp> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg2);

        //        List<ClsSc_StationOutBillSub_Emp> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg3);
             
        //        long HWorkEmpID = subList[0].HWorkEmpID;
        //        long HWorkSourceID = subList[0].HWorkSourceID;
        //        decimal HQty = subList[0].HQty;
        //        decimal HRate = subList[0].HRate;
        //        decimal HProcPrice = subList[0].HProcPrice;
        //        decimal HMoney = subList[0].HMoney;
        //        long HWorkProcID = mainList[0].HWorkProcID;           

        //        foreach (ClsSc_StationOutBillSub_Emp oSub in subList)
        //        {
        //            //ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_IF_ICMOBillList");

        //            if ((OperationType == 1 || OperationType == 2) && ds.Tables[0].Rows.Count == 0)//新增
        //            {
        //                //主表
        //                oCN.RunProc(@"Insert Into Sc_StationOutBillSub_Emp   
        //                    (HBillNo_bak ,HCloseMan ,HEntryCloseDate ,HCloseType ,HRemark ,HSourceInterID
        //                    ,HSourceEntryID ,HSourceBillNo ,HSourceBillType ,HRelationQty ,HRelationMoney 
        //                    ,HWorkEmpID ,HWorkSourceID ,HQty ,HRate ,HProcPrice 
        //                    ,HMoney ,HWorkProcID)
        //                    values('3710',1," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID +
        //                "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + HRemark + "','" + HMaker + "',getdate()" +
        //                ",'" + HSeOrderBillNo + "'," + HSeOrderInterID + "," + HSeOrderEntryID + "," + HEmpID + "," + HCusID +
        //                "," + HCenterID + ",0,0,0,0," + HBomID + ",'','') ");
        //            }               
        //        }

        //        objJsonResult.code = "1";
        //        objJsonResult.count = 1;
        //        objJsonResult.Message = null;
        //        objJsonResult.data = null;
        //        return objJsonResult;
        //    }
        //    catch (Exception e)
        //    {
        //        objJsonResult.code = "0";
        //        objJsonResult.count = 0;
        //        objJsonResult.Message = "Exception！" + e.ToString();
        //        objJsonResult.data = null;
        //        return objJsonResult;
        //    }
        //}
        #endregion
    }
}