/// <summary>
/// エラーチェック処理
/// </summary>
/// <param name="set">画面展開なしの場合:falesに設定する</param>
/// <returns></returns>
private bool CheckData()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i, false) == false)
{
detailControls[i].Focus();
return(false);
}
}
DataTable dt;
if (RdoNotOutput.Checked)
{
doe = GetEntityForOrder();
dt = mibl.D_Order_SelectAllForEDIHacchuu(doe);
//以下の条件でデータが存在しなければエラー (Error if record does not exist)Ｅ１３３
if (dt.Rows.Count == 0)
{
bbl.ShowMessage("E133");
previousCtrl.Focus();
return(false);
}
}
return(true);
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
//更新処理
doe = GetEntity();
DataTable dt = mibl.D_Order_SelectAllForSyonin(doe);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
bbl.ShowMessage("E128");
}
}
public DataTable D_Order_SelectAllForEDIHacchuu(D_Order_Entity doe)
{
string sp = "D_Order_SelectAllForEDIHacchuu";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.StoreCD
} },
{ "@OrderDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderDateFrom
} },
{ "@OrderDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderDateTo
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.StaffCD
} },
{ "@OrderCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderCD
} },
{ "@OrderNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderNO
} },
{ "@ChkMisyonin", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.ChkMisyonin.ToString()
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 発注承認入力データ取得処理
/// </summary>
/// <param name="doe"></param>
/// <returns></returns>
public DataTable D_Order_SelectAllForSyonin(D_Order_Entity doe)
{
string sp = "D_Order_SelectAllForSyonin";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OrderDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderDateFrom
} },
{ "@OrderDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderDateTo
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.StoreCD
} },
{ "@ApprovalStageFLG", new ValuePair {
value1 = SqlDbType.Int, value2 = doe.ApprovalStageFLG
} },
{ "@Misyonin", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = doe.Misyonin.ToString()
} },
{ "@SyoninZumi", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = doe.SyoninZumi.ToString()
} },
{ "@Kyakka", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = doe.Kyakka.ToString()
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 回答納期登録更新処理
/// KaitouNoukiTourokuより更新時に使用
/// </summary>
/// <param name="dme"></param>
/// <param name="operationMode"></param>
/// <param name="operatorNm"></param>
/// <param name="pc"></param>
/// <returns></returns>
public bool D_Order_ExecForKaitouNouki(D_Order_Entity dme, DataTable dt, short operationMode, string operatorNm, string pc)
{
string sp = "PRC_KaitouNoukiTouroku";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString());
AddParam(command, "@StoreCD", SqlDbType.VarChar, dme.StoreCD);
AddParam(command, "@OrderCD", SqlDbType.VarChar, dme.OrderCD);
AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt);
AddParam(command, "@Operator", SqlDbType.VarChar, operatorNm);
AddParam(command, "@PC", SqlDbType.VarChar, pc);
////OUTパラメータの追加
//string outPutParam = "@OutOrderNo";
//command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11);
//command.Parameters[outPutParam].Direction = ParameterDirection.Output;
UseTransaction = true;
string outPutParam = ""; //未使用
bool ret = InsertUpdateDeleteData(sp, ref outPutParam);
//if (ret)
// dme.OrderNO = outPutParam;
return(ret);
}
public DataTable D_Order_SelectDataForKaitouNouki(D_Order_Entity doe)
{
string sp = "D_Order_SelectDataForKaitouNouki";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ArrivalPlanDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.ArrivalPlanDateFrom
} },
{ "@ArrivalPlanDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.ArrivalPlanDateTo
} },
{ "@ArrivalPlanMonthFrom", new ValuePair {
value1 = SqlDbType.Int, value2 = doe.ArrivalPlanMonthFrom
} },
{ "@ArrivalPlanMonthTo", new ValuePair {
value1 = SqlDbType.Int, value2 = doe.ArrivalPlanMonthTo
} },
{ "@OrderDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderDateFrom
} },
{ "@OrderDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderDateTo
} },
{ "@OrderNOFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderNoFrom
} },
{ "@OrderNOTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderNoTo
} },
{ "@EDIDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.EDIDate
} },
{ "@ChkMikakutei", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = doe.ChkMikakutei.ToString()
} },
{ "@ArrivalPlan", new ValuePair {
value1 = SqlDbType.Int, value2 = doe.ArrivalPlanCD
} },
{ "@ChkKanbai", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = doe.ChkKanbai.ToString()
} },
{ "@ChkFuyo", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = doe.ChkFuyo.ToString()
} },
{ "@OrderCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderCD
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.StoreCD
} },
};
return(SelectData(dic, sp));
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
//受注あり
if (!((CheckBox)detailControls[(int)EIndex.ChkJuchuAri]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkZaiko]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkJuchuAri].Focus();
return;
}
//承認状況
if (!((CheckBox)detailControls[(int)EIndex.ChkSyoninzumi]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkMisyonin]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkMisyonin].Focus();
return;
}
//納入先
if (!((CheckBox)detailControls[(int)EIndex.ChkChokuso]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkSouko]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkChokuso].Focus();
return;
}
//発注方法
if (!((CheckBox)detailControls[(int)EIndex.ChkNet]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkFax]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkEdi]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkNet].Focus();
return;
}
doe = GetSearchInfo();
DataTable dt = ssbl.D_Order_SelectAllForShoukai(doe, mse, InOperatorCD, InPcID);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
Btn_F10.Enabled = true;
}
else
{
ssbl.ShowMessage("E128");
}
}
/// <summary>
/// 発注入力更新処理
/// HacchuuNyuuryokuより更新時に使用
/// </summary>
/// <param name="dme"></param>
/// <param name="operationMode"></param>
/// <param name="operatorNm"></param>
/// <param name="pc"></param>
/// <returns></returns>
public bool D_Order_Exec(D_Order_Entity dme, DataTable dt, short operationMode, string operatorNm, string pc)
{
string sp = "PRC_HacchuuNyuuryoku";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString());
AddParam(command, "@OrderNO", SqlDbType.VarChar, dme.OrderNO);
AddParam(command, "@StoreCD", SqlDbType.VarChar, dme.StoreCD);
AddParam(command, "@OrderDate", SqlDbType.VarChar, dme.OrderDate);
AddParam(command, "@ReturnFLG", SqlDbType.TinyInt, dme.ReturnFLG);
AddParam(command, "@SoukoCD", SqlDbType.VarChar, dme.DestinationSoukoCD);
AddParam(command, "@StaffCD", SqlDbType.VarChar, dme.StaffCD);
AddParam(command, "@OrderCD", SqlDbType.VarChar, dme.OrderCD);
AddParam(command, "@OrderPerson", SqlDbType.VarChar, dme.OrderPerson);
AddParam(command, "@AliasKBN", SqlDbType.TinyInt, dme.AliasKBN);
AddParam(command, "@DestinationKBN", SqlDbType.TinyInt, dme.DestinationKBN);
AddParam(command, "@DestinationName", SqlDbType.VarChar, dme.DestinationName);
AddParam(command, "@ZipCD1", SqlDbType.VarChar, dme.DestinationZip1CD);
AddParam(command, "@ZipCD2", SqlDbType.VarChar, dme.DestinationZip2CD);
AddParam(command, "@Address1", SqlDbType.VarChar, dme.DestinationAddress1);
AddParam(command, "@Address2", SqlDbType.VarChar, dme.DestinationAddress2);
AddParam(command, "@DestinationTelphoneNO", SqlDbType.VarChar, dme.DestinationTelphoneNO);
AddParam(command, "@DestinationFaxNO", SqlDbType.VarChar, dme.DestinationFaxNO);
AddParam(command, "@DestinationSoukoCD", SqlDbType.VarChar, dme.DestinationSoukoCD);
AddParam(command, "@OrderHontaiGaku", SqlDbType.Money, dme.OrderHontaiGaku);
AddParam(command, "@OrderTax8", SqlDbType.Money, dme.OrderTax8);
AddParam(command, "@OrderTax10", SqlDbType.Money, dme.OrderTax10);
AddParam(command, "@OrderGaku", SqlDbType.Money, dme.OrderGaku);
AddParam(command, "@CommentOutStore", SqlDbType.VarChar, dme.CommentOutStore);
AddParam(command, "@CommentInStore", SqlDbType.VarChar, dme.CommentInStore);
AddParam(command, "@ApprovalEnabled", SqlDbType.TinyInt, dme.ApprovalEnabled);
AddParam(command, "@ApprovalStageFLG", SqlDbType.Int, dme.ApprovalStageFLG);
AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt);
AddParam(command, "@Operator", SqlDbType.VarChar, operatorNm);
AddParam(command, "@PC", SqlDbType.VarChar, pc);
//OUTパラメータの追加
string outPutParam = "@OutOrderNo";
command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11);
command.Parameters[outPutParam].Direction = ParameterDirection.Output;
UseTransaction = true;
bool ret = InsertUpdateDeleteData(sp, ref outPutParam);
if (ret)
{
dme.OrderNO = outPutParam;
}
return(ret);
}
private D_Order_Entity GetSearchInfo()
{
doe = new D_Order_Entity
{
OrderDateFrom = detailControls[(int)EIndex.DayStart].Text,
OrderDateTo = detailControls[(int)EIndex.DayEnd].Text,
StaffCD = ScStaff.TxtCode.Text,
StoreCD = CboStoreCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboStoreCD.SelectedValue.ToString(),
};
return(doe);
}
/// <summary>
/// 入荷入力より入荷予定処理
/// NyuukaNyuuryokuより在庫データ複製時に使用
/// </summary>
public DataTable Order_Exec(D_Order_Entity de)
{
D_Hacchu_DL dl = new D_Hacchu_DL();
bool ret = dl.D_Order_ExecForNyuka(de);
DataTable dt = new DataTable();
D_Arrival_DL adl = new D_Arrival_DL();
if (ret)
{
dt = adl.D_ArrivalPlan_SelectDataByOrderNO(de);
}
return(dt);
}
/// <summary>
/// 発注先の確認
/// </summary>
/// <param name="colFields"></param>
/// <returns></returns>
private bool CheckOrder(D_Order_Entity doe, string[] colFields, int kbn = 0)
{
try
{
//ＣＳＶ商品略名の左11byte
doe.OrderNO = colFields[25].Substring(0, 11);
doe.OrderCD = dee.VendorCD;
if (kbn == 1 || kbn == 2)
{
//ＣＳＶ商品略名の左13byte～15byte（文字型から数字型に変更必要）
doe.OrderRows = colFields[25].Substring(12, 3);
if (ediAPI_bl.Z_Set(doe.OrderRows) == 0)
{
return(false);
}
}
//【D_Order_Select】
DataTable dt = ediAPI_bl.D_Order_Select(doe);
if (dt.Rows.Count == 0)
{
return(false);
}
if (kbn == 2)
{
doe.OrderSu = dt.Rows[0]["OrderSu"].ToString();
//D_OrderDetails.JanCD≠ ＣＳＶ JANCD
//or D_OrderDetails.OrderSu≠ＣＳＶ 発注数
if (!dt.Rows[0]["JanCD"].ToString().Equals(colFields[26]))
{
return(false);
}
if (ediAPI_bl.Z_Set(dt.Rows[0]["OrderSu"]) != ediAPI_bl.Z_Set(colFields[27]))
{
return(false);
}
}
return(true);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.InnerException.ToString());
return(false);
}
}
public bool D_Order_ExecForNyuka(D_Order_Entity de)
{
string sp = "D_Order_ExecForNyuka";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParam(command, "@StoreCD", SqlDbType.VarChar, de.StoreCD);
AddParam(command, "@ChangeDate", SqlDbType.Date, de.ChangeDate); //ArrivalDate
AddParam(command, "@SoukoCD", SqlDbType.VarChar, de.DestinationSoukoCD);
AddParam(command, "@StaffCD", SqlDbType.VarChar, de.StaffCD);
AddParam(command, "@OrderWayKBN", SqlDbType.TinyInt, de.OrderWayKBN);
AddParam(command, "@OrderCD", SqlDbType.VarChar, de.OrderCD);
AddParam(command, "@OrderPerson", SqlDbType.VarChar, de.OrderPerson);
AddParam(command, "@AliasKBN", SqlDbType.TinyInt, de.AliasKBN);
AddParam(command, "@AdminNO", SqlDbType.Int, de.AdminNO);
AddParam(command, "@SKUCD", SqlDbType.VarChar, de.SKUCD);
AddParam(command, "@SKUName", SqlDbType.VarChar, de.SKUName);
AddParam(command, "@JANCD", SqlDbType.VarChar, de.JANCD);
AddParam(command, "@ColorName", SqlDbType.VarChar, de.ColorName);
AddParam(command, "@SizeName", SqlDbType.VarChar, de.SizeName);
AddParam(command, "@OrderSuu", SqlDbType.Int, de.OrderSuu);
AddParam(command, "@OrderUnitPrice", SqlDbType.Money, de.OrderUnitPrice);
AddParam(command, "@TaniCD", SqlDbType.VarChar, de.TaniCD);
AddParam(command, "@PriceOutTax", SqlDbType.Money, de.PriceOutTax);
AddParam(command, "@Rate", SqlDbType.Decimal, de.Rate);
AddParam(command, "@OrderHontaiGaku", SqlDbType.Money, de.OrderHontaiGaku);
AddParam(command, "@OrderTax", SqlDbType.Money, de.OrderTax);
AddParam(command, "@OrderTaxRitsu", SqlDbType.Int, de.OrderTaxRitsu);
AddParam(command, "@Operator", SqlDbType.VarChar, de.Operator);
//OUTパラメータの追加
string outPutParam = "@OutOrderNo";
command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11);
command.Parameters[outPutParam].Direction = ParameterDirection.Output;
UseTransaction = true;
bool ret = InsertUpdateDeleteData(sp, ref outPutParam);
if (ret)
{
de.OrderNO = outPutParam;
}
return(ret);
}
/// <summary>
/// 発注入力データ取得処理
/// HacchuuNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_Order_SelectData(D_Order_Entity de, short operationMode)
{
string sp = "D_Order_SelectData";
//command.Parameters.Add("@SyoKBN", SqlDbType.TinyInt).Value = mie.SyoKBN;
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = operationMode.ToString()
} },
{ "@OrderNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.OrderNO
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 入荷入力データ取得処理
/// NyuukaNyuuryokuよりデータ抽出時に使用
/// F10:入荷予定押下時
/// </summary>
public DataTable D_ArrivalPlan_SelectDataByOrderNO(D_Order_Entity de)
{
string sp = "D_ArrivalPlan_SelectDataByOrderNO";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OrderNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.OrderNO
} },
{ "@AdminNo", new ValuePair {
value1 = SqlDbType.Int, value2 = de.AdminNO
} },
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.DestinationSoukoCD
} },
};
return(SelectData(dic, sp));
}
private D_Order_Entity GetEntity()
{
doe = new D_Order_Entity
{
ArrivalPlanDateFrom = detailControls[(int)EIndex.ArrivalPlanDateFrom].Text,
ArrivalPlanDateTo = detailControls[(int)EIndex.ArrivalPlanDateTo].Text,
ArrivalPlanMonthFrom = detailControls[(int)EIndex.ArrivalPlanMonthFrom].Text.Replace("/", ""),
ArrivalPlanMonthTo = detailControls[(int)EIndex.ArrivalPlanMonthTo].Text.Replace("/", ""),
OrderDateFrom = detailControls[(int)EIndex.OrderDateFrom].Text,
OrderDateTo = detailControls[(int)EIndex.OrderDateTo].Text,
StoreCD = CboStoreCD.SelectedValue.ToString(),
OrderCD = detailControls[(int)EIndex.OrderCD].Text,
};
if (ChkMikakutei.Checked)
{
doe.ChkMikakutei = 1;
}
else
{
doe.ChkMikakutei = 0;
}
if (ChkKanbai.Checked)
{
doe.ChkKanbai = 1;
}
else
{
doe.ChkKanbai = 0;
}
if (ChkFuyo.Checked)
{
doe.ChkFuyo = 1;
}
else
{
doe.ChkFuyo = 0;
}
return(doe);
}
public DataTable D_Order_Select(D_Order_Entity ode)
{
string sp = "D_Order_Select";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OrderNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = ode.OrderNO
} },
{ "@OrderRows", new ValuePair {
value1 = SqlDbType.Int, value2 = ode.OrderRows
} },
{ "@OrderCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = ode.OrderCD
} },
};
return(SelectData(dic, sp));
}
protected override void ExecDisp()
{
bool exists = false;
for (int i = 0; i < detailControls.Length; i++)
{
if (i != (int)EIndex.StoreCD && !string.IsNullOrWhiteSpace(detailControls[i].Text))
{
exists = true;
}
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
if (!exists)
{
tjbl.ShowMessage("E111");
detailControls[0].Focus();
return;
}
doe = GetSearchInfo();
DataTable dt = tjbl.D_Order_SelectData_SeachHacchuuShoriNO(doe.StoreCD, doe.OrderDateFrom, doe.OrderDateTo, doe.StaffCD);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
tjbl.ShowMessage("E128");
}
}
public DataTable D_Order_Select(D_Order_Entity doe, D_Purchase_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.DestinationSoukoCD
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.StoreCD
} },
{ "@TargetDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PurchaseDateFrom
} },
{ "@TargetDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PurchaseDateTo
} },
};
UseTransaction = true;
return(SelectData(dic, "D_Order_SelectForReport"));
}
public DataTable D_Order_SelectAll(D_Order_Entity doe, M_SKU_Entity mse)
{
string sp = "D_Order_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OrderDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderDateFrom
} },
{ "@OrderDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderDateTo
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.StoreCD
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.StaffCD
} },
{ "@OrderCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderCD
} },
{ "@SKUName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SKUName
} },
{ "@ITemCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ITemCD
} },
{ "@SKUCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SKUCD
} },
{ "@JanCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.JanCD
} },
{ "@MakerItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.MakerItem
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 回答納期データ取得処理
/// </summary>
/// <param name="set">画面展開なしの場合:falesに設定する</param>
/// <returns></returns>
private DataTable CheckData()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i, false) == false)
{
detailControls[i].Focus();
return(null);
}
}
//入荷予定日 （To)
//入荷予定月 （To)
//発注日 （To)
//のどれかの入力があること
//カーソルは 入荷予定日（To)
if (string.IsNullOrWhiteSpace(detailControls[(int)EIndex.ArrivalPlanDateTo].Text) && string.IsNullOrWhiteSpace(detailControls[(int)EIndex.ArrivalPlanMonthTo].Text) &&
string.IsNullOrWhiteSpace(detailControls[(int)EIndex.OrderDateTo].Text))
{
//Ｅ１８０
bbl.ShowMessage("E180");
detailControls[(int)EIndex.ArrivalPlanDateTo].Focus();
return(null);
}
//[D_ArrivalPlan_SelectForPrint]
doe = GetEntity();
DataTable dt = mibl.D_ArrivalPlan_SelectForPrint(doe);
//以下の条件でデータが存在しなければエラー (Error if record does not exist)Ｅ１３３
if (dt.Rows.Count == 0)
{
bbl.ShowMessage("E128");
previousCtrl.Focus();
return(null);
}
return(dt);
}
private D_Order_Entity GetSearchInfo()
{
doe = new D_Order_Entity
{
OrderDateFrom = detailControls[(int)EIndex.DayStart].Text,
OrderDateTo = detailControls[(int)EIndex.DayEnd].Text,
OrderCD = ScOrder.TxtCode.Text,
StaffCD = ScStaff.TxtCode.Text,
StoreCD = CboStoreCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboStoreCD.SelectedValue.ToString(),
};
mse = new M_SKU_Entity
{
SKUName = detailControls[(int)EIndex.SKUName].Text,
ITemCD = detailControls[(int)EIndex.ITemCD].Text, //カンマ区切り
SKUCD = detailControls[(int)EIndex.SKUCD].Text, //カンマ区切り
JanCD = detailControls[(int)EIndex.JanCD].Text, //カンマ区切り
MakerItem = detailControls[(int)EIndex.MakerItem].Text, //カンマ区切り
};
return(doe);
}
/// <summary>
/// 画面情報をセット
/// </summary>
/// <returns></returns>
private D_Order_Entity GetEntity()
{
doe = new D_Order_Entity();
doe.StoreCD = CboStoreCD.SelectedValue.ToString();
doe.OrderDateFrom = detailControls[(int)EIndex.OrderDateFrom].Text;
doe.OrderDateTo = detailControls[(int)EIndex.OrderDateTo].Text;
doe.ApprovalStageFLG = W_ApprovalStageFLG.ToString();
if (ckM_CheckBox1.Checked)
{
doe.Misyonin = 1;
}
else
{
doe.Misyonin = 0;
}
if (ckM_CheckBox2.Checked)
{
doe.SyoninZumi = 1;
}
else
{
doe.SyoninZumi = 0;
}
if (ckM_CheckBox3.Checked)
{
doe.Kyakka = 1;
}
else
{
doe.Kyakka = 0;
}
return(doe);
}
private D_Order_Entity GetEntityForOrder()
{
doe = new D_Order_Entity
{
StoreCD = CboStoreCD.SelectedValue.ToString(),
OrderDateFrom = detailControls[(int)EIndex.OrderDateFrom].Text,
OrderDateTo = detailControls[(int)EIndex.OrderDateTo].Text,
OrderCD = detailControls[(int)EIndex.Vendor].Text,
StaffCD = detailControls[(int)EIndex.Staff].Text,
OrderNO = detailControls[(int)EIndex.OrderNO].Text,
};
if (ChkMisyounin.Checked)
{
doe.ChkMisyonin = 1;
}
else
{
doe.ChkMisyonin = 0;
}
return(doe);
}
private D_Order_Entity GetSearchInfo()
{
doe = new D_Order_Entity
{
OrderDateFrom = detailControls[(int)EIndex.DayStart].Text,
OrderDateTo = detailControls[(int)EIndex.DayEnd].Text,
ArrivalPlanDateFrom = detailControls[(int)EIndex.ArrivalPlanDateFrom].Text,
ArrivalPlanDateTo = detailControls[(int)EIndex.ArrivalPlanDateTo].Text,
ArrivalDateFrom = detailControls[(int)EIndex.ArrivalDateFrom].Text,
ArrivalDateTo = detailControls[(int)EIndex.ArrivalDateTo].Text,
PurchaseDateFrom = detailControls[(int)EIndex.PurchaseDateFrom].Text,
PurchaseDateTo = detailControls[(int)EIndex.PurchaseDateTo].Text,
OrderCD = ScVendor.TxtCode.Text,
StoreCD = CboStoreCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboStoreCD.SelectedValue.ToString(),
JuchuuNO = ScJuchuuNO.TxtCode.Text,
};
if (CboArrivalPlan.SelectedIndex != -1)
{
doe.ArrivalPlanCD = CboArrivalPlan.SelectedValue.ToString();
}
if (CboSoukoName.SelectedIndex != -1)
{
doe.DestinationSoukoCD = CboSoukoName.SelectedValue.ToString();
}
if (((CheckBox)detailControls[(int)EIndex.ChkMikakutei]).Checked)
{
doe.ChkMikakutei = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkKanbai]).Checked)
{
doe.ChkKanbai = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkFuyo]).Checked)
{
doe.ChkFuyo = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkNyukaZumi]).Checked)
{
doe.ChkNyukaZumi = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkMiNyuka]).Checked)
{
doe.ChkMiNyuka = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkJuchuAri]).Checked)
{
doe.ChkJuchuAri = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkZaiko]).Checked)
{
doe.ChkZaiko = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkMisyonin]).Checked)
{
doe.ChkMisyonin = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkSyoninzumi]).Checked)
{
doe.ChkSyoninzumi = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkChokuso]).Checked)
{
doe.ChkChokuso = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkSouko]).Checked)
{
doe.ChkSouko = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkNet]).Checked)
{
doe.ChkNet = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkFax]).Checked)
{
doe.ChkFax = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkEdi]).Checked)
{
doe.ChkEdi = 1;
}
mse = new M_SKU_Entity
{
SKUName = detailControls[(int)EIndex.SKUName].Text,
ITemCD = detailControls[(int)EIndex.ITemCD].Text, //カンマ区切り
SKUCD = detailControls[(int)EIndex.SKUCD].Text, //カンマ区切り
JanCD = detailControls[(int)EIndex.JanCD].Text, //カンマ区切り
MakerItem = detailControls[(int)EIndex.MakerItem].Text, //カンマ区切り
};
return(doe);
}
public DataTable D_Order_Select(D_Order_Entity ode)
{
D_Hacchu_DL dl = new D_Hacchu_DL();
return(dl.D_Order_Select(ode));
}
/// <summary>
/// 回答納期登録取得処理
/// KaitouNoukiTourokuよりデータ抽出時に使用
/// </summary>
public DataTable D_Order_SelectDataForKaitouNouki(D_Order_Entity de)
{
DataTable dt = mdl.D_Order_SelectDataForKaitouNouki(de);
return(dt);
}
/// <summary>
/// 回答納期登録更新処理
/// KaitouNoukiTourokuより更新時に使用
/// </summary>
public bool Order_Exec(D_Order_Entity dme, DataTable dt, short operationMode, string operatorNm, string pc)
{
return(mdl.D_Order_ExecForKaitouNouki(dme, dt, operationMode, operatorNm, pc));
}
/// <summary>
/// 回答納期確認書よりデータ取得
/// </summary>
/// <param name="doe"></param>
/// <returns></returns>
public DataTable D_ArrivalPlan_SelectForPrint(D_Order_Entity doe)
{
return(mdl.D_ArrivalPlan_SelectForPrint(doe));
}
public bool PRC_EDIOrder_Insert(D_Order_Entity doe, D_EDIOrder_Entity dee)
{
return(edl.PRC_EDIOrder_Insert(doe, dee));
}
/// <summary>
/// EDI発注追加用データ取得処理
/// </summary>
public DataTable D_Order_SelectAllForEDIHacchuu(D_Order_Entity doe)
{
return(dl.D_Order_SelectAllForEDIHacchuu(doe));
}
