public DataTable D_Delivery_SelectAll(D_Arrival_Entity de)
{
string sp = "D_Delivery_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ArrivalDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ArrivalDateFrom
} },
{ "@ArrivalDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ArrivalDateTo
} },
{ "@VendorCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.VendorCD
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.StoreCD
} },
{ "@SoukoType", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.SoukoType
} },
{ "@DirectFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.DirectFLG
} },
{ "@OrderKbn", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.OrderKbn
} },
//{ "@VendorDeliveryNo", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.VendorDeliveryNo } },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 仕入入力取得処理(入荷から)
/// ShiireNyuuryokuFromNyuukaよりデータ抽出時に使用
/// </summary>
public DataTable D_Arrival_SelectAllForShiire(D_Arrival_Entity de)
{
D_Arrival_DL dadl = new D_Arrival_DL();
DataTable dt = dadl.D_Arrival_SelectAllForShiire(de);
return(dt);
}
/// <summary>
/// 入荷番号検索
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_Arrival_SelectAll(D_Arrival_Entity de)
{
string sp = "D_Arrival_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ArrivalDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ArrivalDateFrom
} },
{ "@ArrivalDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ArrivalDateTo
} },
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.SoukoCD
} },
{ "@SKUCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.SKUCD
} },
{ "@JanCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JanCD
} },
{ "@VendorDeliveryNo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.VendorDeliveryNo
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 出荷指示入力取得処理(入荷から)
/// ShiireNyuuryokuFromNyuukaよりデータ抽出時に使用
/// </summary>
public DataTable D_Delivery_SelectAll(D_Arrival_Entity de)
{
D_Arrival_DL dadl = new D_Arrival_DL();
DataTable dt = dadl.D_Delivery_SelectAll(de);
return(dt);
}
public DataTable D_ArrivalPlan_Select(D_ArrivalPlan_Entity dape, D_Arrival_Entity dae, D_Purchase_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dape.SoukoCD
} },
{ "@CalcuArrivalPlanDate1", new ValuePair {
value1 = SqlDbType.Date, value2 = dape.CalcuArrivalPlanDate1
} },
{ "@CalcuArrivalPlanDate2", new ValuePair {
value1 = SqlDbType.Date, value2 = dape.CalcuArrivalPlanDate2
} },
{ "@FrmSoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dape.FrmSoukoCD
} },
{ "@ITEMCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dape.ITEMCD
} },
{ "@JanCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dape.JanCD
} },
{ "@SKUCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dape.SKUCD
} },
{ "@ArrivalDate1", new ValuePair {
value1 = SqlDbType.Date, value2 = dae.ArrivalDate1
} },
{ "@ArrivalDate2", new ValuePair {
value1 = SqlDbType.Date, value2 = dae.ArrivalDate2
} },
{ "@PurchaseSu", new ValuePair {
value1 = SqlDbType.Int, value2 = dae.PurchaseSu
} },
{ "@VendorDeliveryNo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dae.VendorDeliveryNo
} },
{ "@PurchaseDateFrom", new ValuePair {
value1 = SqlDbType.Date, value2 = dpe.PurchaseDateFrom
} },
{ "@PurchaseDateTo", new ValuePair {
value1 = SqlDbType.Date, value2 = dpe.PurchaseDateTo
} },
{ "@VendorCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.VendorCD
} },
{ "@StatusFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dape.statusFlg
} },
{ "@DisplayFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dape.DisplayFlg
} },
};
UseTransaction = true;
return(SelectData(dic, "D_ArrivalPlan_Select"));
}
/// <summary>
/// 入荷入力 入荷番号進捗チェック
/// 既に出荷済み,出荷指示済み,ピッキングリスト完了済み警告
/// </summary>
/// <param name="arrivalNO"></param>
/// <returns></returns>
public DataTable CheckNyuukaData(D_Arrival_Entity de)
{
string sp = "CheckNyuukaData";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ArrivalNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ArrivalNO
} },
};
return(SelectData(dic, sp));
}
private D_Arrival_Entity GetSearchInfo()
{
dae = new D_Arrival_Entity
{
ArrivalDateFrom = detailControls[(int)EIndex.DayStart].Text,
ArrivalDateTo = detailControls[(int)EIndex.DayEnd].Text,
SoukoCD = CboStoreCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboStoreCD.SelectedValue.ToString(),
SKUCD = detailControls[(int)EIndex.SKUCD].Text, //カンマ区切り
JanCD = detailControls[(int)EIndex.JanCD].Text, //カンマ区切り
VendorDeliveryNo = detailControls[(int)EIndex.VendorDeliveryNo].Text, //カンマ区切り
};
return(dae);
}
/// <summary>
/// 進捗チェック
/// 既に出荷済み,出荷指示済み,ピッキングリスト完了済み警告
/// </summary>
/// <param name="hacchuNo"></param>
/// <param name="errno"></param>
/// <returns></returns>
public bool CheckNyuukaData(D_Arrival_Entity de, out string errno)
{
DataTable dt = dadl.CheckNyuukaData(de);
bool ret = false;
errno = "";
if (dt.Rows.Count > 0)
{
errno = dt.Rows[0]["errno"].ToString();
}
return(ret);
}
/// <summary>
/// 入荷入力データ取得処理
/// NyuukaNyuuryokuよりデータ抽出時に使用
/// 新規時以外
/// </summary>
public DataTable D_Arrival_SelectData(D_Arrival_Entity de, short operationMode)
{
string sp = "D_Arrival_SelectData";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = operationMode.ToString()
} },
{ "@ArrivalNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.ArrivalNO
} },
};
return(SelectData(dic, sp));
}
public DataTable D_Arrival_Select(D_Arrival_Entity ode)
{
string sp = "D_Arrival_Select";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ArrivalNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = ode.ArrivalNO
} },
//{ "@OrderRows", new ValuePair { value1 = SqlDbType.Int, value2 = ode.OrderRows } },
{ "@VendorCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = ode.VendorCD
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 入荷入力更新処理
/// NyuukaNyuuryokuより更新時に使用
/// </summary>
/// <param name="dme"></param>
/// <param name="operationMode"></param>
/// <returns></returns>
public bool D_Arrival_Exec(D_Arrival_Entity dme, DataTable dt, short operationMode)
{
string sp = "PRC_NyuukaNyuuryoku";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString());
AddParam(command, "@ArrivalNO", SqlDbType.VarChar, dme.ArrivalNO);
AddParam(command, "@VendorDeliveryNo", SqlDbType.VarChar, dme.VendorDeliveryNo);
AddParam(command, "@StoreCD", SqlDbType.VarChar, dme.StoreCD);
AddParam(command, "@VendorCD", SqlDbType.VarChar, dme.VendorCD);
AddParam(command, "@ArrivalDate", SqlDbType.VarChar, dme.ArrivalDate);
AddParam(command, "@SoukoCD", SqlDbType.VarChar, dme.SoukoCD);
AddParam(command, "@StaffCD", SqlDbType.VarChar, dme.StaffCD);
AddParam(command, "@JANCD", SqlDbType.VarChar, dme.JanCD);
AddParam(command, "@AdminNO", SqlDbType.Int, dme.AdminNO);
AddParam(command, "@SKUCD", SqlDbType.VarChar, dme.SKUCD);
AddParam(command, "@ArrivalSu", SqlDbType.Int, dme.ArrivalSu);
AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt);
AddParam(command, "@Operator", SqlDbType.VarChar, dme.InsertOperator);
AddParam(command, "@PC", SqlDbType.VarChar, dme.PC);
//OUTパラメータの追加
string outPutParam = "@OutArrivalNO";
command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11);
command.Parameters[outPutParam].Direction = ParameterDirection.Output;
UseTransaction = true;
bool ret = InsertUpdateDeleteData(sp, ref outPutParam);
if (ret)
{
dme.ArrivalNO = outPutParam;
}
return(ret);
}
/// <summary>
/// Display event
/// </summary>
/// <param name="type"></param>
///
private void F11()
{
if (ErrorCheck())
{
dape = new D_ArrivalPlan_Entity
{
SoukoCD = cboWarehouse.SelectedValue.ToString(),
CalcuArrivalPlanDate1 = txtStockDate1.Text,
CalcuArrivalPlanDate2 = txtStockDate2.Text,
//FrmSoukoCD = cboSourceWH.SelectedValue.ToString(),
ITEMCD = ScItem.TxtCode.Text,
JanCD = ScJanCD.TxtCode.Text,
SKUCD = ScSKUCD.TxtCode.Text,
statusFlg = CheckValue1(),
DisplayFlg = CheckValue2(),
};
if (cboSourceWH.SelectedValue.ToString() == "-1")
{
dape.FrmSoukoCD = string.Empty;
}
dae = new D_Arrival_Entity
{
ArrivalDate1 = txtArrivalDay1.Text,
ArrivalDate2 = txtArrivalDay2.Text,
PurchaseSu = "0",
VendorDeliveryNo = txtDeliveryNote.Text,
};
dpe = new D_Purchase_Entity
{
PurchaseDateFrom = txtPurchaseDate1.Text,
PurchaseDateTo = txtPurchaseDate2.Text,
VendorCD = ScSupplier.TxtCode.Text,
};
dtSearch = nkskbl.D_ArrivalPlan_Select(dape, dae, dpe);
dgvNyuukaShoukai.DataSource = dtSearch;
}
}
protected override void ExecDisp()
{
bool exists = false;
for (int i = 0; i < detailControls.Length; i++)
{
if (i != (int)EIndex.SoukoCD && !string.IsNullOrWhiteSpace(detailControls[i].Text))
{
exists = true;
}
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
if (!exists)
{
nnbl.ShowMessage("E111");
detailControls[0].Focus();
return;
}
dae = GetSearchInfo();
DataTable dt = nnbl.D_Arrival_SelectAll(dae);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
nnbl.ShowMessage("E128");
}
}
/// <summary>
/// 入荷入力取得処理
/// NyuukaNyuuryokuよりデータ抽出時に使用
/// 新規時以外
/// </summary>
public DataTable D_Arrival_SelectData(D_Arrival_Entity de, short operationMode)
{
DataTable dt = dadl.D_Arrival_SelectData(de, operationMode);
return(dt);
}
/// <summary>
/// 入荷入力更新処理
/// NyuukaNyuuryokuより更新時に使用
/// </summary>
public bool Arrival_Exec(D_Arrival_Entity dae, DataTable dt, short operationMode)
{
return(dadl.D_Arrival_Exec(dae, dt, operationMode));
}
/// <summary>
/// 入荷番号検索にて使用
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_Arrival_SelectAll(D_Arrival_Entity de)
{
return(dadl.D_Arrival_SelectAll(de));
}
public DataTable D_ArrivalPlan_Select(D_ArrivalPlan_Entity dape, D_Arrival_Entity dae, D_Purchase_Entity dpe)
{
return(dapdl.D_ArrivalPlan_Select(dape, dae, dpe));
}
