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));
}
