示例#1
0
        public ActionResult DCW003Paging(CmnPagingModel cmnPagingModel)
        {
            DCW003ConditionModel         conditionModel     = base.GetCache <DCW003ConditionModel>(CacheKeys.DCW003_CONDITION);
            List <DCW003FuzokuhinMaster> lstFuzokuhinMaster = new List <DCW003FuzokuhinMaster>();
            string typeMsg  = string.Empty;
            string errorMsg = string.Empty;
            int    rowCount = 0;

            conditionModel.PageIndex = cmnPagingModel.PageIndex;
            conditionModel.PageSize  = cmnPagingModel.PageSize;
            conditionModel.PageBegin = cmnPagingModel.PageBegin;
            conditionModel.PageEnd   = cmnPagingModel.PageEnd;

            DCW003DetailModel    detailModel  = new DCW003DetailModel();
            List <DCW003Result>  resultModel  = new List <DCW003Result>();
            List <DCW003Uketori> uketoriModel = new List <DCW003Uketori>();

            using (DCW003Services services = new DCW003Services())
            {
                lstFuzokuhinMaster         = services.DCW003GetFuzokuhinMaster();
                ViewBag.DocFuzokuhinMaster = lstFuzokuhinMaster;

                services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
            }

            detailModel.ResultModel  = resultModel;
            detailModel.UketoriModel = uketoriModel;
            base.SaveCache(CacheKeys.DCW003_CONDITION, conditionModel);
            InitialDropDownList();
            ViewBag.SearchCondition = conditionModel;
            return(View("_DCW003Result", detailModel));
        }
示例#2
0
        public ActionResult DCW003Search(DCW003ConditionModel conditionModel)
        {
            List <DCW003FuzokuhinMaster> lstFuzokuhinMaster = new List <DCW003FuzokuhinMaster>();

            string typeMsg    = string.Empty;
            string contentMsg = string.Empty;
            int    rowCount   = 0;

            conditionModel.PageIndex = DCW003Constant.DEFAULT_PAGE_INDEX;
            conditionModel.PageSize  = DCW003Constant.DEFAULT_PAGE_SIZE;
            DCW003DetailModel    detailModel  = new DCW003DetailModel();
            List <DCW003Result>  resultModel  = new List <DCW003Result>();
            List <DCW003Uketori> uketoriModel = new List <DCW003Uketori>();

            using (DCW003Services services = new DCW003Services())
            {
                lstFuzokuhinMaster         = services.DCW003GetFuzokuhinMaster();
                ViewBag.DocFuzokuhinMaster = lstFuzokuhinMaster;

                services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
                if (resultModel.Count == 0)
                {
                    UtilityServices.Utility.GetMessage("I0003",
                                                       string.Empty,
                                                       out typeMsg,
                                                       out contentMsg);

                    this.ViewBag.typeMsgI0001    = typeMsg;
                    this.ViewBag.contentMsgI0001 = contentMsg;
                }
            }
            if (conditionModel == null)
            {
                conditionModel.PageIndex = DCW003Constant.DEFAULT_PAGE_INDEX;
                conditionModel.PageSize  = DCW003Constant.DEFAULT_PAGE_SIZE;
                conditionModel.TotalRow  = rowCount;
            }
            conditionModel.TotalRow = resultModel.Count != 0 ? resultModel[0].RowCount : 0;
            base.SaveCache(CacheKeys.DCW003_CONDITION, conditionModel);
            detailModel.ResultModel  = resultModel;
            detailModel.UketoriModel = uketoriModel;
            InitialDropDownList();
            ViewBag.SearchCondition = conditionModel;
            return(View("_DCW003Result", detailModel));
        }
