public string M_NouhinBS_Select(TourokuNouhinModel Tnmodel)
        {
            BaseDL bdl = new BaseDL();

            Tnmodel.Sqlprms    = new SqlParameter[5];
            Tnmodel.Sqlprms[0] = new SqlParameter("@Year", SqlDbType.Int)
            {
                Value = (object)Tnmodel.Year ?? DBNull.Value
            };
            Tnmodel.Sqlprms[1] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
            {
                Value = Tnmodel.BrandCD
            };
            Tnmodel.Sqlprms[2] = new SqlParameter("@Season", SqlDbType.TinyInt)
            {
                Value = (object)Tnmodel.Season ?? DBNull.Value
            };
            Tnmodel.Sqlprms[3] = new SqlParameter("@PeriodStart", SqlDbType.Int)
            {
                Value = (object)Tnmodel.PeriodStart ?? DBNull.Value
            };
            Tnmodel.Sqlprms[4] = new SqlParameter("@PeriodEnd", SqlDbType.Int)
            {
                Value = (object)Tnmodel.PeriodEnd ?? DBNull.Value
            };

            return(bdl.SelectJson("M_NouhinBS_Select", Tnmodel.Sqlprms));
        }
示例#2
0
        public string M_HinBan_Select_List(TourokuProjectModel Tmodel)
        {
            BaseDL bdl = new BaseDL();

            Tmodel.Sqlprms = new SqlParameter[0];
            return(bdl.SelectJson("M_HinBan_Select_List", Tmodel.Sqlprms));
        }
示例#3
0
        public string Mall_Select(MallModel mallModel)
        {
            BaseDL bdl = new BaseDL();

            mallModel.Sqlprms = new SqlParameter[0];
            return(bdl.SelectJson("Mall_Select", mallModel.Sqlprms));
        }
示例#4
0
        public string ItemImportLog_Select(ItemImportLogModel itemImportModel)
        {
            BaseDL bdl = new BaseDL();

            itemImportModel.Sqlprms = new SqlParameter[0];
            return(bdl.SelectJson("ItemImportLog_Select", itemImportModel.Sqlprms));
        }
        public string M_Contrl_YearMonth_ExitCheck(Koushin_GetsujiModel kgmodel)
        {
            BaseDL bdl = new BaseDL();

            kgmodel.Sqlprms = new SqlParameter[0];
            return(bdl.SelectJson("M_Contrl_YearMonth_ExitCheck"));
        }
示例#6
0
        public string M_Hinban_Previous_Next(TourokuProjectModel Tmodel)
        {
            BaseDL bdl = new BaseDL();

            Tmodel.Sqlprms    = new SqlParameter[6];
            Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
            {
                Value = (object)Tmodel.ProjectCD ?? DBNull.Value
            };
            Tmodel.Sqlprms[1] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
            {
                Value = (object)Tmodel.HinbanCD ?? DBNull.Value
            };
            Tmodel.Sqlprms[2] = new SqlParameter("@status", SqlDbType.VarChar)
            {
                Value = (object)Tmodel.status ?? DBNull.Value
            };
            Tmodel.Sqlprms[3] = new SqlParameter("@UserID", SqlDbType.VarChar)
            {
                Value = (object)Tmodel.LoginID ?? DBNull.Value
            };
            Tmodel.Sqlprms[4] = new SqlParameter("@Number", SqlDbType.Int)
            {
                Value = (object)Tmodel.Number ?? DBNull.Value
            };
            Tmodel.Sqlprms[5] = new SqlParameter("@Previous_Next", SqlDbType.VarChar)
            {
                Value = (object)Tmodel.Previous_Next ?? DBNull.Value
            };
            return(bdl.SelectJson("M_Hinban_Previous_Next", Tmodel.Sqlprms));
        }
