public bool M_ITEM_SelectForShiireTanka(M_ITEM_Entity me) { DataTable dt = msdl.M_ITEM_SelectForShiireTanka(me); if (dt.Rows.Count > 0) { me.ITemCD = dt.Rows[0]["ITemCD"].ToString(); me.ChangeDate = dt.Rows[0]["ChangeDate"].ToString(); me.ITemName = dt.Rows[0]["ITemName"].ToString(); me.BrandCD = dt.Rows[0]["BrandCD"].ToString(); me.BrandName = dt.Rows[0]["BrandName"].ToString(); me.MakerItem = dt.Rows[0]["MakerItem"].ToString(); me.SportsCD = dt.Rows[0]["SportsCD"].ToString(); me.SportsName = dt.Rows[0]["SportsName"].ToString(); me.SegmentCD = dt.Rows[0]["SegmentCD"].ToString(); me.SegmentName = dt.Rows[0]["SegmentName"].ToString(); me.PriceOutTax = dt.Rows[0]["PriceOutTax"].ToString(); me.LastYearTerm = dt.Rows[0]["LastYearTerm"].ToString(); me.LastSeason = dt.Rows[0]["LastSeason"].ToString(); me.DeleteFlg = dt.Rows[0]["DeleteFlg"].ToString(); return(true); } return(false); }
public DataTable M_ITEM_SelectBy_ItemCD(M_ITEM_Entity mie) { string sp = "M_ITEM_SelectBy_ItemCD"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@itemcd", new ValuePair { value1 = SqlDbType.VarChar, value2 = mie.ITemCD } }, }; return(SelectData(dic, sp)); }
public DataTable M_ITem_SelectForSKUCDHenkou01(M_ITEM_Entity mie) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@ITemCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mie.ITemCD } }, { "@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = mie.ChangeDate } }, }; return(SelectData(dic, "M_ITem_SelectForSKUCDHenkou01")); }
public DataTable M_Site_SelectByItemCD(M_ITEM_Entity me) { string sp = "M_Site_SelectByItemCD"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@ITemCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = me.ITemCD } }, { "@ChangeDate", new ValuePair { value1 = SqlDbType.VarChar, value2 = me.ChangeDate } }, }; return(SelectData(dic, sp)); }
public DataTable M_ITem_ItemNandPriceoutTax_Select(M_ITEM_Entity mi) { string sp = "M_ITem_ItemNandPriceoutTax_Select"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@ITemCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mi.ITemCD } }, { "@AddDate", new ValuePair { value1 = SqlDbType.Date, value2 = mi.AddDate } }, }; return(SelectData(dic, sp)); }
public DataTable M_ITEM_SelectForShiireTanka(M_ITEM_Entity me) { string sp = "M_ITEM_SelectForShiireTanka"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@ITemCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = me.ITemCD } }, { "@ChangeDate", new ValuePair { value1 = SqlDbType.VarChar, value2 = me.ChangeDate } }, { "@DeleteFlg", new ValuePair { value1 = SqlDbType.VarChar, value2 = me.DeleteFlg } }, }; return(SelectData(dic, sp)); }
/// <summary> /// 商品マスタメンテよりデータ取得 /// </summary> /// <param name="me"></param> /// <remarks>指定した適用日のデータを取得</remarks> /// <returns></returns> public bool M_ITEM_Select(M_ITEM_Entity me) { DataTable dt = mdl.M_ITEM_Select(me); if (dt.Rows.Count > 0) { me.ITemCD = dt.Rows[0]["ITemCD"].ToString(); me.ColorNO = dt.Rows[0]["ColorNO"].ToString(); me.SizeNO = dt.Rows[0]["SizeNO"].ToString(); me.ChangeDate = dt.Rows[0]["ChangeDate"].ToString(); me.VariousFLG = dt.Rows[0]["VariousFLG"].ToString(); me.ITemName = dt.Rows[0]["ITemName"].ToString(); me.KanaName = dt.Rows[0]["KanaName"].ToString(); me.SKUShortName = dt.Rows[0]["SKUShortName"].ToString(); me.EnglishName = dt.Rows[0]["EnglishName"].ToString(); me.SetKBN = dt.Rows[0]["SetKBN"].ToString(); me.PresentKBN = dt.Rows[0]["PresentKBN"].ToString(); me.SampleKBN = dt.Rows[0]["SampleKBN"].ToString(); me.DiscountKBN = dt.Rows[0]["DiscountKBN"].ToString(); me.ColorName = dt.Rows[0]["ColorName"].ToString(); me.SizeName = dt.Rows[0]["SizeName"].ToString(); me.WebFlg = dt.Rows[0]["WebFlg"].ToString(); me.RealStoreFlg = dt.Rows[0]["RealStoreFlg"].ToString(); me.MainVendorCD = dt.Rows[0]["MainVendorCD"].ToString(); me.MakerVendorCD = dt.Rows[0]["MakerVendorCD"].ToString(); me.BrandCD = dt.Rows[0]["BrandCD"].ToString(); me.MakerItem = dt.Rows[0]["MakerItem"].ToString(); me.TaniCD = dt.Rows[0]["TaniCD"].ToString(); me.SportsCD = dt.Rows[0]["SportsCD"].ToString(); me.SegmentCD = dt.Rows[0]["SegmentCD"].ToString(); me.ZaikoKBN = dt.Rows[0]["ZaikoKBN"].ToString(); me.Rack = dt.Rows[0]["Rack"].ToString(); me.VirtualFlg = dt.Rows[0]["VirtualFlg"].ToString(); me.DirectFlg = dt.Rows[0]["DirectFlg"].ToString(); me.ReserveCD = dt.Rows[0]["ReserveCD"].ToString(); me.NoticesCD = dt.Rows[0]["NoticesCD"].ToString(); me.PostageCD = dt.Rows[0]["PostageCD"].ToString(); me.ManufactCD = dt.Rows[0]["ManufactCD"].ToString(); me.ConfirmCD = dt.Rows[0]["ConfirmCD"].ToString(); me.WebStockFlg = dt.Rows[0]["WebStockFlg"].ToString(); me.StopFlg = dt.Rows[0]["StopFlg"].ToString(); me.DiscontinueFlg = dt.Rows[0]["DiscontinueFlg"].ToString(); me.InventoryAddFlg = dt.Rows[0]["InventoryAddFlg"].ToString(); me.MakerAddFlg = dt.Rows[0]["MakerAddFlg"].ToString(); me.StoreAddFlg = dt.Rows[0]["StoreAddFlg"].ToString(); me.NoNetOrderFlg = dt.Rows[0]["NoNetOrderFlg"].ToString(); me.EDIOrderFlg = dt.Rows[0]["EDIOrderFlg"].ToString(); me.CatalogFlg = dt.Rows[0]["CatalogFlg"].ToString(); me.ParcelFlg = dt.Rows[0]["ParcelFlg"].ToString(); me.AutoOrderFlg = dt.Rows[0]["AutoOrderFlg"].ToString(); me.TaxRateFLG = dt.Rows[0]["TaxRateFLG"].ToString(); me.CostingKBN = dt.Rows[0]["CostingKBN"].ToString(); me.SaleExcludedFlg = dt.Rows[0]["SaleExcludedFlg"].ToString(); me.PriceWithTax = dt.Rows[0]["PriceWithTax"].ToString(); me.PriceOutTax = dt.Rows[0]["PriceOutTax"].ToString(); me.Rate = dt.Rows[0]["Rate"].ToString(); me.OrderPriceWithTax = dt.Rows[0]["OrderPriceWithTax"].ToString(); me.OrderPriceWithoutTax = dt.Rows[0]["OrderPriceWithoutTax"].ToString(); me.SaleStartDate = dt.Rows[0]["SaleStartDate"].ToString(); me.WebStartDate = dt.Rows[0]["WebStartDate"].ToString(); me.OrderAttentionCD = dt.Rows[0]["OrderAttentionCD"].ToString(); me.OrderAttentionNote = dt.Rows[0]["OrderAttentionNote"].ToString(); me.CommentInStore = dt.Rows[0]["CommentInStore"].ToString(); me.CommentOutStore = dt.Rows[0]["CommentOutStore"].ToString(); me.ExhibitionSegmentCD = dt.Rows[0]["ExhibitionSegmentCD"].ToString(); me.OrderLot = dt.Rows[0]["OrderLot"].ToString(); me.LastYearTerm = dt.Rows[0]["LastYearTerm"].ToString(); me.LastSeason = dt.Rows[0]["LastSeason"].ToString(); me.LastCatalogNO = dt.Rows[0]["LastCatalogNO"].ToString(); me.LastCatalogPage = dt.Rows[0]["LastCatalogPage"].ToString(); me.LastCatalogText = dt.Rows[0]["LastCatalogText"].ToString(); me.LastInstructionsNO = dt.Rows[0]["LastInstructionsNO"].ToString(); me.LastInstructionsDate = dt.Rows[0]["LastInstructionsDate"].ToString(); me.WebAddress = dt.Rows[0]["WebAddress"].ToString(); me.ApprovalDate = dt.Rows[0]["ApprovalDate"].ToString(); me.DeleteFlg = dt.Rows[0]["DeleteFlg"].ToString(); me.UsedFlg = dt.Rows[0]["UsedFlg"].ToString(); me.InsertOperator = dt.Rows[0]["InsertOperator"].ToString(); me.InsertDateTime = dt.Rows[0]["InsertDateTime"].ToString(); me.UpdateOperator = dt.Rows[0]["UpdateOperator"].ToString(); me.UpdateDateTime = dt.Rows[0]["UpdateDateTime"].ToString(); return(true); } return(false); }
public bool M_ITEM_Exec(M_ITEM_Entity me, DataTable dt, DataTable dtSite, short operationMode) { return(mdl.M_ITEM_Exec(me, dt, dtSite, operationMode)); }
public DataTable M_Site_SelectByItemCD(M_ITEM_Entity me) { M_Site_DL msdl = new M_Site_DL(); return(msdl.M_Site_SelectByItemCD(me)); }
//public DataTable M_SKU_SelectAll(M_SKU_Entity mse) //{ // string sp = "M_SKU_SelectAll"; // Dictionary<string, ValuePair> dic = new Dictionary<string, ValuePair> // { // { "@AdminNO", new ValuePair { value1 = SqlDbType.Int, value2 = mse.AdminNO } }, // { "@SKUCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SKUCD } }, // { "@JanCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.JanCD } }, // { "@SetKBN", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SetKBN } }, // { "@ChangeDate", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.ChangeDate } }, // }; // return SelectData(dic,sp); //} /// <summary> /// 商品マスタ更新処理 /// MasterTouroku_Syohinより更新時に使用 /// </summary> /// <param name="me"></param> /// <returns></returns> public bool M_ITEM_Exec(M_ITEM_Entity me, DataTable dt, DataTable dtSite, short operationMode) { string sp = "PRC_MasterTouroku_Syouhin"; command = new SqlCommand(sp, GetConnection()); command.CommandType = CommandType.StoredProcedure; command.CommandTimeout = 0; AddParam(command, "@OperateMode", SqlDbType.VarChar, operationMode.ToString()); AddParam(command, "@ITemCD", SqlDbType.VarChar, me.ITemCD); AddParam(command, "@ChangeDate", SqlDbType.VarChar, me.ChangeDate); AddParam(command, "@VariousFLG", SqlDbType.TinyInt, me.VariousFLG); AddParam(command, "@ITemName", SqlDbType.VarChar, me.ITemName); AddParam(command, "@KanaName", SqlDbType.VarChar, me.KanaName); AddParam(command, "@SKUShortName", SqlDbType.VarChar, me.SKUShortName); AddParam(command, "@EnglishName", SqlDbType.VarChar, me.EnglishName); AddParam(command, "@SetKBN", SqlDbType.TinyInt, me.SetKBN); AddParam(command, "@PresentKBN", SqlDbType.TinyInt, me.PresentKBN); AddParam(command, "@SampleKBN", SqlDbType.TinyInt, me.SampleKBN); AddParam(command, "@DiscountKBN", SqlDbType.TinyInt, me.DiscountKBN); AddParam(command, "@ColorName", SqlDbType.VarChar, me.ColorName); AddParam(command, "@SizeName", SqlDbType.VarChar, me.SizeName); AddParam(command, "@WebFlg", SqlDbType.TinyInt, me.WebFlg); AddParam(command, "@RealStoreFlg", SqlDbType.TinyInt, me.RealStoreFlg); AddParam(command, "@MainVendorCD", SqlDbType.VarChar, me.MainVendorCD); //AddParam(command, "@MakerVendorCD", SqlDbType.VarChar, me.MakerVendorCD); AddParam(command, "@BrandCD", SqlDbType.VarChar, me.BrandCD); AddParam(command, "@MakerItem", SqlDbType.VarChar, me.MakerItem); AddParam(command, "@TaniCD", SqlDbType.VarChar, me.TaniCD); AddParam(command, "@SportsCD", SqlDbType.VarChar, me.SportsCD); AddParam(command, "@SegmentCD", SqlDbType.VarChar, me.SegmentCD); AddParam(command, "@ZaikoKBN", SqlDbType.TinyInt, me.ZaikoKBN); AddParam(command, "@Rack", SqlDbType.VarChar, me.Rack); AddParam(command, "@VirtualFlg", SqlDbType.TinyInt, me.VirtualFlg); AddParam(command, "@DirectFlg", SqlDbType.TinyInt, me.DirectFlg); AddParam(command, "@ReserveCD", SqlDbType.VarChar, me.ReserveCD); AddParam(command, "@NoticesCD", SqlDbType.VarChar, me.NoticesCD); AddParam(command, "@PostageCD", SqlDbType.VarChar, me.PostageCD); AddParam(command, "@ManufactCD", SqlDbType.VarChar, me.ManufactCD); AddParam(command, "@ConfirmCD", SqlDbType.VarChar, me.ConfirmCD); AddParam(command, "@WebStockFlg", SqlDbType.TinyInt, me.WebStockFlg); AddParam(command, "@StopFlg", SqlDbType.TinyInt, me.StopFlg); AddParam(command, "@DiscontinueFlg", SqlDbType.TinyInt, me.DiscontinueFlg); AddParam(command, "@InventoryAddFlg", SqlDbType.TinyInt, me.InventoryAddFlg); AddParam(command, "@MakerAddFlg", SqlDbType.TinyInt, me.MakerAddFlg); AddParam(command, "@StoreAddFlg", SqlDbType.TinyInt, me.StoreAddFlg); AddParam(command, "@NoNetOrderFlg", SqlDbType.TinyInt, me.NoNetOrderFlg); AddParam(command, "@EDIOrderFlg", SqlDbType.TinyInt, me.EDIOrderFlg); AddParam(command, "@CatalogFlg", SqlDbType.TinyInt, me.CatalogFlg); AddParam(command, "@ParcelFlg", SqlDbType.TinyInt, me.ParcelFlg); AddParam(command, "@AutoOrderFlg", SqlDbType.TinyInt, me.AutoOrderFlg); AddParam(command, "@TaxRateFLG", SqlDbType.TinyInt, me.TaxRateFLG); AddParam(command, "@CostingKBN", SqlDbType.TinyInt, me.CostingKBN); AddParam(command, "@SaleExcludedFlg", SqlDbType.TinyInt, me.SaleExcludedFlg); AddParam(command, "@PriceWithTax", SqlDbType.Money, me.PriceWithTax); AddParam(command, "@PriceOutTax", SqlDbType.Money, me.PriceOutTax); AddParam(command, "@OrderPriceWithTax", SqlDbType.Money, me.OrderPriceWithTax); AddParam(command, "@OrderPriceWithoutTax", SqlDbType.Money, me.OrderPriceWithoutTax); AddParam(command, "@Rate", SqlDbType.Decimal, me.Rate); AddParam(command, "@SaleStartDate", SqlDbType.Date, me.SaleStartDate); AddParam(command, "@WebStartDate", SqlDbType.Date, me.WebStartDate); AddParam(command, "@OrderAttentionCD", SqlDbType.VarChar, me.OrderAttentionCD); AddParam(command, "@OrderAttentionNote", SqlDbType.VarChar, me.OrderAttentionNote); AddParam(command, "@CommentInStore", SqlDbType.VarChar, me.CommentInStore); AddParam(command, "@CommentOutStore", SqlDbType.VarChar, me.CommentOutStore); AddParam(command, "@ExhibitionSegmentCD", SqlDbType.VarChar, me.ExhibitionSegmentCD); AddParam(command, "@OrderLot", SqlDbType.VarChar, me.OrderLot); AddParam(command, "@LastYearTerm", SqlDbType.VarChar, me.LastYearTerm); AddParam(command, "@LastSeason", SqlDbType.VarChar, me.LastSeason); AddParam(command, "@LastCatalogNO", SqlDbType.VarChar, me.LastCatalogNO); AddParam(command, "@LastCatalogPage", SqlDbType.VarChar, me.LastCatalogPage); AddParam(command, "@LastCatalogText", SqlDbType.VarChar, me.LastCatalogText); AddParam(command, "@LastInstructionsNO", SqlDbType.VarChar, me.LastInstructionsNO); AddParam(command, "@LastInstructionsDate", SqlDbType.Date, me.LastInstructionsDate); AddParam(command, "@WebAddress", SqlDbType.VarChar, me.WebAddress); AddParam(command, "@ApprovalDate", SqlDbType.Date, me.ApprovalDate); AddParam(command, "@DeleteFlg", SqlDbType.TinyInt, me.DeleteFlg); AddParam(command, "@UsedFlg", SqlDbType.TinyInt, me.UsedFlg); AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt); AddParamForDataTable(command, "@SiteTable", SqlDbType.Structured, dtSite); AddParam(command, "@Operator", SqlDbType.VarChar, me.InsertOperator); AddParam(command, "@PC", SqlDbType.VarChar, me.PC); string outPutParam = ""; UseTransaction = true; return(InsertUpdateDeleteData(sp, ref outPutParam)); }
public DataTable M_ITem_SelectForSKUCDHenkou01(M_ITEM_Entity mie) { return(midl.M_ITem_SelectForSKUCDHenkou01(mie)); }
public DataTable M_ITEM_NormalSelect(M_ITEM_Entity mie) { return(midl.M_ITEM_NormalSelect(mie)); }
public MasterTouroku_SKUCDHenkou_SKUCD変更() { InitializeComponent(); mskubl = new MasterTouroku_SKUCDHenkou_SKUCD変更_BL(); mie = new M_ITEM_Entity(); }
public DataTable M_ITEM_SelectBy_ItemCD(M_ITEM_Entity me) { return(msdl.M_ITEM_SelectBy_ItemCD(me)); }
public DataTable M_ITem_ItemNandPriceoutTax_Select(M_ITEM_Entity mi) { return(msdl.M_ITem_ItemNandPriceoutTax_Select(mi)); }