智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2025-04-09 5898d7f62ec4b29f313a018c7526ce100e9d30a6 
 WebAPI/Controllers/CJGL/Cj_SingleStationController.cs


@@ -15,6 +15,7 @@


    {


        private json objJsonResult = new json();


        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();


        DataSet ds;




        #region 工序单品不良采集  用户查询关联字段


@@ -29,7 +30,7 @@


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "Sucess！";


                    objJsonResult.Message = "[0000-1-038]Sucess！";


                    objJsonResult.data = new DataTable();


                    return objJsonResult;


                }


@@ -38,7 +39,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


@@ -46,7 +47,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -306,9 +307,24 @@


            //修改条码表的状态


            oCN.RunProc("update Gy_BarCodeBill set HStatus='"+ HResult + "' where HBarCode='"+ oSub.HBarCode + "'");




            LogService.Write("类型:" + oSub.HBadTypeID + ",制单人:" + oSub.HMaker + ",制单日期:" + oSub.HMakeDate);


            //修改出站单的 不良 报废数量


            if (HResult == "不良") {


                oCN.RunProc("update Sc_StationOutBillMain set HBadCount+=1  where HProcExchBillNo='" + oSub.HProcExchBillNo + "' and HProcID=" + oSub.HProcID + " and HInterID=" + linterid);


            if (HResult == "不良")


            {


                LogService.Write("类型:" + oSub.HBadTypeID);


                //工废


                if (oSub.HBadTypeID == 3)


                {


                    oCN.RunProc("update Sc_StationOutBillMain set HBadCount+=1,HWasterQty_Work+=1  where HProcExchBillNo='" + oSub.HProcExchBillNo + "' and HProcID=" + oSub.HProcID + " and HInterID=" + linterid);


                }//料废


                else if (oSub.HBadTypeID == 4)


                {


                    oCN.RunProc("update Sc_StationOutBillMain set HBadCount+=1,HWasterQty_Mater+=1  where HProcExchBillNo='" + oSub.HProcExchBillNo + "' and HProcID=" + oSub.HProcID + " and HInterID=" + linterid);


                }//返工


                else if (oSub.HBadTypeID == 6)


                {


                    oCN.RunProc("update Sc_StationOutBillMain set HBadCount+=1,HBackWorkQty+=1  where HProcExchBillNo='" + oSub.HProcExchBillNo + "' and HProcID=" + oSub.HProcID + " and HInterID=" + linterid);


                }


            }


            else if (HResult == "报废")


            {


@@ -335,7 +351,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查询权限!";


                    objJsonResult.Message = "[0000-1-068]无查询权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -346,16 +362,27 @@


                    HProcID = ds.Tables[0].Rows[0]["HProcID"].ToString();


                }




                //判断当前流转卡是否是开工


                ds = oCN.RunProcReturn("select  * from Sc_ICMOBillStatus_Tmp where HSourceBillNo='" + HBarCode + "' and HICMOStatus<>'0'", "Sc_ICMOBillStatus_Tmp");


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






                //客户制定


                string sErr = "";


                if (oSystemParameter.ShowBill(ref sErr))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "卡号:" + HBarCode + ",流转卡未开工!";


                    objJsonResult.data = null;


                    return objJsonResult;


                    if (oSystemParameter.omodel.WMS_CampanyName == "杭州斯莫尔")


                    {


                        //判断当前流转卡是否是开工


                        ds = oCN.RunProcReturn("select  * from Sc_ICMOBillStatus_Tmp where HSourceBillNo='" + HBarCode + "' and HICMOStatus<>'0'", "Sc_ICMOBillStatus_Tmp");


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


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "[3791-2-018]卡号:" + HBarCode + ",流转卡未开工!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                }






                ds = oCN.RunProcReturn(@"exec h_p_Gy_BarCodeBillBomList '" + HBarCode + "'," + HProcID, "h_p_Gy_BarCodeBillBomList");


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


@@ -366,7 +393,7 @@


                    {


                        objJsonResult.code = "2";


                        objJsonResult.count = 2;


                        objJsonResult.Message = "";


                        objJsonResult.Message = "[0000-1-037]";


                        objJsonResult.data = dataSet.Tables[0];


                        return objJsonResult;


                    }


@@ -374,7 +401,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "配件清单查无数据！,可能是当前用户工序不正确或者流转卡输入错误!";


                        objJsonResult.Message = "[3791-2-019]配件清单查无数据！,可能是当前用户工序不正确或者流转卡输入错误!";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -383,7 +410,7 @@


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "";


                    objJsonResult.Message = "[0000-1-037]";


                    objJsonResult.data = ds.Tables[0];


                }




@@ -394,7 +421,7 @@




                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -423,7 +450,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无保存权限!";


                    objJsonResult.Message = "[0000-2-038]无保存权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -436,7 +463,7 @@


                if (tempList.Count == 0) {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无配件数据!";


                    objJsonResult.Message = "[3791-2-026]无配件数据!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -467,7 +494,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "保存成功!";


                objJsonResult.Message = "[0000-1-050]保存成功!";


                objJsonResult.data = null;


                return objJsonResult;




@@ -477,7 +504,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.Message = "[0000-1-051]没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -503,7 +530,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无保存权限!";


                    objJsonResult.Message = "[0000-2-038]无保存权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -523,7 +550,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "查无数据!";


                    objJsonResult.Message = "[0000-1-045]查无数据!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -531,7 +558,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = ds.Tables[0].Rows[0]["HBackRemark"].ToString() + "！";


                    objJsonResult.Message = "[0000-1-051]" + ds.Tables[0].Rows[0]["HBackRemark"].ToString() + "！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -543,7 +570,7 @@


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "条码:" + omodel.HBarCode_P + ",已存在!";


                    objJsonResult.Message = "[0000-2-039]条码:" + omodel.HBarCode_P + ",已存在!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -562,7 +589,7 @@


                            oCN.RollBack();


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "配件代码:" + HMaterNamePJ + ",数量为0!";


                            objJsonResult.Message = "[3791-2-020]配件代码:" + HMaterNamePJ + ",数量为0!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


@@ -735,7 +762,7 @@


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "出站数量超过流转卡数量!";


                    objJsonResult.Message = "[3791-2-028]出站数量超过流转卡数量!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -744,7 +771,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "保存成功!";


                objJsonResult.Message = "[0000-1-050]保存成功!";


                objJsonResult.data = null;


                return objJsonResult;




@@ -754,7 +781,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.Message = "[0000-1-051]没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -811,7 +838,7 @@


                            {


                                objJsonResult.code = "0";


                                objJsonResult.count = 0;


                                objJsonResult.Message = "条码与流转卡不存在对应关系!";


                                objJsonResult.Message = "[3791-2-016]条码与流转卡不存在对应关系!";


                                objJsonResult.data = null;


                                return objJsonResult;


                            }


@@ -843,7 +870,7 @@


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "条码与流转卡不存在对应关系!";


                            objJsonResult.Message = "[3791-2-016]条码与流转卡不存在对应关系!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


@@ -858,7 +885,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "条码格式不正确!";


                        objJsonResult.Message = "[0000-2-036]条码格式不正确!";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -887,7 +914,7 @@


                            {


                                objJsonResult.code = "0";


                                objJsonResult.count = 0;


                                objJsonResult.Message = "条码与流转卡不存在对应关系!";


                                objJsonResult.Message = "[3791-2-016]条码与流转卡不存在对应关系!";


                                objJsonResult.data = null;


                                return objJsonResult;


                            }


@@ -907,7 +934,7 @@


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "条码与流转卡不存在对应关系!";


                            objJsonResult.Message = "[3791-2-016]条码与流转卡不存在对应关系!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


@@ -917,7 +944,7 @@


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "当前条码的状态为:" + ds.Tables[0].Rows[0]["HStatus"].ToString() + "！";


                        objJsonResult.Message = "[0000-2-037]当前条码的状态为:" + ds.Tables[0].Rows[0]["HStatus"].ToString() + "！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


@@ -925,7 +952,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "";


                objJsonResult.Message = "[0000-1-037]";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


@@ -934,7 +961,7 @@




                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -957,7 +984,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "条形码不能为空，不能生成条码！";


                    objJsonResult.Message = "[0000-2-019]条形码不能为空，不能生成条码！";


                    return objJsonResult;


                }




@@ -1028,7 +1055,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "";


                objJsonResult.Message = "[0000-1-037]";


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1037,7 +1064,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1056,7 +1083,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查询权限!";


                    objJsonResult.Message = "[0000-1-068]无查询权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1066,7 +1093,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "SN码查无数据！";


                    objJsonResult.Message = "[3791-2-023]SN码查无数据！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1075,7 +1102,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "当前条码的状态为:"+ ds.Tables[0].Rows[0]["HStatus"].ToString() + "！";


                    objJsonResult.Message = "[0000-2-037]当前条码的状态为:" + ds.Tables[0].Rows[0]["HStatus"].ToString() + "！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1086,7 +1113,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "配件条码判断失败！";


                    objJsonResult.Message = "[3791-2-024]配件条码判断失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1094,14 +1121,14 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = DBUtility.ClsPub.isStrNull(dataSet.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.Message = "[0000-1-010]" + DBUtility.ClsPub.isStrNull(dataSet.Tables[0].Rows[0]["HBackRemark"]);


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "";


                objJsonResult.Message = "[0000-1-037]";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


@@ -1110,7 +1137,7 @@




                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1129,7 +1156,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查询权限!";


                    objJsonResult.Message = "[0000-1-068]无查询权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1143,7 +1170,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "条码查无数据！";


                    objJsonResult.Message = "[0000-1-045]条码查无数据！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1159,7 +1186,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "当前条码与当前工序不匹配!";


                    objJsonResult.Message = "[3791-2-017]当前条码与当前工序不匹配!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1167,14 +1194,14 @@


                if (ds.Tables[0].Rows[0]["HStatus"].ToString() != "正常") {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "当前条码状态为"+ ds.Tables[0].Rows[0]["HStatus"].ToString() + "!";


                    objJsonResult.Message = "[0000-2-037]当前条码状态为" + ds.Tables[0].Rows[0]["HStatus"].ToString() + "!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "";


                objJsonResult.Message = "[0000-1-037]";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


@@ -1183,7 +1210,7 @@




                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1202,7 +1229,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查询权限!";


                    objJsonResult.Message = "[0000-1-068]无查询权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1211,7 +1238,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "";


                objJsonResult.Message = "[0000-1-037]";


                objJsonResult.data = ds;


                return objJsonResult;


            }


@@ -1220,7 +1247,7 @@




                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1239,7 +1266,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查询权限!";


                    objJsonResult.Message = "[0000-1-068]无查询权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1248,7 +1275,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "";


                objJsonResult.Message = "[0000-1-037]";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


@@ -1257,7 +1284,7 @@




                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1276,7 +1303,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无删除权限!";


                    objJsonResult.Message = "[0000-1-058]无删除权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1287,7 +1314,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "查无数据！";


                    objJsonResult.Message = "[0000-1-045]查无数据！";


                    objJsonResult.data = null;


                }


                string HProcExchInterID = ds.Tables[0].Rows[0]["HProcExchInterID"].ToString();