示例#7
0
        public string Print_Genka_ProjectData(Print_GenkaModel Pmodel)
        {
            BaseDL bdl = new BaseDL();

            Pmodel.Sqlprms    = new SqlParameter[6];
            Pmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
            {
                Value = (object)Pmodel.ProjectCD ?? DBNull.Value
            };
            Pmodel.Sqlprms[1] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
            {
                Value = (object)Pmodel.BrandCD ?? DBNull.Value
            };
            Pmodel.Sqlprms[2] = new SqlParameter("@LoginID", SqlDbType.VarChar)
            {
                Value = (object)Pmodel.LoginID ?? DBNull.Value
            };
            Pmodel.Sqlprms[3] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
            {
                Value = (object)Pmodel.HinbanCD ?? DBNull.Value
            };
            Pmodel.Sqlprms[4] = new SqlParameter("@Season", SqlDbType.VarChar)
            {
                Value = (object)Pmodel.Season ?? DBNull.Value
            };
            Pmodel.Sqlprms[5] = new SqlParameter("@Type", SqlDbType.VarChar)
            {
                Value = (object)Pmodel.Type ?? DBNull.Value
            };
            return(bdl.SelectJson("Print_Genka_ProjectData", Pmodel.Sqlprms));
        }
示例#8
0
        public string M_Contrl_Year_ExitCheck(Print_GenkaModel Pmodel) // for 対象年度
        {
            BaseDL bdl = new BaseDL();

            Pmodel.Sqlprms = new SqlParameter[0];
            return(bdl.SelectJson("M_Contrl_Year_ExitCheck"));
        }
        public string ExportColumn_Select(ExportColumnModel exportColumnModel)
        {
            BaseDL bdl = new BaseDL();

            exportColumnModel.Sqlprms = new SqlParameter[0];
            return(bdl.SelectJson("ExportColumn_Select", exportColumnModel.Sqlprms));
        }
示例#10
0
        public string SKU_Stock_Select(ItemModel item)
        {
            BaseDL bdl = new BaseDL();

            item.Sqlprms    = new SqlParameter[6];
            item.Sqlprms[0] = new SqlParameter("@JanCD", SqlDbType.VarChar)
            {
                Value = item.JanCD
            };
            item.Sqlprms[1] = new SqlParameter("@ItemCD", SqlDbType.VarChar)
            {
                Value = item.ItemCD
            };
            item.Sqlprms[2] = new SqlParameter("@ItemName", SqlDbType.VarChar)
            {
                Value = item.ItemName
            };
            item.Sqlprms[3] = new SqlParameter("@YearCD", SqlDbType.VarChar)
            {
                Value = item.YearCD
            };
            item.Sqlprms[4] = new SqlParameter("@SeasonCD", SqlDbType.VarChar)
            {
                Value = item.SeasonCD
            };
            item.Sqlprms[5] = new SqlParameter("@CompetitionName", SqlDbType.VarChar)
            {
                Value = item.CompetitionName
            };
            return(bdl.SelectJson("SKU_Stock_Select", item.Sqlprms));
        }
        public string D_StockData_IUD(Touroku_NyuukaModel tnmodel)
        {
            BaseDL bdl = new BaseDL();

            tnmodel.Sqlprms    = new SqlParameter[6];
            tnmodel.Sqlprms[0] = new SqlParameter("@SEQ", SqlDbType.VarChar)
            {
                Value = (object)tnmodel.SEQ ?? DBNull.Value
            };
            tnmodel.Sqlprms[1] = new SqlParameter("@MaterialsCD", SqlDbType.VarChar)
            {
                Value = (object)tnmodel.MaterialsCD ?? DBNull.Value
            };
            tnmodel.Sqlprms[2] = new SqlParameter("@StockDate", SqlDbType.VarChar)
            {
                Value = (object)tnmodel.StockDate ?? DBNull.Value
            };
            tnmodel.Sqlprms[3] = new SqlParameter("@StockAmount", SqlDbType.VarChar)
            {
                Value = (object)tnmodel.StockAmount ?? DBNull.Value
            };
            tnmodel.Sqlprms[4] = new SqlParameter("@Remarks", SqlDbType.VarChar)
            {
                Value = (object)tnmodel.Remarks ?? DBNull.Value
            };
            tnmodel.Sqlprms[5] = new SqlParameter("@Mode", SqlDbType.VarChar)
            {
                Value = (object)tnmodel.Mode ?? DBNull.Value
            };
            return(bdl.SelectJson("D_StockData_IUD", tnmodel.Sqlprms));
        }
