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)E103 if (!snbl.CheckDate(detailControls[index].Text)) { //E103 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) { //E106 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)); }