blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2023-05-26 c5dba804d497aca69c6971e082d954e7d13d02d1 
 WebAPI/Controllers/²Ö´æ¹ÜÀí/ÌõÂëÉú³É/Sc_BarCodeController.cs


@@ -1,4 +1,5 @@


using DBUtility;


using DAL;


using DBUtility;


using Newtonsoft.Json;


using Newtonsoft.Json.Converters;


using Newtonsoft.Json.Linq;


@@ -176,39 +177,47 @@


                    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 "退货通知单":


                    case "生产入库单":


                        tabname = "h_v_IF_ProductInBillList_Source";


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


                        break;


                    case "其他入库单":


                    case "采购入库单":


                        tabname = "h_v_IF_POStockInBillList_Source";


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


                        break;


                    case "直接调拨单":


                        break;


                    case "采购退料单":


                    case "销售退货单":


                        tabname = "h_v_IF_SellOutBackBillList_Source";


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


                        break;


                    case "生产退料单":


                        break;


                    case "组装拆卸单":


                        tabname = "h_v_IF_MateOutBackBillList_Source";


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


                        break;


                    default:


                        break;


@@ -217,8 +226,8 @@


                string aa = ds.Tables[0].Columns[0].ToString();


                //ds.Tables[0].Columns["hmainid"].ColumnName.ToUpper();


                //ds.Tables[0].Columns["hsubid"].ColumnName.ToUpper();


                ds.Tables[0].Columns["hmainid"].ColumnName= "HMainID";


                ds.Tables[0].Columns["hsubid"].ColumnName= "HSubID";


                ds.Tables[0].Columns["hmainid"].ColumnName = "HMainID";


                ds.Tables[0].Columns["hsubid"].ColumnName = "HSubID";


                foreach (DataColumn col in ds.Tables[0].Columns)


                {




@@ -344,6 +353,30 @@


                            //写入信息


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


                            break;


                        case "1202": //生产入库


                             //得到信息


                            ds = oWebs.getDataSetBySQL("select * from h_v_IF_ProductInBillList_Source where HMainID=" + oSelectRow.BillMainID + " and HSubID=" + oSelectRow.BillSubID, "h_v_IF_ProductInBillList_Source", ref DBUtility.ClsPub.sExeReturnInfo);


                            //写入信息


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


                            break;


                        case "1201": //采购入库


                            //得到信息


                            ds = oWebs.getDataSetBySQL("select * from h_v_IF_POStockInBillList_Source    where HMainID=" + oSelectRow.BillMainID + " and HSubID=" + oSelectRow.BillSubID, "h_v_IF_POStockInBillList_Source   ", ref DBUtility.ClsPub.sExeReturnInfo);


                            //写入信息


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


                            break;


                        case "1247": //销售退货


                            //得到信息


                            ds = oWebs.getDataSetBySQL("select * from h_v_IF_SellOutBackBillList_Source where HMainID=" + oSelectRow.BillMainID + " and HSubID=" + oSelectRow.BillSubID, "h_v_IF_SellOutBackBillList_Source", ref DBUtility.ClsPub.sExeReturnInfo);


                            //写入信息


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


                            break;


                        case "1244": //生产退料


                            //得到信息


                            ds = oWebs.getDataSetBySQL("select * from h_v_IF_MateOutBackBillList_Source where HMainID=" + oSelectRow.BillMainID + " and HSubID=" + oSelectRow.BillSubID, "h_v_IF_MateOutBackBillList_Source", ref DBUtility.ClsPub.sExeReturnInfo);


                            //写入信息


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


                            break;


                        case "1403": //退货通知单


                            break;


                        case "1203": //其他入库单


@@ -351,8 +384,6 @@


                        case "1207": //直接调拨单


                            break;


                        case "1239": //采购退料单


                            break;


                        case "1244": //生产退料单


                            break;


                        case "1255": //组装拆卸单


                            break;


@@ -415,6 +446,7 @@


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


                ordrlist.HSourceName = dt.Rows[i]["生产线"].ToString();


                ordrlist.HEndDate = dt.Rows[i]["计划完工日期"].ToString();//博日 ç”Ÿäº§è®¢å• å¤±æ•ˆæ—¥æœŸ


                ordrlist.HMinQty = dt.Rows[i]["最小包装数"].ToString();


                if (HBarCodeType == "仪器外购件条码容器规则")


                {


                    ordrlist.HMinQty = dt.Rows[i]["未生成条码数量"].ToString();


@@ -456,6 +488,14 @@


                ordrlist.HUnitName = dt.Rows[i]["计量单位"].ToString();


                ordrlist.HRemark = dt.Rows[i]["备注"].ToString();


                ordrlist.HMTONo = dt.Rows[i]["计划跟踪号"].ToString();




                if(HSourceBillType == "收料通知单")


                {


                    ordrlist.HFurnaceNO = dt.Rows[i]["炉号"].ToString();


                    ordrlist.HCoilNO = dt.Rows[i]["钢卷捆包号"].ToString();


                    ordrlist.HheatNO = dt.Rows[i]["热处理"].ToString();


                }




                if (HBarCodeType == "仪器外购件条码容器规则")


                {


                    ordrlist.HMinQty = dt.Rows[i]["未生成条码数量"].ToString();


@@ -506,6 +546,45 @@


            return ordrlist;


        }




        //根据TABLE写入界面(出入库单据) 


        private object Sub_WriteInForm_InOut(DataTable dt, HSouceOrderList ordrlist, string HBarCodeType, string HSourceBillType)


        {




            for (int i = 0; i < dt.Rows.Count; i++)


            {


                ordrlist.HQty = dt.Rows[i]["可生成条码数量"].ToString();


                ordrlist.HinitQty = dt.Rows[i]["可生成条码数量"].ToString();


                ordrlist.HMinQty = dt.Rows[i]["最小包装数"].ToString();


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


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


                ordrlist.HBillNo = dt.Rows[i]["单据号"].ToString();


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


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


                ordrlist.HDeptNumber = dt.Rows[i]["部门代码"].ToString();


                ordrlist.HDeptName = dt.Rows[i]["部门"].ToString();


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


                ordrlist.HMaterNumber = dt.Rows[i]["物料代码"].ToString();


                ordrlist.HMaterName = dt.Rows[i]["物料名称"].ToString();


                ordrlist.HMaterModel = dt.Rows[i]["规格型号"].ToString();


                ordrlist.HBatchNo = dt.Rows[i]["批号"].ToString();


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


                ordrlist.HUnitNumber = dt.Rows[i]["计量单位代码"].ToString();


                ordrlist.HUnitName = dt.Rows[i]["计量单位"].ToString();


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


                ordrlist.HAuxPropNumber = dt.Rows[i]["辅助属性代码"].ToString();


                ordrlist.HAuxPropName = dt.Rows[i]["辅助属性"].ToString();


                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();


                ordrlist.HMTONo = dt.Rows[i]["计划跟踪号"].ToString();


                ordrlist.HDate = dt.Rows[i]["日期"].ToString(); 


                ordrlist.HShowDate = DateTime.Now.ToString();


            }


            return ordrlist;


        }


        #endregion




        #region [同步资料]


@@ -587,7 +666,7 @@


                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


                string msg2 = sArray[0].ToString();


                string HOrgType = sArray[1].ToString();


                string HSourceBillType = sArray[2].ToString();


                string HSourceBillTypeName = sArray[2].ToString();


                string HSelectBarCodeType = sArray[3].ToString();


                string CampanyName = sArray[4].ToString()=="xxx"?"": sArray[4].ToString();


                string UserName = sArray[5].ToString();


@@ -619,7 +698,7 @@


                else


                {


                    //生成条码


                    SaveBarCode(msg2, HSelectBarCodeType, CampanyName);


                    SaveBarCode(msg2, HSelectBarCodeType, CampanyName, HSourceBillTypeName);


                }


            }


            catch (Exception e)


@@ -681,7 +760,7 @@


        #endregion




        #region[条码生成方法]


        private object SaveBarCode(string msg2, string HSelectBarCodeType, string CampanyName)


        private object SaveBarCode(string msg2, string HSelectBarCodeType, string CampanyName,string HSourceBillTypeName)


        {


            int LSHlen = 6;             //流水号长度


            int SumLen = 10;            //总长度


@@ -708,6 +787,13 @@


            int k = 0;


            int n = 0;                  //同一批生成条码中的第几条


            string sTMNumber = "";      //条码自定义前缀




            string HCoilNO = "";


            string HFurnaceNO = "";


            string HFactory = "";


            decimal HAuxQty = 0;


            string HheatNO = "";




            DataSet Ds;


            msg2 = msg2.Replace("\\", "");


            msg2 = msg2.Replace("\n", "");  //\n


@@ -720,6 +806,12 @@


                    HNumber = DBUtility.ClsPub.isStrNull(ordrlist[j].HMaterID);


                    HMaterNumber = DBUtility.ClsPub.isStrNull(ordrlist[j].HMaterNumber);


                    HBatchNo = ClsPub.isStrNull(ordrlist[j].HBatchNo);




                    HCoilNO = ClsPub.isStrNull(ordrlist[j].HCoilNO);


                    HFurnaceNO = ClsPub.isStrNull(ordrlist[j].HFurnaceNO);


                    HFactory = ClsPub.isStrNull(ordrlist[j].HFactory);


                    HAuxQty = ClsPub.isLong(ordrlist[j].HAuxQty);


                    HheatNO = ClsPub.isStrNull(ordrlist[j].HheatNO);


                    //日期获取方式


                    sDate = DateTime.Now.ToString();


                    //


@@ -990,6 +1082,12 @@


                        barcode.HInnerBillNo2 = ordrlist[j].HInnerBillNo;


                        barcode.HMaker2 = ordrlist[j].HMaker;


                        barcode.HGiveAwayFlag2 = ordrlist[j].HGiveAwayFlag;




                        barcode.HCoilNO = ordrlist[j].HCoilNO;


                        barcode.HFurnaceNO = ordrlist[j].HFurnaceNO;


                        barcode.HFactory = ordrlist[j].HFactory;


                        barcode.HAuxQty = ordrlist[j].HAuxQty;


                        barcode.HheatNO = ordrlist[j].HheatNO;


                        ListRows.Add(barcode);


                        k = k + 1;


                        n = n + 1;


@@ -1030,6 +1128,14 @@


            string HInnerBillNo = "";


            bool HGiveAwayFlag = false;


            Int64 HEntryID = 0;




            string HCoilNO2 = "";


            string HFurnaceNO2 = "";


            string HFactory2 = "";


            decimal HAuxQty2 = 0;


            string HheatNO2 = "";


            DateTime HProduceDate;


            DateTime HExpiryDate;


            try


            {


                oCN.BeginTran();


@@ -1074,6 +1180,14 @@


                        HSeOrderBillNo = ClsPub.isStrNull(ListRows[i].HSeOrderBillNo2);


                        HInnerBillNo = ClsPub.isStrNull(ListRows[i].HInnerBillNo2);


                        HGiveAwayFlag = ClsPub.isBool(ListRows[i].HGiveAwayFlag2);




                        HCoilNO2 = ClsPub.isStrNull(ListRows[i].HCoilNO);


                        HFurnaceNO2 = ClsPub.isStrNull(ListRows[i].HFurnaceNO);


                        HFactory2 = ClsPub.isStrNull(ListRows[i].HFactory);


                        HAuxQty2 = ClsPub.isLong(ListRows[i].HAuxQty);


                        HheatNO2 = ClsPub.isStrNull(ListRows[i].HheatNO);


                        HProduceDate = ClsPub.isDate(ListRows[i].HProduceDate);


                        HExpiryDate = ClsPub.isDate(ListRows[i].HExpiryDate);


                        oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +


                                    ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +


                                    ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +


@@ -1081,7 +1195,8 @@


                                    ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " +


                                    ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +


                                    ",HGiveAwayFlag " +


                                    ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " +


                                    ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo" +


                                    ",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate " +


                                    ") values ("


                                    + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()


                                    + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString()


@@ -1090,7 +1205,7 @@


                                    + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + sDate + "'"


                                    + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString() + "," + HEntryID.ToString() + ""


                                    + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag)


                                    + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "')");


                                    + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "','" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'" + ")");






                        //HNumber = ClsPub.isStrNull(grdSub.Rows[i].Cells[HMaterID2Col].Value);


@@ -1125,6 +1240,23 @@


                //增加 æ¡ç è¶…过未生成功能控制




                //






                //条码生成时同步生成条码出入库记录


                if (HSourceBillTypeName.Trim() == "生产入库单" || HSourceBillTypeName.Trim() == "采购入库单"


                    || HSourceBillTypeName.Trim() == "销售退货单" || HSourceBillTypeName.Trim() == "生产退料单")


                {


                    if (!oWebs.set_BarCodeAutoWMS(HInterID, HSourceBillType, HOrgID, ref DBUtility.ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo;


                        objJsonResult.data = null;


                        objJsonResult.list = null;


                        return objJsonResult;


                    }


                }




                oCN.Commit();


                List<Object> listobj = ListRows.ConvertAll(s => (object)s);//List实体类转换为object


                //获取生成的条码信息