示例#12
0
        public string View_Select(ViewModel viewModel)
        {
            BaseDL bdl = new BaseDL();

            viewModel.Sqlprms    = new SqlParameter[1];
            viewModel.Sqlprms[0] = new SqlParameter("@UserID", viewModel.UserID);
            return(bdl.SelectJson("View_Select", viewModel.Sqlprms));
        }
        public string M_Contrl_YearMonth_Genka_Update(Koushin_GenkaModel kgmodel)
        {
            BaseDL bdl = new BaseDL();

            kgmodel.Sqlprms = new SqlParameter[0];
            //kgmodel.Sqlprms[0] = new SqlParameter("@Date", SqlDbType.VarChar) { Value = (object)kgmodel.processing_date ?? DBNull.Value };
            return(bdl.SelectJson("M_Contrl_YearMonth_Genka_Update", kgmodel.Sqlprms));
        }
示例#14
0
        public string M_Control_SelectAll()
        {
            BaseDL bdl = new BaseDL();

            //Kmodel.Sqlprms = new SqlParameter[0];

            return(bdl.SelectJson("M_Control_SelectAll"));
        }
示例#15
0
        //public string M_Control_FiscalCheck(BaseModel BModel)  //Move to CommonBL
        //{
        //    BaseDL bdl = new BaseDL();
        //    BModel.Sqlprms = new SqlParameter[1];
        //    BModel.Sqlprms[0] = new SqlParameter("@CastDate", SqlDbType.Date) { Value = BModel.inputdate };
        //    return bdl.SelectJson("M_Control_FiscalCheck", BModel.Sqlprms);
        //}

        public string D_Cost_TKeihiCSV(Touroku_KeihiModel Kmodel)
        {
            BaseDL bdl = new BaseDL();

            Kmodel.Sqlprms    = new SqlParameter[12];
            Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.Int)
            {
                Value = (object)Kmodel.CostCD ?? DBNull.Value
            };
            Kmodel.Sqlprms[1] = new SqlParameter("@CostName", SqlDbType.VarChar)
            {
                Value = (object)Kmodel.CostName ?? DBNull.Value
            };
            Kmodel.Sqlprms[2] = new SqlParameter("@CostDateFrom", SqlDbType.Date)
            {
                Value = (object)Kmodel.CostDateFrom ?? DBNull.Value
            };
            Kmodel.Sqlprms[3] = new SqlParameter("@CostDateTo", SqlDbType.Date)
            {
                Value = (object)Kmodel.CostDateTo ?? DBNull.Value
            };
            Kmodel.Sqlprms[4] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
            {
                Value = (object)Kmodel.BrandCD ?? DBNull.Value
            };
            Kmodel.Sqlprms[5] = new SqlParameter("@BrandName", SqlDbType.VarChar)
            {
                Value = (object)Kmodel.BrandName ?? DBNull.Value
            };
            Kmodel.Sqlprms[6] = new SqlParameter("@Season", SqlDbType.VarChar)
            {
                Value = (object)Kmodel.Season ?? DBNull.Value
            };
            Kmodel.Sqlprms[7] = new SqlParameter("@Year", SqlDbType.Int)
            {
                Value = (object)Kmodel.Year ?? DBNull.Value
            };
            Kmodel.Sqlprms[8] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
            {
                Value = (object)Kmodel.ProjectCD ?? DBNull.Value
            };
            Kmodel.Sqlprms[9] = new SqlParameter("@ProjectName", SqlDbType.VarChar)
            {
                Value = (object)Kmodel.ProjectName ?? DBNull.Value
            };
            Kmodel.Sqlprms[10] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
            {
                Value = (object)Kmodel.HinbanCD ?? DBNull.Value
            };
            Kmodel.Sqlprms[11] = new SqlParameter("@HinbanName", SqlDbType.VarChar)
            {
                Value = (object)Kmodel.HinbanName ?? DBNull.Value
            };

            return(bdl.SelectJson("D_Cost_TKeihiCSV", Kmodel.Sqlprms));
        }
示例#16
0
        public string ItemManage_List(ItemModel itemModel)
        {
            BaseDL bdl = new BaseDL();

            itemModel.Sqlprms    = new SqlParameter[12];
            itemModel.Sqlprms[0] = new SqlParameter("@BrandName", SqlDbType.VarChar)
            {
                Value = itemModel.BrandName
            };
            itemModel.Sqlprms[1] = new SqlParameter("@ItemName", SqlDbType.VarChar)
            {
                Value = itemModel.ItemName
            };
            itemModel.Sqlprms[2] = new SqlParameter("@MakerCD", SqlDbType.VarChar)
            {
                Value = itemModel.MakerCD
            };
            itemModel.Sqlprms[3] = new SqlParameter("@MakerName", SqlDbType.VarChar)
            {
                Value = itemModel.MakerName
            };
            itemModel.Sqlprms[4] = new SqlParameter("@YearCD", SqlDbType.VarChar)
            {
                Value = itemModel.YearCD
            };
            itemModel.Sqlprms[5] = new SqlParameter("@SeasonCD", SqlDbType.VarChar)
            {
                Value = itemModel.SeasonCD
            };
            itemModel.Sqlprms[6] = new SqlParameter("@CatalogInfo", SqlDbType.VarChar)
            {
                Value = itemModel.CatalogInfo
            };
            itemModel.Sqlprms[7] = new SqlParameter("@ClassName", SqlDbType.VarChar)
            {
                Value = itemModel.ClassName
            };
            itemModel.Sqlprms[8] = new SqlParameter("@CompetitionName", SqlDbType.VarChar)
            {
                Value = itemModel.CompetitionName
            };
            itemModel.Sqlprms[9] = new SqlParameter("@Type", SqlDbType.VarChar)
            {
                Value = itemModel.Type
            };
            itemModel.Sqlprms[10] = new SqlParameter("@ItemCD", SqlDbType.VarChar)
            {
                Value = itemModel.ItemCD
            };
            itemModel.Sqlprms[11] = new SqlParameter("@ExportID", SqlDbType.VarChar)
            {
                Value = itemModel.ExportID
            };
            return(bdl.SelectJson("ItemManage_Select", itemModel.Sqlprms));
        }
示例#17
0
        public string M_BrandName_Select(KanagataModel kgmodel)
        {
            BaseDL bdl = new BaseDL();

            kgmodel.Sqlprms    = new SqlParameter[1];
            kgmodel.Sqlprms[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
            {
                Value = (object)kgmodel.BrandCD ?? DBNull.Value
            };
            return(bdl.SelectJson("M_BrandName_Select", kgmodel.Sqlprms));
        }
示例#18
0
        public string M_Kanjo_ExistsCheck(KanjoModel Kjmodel)
        {
            BaseDL bdl = new BaseDL();

            Kjmodel.Sqlprms    = new SqlParameter[1];
            Kjmodel.Sqlprms[0] = new SqlParameter("@KanjoCD", SqlDbType.VarChar)
            {
                Value = (object)Kjmodel.KanjoCD ?? DBNull.Value
            };
            return(bdl.SelectJson("M_Kanjo_ExistsCheck", Kjmodel.Sqlprms));
        }
示例#19
0
        public string M_Keihi_ExistsCheck(KeihiSetteiModel Kmodel)
        {
            BaseDL bdl = new BaseDL();

            Kmodel.Sqlprms    = new SqlParameter[1];
            Kmodel.Sqlprms[0] = new SqlParameter("@CostCD", SqlDbType.VarChar)
            {
                Value = (object)Kmodel.CostCD ?? DBNull.Value
            };
            return(bdl.SelectJson("M_Keihi_ExistsCheck", Kmodel.Sqlprms));
        }
示例#20
0
        public string OptionTemplate_Select(OptionTemplateModel optionTemplateModel)
        {
            BaseDL bdl = new BaseDL();

            optionTemplateModel.Sqlprms    = new SqlParameter[1];
            optionTemplateModel.Sqlprms[0] = new SqlParameter("@AutoID", SqlDbType.VarChar)
            {
                Value = optionTemplateModel.AutoID
            };
            return(bdl.SelectJson("OptionTemplate_Select"));
        }
示例#21
0
        public string M_HinBan_ExistsCheck(TourokuProjectModel Tmodel)
        {
            BaseDL bdl = new BaseDL();

            Tmodel.Sqlprms    = new SqlParameter[1];
            Tmodel.Sqlprms[0] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
            {
                Value = (object)Tmodel.HinbanCD ?? DBNull.Value
            };
            return(bdl.SelectJson("M_HinBan_ExistsCheck", Tmodel.Sqlprms));
        }
示例#22
0
        public string M_Hinban_Check_List(TourokuProjectModel Tmodel)
        {
            BaseDL bdl = new BaseDL();

            Tmodel.Sqlprms    = new SqlParameter[1];
            Tmodel.Sqlprms[0] = new SqlParameter("@ProjectCD", SqlDbType.VarChar)
            {
                Value = Tmodel.ProjectCD
            };
            return(bdl.SelectJson("M_Hinban_Check_List", Tmodel.Sqlprms));
        }
示例#23
0
        public string MT_Materials_Select(MasterTouroku_MaterialsModel mmodel)
        {
            BaseDL bdl = new BaseDL();

            mmodel.Sqlprms    = new SqlParameter[1];
            mmodel.Sqlprms[0] = new SqlParameter("@MaterialsName", SqlDbType.VarChar)
            {
                Value = (object)mmodel.MaterialsName ?? DBNull.Value
            };
            return(bdl.SelectJson("MT_Materials_Select", mmodel.Sqlprms));
        }
示例#24
0
        public string M_Casting_ExistsCheck(Touroku_KeihiModel tkmodel)
        {
            BaseDL bdl = new BaseDL();

            tkmodel.Sqlprms    = new SqlParameter[1];
            tkmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
            {
                Value = tkmodel.CastingCD
            };
            return(bdl.SelectJson("M_Casting_ExistsCheck", tkmodel.Sqlprms));
        }
示例#25
0
        public string D_Cost_Edit_List(Touroku_KeihiModel kmodel)
        {
            BaseDL bdl = new BaseDL();

            kmodel.Sqlprms    = new SqlParameter[1];
            kmodel.Sqlprms[0] = new SqlParameter("@SEQ", SqlDbType.Int)
            {
                Value = kmodel.SEQ
            };
            return(bdl.SelectJson("D_Cost_Edit_List", kmodel.Sqlprms));
        }
        public string MT_Materials_SelectByMaterialsCD(Touroku_NyuukaModel tnmodel)
        {
            BaseDL bdl = new BaseDL();

            tnmodel.Sqlprms    = new SqlParameter[1];
            tnmodel.Sqlprms[0] = new SqlParameter("@MaterialsCD", SqlDbType.VarChar)
            {
                Value = (object)tnmodel.MaterialsCD ?? DBNull.Value
            };
            return(bdl.SelectJson("MT_Materials_SelectByMaterialsCD", tnmodel.Sqlprms));
        }
示例#27
0
        public string M_Casting_ExistsCheck(KanagataModel kgmodel)
        {
            BaseDL bdl = new BaseDL();

            kgmodel.Sqlprms    = new SqlParameter[1];
            kgmodel.Sqlprms[0] = new SqlParameter("@CastingCD", SqlDbType.VarChar)
            {
                Value = (object)kgmodel.CastingCD ?? DBNull.Value
            };
            return(bdl.SelectJson("M_Casting_ExistsCheck", kgmodel.Sqlprms));
        }
        public string D_StockData_SelectBySEQ(Touroku_NyuukaModel tnmodel)
        {
            BaseDL bdl = new BaseDL();

            tnmodel.Sqlprms    = new SqlParameter[1];
            tnmodel.Sqlprms[0] = new SqlParameter("@SEQ", SqlDbType.VarChar)
            {
                Value = (object)tnmodel.SEQ ?? DBNull.Value
            };
            return(bdl.SelectJson("D_StockData_SelectBySEQ", tnmodel.Sqlprms));
        }
示例#29
0
        public string ShopTemplate_ExistCheck(ShopTemplateModel shopTemplateModel)
        {
            BaseDL bdl = new BaseDL();

            shopTemplateModel.Sqlprms    = new SqlParameter[1];
            shopTemplateModel.Sqlprms[0] = new SqlParameter("@TemplateID", SqlDbType.VarChar)
            {
                Value = shopTemplateModel.TemplateID
            };
            return(bdl.SelectJson("ShopTemplate_ExistsCheck", shopTemplateModel.Sqlprms));
        }
示例#30
0
        public string M_HinBan_ExistsCheck(Touroku_KeihiModel Kmodel)
        {
            BaseDL bdl = new BaseDL();

            Kmodel.Sqlprms    = new SqlParameter[1];
            Kmodel.Sqlprms[0] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
            {
                Value = Kmodel.HinbanCD
            };
            return(bdl.SelectJson("M_HinBan_ExistsCheck", Kmodel.Sqlprms));
        }