Exemple #1
0
        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));
        }
Exemple #2
0
        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");
            }
        }
Exemple #3
0
        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"));
        }
Exemple #4
0
        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"));
        }
Exemple #5
0
        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));
        }
Exemple #6
0
        /// <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));
        }
Exemple #7
0
        /// <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));
        }
Exemple #8
0
        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();
            }
        }
Exemple #10
0
        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));
        }
Exemple #11
0
        /// <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));
        }
Exemple #12
0
        /// <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();
            }
        }
Exemple #14
0
        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");
            }
        }
Exemple #15
0
        /// <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);
        }
Exemple #16
0
 /// <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));
 }
Exemple #18
0
 /// <summary>
 /// 店舗売上入力取得処理
 /// TempoUriageNyuuryoku よりデータ抽出時に使用
 /// </summary>
 public DataTable D_Juchu_SelectDataForTempoUriage(D_Juchuu_Entity de, short operationMode)
 {
     return(mdl.D_Juchu_SelectDataForTempoUriage(de, operationMode));
 }
Exemple #19
0
        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));
        }
Exemple #23
0
        /// <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);
        }
Exemple #24
0
 /// <summary>
 /// 受注入力更新処理
 /// TempoJuchuuNyuuryokuより更新時に使用
 /// </summary>
 public bool Juchu_Exec(D_Juchuu_Entity dme, DataTable dt, short operationMode)
 {
     return(mdl.D_Juchu_Exec(dme, dt, operationMode));
 }
Exemple #25
0
 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));
        }
Exemple #27
0
    {        /// <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));
        }
Exemple #29
0
 /// <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));
 }