示例#3
0
        private void InitialDropDownList()
        {
            List <DCW003DropDownModel> dropMassho    = new List <DCW003DropDownModel>();
            List <DCW003DropDownModel> dropJishamei  = new List <DCW003DropDownModel>();
            List <DCW003DropDownModel> dropDocStatus = new List <DCW003DropDownModel>();
            List <DCW003DropDownModel> dropYear      = new List <DCW003DropDownModel>();
            DCW003ConditionModel       cache         = base.GetCache <DCW003ConditionModel>(CacheKeys.DCW003_CONDITION);

            using (DCW003Services services = new DCW003Services())
            {
                dropDocStatus = services.DCW003GetMasterDocStatus();
                dropYear      = services.DCW003GetMasterYear();
            }
            //YEAR
            ViewBag.DropYear = dropYear;

            //DOC STATUS
            if (cache.ModeImport == 1 || cache.ModeImport == 2)
            {
                ViewBag.DropDocStatus = dropDocStatus;
            }
            else
            {
                dropDocStatus.RemoveAt(0);
                ViewBag.DropDocStatus = dropDocStatus;
            }
            //MASSHO
            dropMassho.Insert(0, new DCW003DropDownModel {
                Value = "0", Text = "継続"
            });
            dropMassho.Insert(1, new DCW003DropDownModel {
                Value = "1", Text = "抹消"
            });
            ViewBag.DropMassho = dropMassho;

            //JISHAMEI
            dropJishamei.Insert(0, new DCW003DropDownModel {
                Value = "0", Text = ""
            });
            dropJishamei.Insert(1, new DCW003DropDownModel {
                Value = "1", Text = "自社名済"
            });
            ViewBag.DropJishamei = dropJishamei;
        }
