protected void Page_Load(object sender, System.EventArgs e)
        {
            this.gridHelper = new GridHelper(this.gridItem2Route);

            //Laws Lu,2006/09/26 获取产品
            if (Request.QueryString["ItemCode"] != null)
            {
                ItemCode = Request.QueryString["ItemCode"].Trim();
                txtItemCodeQuery.Text = ItemCode;
            }
            moFac = new FacadeFactory(base.DataProvider).CreateMOFacade();
            Domain.MOModel.DefaultItem2Route dItem2Route = null;

            object objOld = moFac.GetDefaultItem2Route(ItemCode);

            this.gridHelper.BuildGridRowhandle   = new BuildGridRowDelegate(this.GetGridRow);
            this.gridHelper.GetRowCountHandle    = new GetRowCountDelegate(this.GetRowCount);
            this.gridHelper.LoadDataSourceHandle = new LoadDataSourceDelegate(this.LoadDataSource);

            if (!this.IsPostBack)
            {
                this.InitWebGrid();

                this.InitPageLanguage(this.languageComponent1, false);

                this.cmdQuery_ServerClick(null, null);
            }

            if (objOld != null)
            {
                dItem2Route = objOld as Domain.MOModel.DefaultItem2Route;
            }
            if (dItem2Route != null)
            {
                lblDefaultRoute.Text = languageComponent1.GetString("$Current_Default_Route ") + dItem2Route.RouteCode;
            }

            if (!this.Page.IsStartupScriptRegistered("SelectableTextBox_Startup_js"))
            {
                string scriptString = string.Format("<script>var STB_Virtual_Path = \"{0}\";</script><script src='{0}SelectQuery/selectableTextBox.js'></script>", this.VirtualHostRoot);

                this.Page.RegisterStartupScript("SelectableTextBox_Startup_js", scriptString);
            }
        }
示例#2
0
        private int GetRowCount()
        {
            if (_modelFacade == null)
            {
                _modelFacade = new SMTFacadeFactory(base.DataProvider).CreateMOFacade();
            }
//			return this._modelFacade.QueryMOIllegibilityCount(
//				FormatHelper.PKCapitalFormat( FormatHelper.CleanString( this.txtMoCodeQuery.Text )),
//				FormatHelper.PKCapitalFormat( FormatHelper.CleanString( this.txtItemCodeQuery.Text )),
//				string.Empty,
//				FormatHelper.CleanString( this.drpMoStatusQuery.SelectedValue ),
//				string.Empty,string.Empty);

            return(this._modelFacade.QueryMOIllegibilityCount(
                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text)),
                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)),
                       string.Empty,
                       this.getSelectMOStatus(),
                       string.Empty, string.Empty));
        }
示例#3
0
        protected void cmdSave_ServerClick(object sender, System.EventArgs e)
        {
            if (txtMOCodeEdit.Enabled == true && FormatHelper.CleanString(this.txtMOCodeEdit.Text) == string.Empty)
            {
                throw new Exception("$CS_MO_NotExit");
            }

            if (facade == null)
            {
                facade = new BenQGuru.eMES.SelectQuery.SPFacade(base.DataProvider);
            }
            BenQGuru.eMES.Material.WarehouseFacade _facade = new BenQGuru.eMES.Material.WarehouseFacade(this.facade.DataProvider);
            ArrayList list = new ArrayList();

            for (int i = 0; i < this.gridSelected.Rows.Count; i++)
            {
                if (IsDecimal(this.gridSelected.Rows[i].Cells[3].Text) && decimal.Parse(this.gridSelected.Rows[i].Cells[3].Text) != 0)
                {
                    WarehouseTicketDetail item = _facade.CreateNewWarehouseTicketDetail();
                    item.TicketNo     = this.GetRequestParam("ticketno");
                    item.ItemCode     = this.gridSelected.Rows[i].Cells[1].Text;
                    item.ItemName     = this.gridSelected.Rows[i].Cells[2].Text;
                    item.MOCode       = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOCodeEdit.Text));
                    item.Qty          = decimal.Parse(this.gridSelected.Rows[i].Cells[3].Text);
                    item.ActualQty    = 0;
                    item.MaintainUser = this.GetUserCode();
                    list.Add(item);
                }
            }
            if (FormatHelper.CleanString(this.txtMOCodeEdit.Text) != string.Empty)
            {
                BenQGuru.eMES.MOModel.MOFacade  mof = new BenQGuru.eMES.MOModel.MOFacade(this.facade.DataProvider);
                BenQGuru.eMES.Domain.MOModel.MO mo  = (BenQGuru.eMES.Domain.MOModel.MO)mof.GetMO(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOCodeEdit.Text)));
                if (mo == null || (mo.MOStatus != MOManufactureStatus.MOSTATUS_RELEASE && mo.MOStatus != MOManufactureStatus.MOSTATUS_OPEN && mo.MOStatus != MOManufactureStatus.MOSTATUS_PENDING))
                {
                    throw new Exception("$CS_MO_NotExit");
                }
            }
            _facade.AddWarehouseTicketDetail(list);
            this.Page.RegisterStartupScript("close window", "<script language='javascript'>CloseWindow();</script>");
        }
