using Opsoft.Data; using Opsoft.NetCore.O3App.Domain.UnitOfWork.WMS.Model; using Opsoft.NetCore.O3App.Shared; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Linq; using System.Net.Http; using System.Text; namespace Opsoft.NetCore.O3App.Repositories.WMS { /// /// WMS公共方法类 /// public static class APPWmsCommonFunc { static readonly List BaseLvl = new List { 0, 1, 2, 3, 4, 5, 6 }; static readonly int LvlC0 = 7; static readonly string Upward = "↑"; static readonly string Downward = "↓"; static readonly string AllSign = "*"; /// /// 计算库存 /// public static string CalculateInventory(APPServerContext context, string orgID, List> myInBillList, bool isPlus, ref List exeSqlList) { string retMess = string.Empty, retSQL = string.Empty; //按物料基本信息汇总数量 var inventoryBill = myInBillList.GroupBy(o => new { o.FUSEFULDATE, o.FSTOCKSTATUSID, o.FKEEPERTYPEID, o.FKEEPERID, o.FOWNERTYPEID, o.FOWNERID, o.FMATERIALID, o.FITEMNUMBER, o.FUNITID, o.FBASEUNITID, o.FSECUNITID, o.FSTOCKID, o.FSTOCKLOCID, o.FKFDATE, o.FLOT, o.FAUXPROPID }).Select(p => new BarCodeMsg() { FUSEFULDATE = p.Key.FUSEFULDATE, FSTOCKSTATUSID = p.Key.FSTOCKSTATUSID, FKEEPERTYPEID = p.Key.FKEEPERTYPEID, FKEEPERID = p.Key.FKEEPERID, FOWNERTYPEID = p.Key.FOWNERTYPEID, FOWNERID = p.Key.FOWNERID, FMATERIALID = p.Key.FMATERIALID, FITEMNUMBER = p.Key.FITEMNUMBER, FUNITID = p.Key.FUNITID, FBASEUNITID = p.Key.FBASEUNITID, FSECUNITID = p.Key.FSECUNITID, FSTOCKID = p.Key.FSTOCKID, FSTOCKLOCID = p.Key.FSTOCKLOCID, FKFDATE = p.Key.FKFDATE, FLOT = p.Key.FLOT, FAUXPROPID = p.Key.FAUXPROPID, FQTY = p.Sum(z => z.FQTY), FBASEQTY = p.Sum(z => z.FBASEQTY), FSECUNITQTY = p.Sum(z => z.FSECUNITQTY) }).ToList(); //获取系统配置 Hashtable PBCursor = context.PBValue("FIsUseInventory,L,;"); //是否使用ERP的库存 bool FIsUseInventory = PBCursor["FIsUseInventory"].ToBoolean(); foreach (var sub in inventoryBill) { //库存值 STKInventoryValue inventoryValue = new STKInventoryValue(); inventoryValue.orgID = orgID; inventoryValue.KeeperType = sub.FKEEPERTYPEID; inventoryValue.KeeperID = sub.FKEEPERID; inventoryValue.OwnType = sub.FOWNERTYPEID; inventoryValue.OwerID = sub.FOWNERID; inventoryValue.MaterialID = sub.FMATERIALID; inventoryValue.StockID = sub.FSTOCKID; inventoryValue.StockPlaceID = sub.FSTOCKLOCID; inventoryValue.StockStatusID = sub.FSTOCKSTATUSID; inventoryValue.Lot = sub.FLOT; inventoryValue.AuxPropID = sub.FAUXPROPID; inventoryValue.KFDate = sub.FKFDATE; inventoryValue.UsefulDate = sub.FUSEFULDATE; inventoryValue.SupplyID = string.Empty; inventoryValue.BaseUnitID = sub.FBASEUNITID; inventoryValue.SecUnitID = sub.FSECUNITID; inventoryValue.BaseQty = isPlus ? sub.FBASEQTY : -sub.FBASEQTY; inventoryValue.SecUnitQty = sub.FSECUNITQTY; //库存控制点 STKInventoryControl inventoryControl = new STKInventoryControl(); inventoryControl.ControlStockQty = true; inventoryControl.IsVirtual = false; inventoryControl.FIsUseInventory = FIsUseInventory; retMess = CheckBill.UpdateInventoryQty( context, inventoryValue, inventoryControl, out retSQL ); if (!retMess.IsNullOrWhiteSpace()) { return retMess; } else if (!FIsUseInventory) { exeSqlList.Add(retSQL); } } return retMess; } /// /// 获取抽样数量、AC、RE /// /// /// 水平 /// aql /// /// public static InspectionRuleValueModel GetInspectionRule(APPServerContext context, int lvl, string aql, int inspectionQty) { InspectionRuleValueModel resultValue = new InspectionRuleValueModel(); if (inspectionQty == 1) { resultValue.SampleSize = 1; resultValue.AC = 0; resultValue.RE = 1; } else if (BaseLvl.Contains(lvl)) { DataTable dtGB2828SizeCode = context.Database.SqlQuery(" SELECT * FROM T_BD_GB2828SAMPLESIZECODE ORDER BY FRANGESTART"); DataTable dtGB2828Plan = context.Database.SqlQuery(" SELECT * FROM T_BD_GB2828SAMPLINGPLAN ORDER BY FNUMBER"); DataRow fitSizeCodeRow = dtGB2828SizeCode.AsEnumerable().FirstOrDefault(o => o["FRANGESTART"].ToInt() <= inspectionQty && inspectionQty <= o["FRANGEEND"].ToInt()); string sizeCode = string.Empty; switch (lvl) { case 0: sizeCode = fitSizeCodeRow["FGENERALLEVELONE"].ToString(); break; case 1: sizeCode = fitSizeCodeRow["FGENERALLEVELTWO"].ToString(); break; case 2: sizeCode = fitSizeCodeRow["FGENERALLEVELTHR"].ToString(); break; case 3: sizeCode = fitSizeCodeRow["FSPECIALLEVELSONE"].ToString(); break; case 4: sizeCode = fitSizeCodeRow["FSPECIALLEVELSTWO"].ToString(); break; case 5: sizeCode = fitSizeCodeRow["FSPECIALLEVELSTHR"].ToString(); break; case 6: sizeCode = fitSizeCodeRow["FSPECIALLEVELSFOU"].ToString(); break; } string columnName = string.Empty; switch (aql) { case "0.01ACRE": case "0.01": columnName = "FACREZEROPOINTZEROONE"; break; case "0.015ACRE": case "0.015": columnName = "FACREZEROPOINTZEROONEFIV"; break; case "0.025ACRE": case "0.025": columnName = "FACREZEROPOINTZEROTWOFIV"; break; case "0.04ACRE": case "0.04": columnName = "FACREZEROPOINTZEROFOU"; break; case "0.065ACRE": case "0.065": columnName = "FACREZEROPOINTZEROFOUFIV"; break; case "0.1ACRE": case "0.1": columnName = "FACREZEROPOINTONE"; break; case "0.15ACRE": case "0.15": columnName = "FACREZEROPOINTONEFIV"; break; case "0.25ACRE": case "0.25": columnName = "FACREZEROPOINTTWOFIV"; break; case "0.4ACRE": case "0.4": columnName = "FACREZEROPOINTFOU"; break; case "0.65ACRE": case "0.65": columnName = "FACREZEROPOINTSIXFIV"; break; case "1.0ACRE": case "1.0": columnName = "FACREONE"; break; case "1.5ACRE": case "1.5": columnName = "FACREONEPOINTFIV"; break; case "2.5ACRE": case "2.5": columnName = "FACRETWOPOINTFIV"; break; case "4.0ACRE": case "4.0": columnName = "FACREFOUPOINT"; break; case "6.5ACRE": case "6.5": columnName = "FACRESIXPOINTFIV"; break; case "10ACRE": case "10": columnName = "FACRETEN"; break; case "15ACRE": case "15": columnName = "FACREFIVTEEN"; break; case "25ACRE": case "25": columnName = "FACRETWFIV"; break; case "40ACRE": case "40": columnName = "FACREFOUTY"; break; case "65ACRE": case "65": columnName = "FACRESIXTYFIV"; break; case "100ACRE": case "100": columnName = "FACREHUNDRED"; break; case "150ACRE": case "150": columnName = "FACREONEHUNDREDFIVTY"; break; case "250ACRE": case "250": columnName = "FACRETWOHUNDREDFIVTY"; break; case "400ACRE": case "400": columnName = "FACREFOUHUNDRED"; break; case "650ACRE": case "650": columnName = "FACRESIXHUNDREDFIVTY"; break; case "1000ACRE": case "1000": columnName = "FACREONETHOUSAND"; break; default: break; } var fitRow = dtGB2828Plan.AsEnumerable().FirstOrDefault(p => p["FNUMBER"].ToString().Equals(sizeCode)); int fitRowNum = dtGB2828Plan.Rows.IndexOf(fitRow); var fitRowValue = fitRow[columnName].ToString(); while (fitRowValue.Equals(Upward) || fitRowValue.Equals(Downward)) { if (fitRowValue.Equals(Upward)) { fitRowNum--; } else if (fitRowValue.Equals(Downward)) { fitRowNum++; } fitRowValue = dtGB2828Plan.Rows[fitRowNum][columnName].ToString(); } resultValue.SampleSize = dtGB2828Plan.Rows[fitRowNum]["FSAMPLESIZE"].ToInt(); if (resultValue.SampleSize > inspectionQty) { resultValue.SampleSize = inspectionQty; } var acreArr = fitRowValue.Split(' '); if (acreArr.Length != 2) { throw new Exception($"第{fitRowNum + 1}行【{columnName}】列的GB2828抽样水平配置有问题"); } resultValue.AC = acreArr[0].ToInt(); resultValue.RE = acreArr[1].ToInt(); } else if (lvl == LvlC0) { DataTable dtC0Plan = context.Database.SqlQuery(" SELECT * FROM T_DB_C0SAMPLINGPLAN ORDER BY FNUMBER"); DataRow fitSizeCodeRow = dtC0Plan.AsEnumerable().FirstOrDefault(o => o["FSTART"].ToInt() <= inspectionQty && inspectionQty <= o["FEND"].ToInt()); string columnName = string.Empty; switch (aql) { case "0.01": columnName = "FZEROPOINTZEROONE"; break; case "0.015": columnName = "FZEROPOINTZEROONEFIVE"; break; case "0.025": columnName = "FZEROPOINTZEROTWOFIVE"; break; case "0.04": columnName = "FZEROPOINTZEROFOUR"; break; case "0.065": columnName = "FZEROPOINTZEROSIXFIVE"; break; case "0.1": columnName = "FZEROPOINTONE"; break; case "0.15": columnName = "FZEROPOINTONEFIVE"; break; case "0.25": columnName = "FZEROPOINTTWOFIVE"; break; case "0.4": columnName = "FZEROPOINTFOUR"; break; case "0.65": columnName = "FZEROPOINTSIXFIVE"; break; case "1.0": columnName = "FONE"; break; case "1.5": columnName = "FONEPOINTFIV"; break; case "2.5": columnName = "FTWOPOINTFIV"; break; case "4.0": columnName = "FFOUPOINT"; break; case "6.5": columnName = "FSIXPOINTFIV"; break; case "10": columnName = "FTEN"; break; default: break; } var sampleSize = fitSizeCodeRow[columnName]; if (sampleSize.ToStringEx().Equals(AllSign) || sampleSize.ToInt() > inspectionQty) { resultValue.SampleSize = inspectionQty; } else { resultValue.SampleSize = sampleSize.ToInt(); } resultValue.AC = 0; resultValue.RE = 1; } return resultValue; } /// /// 提交到ERP,调用api接口实现 /// /// /// /// /// public static ToERPResult SubmitToERP(string DBAias, string tranType, List needNowSyn) { ToERPResult erpResult = null; string result = string.Empty; using (HttpClient httpClient = new HttpClient()) { SubmitData submitData = new SubmitData { DBAias = DBAias, FSrcFormID = tranType, FinteridKeys = needNowSyn }; var content = new StringContent(JsonOperator.JsonSerialize(submitData), Encoding.UTF8, "application/json"); string tempUrl = GetCompleteUrl()+ "/SaveERP/SubmitToERP"; //string tempUrl = "http://localhost:44330/SubmitToERP"; HttpResponseMessage response = httpClient.PostAsync(tempUrl, content).Result; if (response.IsSuccessStatusCode) { result = response.Content.ReadAsStringAsync().Result; return JsonOperator.JsonDeserialize(result); } else { return new ToERPResult { ExecuteResult = false, Message = response.ReasonPhrase }; } } } /// /// 判断条码库存状态是否满足条件 /// /// 表单名 /// 库存状态类型 /// 可使用 /// 不可销售 /// 不可领用 /// public static bool CkeckFStockStatusId(string tranType, string statusType, bool available, bool notSale,bool notGet, out string msg) { //库存状态类型:0=可用,1=待检,2=冻结,3=退回冻结,4=在途,5=收货冻结,6=废品,7=不良,8=不参与核算 bool isOk = true; msg = ""; //库存状态【可使用】时,则不受限制使用。 if (!available) { if (statusType == "2" || statusType == "3" || statusType == "4" || statusType == "5") { switch (tranType.ToUpper()) { case "PRD_PICKMTRL"://生产领料 case "SAL_OUTSTOCK"://销售出库 case "SAL_OUTSTOCK_SUIT"://销售出库(套件) case "STK_MISDELIVERY": //其他出库 case "STK_OEMOUTSTOCK"://受托加工材料出库 case "STK_OEMPICK"://受托加工领料 case "SUB_PICKMTRL"://委外领料 case "SP_PICKMTRL"://简单生产领料 case "STK_TRANSFERMANAGE"://调拨管理 msg = "冻结/在途状态下,不允许出库!"; isOk = false; break; } } else { if (notSale) { //不可销售 switch (tranType.ToUpper()) { case "SAL_OUTSTOCK"://销售出库 case "SAL_OUTSTOCK_SUIT"://销售出库(套件) msg = "此库存状态下,不允许销售出库!"; isOk = false; break; } } if (notGet) { //不可领用 switch (tranType.ToUpper()) { case "PRD_PICKMTRL"://生产领料 case "STK_OEMPICK"://受托加工领料 case "SUB_PICKMTRL"://委外领料 case "SP_PICKMTRL"://简单生产领料 msg = "此库存状态下,不允许领用!"; isOk = false; break; } } } } return isOk; } /// /// 获取当前请求完整的Url地址 /// /// private static string GetCompleteUrl() { string urlBase = new StringBuilder() .Append(HttpContextConfig.Current.Request.Scheme) .Append("://") .Append(HttpContextConfig.Current.Request.Host) .Append(HttpContextConfig.Current.Request.PathBase) .ToString(); if (urlBase.ToUpperEx().Contains("ODKV60")) { return urlBase.Substring(0, urlBase.LastIndexOf('/')); } else { return urlBase; } } #region 更新即时库存(库存转换单据用) /// /// 更新即时库存 /// /// 数据源 /// 模式:1=增加,2=减少 /// 返回信息 /// public static string UpdateStkInventoryByConvertBill(APPServerContext context, List dataSource,string stockOrgId, int mode, out List strSQL) { try { #region 获取【是否使用ERP的库存】系统参数 //获取系统配置 Hashtable PBCursor = context.PBValue("FIsUseInventory,L,;"); //是否使用ERP的库存 bool FIsUseInventory = PBCursor["FIsUseInventory"].ToBoolean(); strSQL = new List(); #endregion foreach (var updateInventory in dataSource) { #region 基本信息检查 if (updateInventory.FMATERIALID.IsNullOrEmpty()) { return "存在物料为空的行,请检查!"; } if (updateInventory.FSTOCKID.IsNullOrEmpty() || updateInventory.FSTOCKID.ToStringEx() == "0") { return "存在仓库为空的行,请检查!"; } if (updateInventory.FSTOCKSTATUSID.IsNullOrEmpty()) { return "存在库存状态为空的行,请检查!"; } if (updateInventory.FOWNERID.IsNullOrEmpty()) { return "存在货主为空的行,请检查!"; } if (updateInventory.FKEEPERID.IsNullOrEmpty()) { return "存在保管者为空的行,请检查!"; } #endregion #region 查询Sql拼接 var querySqlStr = $@"SELECT T01.FINTERID, T01.FBASEUNITQTY, T02.FNAME AS FSTOCKNAME, T03.FNUMBER AS FSTOCKLOCNUMBER FROM T_STK_INVENTORY T01 LEFT JOIN T_BD_STOCK T02 ON T02.FINTERID=T01.FSTOCKID LEFT JOIN T_BAS_FLEXVALUESDETAIL T03 ON T03.FINTERID=T01.FSTOCKLOCID WHERE T01.FSTOCKORGID = '{stockOrgId}' "; //物料 querySqlStr += $" AND FMATERIALID='{updateInventory.FMATERIALID.ToStringEx()}'"; //库存状态 querySqlStr += $" AND FSTOCKSTATUSID='{(mode == 2 ? updateInventory.FSTOCKSTATUSID.ToStringEx() : "KCZT03_SYS")}'"; //仓库 querySqlStr += $" AND FSTOCKID='{updateInventory.FSTOCKID.ToStringEx()}'"; //货主 querySqlStr += $" AND FOWNERID='{updateInventory.FOWNERID.ToStringEx()}'"; //保管者 querySqlStr += $" AND FKEEPERID='{updateInventory.FKEEPERID.ToStringEx()}'"; if (!updateInventory.FLOT.ToStringEx().IsNullOrEmpty()) { querySqlStr += $" AND FLOT='{updateInventory.FLOT.ToStringEx()}'"; } else { querySqlStr += " AND (FLOT='' OR FLOT IS NULL)"; } if (!updateInventory.FAUXPROPID.ToStringEx().IsNullOrEmpty()) { querySqlStr += $" AND FAUXPROPID='{updateInventory.FAUXPROPID.ToStringEx()}'"; } else { querySqlStr += " AND (FAUXPROPID='' OR FAUXPROPID IS NULL)"; } if (!updateInventory.FSTOCKLOCID.ToStringEx().IsNullOrEmpty() && updateInventory.FSTOCKLOCID.ToStringEx() != "0") { querySqlStr += $" AND FSTOCKLOCID='{updateInventory.FSTOCKLOCID.ToStringEx()}'"; } else { querySqlStr += " AND (FSTOCKLOCID='' OR FSTOCKLOCID IS NULL OR FSTOCKLOCID='0')"; } if (!updateInventory.FKFDATE.IsNullOrEmpty()) { querySqlStr += $" AND FKFDATE='{updateInventory.FKFDATE.ToDateTime()}'"; } else { querySqlStr += " AND (FKFDATE='' OR FKFDATE IS NULL)"; } //有效期至判断 if (!updateInventory.FUSEFULDATE.IsNullOrEmpty()) { querySqlStr += $" AND FUSEFULDATE='{updateInventory.FUSEFULDATE.ToDateTime()}'"; } else { querySqlStr += " AND (FUSEFULDATE='' OR FUSEFULDATE IS NULL)"; } DataTable material = context.Database.SqlQuery($@"SELECT FISSECUNIT FROM T_BD_MATERIAL WHERE FINTERID='{updateInventory.FMATERIALID.ToStringEx()}'"); //辅助单位判断 if (material.Rows[0]["FISSECUNIT"].ToBoolean()) { if (!updateInventory.FSECUNITID.IsNullOrEmpty()) { querySqlStr += $" AND FSECUNITID='{updateInventory.FSECUNITID.ToStringEx()}'"; } else { querySqlStr += " AND (FSECUNITID='' OR FSECUNITID IS NULL)"; } } #endregion var inventoryTable = context.Database.SqlQuery(querySqlStr); var baseUnitId = updateInventory.FBASEUNITID.ToStringEx(); decimal baseQty = updateInventory.FBASEQTY.ToDecimal(); decimal inventoryQty = updateInventory.FQTY.ToDecimal(); switch (mode) { case 1: if (!FIsUseInventory) { if (!inventoryTable.IsNullOrEmpty() && inventoryTable.Rows.Count > 0) { var stock = inventoryTable.Rows[0]; strSQL.Add($@"UPDATE T_STK_INVENTORY SET FBASEUNITQTY=FBASEUNITQTY + {baseQty} {(material.Rows[0]["FISSECUNIT"].ToBoolean() ? $",FSECUNITQTY=FSECUNITQTY + {updateInventory.FSECUNITQTY.ToDecimal()}" : "")} ,FQTY=FQTY + {inventoryQty} WHERE FINTERID='{stock.Field("FINTERID")}'"); } else { #region 库存插入物料信息 string strInsert = @"INSERT INTO T_STK_INVENTORY ( UID, FINTERID, FMATERIALID, FSTOCKID, FSTOCKLOCID, FLOT, FAUXPROPID, FSTOCKUNITID, FBASEUNITID, FQTY, FBASEUNITQTY, FKEEPERTYPEID, FKEEPERID, FOWNERTYPEID, FOWNERID, FSTOCKORGID, FSTOCKSTATUSID, FCOMPANYID, M_YMD, M_USER"; if (material.Rows[0]["FISSECUNIT"].ToBoolean()) { strInsert += ",FSECUNITID"; strInsert += ",FSECUNITQTY"; } if (!updateInventory.FKFDATE.IsNullOrEmpty()) { strInsert += ",FKFDATE"; } if (!updateInventory.FUSEFULDATE.IsNullOrEmpty()) { strInsert += ",FUSEFULDATE"; } strInsert += $@") VALUES ( '{Guid.NewGuid()}', '{Guid.NewGuid()}', '{updateInventory.FMATERIALID.ToStringEx()}', '{updateInventory.FSTOCKID.ToStringEx()}', '{updateInventory.FSTOCKLOCID.ToStringEx()}', '{updateInventory.FLOT.ToStringEx()}', '{updateInventory.FAUXPROPID.ToStringEx()}', '{updateInventory.FUNITID.ToStringEx()}', '{baseUnitId}', {inventoryQty}, {baseQty}, '{"ORG_Organizations"}', '{stockOrgId}', '{"ORG_Organizations"}', '{stockOrgId}', '{stockOrgId}', '{"KCZT03_SYS"}', '{stockOrgId}', '{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}', '{context.UserID.Replace("'", "''")}' "; if (material.Rows[0]["FISSECUNIT"].ToBoolean()) { strInsert += $", '{updateInventory.FSECUNITID.ToStringEx()}"; strInsert += $", '{updateInventory.FSECUNITQTY.ToDecimal()}'"; } if (!updateInventory.FKFDATE.IsNullOrEmpty()) { strInsert += $", '{updateInventory.FKFDATE.ToDateTime()}'"; } if (!updateInventory.FUSEFULDATE.IsNullOrEmpty()) { strInsert += $", '{updateInventory.FUSEFULDATE.ToDateTime()}'"; } strInsert += ")"; #endregion strSQL.Add(strInsert); } } break; case 2: if (!inventoryTable.IsNullOrEmpty() && inventoryTable.Rows.Count > 0) { var stock = inventoryTable.Rows[0]; if (stock["FBASEUNITQTY"].ToDecimal() < baseQty) { return $"仓库[{stock["FSTOCKNAME"].ToStringEx()}]" + $"仓位[{stock["FSTOCKLOCNUMBER"].ToStringEx()}]" + $"批号[{updateInventory.FLOT.ToStringEx()}]" + $"辅助属性[{updateInventory.FAUXPROPNAME.ToStringEx()}]" + $"的物料[{updateInventory.FITEMNAME.ToStringEx()}]" + $"的出库基本单位量[{baseQty:0.######}]" + $"超过库存基本单位量[{stock["FBASEUNITQTY"].ToDecimal():0.######}]"; } if (!FIsUseInventory) { strSQL.Add($@"UPDATE T_STK_INVENTORY SET FBASEUNITQTY=FBASEUNITQTY - {baseQty} {(material.Rows[0]["FISSECUNIT"].ToBoolean() ? $",FSECUNITQTY=FSECUNITQTY - {updateInventory.FSECUNITQTY.ToDecimal()}" : "")} ,FQTY=FQTY - {inventoryQty} WHERE FINTERID='{stock["FINTERID"].ToStringEx()}'"); } } else { return $@"更新库存错误:物料[{updateInventory.FITEMNAME.ToStringEx()}] 库存状态[{updateInventory.FSTOCKSTATUSID.ToStringEx()}] 批号[{updateInventory.FLOT.ToStringEx()}] {(updateInventory.FKFDATE.ToStringEx() == "" ? $"保质期[{updateInventory.FKFDATE.ToDateTime().ToStringEx("yyyy-MM-dd")}]有效期至[{updateInventory.FUSEFULDATE.ToDateTime().ToStringEx("yyyy-MM-dd")}]" : "")} 对应的库存信息不存在"; } break; } } return ""; } catch (Exception e) { throw new Exception(e.Message, e); } } #endregion } }