示例#4
0
        public ActionResult DCW003Index(int mode, int check)
        {
            string lstError        = string.Empty;
            string lstNoMap        = string.Empty;
            string lstImport       = string.Empty;
            string lstDocControlNo = string.Empty;
            string messageContent  = string.Empty;
            string messageType     = string.Empty;
            int    rowCount        = 0;

            DCW003Model          model          = new DCW003Model();
            DCW003ConditionModel conditionModel = new DCW003ConditionModel();
            DCW003DetailModel    detailModel    = new DCW003DetailModel();
            List <DCW003Uketori> uketoriModel   = new List <DCW003Uketori>();
            List <DCW003Result>  resultModel    = new List <DCW003Result>();
            DCW003ConditionModel cache          = base.GetCache <DCW003ConditionModel>(CacheKeys.DCW003_CONDITION);

            if (cache == null)
            {
                conditionModel.PageIndex   = DCW003Constant.DEFAULT_PAGE_INDEX;
                conditionModel.PageSize    = DCW003Constant.DEFAULT_PAGE_SIZE;
                conditionModel.KeiCarFlg0  = NUMBER.NUM_0;
                conditionModel.KeiCarFlg1  = NUMBER.NUM_0;
                conditionModel.JishameiFlg = NUMBER.NUM_0;
                conditionModel.MasshoFlg   = NUMBER.NUM_0;
                conditionModel.RadioType   = NUMBER.NUM_1;
            }
            else
            {
                conditionModel = cache;
                mode           = 0;
            }

            List <DCW003FuzokuhinMaster> lstFuzokuhinMaster = new List <DCW003FuzokuhinMaster>();

            using (DCW003Services services = new DCW003Services())
            {
                //Get label master fuzokuhin
                lstFuzokuhinMaster         = services.DCW003GetFuzokuhinMaster();
                ViewBag.DocFuzokuhinMaster = lstFuzokuhinMaster;

                switch (mode)
                {
                case 0:
                {
                    services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
                }
                break;

                //詳細条件で書類を検索する
                case 1:
                {
                    conditionModel.ShohinType           = DCW003Constant.SHOHIN_TYPE_DN;
                    conditionModel.DocStatus102         = 1;
                    conditionModel.AaDnSeiyakuDateStart = null;
                    conditionModel.AaDnSeiyakuDateEnd   = DateTime.Now.AddDays(-1);
                    ViewBag.Mode = 1;
                    services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
                }
                break;

                //本日発送予定の書類を検索する(普通車)
                case 2:
                {
                    conditionModel.ShohinType         = DCW003Constant.SHOHIN_TYPE_DN;
                    conditionModel.DocStatus102       = 1;
                    conditionModel.KeiCarFlg0         = NUMBER.NUM_1;
                    conditionModel.AaDnSeiyakuDateEnd = DateTime.Now.AddDays(-1);

                    services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
                }
                break;

                //本日発送予定の書類を検索する(軽)
                case 3:
                {
                    conditionModel.ShohinType         = DCW003Constant.SHOHIN_TYPE_DN;
                    conditionModel.DocStatus102       = 1;
                    conditionModel.KeiCarFlg1         = NUMBER.NUM_1;
                    conditionModel.AaDnSeiyakuDateEnd = DateTime.Now.AddDays(-1);

                    services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
                }
                break;

                //棚卸し
                case 5:
                {
                    conditionModel.DocStatus102 = 1;

                    services.DCW003Search(conditionModel, lstFuzokuhinMaster, out resultModel, out uketoriModel, out rowCount);
                }
                break;

                //Import 1
                case 6:
                {
                    List <DCW003CsvModel> lstCsv = new List <DCW003CsvModel>();
                    DataTable             tblCsv = (DataTable)TempData["tblCsv"];
                    if (tblCsv != null)
                    {
                        if (tblCsv.Rows.Count > 0)
                        {
                            for (int i = 0; i < tblCsv.Rows.Count; i++)
                            {
                                lstCsv.Add(new DCW003CsvModel
                                    {
                                        ID               = i,
                                        RacFileNo        = tblCsv.Rows[i][0].ToString(),
                                        KeiCarFlg        = tblCsv.Rows[i][1].ToString(),
                                        TorokuNo         = tblCsv.Rows[i][2].ToString(),
                                        HyobanType       = tblCsv.Rows[i][3].ToString(),
                                        ChassisNo        = tblCsv.Rows[i][4].ToString(),
                                        GendokiKatashiki = tblCsv.Rows[i][5].ToString(),
                                        ReportType       = tblCsv.Rows[i][6].ToString(),
                                    });
                            }
                            if (check == 0)
                            {
                                conditionModel.ModeImport = 1;
                                services.DCW003ImportCsv(lstCsv, out lstError, out lstNoMap, out lstImport, out lstDocControlNo);
                                Utility.GetMessage("I0010",
                                                   SubStringList(lstImport), SubStringList(lstError), SubStringList(lstNoMap),
                                                   out messageType,
                                                   out messageContent);
                                ViewBag.contentMsgI0010 = messageContent;
                                ViewBag.typeMsgI0010    = messageType;

                                if (!string.IsNullOrEmpty(lstDocControlNo))
                                {
                                    lstDocControlNo = lstDocControlNo.Substring(1);
                                    services.DCW003GetListImport(lstDocControlNo, lstFuzokuhinMaster, conditionModel.PageIndex, conditionModel.PageSize,
                                                                 out resultModel, out uketoriModel, out rowCount);
                                }
                            }
                            else
                            {
                                conditionModel.ModeImport = 2;
                                services.DCW003GetDocControlExist(lstCsv, lstFuzokuhinMaster, conditionModel.PageIndex, conditionModel.PageSize, 1,
                                                                  out resultModel, out uketoriModel, out lstImport, out rowCount);

                                Utility.GetMessage("I0010",
                                                   lstImport, string.Empty, string.Empty,
                                                   out messageType,
                                                   out messageContent);
                                ViewBag.contentMsgI0010 = messageContent;
                                ViewBag.typeMsgI0010    = messageType;
                            }
                        }
                        else
                        {
                            return(ReturnResult());
                        }
                    }
                }
                break;

                case 7:
                {
                    conditionModel.ModeImport = 3;
                    List <DCW003CsvModel> lstCsv = new List <DCW003CsvModel>();
                    DataTable             tblCsv = (DataTable)TempData["tblCsv"];
                    if (tblCsv != null)
                    {
                        if (tblCsv.Rows.Count > 0)
                        {
                            for (int i = 0; i < tblCsv.Rows.Count; i++)
                            {
                                lstCsv.Add(new DCW003CsvModel
                                    {
                                        ID               = i,
                                        KeiCarFlg        = tblCsv.Rows[i][0].ToString(),
                                        TorokuNo         = tblCsv.Rows[i][1].ToString(),
                                        HyobanType       = tblCsv.Rows[i][2].ToString(),
                                        ChassisNo        = tblCsv.Rows[i][3].ToString(),
                                        GendokiKatashiki = tblCsv.Rows[i][4].ToString(),
                                        ReportType       = tblCsv.Rows[i][5].ToString(),
                                    });
                            }

                            services.DCW003GetDocControlExist(lstCsv, lstFuzokuhinMaster, conditionModel.PageIndex, conditionModel.PageSize, 2,
                                                              out resultModel, out uketoriModel, out lstImport, out rowCount);
                        }
                    }
                }
                break;

                case 8:
                {
                    conditionModel.ModeImport = 3;
                    List <DCW003RFID> lstCsv = new List <DCW003RFID>();
                    DataTable         tblCsv = (DataTable)TempData["tblCsv"];
                    if (tblCsv != null)
                    {
                        if (tblCsv.Rows.Count > 0)
                        {
                            for (int i = 0; i < tblCsv.Rows.Count; i++)
                            {
                                lstCsv.Add(new DCW003RFID
                                    {
                                        ID      = i,
                                        RFIDKey = tblCsv.Rows[i][0].ToString(),
                                    });
                            }

                            resultModel = services.DCW003GetDocControlMaster(lstCsv, conditionModel.PageIndex, conditionModel.PageSize, out rowCount);
                        }
                    }
                }
                break;

                case 9:
                {
                    conditionModel.ModeImport = 4;
                    List <DCW003CsvModel> lstCsv = new List <DCW003CsvModel>();
                    DataTable             tblCsv = (DataTable)TempData["tblCsv"];
                    if (tblCsv != null)
                    {
                        if (tblCsv.Rows.Count > 0)
                        {
                            for (int i = 0; i < tblCsv.Rows.Count; i++)
                            {
                                if (tblCsv.Rows[i][5].ToString() == "自社名依頼")
                                {
                                    tblCsv.Rows[i][5] = "101";
                                }
                                else if (tblCsv.Rows[i][5].ToString() == "抹消依頼")
                                {
                                    tblCsv.Rows[i][5] = "201";
                                }
                                lstCsv.Add(new DCW003CsvModel
                                    {
                                        ID             = i,
                                        IraiDate       = tblCsv.Rows[i][0].ToString(),
                                        ShopCd         = tblCsv.Rows[i][1].ToString(),
                                        GenshaLocation = tblCsv.Rows[i][2].ToString(),
                                        CarName        = tblCsv.Rows[i][3].ToString(),
                                        ChassisNo      = tblCsv.Rows[i][4].ToString(),
                                        JMType         = tblCsv.Rows[i][5].ToString(),
                                        Note           = tblCsv.Rows[i][6].ToString(),
                                    });
                            }

                            services.DCW003GetDocControlExist(lstCsv, lstFuzokuhinMaster, conditionModel.PageIndex, conditionModel.PageSize, 3,
                                                              out resultModel, out uketoriModel, out lstImport, out rowCount);

                            if (resultModel.Count > 0)
                            {
                                services.DCWOO3InserJishameiMassho(resultModel, lstCsv);
                            }
                        }
                    }
                }
                break;
                }
            }

            conditionModel.TotalRow = resultModel.Count != 0 ? resultModel[0].RowCount: 0;
            if (conditionModel.TotalRow == 0 && mode != 6)
            {
                Utility.GetMessage(MessageCd.I0003, string.Empty, out messageType, out messageContent);
                ViewBag.typeMsgI0010    = messageType;
                ViewBag.contentMsgI0010 = messageContent;
            }
            detailModel.UketoriModel = uketoriModel;
            detailModel.ResultModel  = resultModel;
            model.Condition          = conditionModel;
            model.Detail             = detailModel;
            base.SaveCache(CacheKeys.DCW003_CONDITION, conditionModel);
            InitialDropDownList();

            ViewBag.SearchCondition = model.Condition;
            return(View(model));
        }