示例#4
0
        private object[] LoadDataSource(int inclusive, int exclusive)
        {
            if (_modelFacade == null)
            {
                _modelFacade = new SMTFacadeFactory(base.DataProvider).CreateMOFacade();
            }
//			return this._modelFacade.QueryMOIllegibility(
//				FormatHelper.PKCapitalFormat( FormatHelper.CleanString( this.txtMoCodeQuery.Text )),
//				FormatHelper.PKCapitalFormat( FormatHelper.CleanString( this.txtItemCodeQuery.Text )),
//				string.Empty,
//				FormatHelper.CleanString( this.drpMoStatusQuery.SelectedValue ),
//				string.Empty,string.Empty,
//				inclusive, exclusive );
            return(this._modelFacade.QueryMOIllegibility(
                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text)),
                       FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)),
                       string.Empty,
                       this.getSelectMOStatus(),
                       string.Empty, string.Empty,
                       inclusive, exclusive));
        }
示例#5
0
 private void txtMOCodeQuery_TxtboxKeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
 {
     if (e.KeyChar == '\r')
     {
         if (this.checkedMOCode != this.txtMOCodeQuery.Value.Trim().ToUpper())
         {
             this.txtMOCodeQuery.Value = this.txtMOCodeQuery.Value.Trim().ToUpper();
             BenQGuru.eMES.MOModel.MOFacade moFacade = new BenQGuru.eMES.MOModel.MOFacade(this.DataProvider);
             MO mo = (MO)moFacade.GetMO(this.txtMOCodeQuery.Value);
             if (mo == null)
             {
                 ApplicationRun.GetInfoForm().Add(new UserControl.Message(MessageType.Error, "$CS_MO_Not_Exist"));
                 //Application.DoEvents();
                 this.txtMOCodeQuery.TextFocus(true, true);
                 return;
             }
             this.txtItemCodeQuery.Value = mo.ItemCode;
             this.checkedMOCode          = this.txtMOCodeQuery.Value;
         }
         //Application.DoEvents();
         this.txtSSCodeQuery.TextFocus(false, true);
     }
 }
