/// <summary>
/// Get Searching Data
/// </summary>
/// <returns></returns>
private ItemSearch_Entity GetData()
{
ise = new ItemSearch_Entity();
ise.makercd = ucSupplier.UC_Code;
if (!string.IsNullOrWhiteSpace(txtInportDate.Text.Replace("/", "")))
{
ise.InportDate = txtInportDate.Text;
}
ise.Zaiko0 = chkZaikoSuZero.Checked ? "1" : string.Empty;
ise.FirstInport = chkJANCDcut.Checked ? "1" : string.Empty;
ise.brand = ucBrand.UC_Code;
ise.catalog = txtCatalogue.Text;
ise.nendo = cboNendo.SelectedValue.ToString();
ise.season = cboSeason.SelectedValue.ToString();
ise.itemCode = ucITEM.UC_Code;
ise.skucd = ucSKUCD.UC_Code;
ise.makerShohin = ucMakerItem.UC_Code;
ise.jancd = ucJANCD1.UC_Code.TrimStart(',').TrimEnd(',');
if (chkSearch.Checked && (!string.IsNullOrWhiteSpace(ucITEM.UC_Code) || !string.IsNullOrWhiteSpace(ucSKUCD.UC_Code) || !string.IsNullOrWhiteSpace(ucJANCD1.UC_Code)))
{
if (rdoItem.Checked)
{
ise.itemCheck = "1";
}
else
{
ise.makerCheck = "1";
}
}
return(ise);
}
public DataTable PSKS0110S_Select(ItemSearch_Entity ise)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@ItemName", ise.itemName);
dic.Add("@SpecialFlg", ise.specialFlag);
dic.Add("@YoyakuFlg", ise.yoyakuFlg);
dic.Add("@SportsCD", ise.sports);
dic.Add("@BunruiCD", ise.bunrui);
dic.Add("@SupplierCD", ise.supplier);
dic.Add("@BarndCD", ise.brand);
dic.Add("@Nendo", ise.nendo);
dic.Add("@Season", ise.season);
dic.Add("@Catalog", ise.catalog);
dic.Add("@Shijisho", ise.shijisho);
dic.Add("@MakerCD", ise.makercd);
dic.Add("@ItemCD", ise.itemCode);
dic.Add("@JANCD", ise.jancd);
dic.Add("@WebTenpo", ise.webTenpo);
dic.Add("@zaikoExists", ise.zaikoExists);
dic.Add("@SKUCD", ise.skucd);
dic.Add("@ItemCheck", ise.itemCheck);
dic.Add("@MakerCheck", ise.makerCheck);
dic.Add("@MakerLikeSearch", ise.makerLikeSearch);
return(SelectData(dic, "PSKS0110S_Select"));
}
/// <summary>
/// Get Search Data
/// </summary>
/// <returns></returns>
public ItemSearch_Entity GetData()
{
ise = new ItemSearch_Entity();
ise.itemName = txtItemName.Text;
try
{
ise.specialFlag = cboSpecialFlag.SelectedValue.ToString();
}catch
{
ise.specialFlag = "-1";
}
try{ ise.yoyakuFlg = cboYoyakuFlg.SelectedValue.ToString(); }
catch
{
ise.yoyakuFlg = "-1";
}
try{
ise.nendo = cboNendo.SelectedValue.ToString();
}
catch
{
ise.nendo = "-1";
} try{
ise.season = cboSeason.SelectedValue.ToString();
}
catch
{
ise.season = "-1";
}
ise.sports = ucKyouGiName.UC_Code;
ise.bunrui = ucCategory.UC_Code;
ise.brand = ucBrand.UC_Code;
ise.supplier = ucSupplier.UC_Code;
//ise.nendo = cboNendo.SelectedValue.ToString();
//ise.season = cboSeason.SelectedValue.ToString();
ise.catalog = txtCatalog.Text;
ise.shijisho = txtShijisho.Text;
ise.makercd = txtMakerShohinCD.Text.TrimStart(',').TrimEnd(',').Trim().Replace("\r\n", string.Empty);
ise.itemCode = txtItem.Text.TrimStart(',').TrimEnd(',').Trim().Replace("\r\n", string.Empty);
ise.jancd = txtJANCD.Text.TrimStart(',').TrimEnd(',').Trim().Replace("\r\n", string.Empty);;
ise.webTenpo = chkWebTenpo.Checked ? "1" : "0";
ise.zaikoExists = chkZaikoExists.Checked ? "1" : "0";
ise.skucd = ucSKUCD.UC_Code;
if (chkSearch.Checked && (!string.IsNullOrWhiteSpace(txtItem.Text) || !string.IsNullOrWhiteSpace(ucSKUCD.UC_Code) || !string.IsNullOrWhiteSpace(txtJANCD.Text)))
{
ise.itemCheck = rdoItem.Checked ? "1" : string.Empty;
ise.makerCheck = rdoMakerItemCD.Checked ? "1" : string.Empty;
}
if (!string.IsNullOrWhiteSpace(txtMakerShohinCD.Text))
{
ise.makerLikeSearch = chkMakerLikeSearch.Checked ? "1" : string.Empty;
}
return(ise);
}
/// <summary>
/// Get Search Data
/// </summary>
/// <returns></returns>
private ItemSearch_Entity GetItemSearch_Entity()
{
ise = new ItemSearch_Entity();
ise.makercd = txtmakercd.Text;
ise.itemName = txtItemName.Text;
ise.itemCode = txtItemcd.Text;
ise.skucd = txtskucd.Text;
ise.jancd = txtJancd.Text;
ise.supplier = ucSupplier.UC_Code;
ise.brand = ucBrand.UC_Code;
ise.sports = ucKyouGiName.UC_Code;
ise.category = ucCategory.UC_Code;
if (chkSearch.Checked && (!string.IsNullOrWhiteSpace(txtJancd.Text) || !string.IsNullOrWhiteSpace(txtskucd.Text) || !string.IsNullOrWhiteSpace(txtItemcd.Text)))
{
if (rdoITEM.Checked)
{
ise.itemCheck = "1";
}
else
{
ise.makerCheck = "1";
}
}
return(ise);
}
private void DisplayData()
{
Cursor.Current = Cursors.WaitCursor;
dtPSKS0102S = new DataTable();
OperatorCD = loginInfo.OperatorCode;
ise = Getdata();
dtPSKS0102S = new DataTable();
dtPSKS0102S = p102Sbl.PSKS0120S_Select(ise, OperatorCD);
dgvPSKS0102S.DataSource = dtPSKS0102S;
Cursor.Current = Cursors.Default;
btnDisplay.Focus();
}
private void DisplayData()
{
if (ErrorCheck())
{
Cursor.Current = Cursors.WaitCursor;
//tze = new T_Zaiko_Entity();
//string qty = tze.CapitalZaiko;
ise = GetData();
dt_PSKS0110S = psks0110sbl.PSKS0110S_Search_Select(ise);
dgvPSKS0110S.DataSource = dt_PSKS0110S;
Cursor.Current = Cursors.Default;
btnDisplay.Focus();
}
}
public DataTable PCMN0101K_Search(ItemSearch_Entity ise)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@VC_MAKER_SHOHIN", ise.makercd);
dic.Add("@VC_KYOGI_CATEGORY", ise.sports);
dic.Add("@VC_SHOHIN_CATEGORY", ise.category);
dic.Add("@VC_SHOHIN", ise.itemCode);
dic.Add("@VC_BRAND", ise.brand);
dic.Add("@VC_SHIIRESAKI", ise.supplier);
dic.Add("@SKUCD_S", ise.skucd);
dic.Add("@vm_hanbai_shohin", ise.itemName);
dic.Add("@ItemCheck", ise.itemCheck);
dic.Add("@MakerCheck", ise.makerCheck);
dic.Add("@VC_JAN1", ise.jancd);
return(SelectData(dic, "PCMN0101K_Search"));
}
/// <summary>
/// Display Data for GridView
/// </summary>
private void F11()
{
count = 0; // reset count
if (!string.IsNullOrWhiteSpace(txtmakercd.Text) || !string.IsNullOrWhiteSpace(txtItemcd.Text) || !string.IsNullOrWhiteSpace(txtItemName.Text) || !string.IsNullOrWhiteSpace(txtJancd.Text) || !string.IsNullOrWhiteSpace(txtskucd.Text) ||
!string.IsNullOrWhiteSpace(ucBrand.UC_Code) || !string.IsNullOrWhiteSpace(ucSupplier.UC_Code) || !string.IsNullOrWhiteSpace(ucKyouGiName.UC_Code) || !string.IsNullOrWhiteSpace(ucCategory.UC_Code))
{
Cursor.Current = Cursors.WaitCursor;
ise = GetItemSearch_Entity();
DataTable dt = pcmn0101kbl.PCMN0101K_Search(ise);
gv_pcmnk.DataSource = dt;
Cursor.Current = Cursors.Default;
}
else
{
DSP_MSG("E111", "名前", string.Empty, string.Empty, string.Empty, string.Empty);
}
}
/// <summary>
/// Display Data for GridView
/// </summary>
protected void Search()
{
if (!string.IsNullOrWhiteSpace(ucSupplier.UC_Code))
{
Cursor.Current = Cursors.WaitCursor;
DataTable dtmakerinput = new DataTable();
ise = GetData();
//dt_PSKS0104I = new DataTable();
dt_PSKS0104I = psks0104ibl.PSKS0104I_Select(ise);
dgvPSK0104I.DataSource = dt_PSKS0104I;
DisabledCtrl();
}
else
{
DSP_MSG("E102", "名前", string.Empty, string.Empty, string.Empty, string.Empty);
ucSupplier.SetFocus();
}
}
public DataTable PSKS0104I_Select(ItemSearch_Entity ise)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@VC_SHIIRESAKI", ise.makercd);
dic.Add("@InportDateTime", ise.InportDate);
dic.Add("@VC_BRAND", ise.brand);
dic.Add("@VO_CATALOG", ise.catalog);
dic.Add("@VK_NENDO", ise.nendo);
dic.Add("@VK_SEASON", ise.season);
dic.Add("@Item", ise.itemCode);
dic.Add("@SKUCD", ise.skucd);
dic.Add("@VC_JAN1", ise.jancd);
dic.Add("@ItemCheck", ise.itemCheck);
dic.Add("@MakerCheck", ise.makerCheck);
dic.Add("@Zaiko0", ise.Zaiko0);
dic.Add("@FirstInport", ise.FirstInport);
dic.Add("@VC_MAKER_SHOHIN", ise.makerShohin);
return(SelectData(dic, "PSKS0104I_SELECT"));
}
/// <summary>
/// Display Data for GridView
/// repaied by PTK 02182019
/// </summary>
private void DisplayData()
{
if (ErrorCheck())
{
Cursor.Current = Cursors.WaitCursor;
tze = new T_Zaiko_Entity();
string qty = tze.CapitalZaiko;
ise = GetData();
dt_PSKS0110S = psks0110sbl.PSKS0110S_Select(ise);
if (dt_PSKS0110S.Rows.Count > 0)
{
//if(dt_PSKS0110S !=null || dt_PSKS0110S.Rows.Count>0)
//{
dgvPSKS0110S.DataSource = dt_PSKS0110S;
Cursor.Current = Cursors.Default;
btnDisplay.Focus();
}
else
{
DSP_MSG("E128", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
}
}
}
public DataTable PSKS0120S_Select(ItemSearch_Entity ise, string OperatorCD)
{
return(Isdl.PSKS0120S_Select(ise, OperatorCD));
}
public DataTable PSKS0110S_Search_Select(ItemSearch_Entity ise)
{
return(isdl.PSKS0110S_Search_Select(ise));
}
public DataTable PCMN0101K_Search(ItemSearch_Entity ise)
{
return(isdl.PCMN0101K_Search(ise));
}