示例#5
0
        /// <summary>
        /// Search with condition
        /// </summary>
        /// <param name="condition"></param>
        /// <param name="lstFuzokuhinMaster"></param>
        /// <param name="lstResult"></param>
        /// <param name="lstUketori"></param>
        public void DCW003Search(DCW003ConditionModel condition, List <DCW003FuzokuhinMaster> lstFuzokuhinMaster,
                                 out List <DCW003Result> lstResult, out List <DCW003Uketori> lstUketori, out int rowCount)
        {
            if (condition.DocumentStocktaking.Equals(1))
            {
                condition.KeiCarFlg0 = NUMBER.NUM_0;
                condition.KeiCarFlg1 = NUMBER.NUM_0;
                condition.ShohinType = null;
            }
            if (condition.DocumentNomalCar.Equals(1) || condition.DocumentNotNomalCar.Equals(1))
            {
                condition.ShohinType   = DCW003Constant.SHOHIN_TYPE_DN;
                condition.RadioType    = NUMBER.NUM_1;
                condition.DocStatus102 = 1;
                if (condition.DocumentNomalCar.Equals(1))
                {
                    condition.KeiCarFlg0 = NUMBER.NUM_1;
                }
                if (condition.DocumentNotNomalCar.Equals(1))
                {
                    condition.KeiCarFlg1 = NUMBER.NUM_1;
                }
            }

            lstUketori = new List <DCW003Uketori>();
            if (!string.IsNullOrWhiteSpace(condition.ShuppinnTorokuNo))
            {
                condition.ShuppinnTorokuNo = condition.ShuppinnTorokuNo.Replace(Environment.NewLine, ",");
            }

            lstResult = da.DCW003SearchCondition(condition, out rowCount);

            if (lstResult.Count > 0)
            {
                List <string> lstDocControlNo = new List <string>();
                foreach (var item in lstResult)
                {
                    lstDocControlNo.Add(item.DocControlNo);
                }

                List <DCW003UketoriDetail> lstUketoriDetail = new List <DCW003UketoriDetail>();
                lstUketoriDetail = da.DCW003GetUketoriDetail(lstDocControlNo);

                List <DCW003UketoriDetail> lstUketoriDetailReset = new List <DCW003UketoriDetail>();
                lstUketoriDetailReset = ResetUketoriDetail(lstFuzokuhinMaster, lstDocControlNo);
                foreach (var item in lstUketoriDetailReset)
                {
                    foreach (var uketori in lstUketoriDetail)
                    {
                        if (uketori.DocControlNo == item.DocControlNo && uketori.DocFuzoKuhinCd == item.DocFuzoKuhinCd)
                        {
                            item.IsChecked = 1;
                            item.Note      = uketori.Note;
                        }
                    }
                }

                List <DCW003Uketori>       lstUketoriTemp = new List <DCW003Uketori>();
                List <DCW003UketoriDetail> lstUketoriDetailTemp;
                foreach (var item in lstResult)
                {
                    lstUketoriDetailTemp = new List <DCW003UketoriDetail>();
                    lstUketoriDetailTemp = lstUketoriDetailReset.Where(x => x.DocControlNo == item.DocControlNo).ToList();
                    lstUketoriTemp.Add(new DCW003Uketori
                    {
                        DocControlNo           = item.DocControlNo,
                        AaKaisaiDate           = item.AaKaisaiDate,
                        ChassisNo              = item.ChassisNo,
                        DnSeiyakuDate          = item.DnSeiyakuDate,
                        JishameiFlg            = item.JishameiFlg,
                        KeiCarFlg              = item.KeiCarFlg,
                        ShakenLimitDate        = item.ShakenLimitDate,
                        ShiireShuppinnTorokuNo = item.ShiireShuppinnTorokuNo,
                        ShoruiLimitDate        = item.ShoruiLimitDate,
                        TorokuNo = item.TorokuNo,
                        UriageShuppinnTorokuNo = item.UriageShuppinnTorokuNo,
                        MeihenShakenTorokuDate = item.MeihenShakenTorokuDate,
                        UketoriDetail          = lstUketoriDetailTemp
                    });
                }

                lstUketori = lstUketoriTemp;
            }
        }