示例#6
0
        //获取比对结果
        private void GetCompareDate()
        {
            Hashtable _compareHT = new Hashtable();

            //TODO 此处调用查询方法
            if (facade == null)
            {
                facade = new FacadeFactory(base.DataProvider).CreateMOFacade();
            }

            //获取工单标注BOM
            object[] MOStandardBoms = facade.GetMOBOM(this.MOCode);

            #region 测试 比对


            //
            //			MOBOM StandardmoBom0 = new MOBOM();
            //			StandardmoBom0.MOCode = "FFF-050718-05";
            //			StandardmoBom0.ItemCode = "GSM7503RD18";
            //			StandardmoBom0.MOBOMItemCode = "FKV8.074.967WE01";
            //			StandardmoBom0.MOBOMItemName = "子阶料0";
            //			StandardmoBom0.MOBOMItemQty = 1;
            //			StandardmoBom0.MOBOMItemUOM = "EA";
            //
            //			MOBOM StandardmoBom1 = new MOBOM();
            //			StandardmoBom1.MOCode = "FFF-050718-05";
            //			StandardmoBom1.ItemCode = "GSM7503RD18";
            //			StandardmoBom1.MOBOMItemCode = "FKV8.074.967RD01";
            //			StandardmoBom1.MOBOMItemName = "子阶料1";
            //			StandardmoBom1.MOBOMItemQty = 1;
            //			StandardmoBom1.MOBOMItemUOM = "EA";
            //
            //			MOBOM StandardmoBom2 = new MOBOM();
            //			StandardmoBom2.MOCode = "FFF-050718-05";
            //			StandardmoBom2.ItemCode = "GSM7503RD18";;
            //			StandardmoBom2.MOBOMItemCode = "FKV8.074.968WE01";
            //			StandardmoBom2.MOBOMItemName = "子阶料2";
            //			StandardmoBom2.MOBOMItemQty = 1;
            //			StandardmoBom2.MOBOMItemUOM = "EA";
            //
            //			//数量不对
            //			MOBOM StandardmoBom3 = new MOBOM();
            //			StandardmoBom3.MOCode = "FFF-050718-05";
            //			StandardmoBom3.ItemCode = "GSM7503RD18";;
            //			StandardmoBom3.MOBOMItemCode = "FKV8.074.966RD01";
            //			StandardmoBom3.MOBOMItemName = "子阶料3";
            //			StandardmoBom3.MOBOMItemQty = 5;
            //			StandardmoBom3.MOBOMItemUOM = "EA";
            //
            //			//只存在于MOBOM
            //			MOBOM StandardmoBom4 = new MOBOM();
            //			StandardmoBom4.MOCode = "FFF-050718-05";
            //			StandardmoBom4.ItemCode = "GSM7503RD18";;
            //			StandardmoBom4.MOBOMItemCode = "FKV8.074.968WW01";
            //			StandardmoBom4.MOBOMItemName = "子阶料w";
            //			StandardmoBom4.MOBOMItemQty = 1;
            //			StandardmoBom4.MOBOMItemUOM = "EA";
            //
            //			//获取工单标注BOM
            //			object[] MOStandardBoms = new object[]{StandardmoBom0,StandardmoBom1,StandardmoBom2,StandardmoBom3,StandardmoBom4};

            #endregion

            //获取比对结果
            _compareHT = facade.CompareMOBOM(MOStandardBoms, this.ItemCode, this.MOCode, this.RouteCode);

            //Test : 测试数据	显示
            #region  测试数据	显示

            //			ArrayList SucessResult = new ArrayList();
            //			MOBOM moBom = new MOBOM();
            //			moBom.MOCode = "工单123";
            //			moBom.ItemCode = "手机456";
            //			moBom.MOBOMItemCode = "YJ001";
            //			moBom.MOBOMItemName = "液晶面板001";
            //			moBom.MOBOMItemQty = 24;
            //			moBom.MOBOMItemUOM = "块";
            //			moBom.MOBOMException = "比对成功";
            //			SucessResult.Add(moBom);
            //
            //			ArrayList InMOStandardBOMResult = new ArrayList();
            //			MOBOM StandardmoBom = new MOBOM();
            //			StandardmoBom.MOCode = "工单123";
            //			StandardmoBom.ItemCode = "手机456";
            //			StandardmoBom.MOBOMItemCode = "YJ0099";
            //			StandardmoBom.MOBOMItemName = "液晶面板99";
            //			StandardmoBom.MOBOMItemQty = 29;
            //			StandardmoBom.MOBOMItemUOM = "块";
            //			StandardmoBom.MOBOMException = "比对失败 只存在于标准BOM";
            //			InMOStandardBOMResult.Add(StandardmoBom);
            //
            //			ArrayList InMORouteResult = new ArrayList();
            //			OPBOMDetail opBOM = new OPBOMDetail();
            //			opBOM.ItemCode = "手机456";
            //			opBOM.OPBOMItemCode = "YJ100";
            //			opBOM.OPBOMItemName = "液晶面板100";
            //			opBOM.OPBOMItemQty = 65;
            //			opBOM.OPBOMItemUOM = "块";
            //			opBOM.OPBOMSourceItemCode = "YJ1001";
            //			InMORouteResult.Add(opBOM);
            //
            //
            //			_compareHT["SucessResult"] = SucessResult;
            //			_compareHT["InMOStandardBOMResult"] = InMOStandardBOMResult;
            //			_compareHT["InMORouteResult"] = InMORouteResult;

            #endregion

            this.CompareHT       = _compareHT;
            Session["CompareHT"] = this.CompareHT;
        }
