public M_SKUTag_Entity GetTagEntity() { msT_Entity = new M_SKUTag_Entity() { TagName1 = CB_Tagu1.Text, TagName2 = CB_Tagu2.Text, TagName3 = CB_Tagu3.Text, TagName4 = CB_Tagu4.Text, TagName5 = CB_Tagu5.Text, }; return(msT_Entity); }
private void F11() { if (ErrorCheck()) { if (CKB_searchsuru.Checked == true && RB_item.Checked == true) { type = 1; } else if (CKB_searchsuru.Checked == true && RB_Makashohincd.Checked == true) { type = 2; } else { type = 3; } msku_Entity = GetDataEntity(); msInfo_Entity = GetInfoEntity(); msT_Entity = GetTagEntity(); ds_Entity = GetStockEntity(); dtData = zaibl.ZaikoShoukai_Search(msku_Entity, msInfo_Entity, msT_Entity, ds_Entity, type); if (dtData.Rows.Count > 0) { GV_Zaiko.Refresh(); GV_Zaiko.DataSource = dtData; adminno = dtData.Rows[0]["AdminNo"].ToString(); soukocd = dtData.Rows[0]["倉庫CD"].ToString(); } else { GV_Zaiko.DataSource = null; bbl.ShowMessage("E128"); dtData.Clear(); } } }
public DataTable ZaikoShoukai_Search(M_SKU_Entity msku_entity, M_SKUInfo_Entity msInfo_entity, M_SKUTag_Entity msTag, D_Stock_Entity ds_Entity, int Type) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = msku_entity.ChangeDate } }, { "@VendorCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.MainVendorCD } }, { "@makerCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.MakerVendorCD } }, { "@brandCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.BrandCD } }, { "@SKUName", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.SKUName } }, { "@JanCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.JanCD } }, { "@SkuCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.SKUCD } }, { "@MakerItem", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.MakerItem } }, { "@ItemCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.ITemCD } }, { "@CommentInStore", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.CommentInStore } }, { "@ReserveCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.ReserveCD } }, { "@NticesCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.NoticesCD } }, { "@PostageCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.PostageCD } }, { "@OrderAttentionCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.OrderAttentionCD } }, { "@SportsCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msku_entity.SportsCD } }, { "@InsertDateTimeT", new ValuePair { value1 = SqlDbType.Date, value2 = msku_entity.InputDateTo } }, { "@InsertDateTimeF", new ValuePair { value1 = SqlDbType.Date, value2 = msku_entity.InputDateFrom } }, { "@UpdateDateTimeT", new ValuePair { value1 = SqlDbType.Date, value2 = msku_entity.UpdateDateFrom } }, { "@UpdateDateTimeF", new ValuePair { value1 = SqlDbType.Date, value2 = msku_entity.UpdateDateTo } }, { "@ApprovalDateF", new ValuePair { value1 = SqlDbType.Date, value2 = msku_entity.ApprovalDateFrom } }, { "@ApprovalDateT", new ValuePair { value1 = SqlDbType.Date, value2 = msku_entity.ApprovalDateTo } }, { "@YearTerm", new ValuePair { value1 = SqlDbType.VarChar, value2 = msInfo_entity.YearTerm } }, { "@Season", new ValuePair { value1 = SqlDbType.VarChar, value2 = msInfo_entity.Season } }, { "@CatalogNo", new ValuePair { value1 = SqlDbType.VarChar, value2 = msInfo_entity.CatalogNO } }, { "@InstructionsNO", new ValuePair { value1 = SqlDbType.VarChar, value2 = msInfo_entity.InstructionsNO } }, { "@TagName1", new ValuePair { value1 = SqlDbType.VarChar, value2 = msTag.TagName1 } }, { "@TagName2", new ValuePair { value1 = SqlDbType.VarChar, value2 = msTag.TagName2 } }, { "@TagName3", new ValuePair { value1 = SqlDbType.VarChar, value2 = msTag.TagName3 } }, { "@TagName4", new ValuePair { value1 = SqlDbType.VarChar, value2 = msTag.TagName4 } }, { "@TagName5", new ValuePair { value1 = SqlDbType.VarChar, value2 = msTag.TagName5 } }, { "@type", new ValuePair { value1 = SqlDbType.Int, value2 = Type.ToString() } }, { "@SoukoCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = ds_Entity.SoukoCD } }, { "@RackNoF", new ValuePair { value1 = SqlDbType.VarChar, value2 = ds_Entity.RackNOFrom } }, { "@RackNoT", new ValuePair { value1 = SqlDbType.VarChar, value2 = ds_Entity.RackNOTo } }, }; return(SelectData(dic, "ZaikoShoukai_Search")); }
public DataTable ZaikoShoukai_Search(M_SKU_Entity msku, M_SKUInfo_Entity msInfo, M_SKUTag_Entity mstag, D_Stock_Entity ds_Entity, int Type) { return(zaidl.ZaikoShoukai_Search(msku, msInfo, mstag, ds_Entity, Type)); }
public void F12() { //if (PrintMode != EPrintMode.DIRECT) // return; if (ErrorCheck()) { string[] strlist = txtRemarks.Text.Split(','); dse = new D_Stock_Entity { AdminNO = txtTargetDays.Text, SoukoCD = cboWarehouse.SelectedValue.ToString(), RackNOFrom = txtStorageFrom.Text, RackNOTo = txtStorageTo.Text, Keyword1 = (strlist.Length > 0) ? strlist[0].ToString() : "", Keyword2 = (strlist.Length > 1) ? strlist[1].ToString() : "", Keyword3 = (strlist.Length > 2) ? strlist[2].ToString() : "", }; mskue = new M_SKU_Entity { MainVendorCD = Sc_Maker.TxtCode.Text, BrandCD = Sc_Brand.TxtCode.Text, SKUName = txtProductName.Text, JanCD = txtJANCD.Text, SKUCD = txtSKUCD.Text, ITemCD = txtItem.Text, MakerItem = txtManufactureCD.Text, SportsCD = Sc_Competition.TxtCode.Text, ReserveCD = cboReservation.SelectedValue.ToString(), NoticesCD = cboNotices.SelectedValue.ToString(), PostageCD = cboPostage.SelectedValue.ToString(), OrderAttentionCD = cboOrder.ToString() }; info = new M_SKUInfo_Entity { YearTerm = CboYear.SelectedValue.ToString(), Season = cboSeason.SelectedValue.ToString(), CatalogNO = txtCatalog.Text, InstructionsNO = txtInstructionNo.Text, }; mtage = new M_SKUTag_Entity { TagName1 = cboTag1.SelectedValue.ToString(), TagName2 = cboTag2.SelectedValue.ToString(), TagName3 = cboTag3.SelectedValue.ToString(), TagName4 = cboTag4.SelectedValue.ToString(), TagName5 = cboTag5.SelectedValue.ToString() }; DataTable dtSelect = new DataTable(); dtSelect = tzkbl.D_StockSelectForTairyuzaikohyo(dse, mskue, info, mtage); if (dtSelect.Rows.Count > 0) { //CheckBeforeExport(); try { } finally { //画面はそのまま txtTargetDays.Focus(); } } } }
public DataTable D_StockSelectForTairyuzaikohyo(D_Stock_Entity dse, M_SKU_Entity skue, M_SKUInfo_Entity info, M_SKUTag_Entity tage) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@SoukoCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dse.SoukoCD } }, { "@RackNOFrom", new ValuePair { value1 = SqlDbType.VarChar, value2 = dse.RackNOFrom } }, { "@RackNOTo", new ValuePair { value1 = SqlDbType.VarChar, value2 = dse.RackNOTo } }, { "@AdminNO", new ValuePair { value1 = SqlDbType.Int, value2 = dse.AdminNO } }, { "@keyword1", new ValuePair { value1 = SqlDbType.VarChar, value2 = dse.Keyword1 } }, { "@keyword2", new ValuePair { value1 = SqlDbType.VarChar, value2 = dse.Keyword2 } }, { "@keyword3", new ValuePair { value1 = SqlDbType.Int, value2 = dse.Keyword3 } }, { "@MainVendorCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = skue.MainVendorCD } }, { "@BrandCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = skue.BrandCD } }, { "@SKUName", new ValuePair { value1 = SqlDbType.VarChar, value2 = skue.SKUName } }, { "@JanCD", new ValuePair { value1 = SqlDbType.Int, value2 = skue.JanCD } }, { "@SKUCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = skue.SKUCD } }, { "@ItemCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = skue.ITemCD } }, { "@MakerItem", new ValuePair { value1 = SqlDbType.Int, value2 = skue.MakerItem } }, { "@SportsCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = skue.SportsCD } }, { "@ReserveCD", new ValuePair { value1 = SqlDbType.Int, value2 = skue.ReserveCD } }, { "@NoticesCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = skue.NoticesCD } }, { "@PostageCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = skue.PostageCD } }, { "@OrderAttentionCD", new ValuePair { value1 = SqlDbType.Int, value2 = skue.OrderAttentionCD } }, { "@YearTerm", new ValuePair { value1 = SqlDbType.Int, value2 = info.YearTerm } }, { "@Season", new ValuePair { value1 = SqlDbType.VarChar, value2 = info.Season } }, { "@CatalogNO", new ValuePair { value1 = SqlDbType.VarChar, value2 = info.CatalogNO } }, { "@InsturctionsNO", new ValuePair { value1 = SqlDbType.Int, value2 = info.InstructionsNO } }, { "@TagName1", new ValuePair { value1 = SqlDbType.Int, value2 = tage.TagName1 } }, { "@TagName2", new ValuePair { value1 = SqlDbType.Int, value2 = tage.TagName2 } }, { "@TagName3", new ValuePair { value1 = SqlDbType.VarChar, value2 = tage.TagName3 } }, { "@TagName4", new ValuePair { value1 = SqlDbType.VarChar, value2 = tage.TagName4 } }, { "@TagName5", new ValuePair { value1 = SqlDbType.Int, value2 = tage.TagName5 } }, }; return(SelectData(dic, "D_StockSelectForTairyuzaikohyo")); }
public DataTable D_StockSelectForTairyuzaikohyo(D_Stock_Entity dse,M_SKU_Entity mke,M_SKUInfo_Entity info,M_SKUTag_Entity tage) { return dsdl.D_StockSelectForTairyuzaikohyo(dse, mke, info, tage); }