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


@@ -127,6 +127,10 @@


                    list.Add("仪器成品条码规则");


                    list.Add("试剂成品条码规则");


                }


                else if (sCapName == "添康科技")


                {


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


                }


                else


                {


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


@@ -232,6 +236,11 @@


                        tabname = "h_v_IF_ProcessExchangeBillList_Source";


                        count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_ProcessExchangeBillList_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_ProcessExchangeBillList_Source " + sWhere + ")   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        break;


                    case "销售出库单":


                        tabname = "h_v_IF_SellOutBillList_Source";


                        count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList_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_SellOutBillList_Source " + sWhere + ")   as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)");


                        break;


                    default:


                        break;


@@ -346,6 +355,12 @@


                        case "3711": //生产汇报单


                            //得到信息


                            ds = oCN.RunProcReturn("select * from h_v_IF_ICMOReportList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_ICMOReportList");


                            //写入信息


                            ListRows.Add(HSourceOrderList1(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType));


                            break;


                        case "1205": //销售出库单


                            //得到信息


                            ds = oCN.RunProcReturn("select * from h_v_IF_SellOutBillList_BarCode where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_SellOutBillList_BarCode");


                            //写入信息


                            ListRows.Add(HSourceOrderList1(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType));


                            break;


@@ -578,6 +593,15 @@


                    ordrlist.HSPNumber = dt.Rows[i]["仓位代码"].ToString();


                    ordrlist.HSPName = dt.Rows[i]["仓位"].ToString();


                }


                if(HSourceBillType == "销售出库单")


                {


                    ordrlist.HWhID = dt.Rows[i]["HWhID"].ToString();


                    ordrlist.HWhNumber = dt.Rows[i]["仓库代码"].ToString();


                    ordrlist.HWhName = dt.Rows[i]["仓库"].ToString();


                    //ordrlist.HSPID = dt.Rows[i]["HSPID"].ToString();


                    //ordrlist.HSPNumber = dt.Rows[i]["仓位代码"].ToString();


                    //ordrlist.HSPName = dt.Rows[i]["仓位"].ToString();


                }


            }


            return ordrlist;


        }


@@ -663,13 +687,13 @@


                if (oDs == null && oDs.Tables[0].Rows.Count == 0)


                {


                    objJsonResult.code = "1";


                    objJsonResult.Message="生成批次失败！";


                    objJsonResult.Message= "[0000-2-053]生成批次失败！";


                    return objJsonResult;


                }


                else if (DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0][0]) == "1")


                {


                    objJsonResult.code = "1";


                    objJsonResult.Message = "生成批次成功！";


                    objJsonResult.Message = "[0000-2-054]生成批次成功！";


                    objJsonResult.data = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HBatchNo"]);


                    HBatchNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HBatchNo"]);


                    b = true;


@@ -680,7 +704,7 @@


            if (b == false)


            {


                objJsonResult.code = "1";


                objJsonResult.Message="没有需要生成批次的明细行！";


                objJsonResult.Message= "[3899-2-003]没有需要生成批次的明细行！";


                return objJsonResult;


            }


            else //完全封闭


@@ -721,7 +745,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "选择组织有错误!";


                    objJsonResult.Message = "[0000-2-055]选择组织有错误!";


                    return objJsonResult;


                }


                if (!Sub_AllowSave(msg2, HSelectBarCodeType))//单据完整性判断


@@ -742,7 +766,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "条码生成失败!"+e.Message;


                objJsonResult.Message = "[3899-2-006]条码生成失败!" + e.Message;


                return objJsonResult;


            }


            return objJsonResult;


@@ -775,7 +799,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "条码生成完整性判断错误";


                        objJsonResult.Message = "[3899-2-007]条码生成完整性判断错误";


                        return false;


                    }


                    else if (DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0][0]) == "1")


@@ -1284,6 +1308,10 @@


                        {


                            HBarCodeType = "唯一条码";


                        }


                        if (CampanyName == "九菱")


                        {


                            HBarCode = HBarCode + ClsPub.isStrNull(ListRows[i].HMTONo2);


                        }


                        //


                        HMaterID = ClsPub.isLong(ListRows[i].HMaterID2);


                        HEntryID = ClsPub.isLong(ListRows[i].HEntryID2);


@@ -1405,7 +1433,7 @@


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取资源绑定数据成功！";


                    objJsonResult.Message = "[0000-1-037]获取资源绑定数据成功！";


                    objJsonResult.data = JsonConvert.DeserializeObject<DataTable>(JsonConvert.SerializeObject(ds.Tables[0], new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" }));  //序列化DataSet中的时间格式，然后再反序列化回来


                    objJsonResult.list = listobj;


                    return objJsonResult;


@@ -1414,7 +1442,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有返回任何结果,条码不存在！";


                    objJsonResult.Message = "[0000-2-020]没有返回任何结果,条码不存在！";


                    objJsonResult.data = null;


                    objJsonResult.list = listobj;


                    return objJsonResult;


@@ -1425,7 +1453,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "条码生成失败！" + e.Message;


                objJsonResult.Message = "[3899-2-006]条码生成失败！" + e.Message;


                return objJsonResult;


            }


        }