/// <summary>
/// 返品入力取得処理(入荷から)
/// HenpinNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_Stock_SelectAllForShiireH(D_Stock_Entity de)
{
D_Stock_DL dadl = new D_Stock_DL();
DataTable dt = dadl.D_Stock_SelectAllForShiireH(de);
return(dt);
}
public DataTable D_Stock_SelectAllForShiireH(D_Stock_Entity de)
{
string sp = "D_Stock_SelectAllForShiireH";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ExpectReturnDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ExpectReturnDateFrom
} },
{ "@ExpectReturnDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ExpectReturnDateTo
} },
{ "@VendorCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.VendorCD
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.StoreCD
} },
{ "@F10", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.F10.ToString()
} }
};
return(SelectData(dic, sp));
}
public DataTable SelectDataForPrint(D_Stock_Entity dse, string option)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.SoukoCD
} },
{ "@SKUCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.SKUCD
} },
{ "@ArrivalStartDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.ArrivalStartDate.Replace('/', '-')
} },
{ "@ArrivalEndDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.ArrivalEndDate.Replace('/', '-')
} },
{ "@RegisterFlg", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.RegisterFlg
} },
{ "@LocationFlg", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.LocationFlg
} },
{ "@Option", new ValuePair {
value1 = SqlDbType.VarChar, value2 = option
} },
};
return(SelectData(dic, "TanaireList_DataSelect"));
}
public bool M_Location_InsertUpdate(D_Stock_Entity dse, M_Location_Entity mle)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@xml", new ValuePair {
value1 = SqlDbType.Xml, value2 = dse.xml1
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.Operator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.Key
} },
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "M_Location_InsertUpdate"));
}
public Select_RackNO(D_Stock_Entity ds)
{
InitializeComponent();
HeaderTitleText = ProNm;
this.Text = ProNm;
dse = ds;
}
public D_Stock_Entity GetStockEntity()
{
ds_Entity = new D_Stock_Entity()
{
SoukoCD = CB_Soko.SelectedValue.ToString(),
RackNOFrom = TB_RackNoF.Text,
RackNOTo = TB_RackNoT.Text,
};
return(ds_Entity);
}
public DataTable D_Stock_SelectRackNO(D_Stock_Entity de)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.SoukoCD
} },
{ "@AdminNO", new ValuePair {
value1 = SqlDbType.Int, value2 = de.AdminNO
} },
};
return(SelectData(dic, "D_Stock_SelectRackNO"));
}
public bool D_Stock_SelectSuryo(D_Stock_Entity de)
{
D_Stock_DL dsdl = new D_Stock_DL();
DataTable dt = dsdl.D_Stock_SelectSuryo(de);
if (dt.Rows.Count == 0)
{
return(false);
}
if (Z_Set(dt.Rows[0]["StockSu"]) < Z_Set(de.StockSu) || Z_Set(dt.Rows[0]["AllowableSu"]) < Z_Set(de.StockSu))
{
return(false);
}
return(true);
}
private D_Stock_Entity GetDStockEntity()
{
string regFlg = string.Empty;
string locateFlg = string.Empty;
if (chkUnregistered.Checked && chkRegistered.Checked)
{
regFlg = "両方";
}
else if (chkUnregistered.Checked)
{
regFlg = "未登録";
}
else if (chkRegistered.Checked)
{
regFlg = "登録済";
}
if (chkLocationAri.Checked && chkLocationNashi.Checked)
{
locateFlg = "両方";
}
else if (chkLocationAri.Checked)
{
locateFlg = "あり";
}
else if (chkLocationNashi.Checked)
{
locateFlg = "なし";
}
dse = new D_Stock_Entity
{
SoukoCD = cboSouko.SelectedValue.ToString(),
SKUCD = ScSKUCD.Code,
ArrivalStartDate = txtStartDate.Text,
ArrivalEndDate = txtEndDate.Text,
RegisterFlg = regFlg,
LocationFlg = locateFlg,
};
return(dse);
}
private void InsertUpdate(D_Stock_Entity dse, M_Location_Entity mle)
{
//*** Insert Update Function
if (tnbnBL.M_Location_InsertUpdate(dse, mle))
{
//Clear(PanelHeader);
////Clear(panelDetail);
//BindCombo();
//chkNotRegister.Checked = true;
//ScStorage.Value1 = cboWarehouse.SelectedValue.ToString();
//dgvTanaban.ClearSelection();
//txtArrivalDateFrom.Focus();
Clear();
tnbnBL.ShowMessage("I101");
}
else
{
tnbnBL.ShowMessage("S001");
}
}
private void F12()
{
if (ErrorCheck(12))
{
if (tnbnBL.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
{
mle = new M_Location_Entity();
dse = new D_Stock_Entity();
DataTable dtUpdate = new DataTable();
dtUpdate.Columns.Add("RackNo");
dtUpdate.Columns.Add("StockNo");
foreach (DataGridViewRow row in dgvTanaban.Rows)
{
//bool chk =(bool)row.Cells["colChk"].Value;
//if(chk)
//{
DataRow dtrow = dtUpdate.NewRow();
dtrow["RackNo"] = row.Cells["colRackNo1"].Value.ToString();
dtrow["StockNo"] = row.Cells["colStockNo"].Value.ToString();
dtUpdate.Rows.Add(dtrow);
//}
}
dse = new D_Stock_Entity
{
dt1 = dtUpdate,
};
mle = GetEntity();
InsertUpdate(dse, mle);
}
else
{
PreviousCtrl.Focus();
}
}
}
public DataTable M_Location_DataSelect(D_Stock_Entity dse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ArrivalStartDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.ArrivalStartDate
} },
{ "@ArrivalEndDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.ArrivalEndDate
} },
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dse.SoukoCD
} },
{ "@Unregister", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dse.UnregisterFlg
} },
{ "@Register", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dse.RegisterFlg
} }
};
return(SelectData(dic, "M_Location_DataSelect"));
}
/// <summary>
/// Display event
/// </summary>
/// <param name="type"></param>
///
private void F11()
{
if (ErrorCheck(11))
{
dse = GetStockEntity();
dtstorage = tnbnBL.M_Location_DataSelect(dse);
if (dtstorage.Rows.Count == 0)
{
tnbnBL.ShowMessage("E128");
dgvTanaban.DataSource = string.Empty;
txtArrivalDateFrom.Focus();
}
else
{
dgvTanaban.DataSource = dtstorage;
}
}
else
{
dgvTanaban.DataSource = string.Empty;
}
}
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 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 void F12()
//{
// tnlbl = new TanaireList_BL();
// if (ErrorCheck(12))
// {
// if (tnlbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
// {
// dse = GetDStockEntity();
// //if (string.IsNullOrWhiteSpace(ScSKUCD.Code))
// // dtPrint = tnlbl.SelectDataForPrint(dse,"1");
// //else
// // dtPrint = tnlbl.SelectDataForPrint(dse,"2");
// //PrintSec();
// }
// else
// PreviousCtrl.Focus();
// }
//}
protected override void PrintSec()
{
// レコード定義を行う
// DataTable table = new DataTable();
tnlbl = new TanaireList_BL();
string header = string.Empty;
DataTable dtPrint = new DataTable();
if (ErrorCheck())
{
dse = GetDStockEntity();
if (!string.IsNullOrWhiteSpace(ScSKUCD.Code))
{
dtPrint = tnlbl.SelectDataForPrint(dse, "1");
header = "棚入れリスト";
}
else
{
dtPrint = tnlbl.SelectDataForPrint(dse, "2");
header = "棚入れリスト(履歴）";
}
try
{
if (dtPrint.Rows.Count <= 0 || dtPrint == null)
{
bbl.ShowMessage("E128");
txtStartDate.Focus();
}
else
{
//xsdファイルを保存します。
//①保存した.xsdはプロジェクトに追加しておきます。
DialogResult ret;
TanaireList_Report Report = new TanaireList_Report();
switch (PrintMode)
{
case EPrintMode.DIRECT:
ret = bbl.ShowMessage("Q202");
if (ret == DialogResult.No)
{
return;
}
//}
// 印字データをセット
Report.SetDataSource(dtPrint);
Report.Refresh();
Report.SetParameterValue("txtSouko", cboSouko.SelectedValue.ToString() + " " + cboSouko.Text);
Report.SetParameterValue("txtHeader", header);
if (ret == DialogResult.Yes)
{
var previewForm = new Viewer();
previewForm.CrystalReportViewer1.ShowPrintButton = true;
previewForm.CrystalReportViewer1.ReportSource = Report;
previewForm.ShowDialog();
}
else /// //Still Not Working because of Applymargin and Printer not Setting up (PTK Will Solve)
{
//int marginLeft = 360;
CrystalDecisions.Shared.PageMargins margin = Report.PrintOptions.PageMargins;
margin.leftMargin = DefaultMargin.Left; // mmの指定をtwip単位に変換する
margin.topMargin = DefaultMargin.Top;
margin.bottomMargin = DefaultMargin.Bottom; //mmToTwip(marginLeft);
margin.rightMargin = DefaultMargin.Right;
Report.PrintOptions.ApplyPageMargins(margin); /// Error Now
// プリンタに印刷
System.Drawing.Printing.PageSettings ps;
try
{
System.Drawing.Printing.PrintDocument pDoc = new System.Drawing.Printing.PrintDocument();
CrystalDecisions.Shared.PrintLayoutSettings PrintLayout = new CrystalDecisions.Shared.PrintLayoutSettings();
System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings();
Report.PrintOptions.PrinterName = "\\\\dataserver\\Canon LBP2900";
System.Drawing.Printing.PageSettings pSettings = new System.Drawing.Printing.PageSettings(printerSettings);
Report.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true;
Report.PrintOptions.PrinterDuplex = PrinterDuplex.Simplex;
Report.PrintToPrinter(printerSettings, pSettings, false, PrintLayout);
}
catch (Exception ex)
{
}
}
break;
case EPrintMode.PDF:
if (bbl.ShowMessage("Q204") != DialogResult.Yes)
{
return;
}
string filePath = "";
if (!ShowSaveFileDialog(InProgramNM, out filePath))
{
return;
}
// 印字データをセット
Report.SetDataSource(dtPrint);
Report.Refresh();
Report.SetParameterValue("txtSouko", cboSouko.SelectedValue.ToString() + " " + cboSouko.Text);
Report.SetParameterValue("txtHeader", header);
bool result = OutputPDF(filePath, Report);
//PDF出力が完了しました。
bbl.ShowMessage("I202");
break;
}
InsertLog(Get_L_Log_Entity(dtPrint));
}
//else
//{
// bbl.ShowMessage("E128");
// txtStartDate.Focus();
// }
}
finally
{
}
}
}
public DataTable D_Stock_SelectRackNO(D_Stock_Entity de)
{
D_Stock_DL dsdl = new D_Stock_DL();
return(dsdl.D_Stock_SelectRackNO(de));
}
public bool M_Location_InsertUpdate(D_Stock_Entity dse, M_Location_Entity mle)
{
dse.xml1 = DataTableToXml(dse.dt1);
return(mldl.M_Location_InsertUpdate(dse, mle));
}
public DataTable M_Location_DataSelect(D_Stock_Entity dse)
{
return(mldl.M_Location_DataSelect(dse));
}
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 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 DataTable SelectDataForPrint(D_Stock_Entity dse, string option)
{
return(dsdl.SelectDataForPrint(dse, option));
}
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 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);
}