示例#6
0
文件: DCW003Da.cs 项目: whoait/docol
        /// <summary>
        /// Search with condition
        /// </summary>
        /// <param name="searchConditions"></param>
        /// <returns></returns>
        public List <DCW003Result> DCW003SearchCondition(DCW003ConditionModel searchConditions, out int rowCount)
        {
            DataTable tblTorokuNo = new DataTable();

            tblTorokuNo.Columns.Add("TorokuNo", typeof(string));
            if (!string.IsNullOrWhiteSpace(searchConditions.ShuppinnTorokuNo))
            {
                string[] lstTorokuNo = searchConditions.ShuppinnTorokuNo.Split(',');
                foreach (var item in lstTorokuNo)
                {
                    if (!string.IsNullOrWhiteSpace(item))
                    {
                        if (item.Trim().Length <= 8)
                        {
                            DataRow row = tblTorokuNo.NewRow();
                            row["TorokuNo"] = item.Trim();
                            tblTorokuNo.Rows.Add(row);
                        }
                    }
                }
            }

            using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_SEARCH_CONDITION))
            {
                DbManager.Add(DWC003StoreName.PARAM_SHUPPINN_TOROKUNO, searchConditions.ShuppinnTorokuNo);
                DbManager.Add(DWC003StoreName.PARAM_LIST_TOROKU_NO, SqlDbType.Structured, tblTorokuNo);
                DbManager.Add(DWC003StoreName.PARAM_CHASSIS_NO, searchConditions.ChassisNo);
                DbManager.Add(DWC003StoreName.PARAM_RADIO_TYPE, searchConditions.RadioType);
                DbManager.Add(DWC003StoreName.PARAM_SHOHIN_TYPE, searchConditions.ShohinType);
                DbManager.Add(DWC003StoreName.PARAM_SHOP_CD, searchConditions.ShopCd);
                DbManager.Add(DWC003StoreName.PARAM_SHOP_NAME, searchConditions.ShopName);
                DbManager.Add(DWC003StoreName.PARAM_RAKUSATSU_SHOP_CD, searchConditions.RakusatsuShopCd);
                DbManager.Add(DWC003StoreName.PARAM_RAKUSATSU_SHOP_NAME, searchConditions.RakusatsuShopName);
                DbManager.Add(DWC003StoreName.PARAM_DOC_STATUS_102, searchConditions.DocStatus102);
                DbManager.Add(DWC003StoreName.PARAM_DOC_STATUS_103, searchConditions.DocStatus103);
                DbManager.Add(DWC003StoreName.PARAM_DOC_STATUS_104, searchConditions.DocStatus104);
                DbManager.Add(DWC003StoreName.PARAM_DOC_STATUS_105, searchConditions.DocStatus105);
                DbManager.Add(DWC003StoreName.PARAM_FILE_NO, searchConditions.FileNo);
                DbManager.Add(DWC003StoreName.PARAM_KEICAR_0_FLG, searchConditions.KeiCarFlg0);
                DbManager.Add(DWC003StoreName.PARAM_KEICAR_1_FLG, searchConditions.KeiCarFlg1);
                DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_FLG, searchConditions.JishameiFlg);
                DbManager.Add(DWC003StoreName.PARAM_MASSHO_FLG, searchConditions.MasshoFlg);
                DbManager.Add(DWC003StoreName.PARAM_AA_DN_DATE_START, searchConditions.AaDnSeiyakuDateStart);
                DbManager.Add(DWC003StoreName.PARAM_AA_DN_DATE_END, searchConditions.AaDnSeiyakuDateEnd);
                DbManager.Add(DWC003StoreName.PARAM_SHORUI_LIMIT_DATE_START, searchConditions.ShoruiLimitDateStart);
                DbManager.Add(DWC003StoreName.PARAM_SHORUI_LIMIT_DATE_END, searchConditions.ShoruiLimitDateEnd);
                DbManager.Add(DWC003StoreName.PARAM_DOC_NYUKO_DATE_START, searchConditions.DocNyukoDateStart);
                DbManager.Add(DWC003StoreName.PARAM_DOC_NYUKO_DATE_END, searchConditions.DocNyukoDateEnd);
                DbManager.Add(DWC003StoreName.PARAM_DOC_SHUKKO_DATE_START, searchConditions.DocShukkoDateStart);
                DbManager.Add(DWC003StoreName.PARAM_DOC_SHUKKO_DATE_END, searchConditions.DocShukkoDateEnd);
                DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_IRAI_SHUKKO_DATE_START, searchConditions.JishameiIraiShukkoDateStart);
                DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_IRAI_SHUKKO_DATE_END, searchConditions.JishameiIraiShukkoDateEnd);
                DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_KANRYO_NYUKO_DATE_START, searchConditions.JishameiKanryoNyukoDateStart);
                DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_KANRYO_NYUKO_DATE_END, searchConditions.JishameiKanryoNyukoDateEnd);
                DbManager.Add(DWC003StoreName.PARAM_MASSHO_IRAI_SHUKKO_DATE_START, searchConditions.MasshoIraiShukkoDateStart);
                DbManager.Add(DWC003StoreName.PARAM_MASSHO_IRAI_SHUKKO_DATE_END, searchConditions.MasshoIraiShukkoDateEnd);
                DbManager.Add(DWC003StoreName.PARAM_MASSHO_KANRYO_NYUKO_DATE_START, searchConditions.MasshoKanryoNyukoDateStart);
                DbManager.Add(DWC003StoreName.PARAM_MASSHO_KANRYO_NYUKO_DATE_END, searchConditions.MasshoKanryoNyukoDateEnd);
                DbManager.Add(DWC003StoreName.PARAM_SHAKEN_LIMIT_DATE_START, searchConditions.ShakenLimitDateStart);
                DbManager.Add(DWC003StoreName.PARAM_SHAKEN_LIMIT_DATE_END, searchConditions.ShakenLimitDateEnd);
                DbManager.Add(DWC003StoreName.PARAM_PAGE_INDEX, searchConditions.PageIndex);
                DbManager.Add(DWC003StoreName.PARAM_PAGE_SIZE, searchConditions.PageSize);

                DataTable tableResult = DbManager.GetDataTable();
                rowCount = tableResult.Rows.Count;

                return(Entities.EntityHelper <DCW003Result> .GetListObject(tableResult));
            }
        }