@@ -1320,7 +1347,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1329,7 +1356,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1348,7 +1375,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无删除权限!";


                    objJsonResult.Message = "[0000-1-058]无删除权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1361,7 +1388,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "查无数据！";


                    objJsonResult.Message = "[0000-1-045]查无数据！";


                    objJsonResult.data = null;


                }




@@ -1390,7 +1417,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1399,7 +1426,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1418,7 +1445,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查询权限!";


                    objJsonResult.Message = "[0000-1-068]无查询权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1432,7 +1459,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "条码查无数据！";


                    objJsonResult.Message = "[0000-2-020]条码查无数据！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1449,7 +1476,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "当前条码与当前工序不匹配!";


                    objJsonResult.Message = "[3791-2-017]当前条码与当前工序不匹配!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1458,7 +1485,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "当前条码状态为" + ds.Tables[0].Rows[0]["HStatus"].ToString() + "!";


                    objJsonResult.Message = "[0000-2-037]当前条码状态为" + ds.Tables[0].Rows[0]["HStatus"].ToString() + "!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1466,7 +1493,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "";


                objJsonResult.Message = "[0000-1-037]";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


@@ -1475,7 +1502,7 @@




                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1542,7 +1569,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查询权限!";


                    objJsonResult.Message = "[0000-1-068]无查询权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1562,7 +1589,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


