public DataTable D_Juchu_SelectDataForTempoUriage(D_Juchuu_Entity de, short operationMode)
{
string sp = "D_Juchu_SelectDataForTempoUriage";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = operationMode.ToString()
} },
{ "@DateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuDateFrom
} },
{ "@DateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuDateTo
} },
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.CustomerCD
} },
{ "@CustomerName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.CustomerName
} },
{ "@KanaName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.KanaName
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.StoreCD
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.StaffCD
} },
};
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.ChkMihikiate]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkMiuriage]).Checked &&
!((CheckBox)detailControls[(int)EIndex.ChkMiseikyu]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkMinyukin]).Checked &&
!((CheckBox)detailControls[(int)EIndex.ChkAll]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkMihikiate].Focus();
return;
}
//受注種別
if (!((CheckBox)detailControls[(int)EIndex.ChkTujo]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkHenpin]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkTujo].Focus();
return;
}
//発注状況
if (!((CheckBox)detailControls[(int)EIndex.ChkMinyuka]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkMihachu]).Checked &&
!((CheckBox)detailControls[(int)EIndex.ChkNokiKaito]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkMisiire]).Checked &&
!((CheckBox)detailControls[(int)EIndex.ChkHachuAll]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkMihachu].Focus();
return;
}
dje = GetSearchInfo();
DataTable dt = ssbl.D_Juchu_SelectAll(dje, mse);
GvDetail.DataSource = null;
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
btnSubF10.Enabled = true;
}
else
{
btnSubF10.Enabled = false;
ssbl.ShowMessage("E128");
}
}
public DataTable D_Juchuu_DataSelect_ForShukkaShoukai(D_Juchuu_Entity dje)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@JuchuuNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dje.JuchuuNO
} },
};
return(SelectData(dic, "D_Juchuu_DataSelect_ForShukkaShoukai"));
}
public DataTable D_JuChuu_DataSelect(D_Juchuu_Entity dje)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dje.StoreCD
} },
};
return(SelectData(dic, "D_JuChuu_DataSelect"));
}
public bool DeleteTemporaryReserve(D_Juchuu_Entity de)
{
string sp = "DeleteTemporaryReserve";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@JuchuuNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuuNO
} },
};
return(InsertUpdateDeleteData(dic, sp));
}
/// <summary>
/// 出荷入力（JANCDチェック）
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_Juchuu_SelectData_ForShukka(D_Juchuu_Entity de)
{
string sp = "D_Juchuu_SelectData_ForShukka";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@JuchuuNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuuNO
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 店舗レジ販売履歴照会データ取得処理
/// TempoRegiHanbaiRirekiよりデータ抽出時に使用
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_Juchuu_SelectData_ForTempoRegiHanbaiRireki(D_Juchuu_Entity de)
{
string sp = "D_Juchuu_SelectData_ForTempoRegiHanbaiRireki";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.CustomerCD
} },
};
return(SelectData(dic, sp));
}
public string D_Juchu_SelectData(D_Juchuu_Entity de)
{
DataTable dt = mdl.D_Juchu_SelectData(de, 2);
if (dt.Rows.Count > 0)
{
return(dt.Rows[0]["SalesNO"].ToString());
}
else
{
return("");
}
}
private void DispFromJuchuNO(string juchuNo, string salesNo = "")
{
D_Juchuu_Entity dje = new D_Juchuu_Entity();
dje.JuchuuNO = mJuchuNo;
dtJuchu = tprg_Shukka_Bl.D_Juchu_Select(dje, (short)OperationMode, salesNo);
if (dtJuchu.Rows.Count > 0)
{
if (OperationMode == FrmMainForm.EOperationMode.INSERT)
{
txtSalesDate.Text = bbl.GetDate();
}
else
{
txtSalesDate.Text = dtJuchu.Rows[0]["SalesDate"].ToString();
//txtSalesDate.Enabled = false;
//txtFirstCollectPlanDate.Enabled = false;
txtShippingSu.Enabled = false;
btnOk.Enabled = false;
}
//入金日を計算
Save(3);
//【Data Area】
CheckData_M_StoreButtonDetailes();
M_StoreBottunGroup_Entity msg = new M_StoreBottunGroup_Entity();
msg.StoreCD = mStoreCD;
msg.ProgramKBN = "1";
StoreBottunGroup_BL sgbl = new StoreBottunGroup_BL();
dtBottunGroup = sgbl.M_StoreButtonGroup_SelectAll(msg);
DispFromButtonGroupTable();
//【Data Area Detail】
DispFromDataTable();
//【Data Area】
SetDataFromDataTable();
Calkkin();
}
else
{
EndSec();
}
}
public DataTable D_Juchuu_SelectForSeisan(D_Juchuu_Entity dje)
{
string sp = "D_Juchuu_SelectForSeisan";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dje.StoreCD
} },
{ "@Date", new ValuePair {
value1 = SqlDbType.Date, value2 = dje.ChangeDate
} }
};
return(SelectData(dic, sp));
}
/// <summary>
/// 店舗レジ出荷売上入力データ取得処理
/// TempoShukkaNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_Juchuu_SelectData_ForTempoShukkaNyuuryoku(D_Juchuu_Entity de, short operationMode, string salesNO = "")
{
string sp = "D_Juchuu_SelectData_ForTempoShukkaNyuuryoku";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = operationMode.ToString()
} },
{ "@JuchuuNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuuNO
} },
{ "@SalesNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = salesNO
} },
};
return(SelectData(dic, sp));
}
/// <summary>
/// 受注入力データ取得処理
/// TempoJuchuuNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_Juchu_SelectData(D_Juchuu_Entity de, short operationMode, short tennic = 0)
{
string sp = "D_Juchuu_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()
} },
{ "@JuchuuNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuuNO
} },
{ "@Tennic", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = tennic.ToString()
} },
};
return(SelectData(dic, sp));
}
private void DispFromJuchu()
{
D_Juchuu_Entity dje = new D_Juchuu_Entity();
dje.CustomerCD = txtCustomerNo.Text;
dtJuchu = tprg_Hanbai_Bl.D_Juchu_Select(dje);
if (dtJuchu.Rows.Count > 0)
{
//【Data Area Detail】
DispFromDataTable();
}
else
{
//該当データなし
bbl.ShowMessage("E128");
//EndSec();
}
}
protected override void ExecDisp()
{
dje = new D_Juchuu_Entity
{
JuchuuNO = JuchuuNO,
};
DataTable dt = nnbl.D_Juchuu_SelectData_ForNyuuka(dje);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
nnbl.ShowMessage("E128");
}
}
/// <summary>
/// 受注入力更新処理
/// TempoJuchuuNyuuryokuより更新時に使用
/// </summary>
/// <param name="dme"></param>
/// <param name="operationMode"></param>
/// <param name="operatorNm"></param>
/// <param name="pc"></param>
/// <returns></returns>
public bool D_Juchu_Exec(D_Juchuu_Entity dme, DataTable dt, short operationMode)
{
string sp = "PRC_TempoJuchuuNyuuryoku";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString());
AddParam(command, "@JuchuuNO", SqlDbType.VarChar, dme.JuchuuNO);
AddParam(command, "@JuchuuProcessNO", SqlDbType.VarChar, dme.JuchuuProcessNO);
AddParam(command, "@StoreCD", SqlDbType.VarChar, dme.StoreCD);
AddParam(command, "@JuchuuDate", SqlDbType.VarChar, dme.JuchuuDate);
AddParam(command, "@ReturnFLG", SqlDbType.TinyInt, dme.ReturnFLG);
AddParam(command, "@SoukoCD", SqlDbType.VarChar, dme.SoukoCD);
AddParam(command, "@StaffCD", SqlDbType.VarChar, dme.StaffCD);
AddParam(command, "@CustomerCD", SqlDbType.VarChar, dme.CustomerCD);
AddParam(command, "@CustomerName", SqlDbType.VarChar, dme.CustomerName);
AddParam(command, "@CustomerName2", SqlDbType.VarChar, dme.CustomerName2);
AddParam(command, "@AliasKBN", SqlDbType.TinyInt, dme.AliasKBN);
AddParam(command, "@ZipCD1", SqlDbType.VarChar, dme.ZipCD1);
AddParam(command, "@ZipCD2", SqlDbType.VarChar, dme.ZipCD2);
AddParam(command, "@Address1", SqlDbType.VarChar, dme.Address1);
AddParam(command, "@Address2", SqlDbType.VarChar, dme.Address2);
AddParam(command, "@Tel11", SqlDbType.VarChar, dme.Tel11);
AddParam(command, "@Tel12", SqlDbType.VarChar, dme.Tel12);
AddParam(command, "@Tel13", SqlDbType.VarChar, dme.Tel13);
AddParam(command, "@Tel21", SqlDbType.VarChar, dme.Tel21);
AddParam(command, "@Tel22", SqlDbType.VarChar, dme.Tel22);
AddParam(command, "@Tel23", SqlDbType.VarChar, dme.Tel23);
AddParam(command, "@DeliveryCD", SqlDbType.VarChar, dme.DeliveryCD);
AddParam(command, "@DeliveryName", SqlDbType.VarChar, dme.DeliveryName);
AddParam(command, "@DeliveryName2", SqlDbType.VarChar, dme.DeliveryName2);
AddParam(command, "@DeliveryAliasKBN", SqlDbType.TinyInt, dme.DeliveryAliasKBN);
AddParam(command, "@DeliveryZipCD1", SqlDbType.VarChar, dme.DeliveryZipCD1);
AddParam(command, "@DeliveryZipCD2", SqlDbType.VarChar, dme.DeliveryZipCD2);
AddParam(command, "@DeliveryAddress1", SqlDbType.VarChar, dme.DeliveryAddress1);
AddParam(command, "@DeliveryAddress2", SqlDbType.VarChar, dme.DeliveryAddress2);
AddParam(command, "@DeliveryTel11", SqlDbType.VarChar, dme.DeliveryTel11);
AddParam(command, "@DeliveryTel12", SqlDbType.VarChar, dme.DeliveryTel12);
AddParam(command, "@DeliveryTel13", SqlDbType.VarChar, dme.DeliveryTel13);
AddParam(command, "@JuchuuGaku", SqlDbType.Money, dme.JuchuuGaku);
AddParam(command, "@Discount", SqlDbType.Money, dme.Discount);
AddParam(command, "@HanbaiHontaiGaku", SqlDbType.Money, dme.HanbaiHontaiGaku);
AddParam(command, "@HanbaiTax8", SqlDbType.Money, dme.HanbaiTax8);
AddParam(command, "@HanbaiTax10", SqlDbType.Money, dme.HanbaiTax10);
AddParam(command, "@HanbaiGaku", SqlDbType.Money, dme.HanbaiGaku);
AddParam(command, "@CostGaku", SqlDbType.Money, dme.CostGaku);
AddParam(command, "@ProfitGaku", SqlDbType.Money, dme.ProfitGaku);
AddParam(command, "@Point", SqlDbType.Money, dme.Point);
AddParam(command, "@InvoiceGaku", SqlDbType.Money, dme.InvoiceGaku);
//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, "@PaymentMethodCD", SqlDbType.VarChar, dme.PaymentMethodCD);
AddParam(command, "@PaymentPlanNO", SqlDbType.TinyInt, dme.PaymentPlanNO);
AddParam(command, "@SalesPlanDate", SqlDbType.Date, dme.SalesPlanDate);
AddParam(command, "@FirstPaypentPlanDate", SqlDbType.Date, dme.FirstPaypentPlanDate);
AddParam(command, "@LastPaymentPlanDate", SqlDbType.Date, dme.LastPaymentPlanDate);
AddParam(command, "@CommentOutStore", SqlDbType.VarChar, dme.CommentOutStore);
AddParam(command, "@CommentInStore", SqlDbType.VarChar, dme.CommentInStore);
AddParam(command, "@MitsumoriNO", SqlDbType.VarChar, dme.MitsumoriNO);
AddParam(command, "@NouhinsyoComment", SqlDbType.VarChar, dme.NouhinsyoComment);
AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt);
AddParam(command, "@Operator", SqlDbType.VarChar, dme.InsertOperator);
AddParam(command, "@PC", SqlDbType.VarChar, dme.PC);
//OUTパラメータの追加
string outPutParam = "@OutJuchuuNo";
command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11);
command.Parameters[outPutParam].Direction = ParameterDirection.Output;
UseTransaction = true;
bool ret = InsertUpdateDeleteData(sp, ref outPutParam);
if (ret)
{
dme.JuchuuNO = outPutParam;
}
return(ret);
}
/// <summary>
/// 店舗受注照会にて使用
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_Juchu_SelectAllForShoukai(D_Juchuu_Entity de, M_SKU_Entity mse, string operatorNm, string pc)
{
return(mdl.D_Juchu_SelectAllForShoukai(de, mse, operatorNm, pc));
}
public DataTable D_Juchuu_DataSelect_ForShukkaShoukai(D_Juchuu_Entity dje)
{
return(djdl.D_Juchuu_DataSelect_ForShukkaShoukai(dje));
}
/// <summary>
/// 店舗売上入力取得処理
/// TempoUriageNyuuryoku よりデータ抽出時に使用
/// </summary>
public DataTable D_Juchu_SelectDataForTempoUriage(D_Juchuu_Entity de, short operationMode)
{
return(mdl.D_Juchu_SelectDataForTempoUriage(de, operationMode));
}
private D_Juchuu_Entity GetSearchInfo()
{
dje = new D_Juchuu_Entity
{
JuchuDateFrom = detailControls[(int)EIndex.DayStart].Text,
JuchuDateTo = detailControls[(int)EIndex.DayEnd].Text,
SalesDateFrom = detailControls[(int)EIndex.SalesDateFrom].Text,
SalesDateTo = detailControls[(int)EIndex.SalesDateTo].Text,
BillingCloseDateFrom = detailControls[(int)EIndex.BillingDateFrom].Text,
BillingCloseDateTo = detailControls[(int)EIndex.BillingDateTo].Text,
CollectClearDateFrom = detailControls[(int)EIndex.CollectDateFrom].Text,
CollectClearDateTo = detailControls[(int)EIndex.CollectDateTo].Text,
JuchuuNOFrom = ScJuchuuNO.TxtCode.Text,
JuchuuNOTo = ScJuchuuNOTo.TxtCode.Text,
CustomerCD = ScCustomer.TxtCode.Text,
KanaName = detailControls[(int)EIndex.KanaName].Text,
Tel11 = detailControls[(int)EIndex.Tel1].Text,
Tel12 = detailControls[(int)EIndex.Tel2].Text,
Tel13 = detailControls[(int)EIndex.Tel3].Text,
VendorCD = detailControls[(int)EIndex.VendorCD].Text,
StaffCD = detailControls[(int)EIndex.StaffCD].Text,
StoreCD = CboStoreCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboStoreCD.SelectedValue.ToString(),
};
if (((CheckBox)detailControls[(int)EIndex.ChkMihikiate]).Checked)
{
dje.ChkMihikiate = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkMiuriage]).Checked)
{
dje.ChkMiuriage = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkMiseikyu]).Checked)
{
dje.ChkMiseikyu = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkMinyukin]).Checked)
{
dje.ChkMinyukin = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkAll]).Checked)
{
dje.ChkAll = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkTujo]).Checked)
{
dje.ChkTujo = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkHenpin]).Checked)
{
dje.ChkHenpin = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkMihachu]).Checked)
{
dje.ChkMihachu = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkNokiKaito]).Checked)
{
dje.ChkNokiKaito = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkMinyuka]).Checked)
{
dje.ChkMinyuka = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkMisiire]).Checked)
{
dje.ChkMisiire = 1;
}
if (((CheckBox)detailControls[(int)EIndex.ChkHachuAll]).Checked)
{
dje.ChkHachuAll = 1;
}
mse = new M_SKU_Entity
{
SKUName = detailControls[(int)EIndex.SKUName].Text,
SKUCD = detailControls[(int)EIndex.SKUCD].Text, //カンマ区切り
JanCD = detailControls[(int)EIndex.JanCD].Text, //カンマ区切り
MakerItem = detailControls[(int)EIndex.KanaName].Text, //カンマ区切り
};
return(dje);
}
public DataTable D_Juchuu_SelectData_ForShukka(D_Juchuu_Entity de)
{
D_Juchuu_DL mdl = new D_Juchuu_DL();
return(mdl.D_Juchuu_SelectData_ForShukka(de));
}
private bool CheckDetail(int index)
{
switch (index)
{
case (int)EIndex.DayStart:
case (int)EIndex.DayEnd:
case (int)EIndex.PlanDateStart:
case (int)EIndex.PlanDateEnd:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
return(true);
}
detailControls[index].Text = snbl.FormatDate(detailControls[index].Text);
//日付として正しいこと(Be on the correct date)Ｅ１０３
if (!snbl.CheckDate(detailControls[index].Text))
{
//Ｅ１０３
snbl.ShowMessage("E103");
return(false);
}
//(From) ≧ (To)である場合Error
if (index == (int)EIndex.DayEnd || index == (int)EIndex.PlanDateEnd)
{
if (!string.IsNullOrWhiteSpace(detailControls[index - 1].Text) && !string.IsNullOrWhiteSpace(detailControls[index].Text))
{
int result = detailControls[index].Text.CompareTo(detailControls[index - 1].Text);
if (result < 0)
{
//Ｅ１０６
snbl.ShowMessage("E104");
return(false);
}
}
}
break;
case (int)EIndex.SoukoCD:
//選択必須(Entry required)
if (!RequireCheck(new Control[] { detailControls[index] }))
{
return(false);
}
break;
case (int)EIndex.StaffCD:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
ScStaff.LabelText = "";
return(true);
}
//スタッフマスター(M_Staff)に存在すること
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = detailControls[index].Text,
ChangeDate = snbl.GetDate() // detailControls[(int)EIndex.MitsumoriDate].Text
};
Staff_BL bl = new Staff_BL();
bool ret = bl.M_Staff_Select(mse);
if (ret)
{
ScStaff.LabelText = mse.StaffName;
}
else
{
snbl.ShowMessage("E101");
ScStaff.LabelText = "";
return(false);
}
break;
case (int)EIndex.JuchuuNO:
//入力された場合
if (!string.IsNullOrWhiteSpace(detailControls[index].Text))
{
//受注(D_Juchuu)の存在しない場合エラー
D_Juchuu_Entity de = new D_Juchuu_Entity();
de.JuchuuNO = detailControls[index].Text;
TempoJuchuuNyuuryoku_BL tbl = new TempoJuchuuNyuuryoku_BL();
DataTable dt = tbl.D_Juchu_SelectData(de, 2);
if (dt.Rows.Count == 0)
{
bbl.ShowMessage("E138", "受注番号");
return(false);
}
else
{
//DeleteDateTime 「削除された受注番号」
if (!string.IsNullOrWhiteSpace(dt.Rows[0]["DeleteDateTime"].ToString()))
{
bbl.ShowMessage("E140", "受注番号");
return(false);
}
}
}
break;
}
return(true);
}
/// <summary>
/// 受注取得処理
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_Juchuu_DataSelect_ForShukkaShoukai(D_Juchuu_Entity de)
{
D_Juchuu_DL mdl = new D_Juchuu_DL();
return(mdl.D_Juchuu_DataSelect_ForShukkaShoukai(de));
}
/// <summary>
/// 受注入力取得処理
/// TempoJuchuuNyuuryokuよりデータ抽出時に使用
/// </summary>
public DataTable D_Juchu_SelectData(D_Juchuu_Entity de, short operationMode, short tennic = 0)
{
DataTable dt = mdl.D_Juchu_SelectData(de, operationMode, tennic);
return(dt);
}
/// <summary>
/// 受注入力更新処理
/// TempoJuchuuNyuuryokuより更新時に使用
/// </summary>
public bool Juchu_Exec(D_Juchuu_Entity dme, DataTable dt, short operationMode)
{
return(mdl.D_Juchu_Exec(dme, dt, operationMode));
}
public bool DeleteTemporaryReserve(D_Juchuu_Entity de)
{
return(mdl.DeleteTemporaryReserve(de));
}
public DataTable D_Juchu_Select(D_Juchuu_Entity de)
{
D_Juchuu_DL dl = new D_Juchuu_DL();
return(dl.D_Juchuu_SelectData_ForTempoRegiHanbaiRireki(de));
}
{ /// <summary>
/// 受注番号検索にて使用
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable D_Juchu_SelectAll(D_Juchuu_Entity de, M_SKU_Entity mse)
{
string sp = "D_Juchuu_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@JuchuuDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuDateFrom
} },
{ "@JuchuuDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuDateTo
} },
{ "@SalesDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.SalesDateFrom
} },
{ "@SalesDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.SalesDateTo
} },
{ "@BillingCloseDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.BillingCloseDateFrom
} },
{ "@BillingCloseDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.BillingCloseDateTo
} },
{ "@CollectClearDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.CollectClearDateFrom
} },
{ "@CollectClearDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.CollectClearDateTo
} },
{ "@ChkMihikiate", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkMihikiate.ToString()
} },
{ "@ChkMiuriage", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkMiuriage.ToString()
} },
{ "@ChkMiseikyu", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkMiseikyu.ToString()
} },
{ "@ChkMinyukin", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkMinyukin.ToString()
} },
{ "@ChkAll", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkAll.ToString()
} },
{ "@ChkTujo", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkTujo.ToString()
} },
{ "@ChkHenpin", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkHenpin.ToString()
} },
{ "@ChkGaisho", new ValuePair {
value1 = SqlDbType.Int, value2 = de.ValGaisho.ToString()
} },
{ "@ChkTento", new ValuePair {
value1 = SqlDbType.Int, value2 = de.ValTento.ToString()
} },
{ "@ChkWeb", new ValuePair {
value1 = SqlDbType.Int, value2 = de.ValWeb.ToString()
} },
{ "@ChkMihachu", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkMihachu.ToString()
} },
{ "@ChkNokiKaito", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkNokiKaito.ToString()
} },
{ "@ChkMinyuka", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkMinyuka.ToString()
} },
{ "@ChkMisiire", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkMisiire.ToString()
} },
{ "@ChkHachuAll", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = de.ChkHachuAll.ToString()
} },
{ "@CustomerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.CustomerCD
} },
{ "@CustomerName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.CustomerName
} },
{ "@OrderCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.VendorCD
} },
{ "@OrderName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.VendorName
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.StoreCD
} },
{ "@KanaName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.KanaName
} },
{ "@Tel1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.Tel11
} },
{ "@Tel2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.Tel12
} },
{ "@Tel3", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.Tel13
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.StaffCD
} },
{ "@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
} },
{ "@JuchuuNOFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuuNOFrom
} },
{ "@JuchuuNOTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.JuchuuNOTo
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.Operator
} },
//{ "@PC", new ValuePair { value1 = SqlDbType.VarChar, value2 = pc} },
};
return(SelectData(dic, sp));
}
public DataTable D_Juchu_Select(D_Juchuu_Entity de, short operationMode, string salesNo = "")
{
D_Juchuu_DL dl = new D_Juchuu_DL();
return(dl.D_Juchuu_SelectData_ForTempoShukkaNyuuryoku(de, operationMode, salesNo));
}
/// <summary>
/// 受注検索にて使用
/// </summary>
/// <param name="de"></param>
/// <param name="mse"></param>
/// <returns></returns>
public DataTable D_Juchu_SelectAll(D_Juchuu_Entity de, M_SKU_Entity mse)
{
return(mdl.D_Juchu_SelectAll(de, mse));
}
