智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2023-06-29 2d3fc93b131c7aa771e8f7d08a82d5e9b4946eff 
 WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/JIT_DayPlanPlatFormImportController.cs


@@ -55,6 +55,7 @@


                tb2.Columns.Add("单据号", typeof(string));


                tb2.Columns.Add("HWorkShopID", typeof(Int32));//生产车间


                tb2.Columns.Add("HEmpID", typeof(Int32));//职员


                tb2.Columns.Add("员工", typeof(string));//职员


                tb2.Columns.Add("HUnitID", typeof(Int32));//计量单位


                tb2.Columns.Add("HSourceID", typeof(Int32));//生产资源id


                tb2.Columns.Add("ICMOBillHInterID", typeof(Int32));//生产订单主id


@@ -105,8 +106,10 @@


                    ds = oCN.RunProcReturn(sql1, "h_v_IF_ICMOBillList");




                    if (ds.Tables[0].Rows.Count == 0)


                    {


                        error += $"没有生产订单信息，生产订单号:{ tb2.Rows[i]["生产订单号*"].ToString()},生产车间编码:{tb2.Rows[i]["生产车间编码*"].ToString()}" +


                            $",生产订单明细行号:{ tb2.Rows[i]["生产订单明细行号*"].ToString()},物料编码:{ tb2.Rows[i]["物料编码*"].ToString()}";


                               $",生产订单明细行号:{ tb2.Rows[i]["生产订单明细行号*"].ToString()},物料编码:{ tb2.Rows[i]["物料编码*"].ToString()}";


                    }




                    if (error.Length > 0)


                    {


@@ -142,6 +145,7 @@


                        tb2.Rows[i]["HSourceID"] = ds.Tables[0].Rows[0]["HSourceID"].ToString();


                        tb2.Rows[i]["HEmpID"] = ds.Tables[0].Rows[0]["HEmpID"].ToString();


                        tb2.Rows[i]["员工编码"] = ds.Tables[0].Rows[0]["职员代码"].ToString();


                        tb2.Rows[i]["员工"] = ds.Tables[0].Rows[0]["职员"].ToString();


                        tb2.Rows[i]["HUnitID"] = ds.Tables[0].Rows[0]["HUnitID"].ToString();


                        tb2.Rows[i]["计量单位"] = ds.Tables[0].Rows[0]["计量单位"].ToString();


                        tb2.Rows[i]["批次号"] = ds.Tables[0].Rows[0]["批次"].ToString();


@@ -153,7 +157,8 @@


                        //员工


                        ds = oCN.RunProcReturn($"select * from Gy_Employee  where HNumber='{tb2.Rows[i]["员工编码"].ToString()}'", "Gy_Employee");


                        if (ds.Tables[0].Rows.Count > 0) {


                            tb2.Rows[i]["员工编码"] = ds.Tables[0].Rows[0]["HItemID"].ToString();


                            tb2.Rows[i]["HEmpID"] = ds.Tables[0].Rows[0]["HItemID"].ToString();


                            tb2.Rows[i]["员工"] = ds.Tables[0].Rows[0]["HName"].ToString();


                        }


                        else


                        {