示例#7
0
        protected override void ImportData(Excel.Worksheet sheet, string[] strHeader)
        {
            DBDateTime       dbDateTime = FormatHelper.GetNowDBDateTime(ApplicationService.DataProvider);
            ImportDataEngine impEng     = new ImportDataEngine(ApplicationService.DataProvider, this.configObjList, this.configMatchType, ApplicationService.LoginUserCode, dbDateTime);

            impEng.ImportDataMapping = Properties.Settings.Default.DataMappingType;
            impEng.UpdateRepeatData  = Properties.Settings.Default.DataRepeat;
            ApplicationService.DataProvider.BeginTransaction();
            try
            {
                int iRow           = 2;
                int iImportedCount = 0;
                while (true)
                {
                    string[] strRow = ReadExcelRow(sheet, iRow, strHeader.Length);
                    if (strRow == null)
                    {
                        break;
                    }
                    // 导入产品
                    try
                    {
                        // 产品途程主资料
                        BenQGuru.eMES.MOModel.MOFacade   moFacade   = new BenQGuru.eMES.MOModel.MOFacade(ApplicationService.DataProvider);
                        BenQGuru.eMES.MOModel.ItemFacade itemFacade = new BenQGuru.eMES.MOModel.ItemFacade(ApplicationService.DataProvider);

                        BenQGuru.eMES.Domain.MOModel.Item2Route itemRoute = new BenQGuru.eMES.Domain.MOModel.Item2Route();
                        itemRoute.ItemCode       = strRow[0].Trim().ToUpper();
                        itemRoute.RouteCode      = strRow[1].Trim().ToUpper();
                        itemRoute.OrganizationID = int.Parse(strRow[2].Trim().ToUpper());
                        itemRoute.IsReference    = "0";
                        itemRoute.MaintainUser   = ApplicationService.LoginUserCode;
                        itemRoute.MaintainDate   = dbDateTime.DBDate;
                        itemRoute.MaintainTime   = dbDateTime.DBTime;

                        object ir = itemFacade.GetItem2Route(itemRoute.ItemCode, itemRoute.RouteCode, itemRoute.OrganizationID.ToString());
                        if (ir == null)
                        {
                            ApplicationService.DataProvider.Insert(itemRoute);
                        }
                        else
                        {
                            ApplicationService.DataProvider.Update(itemRoute);
                        }

                        // 产品默认途程
                        BenQGuru.eMES.Domain.MOModel.DefaultItem2Route defRoute = null;
                        BenQGuru.eMES.Domain.MOModel.DefaultItem2Route dr       = moFacade.GetDefaultItem2Route(itemRoute.ItemCode) as BenQGuru.eMES.Domain.MOModel.DefaultItem2Route;
                        if (dr != null)
                        {
                            defRoute = dr;
                        }
                        else
                        {
                            defRoute = new BenQGuru.eMES.Domain.MOModel.DefaultItem2Route();
                        }

                        defRoute.ItemCode = itemRoute.ItemCode;

                        if (strRow[3].Trim().ToUpper() == "YES")
                        {
                            defRoute.RouteCode = itemRoute.RouteCode;
                        }
                        if (defRoute.RouteCode != null && defRoute.RouteCode != "")
                        {
                            defRoute.MDate = dbDateTime.DBDate;
                            defRoute.MTime = dbDateTime.DBTime;

                            if (dr == null)
                            {
                                ApplicationService.DataProvider.Insert(defRoute);
                            }
                            else
                            {
                                ApplicationService.DataProvider.Update(defRoute);
                            }
                        }

                        // 产品途程工序列表

                        //将原来的删除
                        string strSql = string.Format("delete tblitemroute2op where itemcode = '{0}' and routecode='{1}' and orgid = {2}", itemRoute.ItemCode, itemRoute.RouteCode, itemRoute.OrganizationID.ToString());
                        ApplicationService.DataProvider.CustomExecute(new SQLCondition(strSql));

                        strSql  = "insert into tblitemroute2op (opid,routecode,opcode,opseq,opcontrol,idmergetype,idmergerule,muser,mdate,mtime,itemcode,orgid) ";
                        strSql += "select routecode||opcode||'{0}',routecode,opcode,opseq,opcontrol,'idmergetype_idmerge',1,muser,mdate,mtime,'{0}',{2} ";
                        strSql += "from tblroute2op where routecode='{1}' ";
                        strSql  = string.Format(strSql, itemRoute.ItemCode, itemRoute.RouteCode, itemRoute.OrganizationID.ToString());
                        ApplicationService.DataProvider.CustomExecute(new SQLCondition(strSql));
                        iImportedCount++;
                    }
                    catch (Exception ex)
                    {
                        string strResult = ex.Message;
                        if (strResult == "$DATA_REPEAT_CANCEL")      // 如果是重复数据,并设置终止
                        {
                            throw new Exception(strResult);
                        }
                        else if (strResult != "$Import_Unique_Data_Exist")  // $Import_Unique_Data_Exist表示重复数据,设置忽略
                        {
                            if (Properties.Settings.Default.DataError == ImportDataEngine.OnErrorDeal.Cancel)
                            {
                                throw new Exception(strResult);
                            }
                        }
                    }
                    iRow++;
                }
                ApplicationService.DataProvider.CommitTransaction();
                MessageBox.Show(UserControl.MutiLanguages.ParserMessage("$CycleImport_Success [" + iImportedCount.ToString() + "]"), this.MainForm.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                ApplicationService.DataProvider.RollbackTransaction();
                MessageBox.Show(UserControl.MutiLanguages.ParserMessage(ex.Message), this.MainForm.Text, MessageBoxButtons.OK, MessageBoxIcon.Stop);
            }
        }
示例#8
0
        protected override string[] FormatExportRecord(object obj)
        {
            /*
             * MOStock stock = (MOStock)obj;
             * string dNGRateManual, dNGRateFromItem, dWearOffRateTotal;
             * if (stock.IssueQty != 0)
             * {
             *      dNGRateManual = Math.Round(stock.ScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
             *      dNGRateFromItem = Math.Round((stock.ReturnScrapQty - stock.ScrapQty) / stock.IssueQty * 100, 2).ToString() + "%";
             *      dWearOffRateTotal = Math.Round(stock.ReturnScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
             * }
             * else
             * {
             *      dNGRateManual = dNGRateFromItem = dWearOffRateTotal = "0%";
             * }
             * string[] strArr =
             *      new string[]{	stock.MOCode,
             *                                      stock.ItemCode,
             *                                      GetItemName(stock.ItemCode),
             *                                      Math.Round(stock.ReceiptQty, 2).ToString(),
             *                                      Math.Round(stock.IssueQty, 2).ToString(),
             *                                      Math.Round(stock.ScrapQty, 2).ToString(),
             *                                      Math.Round(stock.ReturnQty, 2).ToString(),
             *                                      Math.Round(stock.ReturnScrapQty, 2).ToString(),
             *                                      Math.Round(stock.ReceiptQty - stock.IssueQty - stock.ReturnQty - stock.ReturnScrapQty, 2).ToString(),
             *                                      dNGRateManual,
             *                                      dNGRateFromItem,
             *                                      dWearOffRateTotal
             *                              };
             * stock = null;
             * return strArr;
             */
            MOStock stock = (MOStock)obj;
            string  dNGRateManual, dNGRateFromItem, dWearOffRateTotal;


            string dMOWasteRate = "0%";                 //工单损耗率
            string dMOScrapRate = "0%";;                //工单报废率

            #region 工单损耗率,工单报废率 不显示不计算

            //			decimal wasteRate = 0;
            //			decimal scrapRate = 0;
            //			if(stock.MOLoadingQty !=0 && (stock.MOLoadingQty + stock.TSLoadingQty) != 0 )
            //			if(stock.MOStatus == BenQGuru.eMES.Web.Helper.MOManufactureStatus.MOSTATUS_CLOSE)
            //			{
            //					wasteRate = (stock.ScrapQty + stock.TSUnCompletedQty) / stock.MOLoadingQty;
            //					scrapRate = (stock.ScrapQty + stock.TSUnCompletedQty) / (stock.MOLoadingQty + stock.TSLoadingQty);
            //			}
            //			else
            //			{
            //				wasteRate = stock.ScrapQty/ stock.MOLoadingQty;
            //				scrapRate = stock.ScrapQty / (stock.MOLoadingQty + stock.TSLoadingQty);
            //			}
            //			if(wasteRate != 0)
            //			{
            //				dMOWasteRate = wasteRate.ToString("##.##%");
            //			}
            //			if(scrapRate != 0)
            //			{
            //				dMOScrapRate = scrapRate.ToString("##.##%");
            //			}

            #endregion

            if (stock.IssueQty != 0)
            {
                dNGRateManual     = Math.Round(stock.ScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
                dNGRateFromItem   = Math.Round((stock.ReturnScrapQty - stock.ScrapQty) / stock.IssueQty * 100, 2).ToString() + "%";
                dWearOffRateTotal = Math.Round(stock.ReturnScrapQty / stock.IssueQty * 100, 2).ToString() + "%";
            }
            else
            {
                dNGRateManual = dNGRateFromItem = dWearOffRateTotal = "0%";
            }


            //
            if (htMOList == null)
            {
                htMOList = new Hashtable();
            }
            if (htMOList.Contains(stock.MOCode) == false)
            {
                if (moFacade == null)
                {
                    moFacade = new BenQGuru.eMES.MOModel.MOFacade(this.DataProvider);
                }
                Domain.MOModel.MO mo = (Domain.MOModel.MO)moFacade.GetMO(stock.MOCode);
                if (sbomFacade == null)
                {
                    sbomFacade = new BenQGuru.eMES.MOModel.SBOMFacade(this.DataProvider);
                }
                object[] objsBom  = sbomFacade.Query(mo.ItemCode);
                object[] objValue = new object[] { mo, objsBom };
                htMOList.Add(stock.MOCode, objValue);
            }
            object[]          objMOValue       = (object[])htMOList[stock.MOCode];
            Domain.MOModel.MO moValue          = (Domain.MOModel.MO)objMOValue[0];
            string            strMOQty         = Convert.ToInt32(moValue.MOPlanQty).ToString();
            object[]          objMOBom         = (object[])objMOValue[1];
            string            strMOMaterialQty = "0";
            if (objMOBom != null)
            {
                for (int i = 0; i < objMOBom.Length; i++)
                {
                    Domain.MOModel.SBOM sbom = (Domain.MOModel.SBOM)objMOBom[i];
                    if (sbom.SBOMItemCode == stock.ItemCode)
                    {
                        strMOMaterialQty = Math.Round(moValue.MOPlanQty * sbom.SBOMItemQty, 2).ToString();
                        break;
                    }
                }
            }
            string strDiffMaterialQty = "0";
            try
            {
                decimal dTmp = Convert.ToDecimal(strMOMaterialQty) - stock.ReceiptQty + stock.ReturnScrapQty + stock.ReturnQty;
                strDiffMaterialQty = Math.Round(dTmp, 2).ToString();
            }
            catch {}
            string strMemoQty = this.GetMemoQty(stock.MOCode, stock.ItemCode);
            //
            string[] row =
                new string[] {
                stock.MOCode,
                stock.ItemCode,
                GetItemName(stock.ItemCode),
                strMOQty,
                strMOMaterialQty,
                Math.Round(stock.ReceiptQty, 2).ToString(),
                strDiffMaterialQty,
                Math.Round(stock.IssueQty, 2).ToString(),
                Math.Round(stock.ScrapQty, 2).ToString(),
                Math.Round(stock.ReturnQty, 2).ToString(),
                Math.Round(stock.ReturnScrapQty, 2).ToString(),
                Math.Round(stock.ReceiptQty - stock.IssueQty - stock.ReturnQty - stock.ReturnScrapQty, 2).ToString(),
                strMemoQty,
                ""
            };
            stock = null;
            return(row);
        }