public string[] ConfirmPick_Zj(string warehouseCode, string orderCode, string orgcode, string org_warehouseid, string storageCode, string palletCode, string invCode, string orderbID, string StockID, string erp_orderbID, string produceDate, string expiryDate, string produceNum, string producenum_In, string producenum_Pro, string producenum_supplier, string property_def4, string property_def5, string property_def6, string property_def7, string property_def8, string property_def9, string property_def10, string boxCode, string num, string billtype, string operatorCode, string DBNo, string CustCode, string custtype, string ownercode, string ownertype, string scantype)
        {
            string[] result_0 = new string[2];

            decimal picknum = 0;

            string ordernum = string.Empty;

            string ctrPallet = string.Empty;

            List<string> sqltxts = new List<string>();

            //判断对应的单据是否有废弃申请,如果有就阻止提交
            string sqltxt = "select ordercode from impl_so_order_cancle where ordercode = '" + orderCode + "' and warehousecode='" + warehouseCode + "' and flag !='X'";

            string[,] result_query = api._QueryData(sqltxt, DBNo);

            if (result_query[0, 0] == "0")
            {
                //生成待上架
                sqltxt = "insert into WH_INSTOCK (pick_id,pickcode,mergecode,warehouseCode,storagecode,storagetype,invCode,num,dodate," + "operatorcode,Status,producenum,producedate,expirydate,qualitydaynum,ownerCode,ownertype,palletcode,receipttype,orgcode,org_warehouseid,inbatch," + pf.getCustomCol() + ",receiptid) " +
                    "select b.id,ordercode,ordercode,warehouseCode,b.storagecode,'',b.invCode,num,dbo.getdatetime('date'),'','0',producenum,producedate,expirydate,datediff(day,'',''),ownerCode,ownertype,'','f',orgcode,org_warehouseid,'' inbatch," + pf.GetCustomColInitValue("") + ",b.id from wh_short_pick b where ordercode='" + orderCode + "' and flag='0'";

                sqltxts.Add(sqltxt);

                //废弃拣选明细
                sqltxt = "update wh_short_pick set flag='X' where ordercode='" + orderCode + "' and warehousecode='" + warehouseCode + "'";

                sqltxts.Add(sqltxt);

                //将废弃申请改为生效
                /*sqltxt = "update impl_so_order_cancle set flag='Y',dodate=dbo.getdatetime('date'),dotime=dbo.getdatetime('time') where ordercode='" + result_query[1, 0] + "' and isnull(flag,'N')='N'";

                sqltxts.Add(sqltxt);*/

                var res = api.ExecSQLS(sqltxts.ToArray(), DBNo);

                if (res[0] == "0")
                {
                    result_0[0] = "B";

                    result_0[1] = "该订单已经废弃,系统已自动划零,请将已拣选商品做【还架】操作";

                    return result_0;
                }
                else
                {
                    result_0[0] = "-1";

                    result_0[1] = "提交失败,请重试";

                    api.InLog("直接拣选提交", res[1], operatorCode, DBNo);

                    return result_0;
                }

            }
            else if (result_query[0, 0] == "-1")
            {
                result_0[0] = "-1";

                result_0[1] = "查询订单废弃信息出错,请重试";



                return result_0;
            }

            PubFunction pb = new PubFunction();

            //返回值 商品编码/是否启用箱码/条码类型/是否启用批次码管理/明细ID/箱码数量
            var result = pb.getInvProduceInfo(warehouseCode, invCode, DBNo);

            if (result[2] == "Y")
            {
                if (boxCode == string.Empty)
                {
                    result_0[0] = "1";

                    result_0[1] = "商品启用箱码管理,箱码不能为空,请检查";

                    return result_0;
                }
            }

            if (result[1] == "Y")
            {
                if (property_def9 == string.Empty)
                {
                    result_0[0] = "1";

                    result_0[1] = "商品启用批次管理,批次码不能为空,请检查";

                    return result_0;
                }
            }

            sqltxt = "select isnull(SUM(num),0) from wh_short_pick where ordercode ='" + orderCode + "' and orderbid = '" + orderbID + "' and warehousecode = '" + warehouseCode + "'";

            string[,] re = api._QueryData(sqltxt, DBNo);

            if (re[0, 0] == "0")
            {
                picknum = decimal.Parse(re[1, 0]);
            }
            else
            {
                result_0[0] = "-1";

                result_0[1] = "提交失败";

                api.InLog("直接拣选提交，获取产品已拣选数量失败", "错误信息:\r\n" + re[0, 1] + "\r\nsql语句:" + sqltxt, operatorCode, DBNo);

                return result_0;
            }

            sqltxt = "select isnull(SUM(ordernum),0),property_def10,(select custtype from so_order_h where ordercode='" + orderCode + "') from so_order_b where ordercode ='" + orderCode + "' and invcode = '" + invCode + "' and id=" + orderbID + " group by property_def10";

            re = api._QueryData(sqltxt, DBNo);

            if (re[0, 0] == "0")
            {
                ordernum = re[1, 0];

                property_def10 = re[1, 1];

                custtype = re[1, 2];
            }
            else if (re[0, 0] == "1")
            {
                result_0[0] = "1";

                result_0[1] = "订单中不包含此商品";

                return result_0;
            }
            else
            {
                result_0[0] = "-1";

                result_0[1] = "提交失败";

                api.InLog("直接拣选提交，获取订单数量失败", "错误信息:\r\n" + re[0, 1] + "\r\nsql语句:" + sqltxt, operatorCode, DBNo);

                return result_0;
            }

            string IsExcess = "N";

            string ExcessRate = "1";

            decimal package = 1;

            /*sqltxt = "select isnull(isexcess,'0'),isnull(excessrate,0),dbo.getpackage(warehousecode,invcode,'') from bd_inventory_property where invcode='" + invCode + "' and warehousecode='" + warehouseCode + "'";

            re = api._QueryData(sqltxt, DBNo);

            if (re[0, 0] == "0")
            {
                IsExcess = re[1, 0];

                ExcessRate = re[1, 1];

                package = Convert.ToDecimal(re[1, 2]);
            }
            else if (re[0, 0] == "1")
            {
                result_0[0] = "1";

                result_0[1] = "该商品未维护物流属性";

                return result_0;
            }
            else
            {
                result_0[0] = "-1";

                result_0[1] = "提交失败";

                api.InLog("直接拣选提交，获取超发标志失败失败", "错误信息:\r\n" + re[0, 1] + "\r\nsql语句:" + sqltxt, operatorCode, DBNo);

                return result_0;
            }*/

            //校验本次拣选的数量是否在订单数量+超发数量范围内
            result_0 = CheckNum_new(picknum, ordernum, num, IsExcess, ExcessRate);

            if (result_0[0] != "0")
            {
                return result_0;
            }



            //判断箱码库存等于本次提交数量,则是整箱出库


            // sqltxt = "select (select isnull(ctrPallet,'')  from bd_storageinfo where storagecode='" + storageCode + "')from bd_inventory_property where invcode='" + invCode + "' and warehousecode='" + warehouseCode + "'";

            string ispiece = "";

            sqltxt = "select isnull(ctrPallet,''),isnull(ispiece,'0')  from bd_storageinfo where storagecode='" + storageCode + "'";

            re = api._QueryData(sqltxt, DBNo);

            if (re[0, 0] == "0")
            {
                ctrPallet = re[1, 0];

                ispiece = re[1, 1];

                if (ispiece == "0")//整装区
                {
                    if (Convert.ToDecimal(num) % package != 0)
                    {
                        result_0[0] = "1";

                        result_0[1] = "整装区出库,数量必须是包装的倍数,请检查";

                        return result_0;
                    }
                }
            }
            else if (re[0, 0] == "1")
            {
                result_0[0] = "1";

                result_0[1] = "该商品未维护物流属性";

                return result_0;
            }
            else
            {
                result_0[0] = "-1";

                result_0[1] = "提交失败";

                api.InLog("直接拣选提交，获取超发标志失败失败", "错误信息:\r\n" + re[0, 1] + "\r\nsql语句:" + sqltxt, operatorCode, DBNo);

                return result_0;
            }

            string sqlwhere = string.Empty;

            if (produceDate != string.Empty)
            {
                sqlwhere += " and isnull(producedate,'')='" + produceDate + "'";
            }
            if (expiryDate != string.Empty)
            {
                sqlwhere += " and isnull(expirydate,'')='" + expiryDate + "'";
            }
            if (produceNum != string.Empty)
            {
                sqlwhere += " and isnull(producenum,'')='" + produceNum + "'";
            }

            if (producenum_In != string.Empty)
            {
                sqlwhere += " and isnull(producenum_In,'')='" + producenum_In + "'";
            }
            if (producenum_Pro != string.Empty)
            {
                sqlwhere += " and isnull(producenum_Pro,'')='" + producenum_Pro + "'";
            }
            if (producenum_supplier != string.Empty)
            {
                sqlwhere += " and isnull(producenum_supplier,'')='" + producenum_supplier + "'";
            }
            if (property_def4 != string.Empty)
            {
                sqlwhere += " and isnull(property_def4,'')='" + property_def4 + "'";
            }
            if (property_def5 != string.Empty)
            {
                sqlwhere += " and isnull(property_def5,'')='" + property_def5 + "'";
            }
            if (property_def6 != string.Empty)
            {
                sqlwhere += " and isnull(property_def6,'')='" + property_def6 + "'";
            }
            if (property_def7 != string.Empty)
            {
                sqlwhere += " and isnull(property_def7,'')='" + property_def7 + "'";
            }
            if (property_def8 != string.Empty)
            {
                sqlwhere += " and isnull(property_def8,'')='" + property_def8 + "'";
            }
            if (property_def9 != string.Empty)
            {
                sqlwhere += " and isnull(property_def9,'')='" + property_def9 + "'";
            }
            if (property_def10 != string.Empty)
            {
                sqlwhere += " and isnull(property_def10,'')='" + property_def10 + "'";
            }


            //校检库存是否足够
            sqltxt = "select a.id from WH_STOCK a Where a.invcode='" + invCode + "' and a.id = " + StockID + " and (a.num-a.tasknum-isnull(freezenum,0)) >= " + num + sqlwhere + " and ownercode='" + ownercode + "' and ownertype='" + ownertype + "'";

            re = api._QueryData(sqltxt, DBNo);

            if (re[0, 0] == "1")
            {
                result_0[0] = "1";

                result_0[1] = "库存信息不存在或数量不足,请检查";

                api.InLog("任务拣选提交", sqltxt, "", DBNo);

                return result_0;
            }
            else if (re[0, 0] == "-1")
            {
                result_0[0] = "-1";

                result_0[1] = "提交失败";

                api.InLog("直接拣选提交，检测拣选库位是否有足够的库存失败", "错误信息:\r\n" + re[0, 1] + "\r\nsql语句:" + sqltxt, operatorCode, DBNo);

                return result_0;
            }

            string palletStockID = string.Empty;

            if (ctrPallet == "Y" || result[2] == "Y")//库位管托盘,要判断托盘库存是否足够
            {
                sqltxt = "select a.id from WH_STOCK_pallet a Where a.invcode='" + invCode + "' and a.stockid = " + StockID + " and (a.num-isnull(freezenum,0)) >= " + num + " and palletcode='" + palletCode + "'" + sqlwhere + " and ownercode='" + ownercode + "' and ownertype='" + ownertype + "' and isnull(boxcode,'')='" + boxCode + "'";

                re = api._QueryData(sqltxt, DBNo);

                if (re[0, 0] == "0")
                {
                    palletStockID = re[1, 0];
                }
                else if (re[0, 0] == "1")
                {
                    result_0[0] = "1";

                    result_0[1] = "托盘库存信息不存在或数量不足,请检查";

                    return result_0;
                }
                else if (re[0, 0] == "-1")
                {
                    result_0[0] = "-1";

                    result_0[1] = "提交失败";

                    api.InLog("直接拣选提交，检测拣选库位是否有足够的库存失败", "错误信息:\r\n" + re[0, 1] + "\r\nsql语句:" + sqltxt, operatorCode, DBNo);

                    return result_0;
                }
            }

            //写入拣选记录
            //此处的拣选记录是每次拣选加一条，没有update，需要记录每次拣选的信息。
            sqltxt = "insert into wh_short_pick(ordercode,erp_orderbid,num,producedate,expirydate,producenum,orgcode,org_warehouseid,flag,orderbID,invcode,doman,dodate,dotime,storagecode,palletcode,warehousecode,areacode,billtype,custcode,custtype,ownercode,ownertype,stockid,stockid_pallet,boxcode," + pf.getCustomCol() + ",scantype)"
                   + " values('" + orderCode + "','" + erp_orderbID + "'," + num + ",'" + produceDate + "','" + expiryDate + "','" + produceNum + "','" + orgcode + "','" + org_warehouseid + "',0,'" + orderbID + "','" + invCode + "','" + operatorCode + "',convert(varchar(10),getdate(),120),convert(varchar(10),getdate(),24),'" + storageCode + "','" + palletCode + "','" + warehouseCode + "',dbo.GetAreaCodeByStorageCode('" + storageCode + "','" + warehouseCode + "')," + "'" + billtype + "','" + CustCode + "','" + custtype + "','" + ownercode + "','" + ownertype + "','" + StockID + "','" + palletStockID + "','" + boxCode + "','" + producenum_In + "', '" + producenum_Pro + "', '" + producenum_supplier + "', '" + property_def4 + "', '" + property_def5 + "', '" + property_def6 + "', '" + property_def7 + "', '" + property_def8 + "', '" + property_def9 + "', '" + property_def10 + "','" + scantype + "')";

            sqltxts.Add(sqltxt);

            sqltxt = "update WH_STOCK set num = num - " + num + " Where id = " + StockID;

            sqltxts.Add(sqltxt);

            sqltxt = pf.GetStockChangeSQL(-decimal.Parse(num), orderbID, orderCode, StockID, ClsStatus.TaskBillType.zjPick, "0");

            sqltxts.Add(sqltxt);

            if (ctrPallet == "Y")
            {
                sqltxt = "insert into wh_stock_pallet_changeinfo( stockID,ystockID,ownercode,ownertype,orgcode,warehousecode,storagecode,palletcode,inbatch,invcode,ynum,cnum,producedate,expirydate,"
                  + " producenum,taskid,type,DODATE,dotime,org_warehouseid,ordercode,boxcode," + pf.getCustomCol() + ") "
                  + " select id,stockID,ownercode,ownertype,orgcode,warehousecode ,storagecode ,palletcode ,inbatch ,invcode ,0,-" + num + ",producedate,expirydate ,producenum,"
                  + "'" + orderbID + "','" + ClsStatus.TaskBillType.zjPick + "',CONVERT(varchar(10),GETDATE(),120),CONVERT(varchar(10),GETDATE(),8),org_warehouseid,'" + orderCode + "',boxcode," + pf.GetCustomColGroupBy("") + " from wh_stock_pallet where ID  = " + palletStockID;

                sqltxts.Add(sqltxt);

                sqltxt = "update WH_STOCK_Pallet set num = num - " + num + " Where id = " + palletStockID + " and palletcode='" + palletCode + "'";

                sqltxts.Add(sqltxt);

                /*sqltxt = pf.GetStockPalletChangeSQL(-decimal.Parse(num), orderbID, orderCode, palletStockID, ClsStatus.TaskBillType.zjPick, "0");

                sqltxts.Add(sqltxt);*/

                //0库存的插入备份表
                sqltxt = "insert into wh_stock_pallet_backup(ID ,stockID ,warehousecode ,orgcode ,org_warehouseid ,storagecode ,palletcode ,invcode ,num ,inbatch ,producedate ,expirydate ,producenum ,producenum_In ,producenum_Pro ,producenum_supplier ,ownertype ,ownercode  ,freezenum ,freezetype ,freezedetail ,property_def4 ,property_def5 ,property_def6 ,property_def7 ,property_def8 ,property_def9 ,property_def10,dodate,dotime,boxcode ) SELECT ID ,stockID ,warehousecode ,orgcode ,org_warehouseid ,storagecode ,palletcode ,invcode ,num ,inbatch ,producedate ,expirydate ,producenum ,producenum_In ,producenum_Pro ,producenum_supplier ,ownertype ,ownercode  ,freezenum ,freezetype ,freezedetail ,property_def4 ,property_def5 ,property_def6 ,property_def7 ,property_def8 ,property_def9 ,property_def10 ,dbo.getdatetime('date') ,dbo.getdatetime('time'),boxcode from wh_stock_pallet where id =" + palletStockID + " and num=0";

                sqltxts.Add(sqltxt);

                //如果库位托盘没有托盘库存了,就释放该托盘
                sqltxt = "update BD_PALLETINFO set useflag ='0' Where  palletcode = '" + palletCode + "' and palletcode not in (select palletcode from wh_stock_pallet where palletcode ='" + palletCode + "' and num>0 and warehousecode='" + warehouseCode + "')";

                sqltxts.Add(sqltxt);

                //删除0库存库位托盘
                sqltxt = "delete from wh_stock_pallet where id =" + palletStockID + " and num=0";

                sqltxts.Add(sqltxt);
            }

            string[] reX = api.ExecSQLS(sqltxts.ToArray(), DBNo);

            if (reX[0] != "0")
            {
                result_0[0] = "-1";

                result_0[1] = "提交失败,请重试";

                api.InLog("直接拣选提交，获取超发标志失败失败", "错误信息:\r\n" + reX[1] + "\r\nsql语句:" + sqltxt, operatorCode, DBNo);

                return result_0;
            }
            else
            {
                //检查下是否还有任务,没有就返回A
                sqltxt = "select a.id from so_order_b a,BD_INVENTORYINFO b where a.invcode = b.invcode and a.ordercode  ='" + orderCode + "' and (a.ordernum-a.outnum-(select isnull(SUM(num),0) from wh_short_pick where orderbID =a.ID and flag =0))>0";

                string[,] res_sql = api._QueryData(sqltxt, DBNo);

                if (res_sql[0, 0] == "1")
                {
                    result_0[0] = "A";

                    result_0[1] = "单据已经拣选完成,是否整单确认?";

                    return result_0;
                }
                else if (res_sql[0, 0] == "-1")
                {
                    result_0[0] = "-1";

                    result_0[1] = "校验任务信息失败,请重试" + res_sql[0, 1];

                    return result_0;
                }
                else if (res_sql[0, 0] == "0")
                {
                    sqltxt = "select cast((select isnull(SUM(num),0) from wh_short_pick where orderbID =a.ID and flag =0) as float) AS picknum, cast(((select isnull(SUM(num),0) from wh_short_pick where orderbID =a.ID and flag =0))/dbo.getpackage((select warehousecode from so_order_h where ordercode = a.ordercode),a.invcode,property_def10) as float) AS picknumber from so_order_b a where ordercode='" + orderCode + "' and id=" + orderbID;

                    string[,] result_query_99 = api._QueryData(sqltxt, DBNo);

                    if (result_query_99[0, 0] == "0")
                    {
                        result_0 = new string[3];

                        result_0[0] = "0";

                        result_0[1] = result_query_99[1, 0];

                        result_0[2] = result_query_99[1, 1];

                        return result_0;
                    }
                    else if (result_query_99[0, 0] == "1")
                    {
                        result_0 = new string[3];

                        result_0[0] = "0";

                        result_0[1] = "0";

                        result_0[2] = "0";

                        return result_0;
                    }
                    else if (result_query_99[0, 0] == "-1")
                    {
                        result_0 = new string[3];

                        result_0[0] = "-1";

                        result_0[1] = "0";

                        result_0[2] = "0";

                        api.InLog("查询已拣选数量", result_query[0, 1], "", DBNo);

                        return result_0;
                    }

                    result_0 = new string[3];

                    result_0[0] = "0";

                    result_0[1] = res_sql[1, 0];

                    result_0[2] = res_sql[1, 1];

                    return result_0;
                }

                result_0[0] = "0";

                result_0[1] = "操作成功";
            }

            return result_0;
        }