智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yxj
2023-06-16 a6f521ecffd706f51b068487e89476aa80041ae8 
 WebAPI/Controllers/²Ö´æ¹ÜÀí/ÌõÂëÉú³É/Sc_BarCodeController.cs


@@ -132,7 +132,7 @@


                    list.Add("唯一条码");


                    list.Add("品种条码");


                    list.Add("批次条码");


                    //list.Add("托盘条码");


                    list.Add("托盘条码");


                }


                objJsonResult.code = "1";


                objJsonResult.count = 1;


@@ -177,27 +177,27 @@


                    case "生产订单":


                        tabname = "h_v_IFCLD_ICMOBillList_Source"; 


                        count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IFCLD_ICMOBillList_Source "+sWhere+ " and ä»»åŠ¡æ•°é‡>isnull(入库数量,0)  and çŠ¶æ€<>'结案' order by å•æ®å·", tabname).Tables[0].Rows.Count;


                        sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by å•æ®å·) as HRowNumber,* from h_v_IFCLD_ICMOBillList_Source " + sWhere + " and ä»»åŠ¡æ•°é‡>isnull(入库数量,0)  and çŠ¶æ€<>'结案')   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        sql = string.Format(@"select * from(select row_number() over (order by å•æ®å·) as HRowNumber,* from h_v_IFCLD_ICMOBillList_Source " + sWhere + " and ä»»åŠ¡æ•°é‡>isnull(入库数量,0)  and çŠ¶æ€<>'结案')   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        break;


                    case "生产汇报单":


                        tabname = "h_v_IF_ICMOReportBillList_Source";


                        count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_ICMOReportBillList_Source " + sWhere + " order by å•æ®å· desc,hsubid", tabname).Tables[0].Rows.Count;


                        sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by å•æ®å· desc,hsubid) as HRowNumber,* from h_v_IF_ICMOReportBillList_Source " + sWhere + ")   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        sql = string.Format(@"select * from(select row_number() over (order by å•æ®å· desc,hsubid) as HRowNumber,* from h_v_IF_ICMOReportBillList_Source " + sWhere + ")   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        break;


                    case "采购订单":


                        tabname = "h_v_IF_POOrderBillList_Source";


                        count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_POOrderBillList_Source " + sWhere + " order by å•æ®å· desc,hsubid", tabname).Tables[0].Rows.Count;


                        sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by å•æ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POOrderBillList_Source " + sWhere + ")   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        sql = string.Format(@"select * from(select row_number() over (order by å•æ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POOrderBillList_Source " + sWhere + ")   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        break;


                    case "收料通知单":


                        tabname = "h_v_IF_POInStockBillList_Source";


                        count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_POInStockBillList_Source " + sWhere + " order by å•æ®å· desc,hsubid", tabname).Tables[0].Rows.Count;


                        sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by å•æ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POInStockBillList_Source " + sWhere + ")   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        sql = string.Format(@"select * from(select row_number() over (order by å•æ®å· desc,hsubid) as HRowNumber,* from h_v_IF_POInStockBillList_Source " + sWhere + ")   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        break;


                    case "委外订单":


                        tabname = "h_v_IF_EntrustOrderBillList_Source";


                        count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_EntrustOrderBillList_Source " + sWhere + " order by å•æ®å· desc,hsubid", tabname).Tables[0].Rows.Count;


                        sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by å•æ®å· desc,hsubid) as HRowNumber,* from h_v_IF_EntrustOrderBillList_Source " + sWhere + ")   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        sql = string.Format(@"select * from(select row_number() over (order by å•æ®å· desc,hsubid) as HRowNumber,* from h_v_IF_EntrustOrderBillList_Source " + sWhere + ")   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        break;


                    case "生产入库单":


                        tabname = "h_v_IF_ProductInBillList_Source";


@@ -959,10 +959,14 @@


                        LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);


                        LSHlen = 5;


                    }


                    //else if (cmbHBarCodeType.Text == "托盘条码")


                    //{


                    //    TM = HOrgNumber + HNumber + LSH2;


                    //}


                    else if (HSelectBarCodeType == "托盘条码")


                    {


                        LSHlen = 4;     //流水号长度


                        //条码前缀 = ç‰©æ–™å†…码 + å¹´ + æœˆ + æ—¥


                        sTMNumber = HNumber + sYear + sPeriod + sDay;


                        Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo");    //获取最大流水号


                        LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);


                    }


                    else


                    {


                        objJsonResult.code = "0";


@@ -1002,7 +1006,7 @@


                        {


                            LSH2 = "0" + LSH2;


                        }


                        if (HSelectBarCodeType == "唯一条码")


                        if (HSelectBarCodeType == "唯一条码" || HSelectBarCodeType == "托盘条码")


                        {


                            //条码编号 = æ¡ç å‰ç¼€ + æµæ°´å·


                            TM = sTMNumber + LSH2;