public M_SKUInfo_Entity GetInfoEntity()
{
msInfo_Entity = new M_SKUInfo_Entity()
{
YearTerm = CB_year.SelectedValue.ToString(),
Season = CB_Season.SelectedValue.ToString(),
CatalogNO = TB_Catalog.Text.ToString(),
InstructionsNO = TB_Shijishobengo.Text,
};
return(msInfo_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"));
}
protected override void ExecDisp()
{
bool inputFlg = false;
for (int i = 0; i < detailControls.Length; i++)
{
if (!string.IsNullOrWhiteSpace(detailControls[i].Text))
{
inputFlg = true;
}
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
if (inputFlg == false)
{
//全てが空白(入力が無い)場合、エラーとする。
sbl.ShowMessage("E111");
return;
}
M_SKUInfo_Entity msie = new M_SKUInfo_Entity();
mse = GetSearchInfo(msie);
DataTable dt = sbl.M_SKU_SelectForSearchProduct(mse, msie);
if (dt.Rows.Count > 0)
{
//ストアドで実装するように変更
//if (!string.IsNullOrWhiteSpace(detailControls[(int)EIndex.ITemCD].Text))
//{
// string[] itemDt = detailControls[(int)EIndex.ITemCD].Text.Split(',');
// if (itemDt.Length > 0)
// {
// //foreach (DataRow dr in dt.Rows)
// for(int i=dt.Rows.Count-1; 0<=i; i--)
// {
// int index = Array.IndexOf(itemDt, dt.Rows[i]["ItemCD"].ToString());
// if (index < 0)
// {
// dt.Rows.Remove(dt.Rows[i]);
// }
// }
// }
//}
//if (!string.IsNullOrWhiteSpace(detailControls[(int)EIndex.MakerItem].Text))
//{
// string[] makerDt = detailControls[(int)EIndex.MakerItem].Text.Split(',');
// if (makerDt.Length > 0)
// {
// for (int i = dt.Rows.Count - 1; 0 <= i; i--)
// {
// int index = Array.IndexOf(makerDt, dt.Rows[i]["MakerItem"].ToString());
// if (index < 0)
// {
// dt.Rows.Remove(dt.Rows[i]);
// }
// }
// }
//}
if (ChkSearch.Checked)
{
string[] item = new string[dt.Rows.Count];
int itemCount = 0;
if (ckM_RadioButton3.Checked)
{
foreach (DataRow dr in dt.Rows)
{
int index = Array.IndexOf(item, dr["ItemCD"].ToString());
if (index < 0)
{
item[itemCount] = dr["ItemCD"].ToString();
itemCount++;
}
}
string val = "";
for (int i = 0; i < itemCount; i++)
{
if (i == 0)
{
val += item[i];
}
else
{
val += "," + item[i];
}
}
detailControls[(int)EIndex.ITemCD].Text = val;
}
else
{
foreach (DataRow dr in dt.Rows)
{
int index = Array.IndexOf(item, dr["MakerItem"].ToString());
if (index < 0)
{
item[itemCount] = dr["MakerItem"].ToString();
itemCount++;
}
}
string val = "";
for (int i = 0; i < itemCount; i++)
{
if (i == 0)
{
val += item[i];
}
else
{
val += "," + item[i];
}
}
detailControls[(int)EIndex.MakerItem].Text = val;
}
}
GvDetail.DataSource = dt;
GvDetail.ScrollBars = ScrollBars.Both;
GvDetail.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
GvDetail.CurrentRow.Selected = true;
if (Mode == "5")
{
GvDetail.ReadOnly = false;
for (int i = 0; i < GvDetail.ColumnCount; i++)
{
if (i.Equals(0))
{
GvDetail.Columns[i].ReadOnly = false;
}
else
{
GvDetail.Columns[i].ReadOnly = true;
}
}
}
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
sbl.ShowMessage("E128");
}
}
private M_SKU_Entity GetSearchInfo(M_SKUInfo_Entity msie)
{
string rsvCd = "";
if (cboReserveCD.SelectedValue != null)
{
if (!cboReserveCD.SelectedValue.Equals("-1"))
{
rsvCd = cboReserveCD.SelectedValue.ToString();
}
}
string posCd = "";
if (cboPostageCD.SelectedValue != null)
{
if (!cboPostageCD.SelectedValue.Equals("-1"))
{
posCd = cboPostageCD.SelectedValue.ToString();
}
}
string notCd = "";
if (cboNoticesCD.SelectedValue != null)
{
if (!cboNoticesCD.SelectedValue.Equals("-1"))
{
notCd = cboNoticesCD.SelectedValue.ToString();
}
}
string orACd = "";
if (cboOrderAttentionCD.SelectedValue != null)
{
if (!cboOrderAttentionCD.SelectedValue.Equals("-1"))
{
orACd = cboOrderAttentionCD.SelectedValue.ToString();
}
}
string tag1 = "";
if (cboTagName1.SelectedValue != null)
{
if (!cboTagName1.SelectedValue.Equals("-1"))
{
tag1 = cboTagName1.SelectedText;
}
}
string tag2 = "";
if (cboTagName2.SelectedValue != null)
{
if (!cboTagName2.SelectedValue.Equals("-1"))
{
tag2 = cboTagName2.SelectedText;
}
}
string tag3 = "";
if (cboTagName3.SelectedValue != null)
{
if (!cboTagName3.SelectedValue.Equals("-1"))
{
tag3 = cboTagName3.SelectedText;
}
}
string tag4 = "";
if (cboTagName4.SelectedValue != null)
{
if (!cboTagName4.SelectedValue.Equals("-1"))
{
tag4 = cboTagName4.Text;
}
}
string tag5 = "";
if (cboTagName5.SelectedValue != null)
{
if (!cboTagName5.SelectedValue.Equals("-1"))
{
tag5 = cboTagName5.SelectedText;
}
}
mse = new M_SKU_Entity
{
MainVendorCD = detailControls[(int)EIndex.VendorCd].Text,
BrandCD = detailControls[(int)EIndex.BrandCD].Text,
SKUName = detailControls[(int)EIndex.SKUName].Text,
JanCD = detailControls[(int)EIndex.JanCD].Text,
SKUCD = detailControls[(int)EIndex.SKUCD].Text,
CommentInStore = detailControls[(int)EIndex.CommentInStore].Text, //カンマ区切り
ReserveCD = rsvCd,
NoticesCD = notCd,
PostageCD = posCd,
OrderAttentionCD = orACd,
SportsCD = detailControls[(int)EIndex.SportsCD].Text,
TagName1 = cboTagName1.Text,
TagName2 = cboTagName2.Text,
TagName3 = cboTagName3.Text,
TagName4 = cboTagName4.Text,
TagName5 = cboTagName5.Text,
//ClassificationA = scClassificationA.TxtCode.Text,
//ClassificationB = scClassificationB.TxtCode.Text,
//ClassificationC = scClassificationC.TxtCode.Text,
MakerItem = detailControls[(int)EIndex.MakerItem].Text, //カンマ区切り
ITemCD = detailControls[(int)EIndex.ITemCD].Text, //カンマ区切り
InputDateFrom = detailControls[(int)EIndex.InputStart].Text,
InputDateTo = detailControls[(int)EIndex.InputEnd].Text,
UpdateDateFrom = detailControls[(int)EIndex.UpdateStart].Text,
UpdateDateTo = detailControls[(int)EIndex.UpdateEnd].Text,
ApprovalDateFrom = detailControls[(int)EIndex.DayStart].Text,
ApprovalDateTo = detailControls[(int)EIndex.DayEnd].Text,
ChangeDate = this.ChangeDate,
};
msie.YearTerm = CboYearTerm.SelectedValue.Equals("-1") ? string.Empty : CboYearTerm.SelectedValue.ToString();
msie.Season = CboSeason.SelectedValue.Equals("-1") ? string.Empty : CboSeason.SelectedValue.ToString();
msie.CatalogNO = detailControls[(int)EIndex.CatalogNO].Text;
msie.InstructionsNO = detailControls[(int)EIndex.InstructionsNO].Text;
if (ckM_RadioButton1.Checked)
{
mse.OrOrAnd = "0";
}
else
{
mse.OrOrAnd = "1";
}
if (ChkSearch.Checked)
{
mse.SearchFlg = "1";
if (ckM_RadioButton3.Checked)
{
mse.ItemOrMaker = "0";
}
else
{
mse.ItemOrMaker = "1";
}
}
else
{
mse.SearchFlg = "0";
}
return(mse);
}
public DataTable M_SKU_SelectForSearchProduct(M_SKU_Entity mse, M_SKUInfo_Entity msie)
{
return(mdl.M_SKU_SelectForSearchProduct(mse, msie));
}
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 M_SKU_SelectForSearchProduct(M_SKU_Entity mse, M_SKUInfo_Entity msie)
{
string sp = "M_SKU_SelectForSearchProduct";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@MainVendorCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.MainVendorCD
} },
{ "@BrandCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.BrandCD
} },
{ "@SKUName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SKUName
} },
{ "@JanCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.JanCD
} },
{ "@SKUCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SKUCD
} },
{ "@CommentInStore", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.CommentInStore
} },
{ "@OrOrAnd", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.OrOrAnd
} },
{ "@ReserveCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ReserveCD
} },
{ "@NoticesCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.NoticesCD
} },
{ "@PostageCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.PostageCD
} },
{ "@OrderAttentionCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.OrderAttentionCD
} },
{ "@SportsCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SportsCD
} },
{ "@TagName1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.TagName1
} },
{ "@TagName2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.TagName2
} },
{ "@TagName3", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.TagName3
} },
{ "@TagName4", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.TagName4
} },
{ "@TagName5", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.TagName5
} },
//{ "@ClassificationA", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.ClassificationA } },
//{ "@ClassificationB", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.ClassificationB } },
//{ "@ClassificationC", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.ClassificationC } },
{ "@YearTerm", new ValuePair {
value1 = SqlDbType.VarChar, value2 = msie.YearTerm
} },
{ "@Season", new ValuePair {
value1 = SqlDbType.VarChar, value2 = msie.Season
} },
{ "@CatalogNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = msie.CatalogNO
} },
{ "@InstructionsNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = msie.InstructionsNO
} },
{ "@MakerItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.MakerItem
} },
{ "@ITemCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ITemCD
} },
{ "@InputDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.InputDateFrom
} },
{ "@InputDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.InputDateTo
} },
{ "@UpdateDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.UpdateDateFrom
} },
{ "@UpdateDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.UpdateDateTo
} },
{ "@ApprovalDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ApprovalDateFrom
} },
{ "@ApprovalDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ApprovalDateTo
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ChangeDate
} },
{ "@SearchFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.SearchFlg
} },
{ "@ItemOrMaker", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.ItemOrMaker
} },
};
return(SelectData(dic, sp));
}
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);
}