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