@@ -1571,7 +1598,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1598,7 +1625,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无保存权限!";


                    objJsonResult.Message = "[0000-2-038]无保存权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1674,15 +1701,27 @@


                        if (dataSet.Tables[0].Rows.Count > 0)


                        {


                            string HOutInterID = dataSet.Tables[0].Rows[0][0].ToString();




                            oCN.RunProc("update Sc_StationOutBillMain set HBadCount-=1 where HInterID='" + HOutInterID + "'");


                            //斯莫尔的情况 分 工废料废 返工


                            //工废


                            if (subLsit[0].HBadTypeID == 3)


                            {


                                oCN.RunProc("update Sc_StationOutBillMain set HBadCount-=1,HWasterQty_Work-=1  where HInterID='" + HOutInterID + "'");


                            }//料废


                            else if (subLsit[0].HBadTypeID == 4)


                            {


                                oCN.RunProc("update Sc_StationOutBillMain set HBadCount-=1,HWasterQty_Mater-=1 where HInterID='" + HOutInterID + "'");


                            }//返工


                            else if (subLsit[0].HBadTypeID == 6)


                            {


                                oCN.RunProc("update Sc_StationOutBillMain set HBadCount-=1,HBackWorkQty-=1 where HInterID='" + HOutInterID + "'");


                            }


                        }


                        else


                        {


                            oCN.RollBack();


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "保存失败,当前流转卡当前工序的出站单没有不良数量!";


                            objJsonResult.Message = "[3748-2-005]保存失败,当前流转卡当前工序的出站单没有不良数量!";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


@@ -1692,7 +1731,7 @@


                    oCN.RollBack();


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "保存失败,无结果！";


                    objJsonResult.Message = "[0000-1-051]保存失败,无结果！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1702,7 +1741,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-050]Sucess！";


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1711,7 +1750,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-051]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1730,7 +1769,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无删除权限!";


                    objJsonResult.Message = "[0000-1-058]无删除权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1740,7 +1779,7 @@


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


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "查无数据！";


                    objJsonResult.Message = "[0000-1-045]查无数据！";


                    objJsonResult.data = null;


                }




@@ -1779,7 +1818,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-010]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1851,7 +1890,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无查询权限!";


                    objJsonResult.Message = "[0000-1-068]无查询权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -1861,7 +1900,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


            }


@@ -1869,7 +1908,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1939,7 +1978,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


@@ -1949,7 +1988,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -1979,7 +2018,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


@@ -1989,7 +2028,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -2019,7 +2058,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


@@ -2029,7 +2068,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -2059,7 +2098,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


@@ -2068,7 +2107,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -2098,7 +2137,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


@@ -2108,7 +2147,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -2138,7 +2177,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


@@ -2148,7 +2187,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


@@ -2178,7 +2217,7 @@




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.Message = "[0000-1-037]Sucess！";


                objJsonResult.data = ds.Tables[0];


                objJsonResult.list = columnNameList;


                return objJsonResult;


@@ -2188,7 +2227,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }