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));
}
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));
}
public string Mall_Select(MallModel mallModel)
{
BaseDL bdl = new BaseDL();
mallModel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("Mall_Select", mallModel.Sqlprms));
}
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"));
}
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));
}
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));
}
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));
}
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));
}
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));
}
public string M_Control_SelectAll()
{
BaseDL bdl = new BaseDL();
//Kmodel.Sqlprms = new SqlParameter[0];
return(bdl.SelectJson("M_Control_SelectAll"));
}
//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));
}
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));
}
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));
}
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));
}
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));
}
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"));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}