示例#7
0
        /// <summary>
        /// Search with condition
        /// </summary>
        /// <param name="condition"></param>
        /// <param name="lstFuzokuhinMaster"></param>
        /// <param name="lstResult"></param>
        /// <param name="lstUketori"></param>
        public void DCW003Search(DCW003ConditionModel condition, List <DCW003FuzokuhinMaster> lstFuzokuhinMaster,
                                 out List <DCW003Result> lstResult, out List <DCW003Uketori> lstUketori, out int rowCount)
        {
            if (condition.DocumentNomalCar.Equals(1) || condition.DocumentNotNomalCar.Equals(1))
            {
                if (condition.ShohinType == DCW003Constant.SHOHIN_TYPE_AA)
                {
                    condition.ShohinType = null;
                }
                else
                {
                    condition.ShohinType = DCW003Constant.SHOHIN_TYPE_DN;
                }

                condition.RadioType    = NUMBER.NUM_1;
                condition.DocStatus102 = 1;
                condition.Mode         = 2;
                if (condition.DocumentNomalCar.Equals(1))
                {
                    condition.KeiCarFlg0 = NUMBER.NUM_1;
                }
                if (condition.DocumentNotNomalCar.Equals(1))
                {
                    condition.KeiCarFlg1 = NUMBER.NUM_1;
                }
            }

            if (condition.DocumentStocktaking.Equals(1))
            {
                condition.DocStatus102 = 1;
                condition.Mode         = 4;
            }
            if ((condition.DocumentStocktaking.Equals(1) && condition.DocumentNomalCar.Equals(1)) || (condition.DocumentStocktaking.Equals(1) && condition.DocumentNotNomalCar.Equals(1)))
            {
                condition.Mode = 2;
            }

            if (condition.DocumentSrearchAA.Equals(1))
            {
                if (condition.ShohinType == DCW003Constant.SHOHIN_TYPE_DN)
                {
                    condition.ShohinType = null;
                }
                else
                {
                    if (condition.FlgSearchAADN.Equals(0))
                    {
                        condition.ShohinType = DCW003Constant.SHOHIN_TYPE_AA;
                    }
                    else
                    {
                        condition.ShohinType = null;
                    }
                }
                condition.DocStatus102 = 1;
                condition.Mode         = 4;
                if (condition.DocumentNomalCar.Equals(1) && condition.DocumentSrearchAA.Equals(1))
                {
                    condition.ShohinType = null;
                    condition.Mode       = 4;
                }
                if (condition.DocumentNotNomalCar.Equals(1) && condition.DocumentSrearchAA.Equals(1))
                {
                    condition.ShohinType = null;
                    condition.Mode       = 4;
                }
                if (condition.DocumentStocktaking.Equals(1) && condition.DocumentSrearchAA.Equals(1))
                {
                    condition.ShohinType = null;
                    condition.Mode       = 4;
                }
            }

            lstUketori = new List <DCW003Uketori>();
            if (!string.IsNullOrWhiteSpace(condition.ShuppinnTorokuNo))
            {
                condition.ShuppinnTorokuNo = condition.ShuppinnTorokuNo.Replace(Environment.NewLine, ",");
            }

            if (!string.IsNullOrWhiteSpace(condition.ChassisNo))
            {
                condition.ChassisNo = condition.ChassisNo.Replace(Environment.NewLine, ",");
            }

            lstResult = da.DCW003SearchCondition(condition, out rowCount);

            if (lstResult.Count > 0)
            {
                List <string> lstDocControlNo = new List <string>();
                foreach (var item in lstResult)
                {
                    lstDocControlNo.Add(item.DocControlNo);
                }

                List <DCW003UketoriDetail> lstUketoriDetail = new List <DCW003UketoriDetail>();
                lstUketoriDetail = da.DCW003GetUketoriDetail(lstDocControlNo);



                List <DCW003Result> lstDocNoHis = new List <DCW003Result>();

                //lstDocNoHis = da.GetDocNoHistory(lstDocControlNo);

                List <DCW003UketoriDetail> lstUketoriDetailReset = new List <DCW003UketoriDetail>();
                lstUketoriDetailReset = ResetUketoriDetail(lstFuzokuhinMaster, lstDocControlNo);
                foreach (var item in lstUketoriDetailReset)
                {
                    foreach (var uketori in lstUketoriDetail)
                    {
                        if (uketori.DocControlNo == item.DocControlNo && uketori.DocFuzoKuhinCd == item.DocFuzoKuhinCd)
                        {
                            if (uketori.HisUketoriDocControlNo == "1")
                            {
                                item.IsChecked = 1;
                                item.Note      = uketori.Note;
                                item.HisUketoriDocControlNo = uketori.HisUketoriDocControlNo;
                            }
                            else
                            {
                                item.Note = uketori.Note;
                                item.HisUketoriDocControlNo = uketori.HisUketoriDocControlNo;
                            }
                        }

                        else
                        {
                            item.HisUketoriDocControlNo = uketori.HisUketoriDocControlNo;
                        }
                    }
                }
                foreach (var item in lstUketoriDetailReset)
                {
                    foreach (var uketori in lstUketoriDetail)
                    {
                        if (uketori.HisUketoriDocControlNo == "1" && uketori.DocControlNo == item.DocControlNo)
                        {
                            item.HisUketoriDocControlNo = "1";
                        }
                    }
                    //if (a == 1) {

                    //}
                    //a = 0;
                }

                List <DCW003Uketori>       lstUketoriTemp = new List <DCW003Uketori>();
                List <DCW003UketoriDetail> lstUketoriDetailTemp;
                foreach (var item in lstResult)
                {
                    lstUketoriDetailTemp = new List <DCW003UketoriDetail>();
                    lstUketoriDetailTemp = lstUketoriDetailReset.Where(x => x.DocControlNo == item.DocControlNo).ToList();
                    lstUketoriTemp.Add(new DCW003Uketori
                    {
                        DocControlNo            = item.DocControlNo,
                        ShopCd                  = item.ShopCd,
                        DocNyukoDate            = item.DocNyukoDate,
                        AaKaisaiDate            = item.AaKaisaiDate,
                        ChassisNo               = item.ChassisNo,
                        DnSeiyakuDate           = item.DnSeiyakuDate,
                        JishameiFlg             = item.JishameiFlg,
                        KeiCarFlg               = item.KeiCarFlg,
                        ShakenLimitDate         = item.ShakenLimitDate,
                        ShiireShuppinnTorokuNo  = item.ShiireShuppinnTorokuNo,
                        ShoruiLimitDate         = item.ShoruiLimitDate,
                        TorokuNo                = item.TorokuNo,
                        MasshoFlg               = item.MasshoFlg,
                        UriageCancelFlg         = item.UriageCancelFlg,
                        ShiireCancelFlg         = item.ShiireCancelFlg,
                        CcName                  = item.CcName,
                        CarName                 = item.CarName,
                        JoshaTeiinNum           = item.JoshaTeiinNum,
                        JishameiKanryoNyukoDate = item.JishameiKanryoNyukoDate,
                        UriageShuppinnTorokuNo  = item.UriageShuppinnTorokuNo,
                        MeihenShakenTorokuDate  = item.MeihenShakenTorokuDate,
                        UketoriDetail           = lstUketoriDetailTemp
                    });
                }

                lstUketori = lstUketoriTemp;
            }
        }