Exemplo n.º 1
0
        public bool M_Staff_Delete(M_Staff_Entity mse)
        {
            string sp = "M_Staff_Delete";

            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StaffCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.StaffCD
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.Date, value2 = mse.ChangeDate
                  } },
                { "@Operator", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.Operator
                  } },
                { "@Program", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.ProgramID
                  } },
                { "@PC", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.PC
                  } },
                { "@OperateMode", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.ProcessMode
                  } },
                { "@KeyItem", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.Key
                  } }
            };

            return(InsertUpdateDeleteData(dic, sp));
        }
        private void Form_Load(object sender, EventArgs e)
        {
            try
            {
                Scr_Clr();

                //スタッフマスター(M_Staff)に存在すること
                //[M_Staff]
                M_Staff_Entity mse = new M_Staff_Entity
                {
                    StaffCD    = OperatorCD, //パラメータでオペレータCDをセット
                    ChangeDate = tjbl.GetDate()
                };
                Staff_BL bl  = new Staff_BL();
                bool     ret = bl.M_Staff_Select(mse);
                if (ret)
                {
                    CboStoreCD.SelectedValue = mse.StoreCD;
                }
                CboStoreCD.SelectedValue = storeCD;

                detailControls[(int)EIndex.DayEnd].Text = tjbl.GetDate();
            }
            catch (Exception ex)
            {
                //エラー時共通処理
                MessageBox.Show(ex.Message);
                //EndSec();
            }
        }
        private void F12()
        {
            if (ErrorCheck(12))
            {
                if (mstaffBL.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
                {
                    //*** Create Entity Object
                    staffdata = GetStaffEntity();
                    switch (OperationMode)
                    {
                    case EOperationMode.INSERT:
                        InsertUpdate(1);
                        break;

                    case EOperationMode.UPDATE:
                        InsertUpdate(2);
                        break;

                    case EOperationMode.DELETE:
                        Delete();
                        break;
                    }
                }
                else
                {
                    PreviousCtrl.Focus();
                }
            }
        }
Exemplo n.º 4
0
        /// <summary>
        /// Login button click
        /// Check Operator Code & password
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void BtnLogin_Click(object sender, EventArgs e)
        {
            //Base_BL bbl = new Base_BL();
            //bbl.ShowMessage("I001", "テスト", "テスト1");
            if (ErrorCheck())
            {
                //共通処理 受取パラメータ、接続情報
                //コマンドライン引数より情報取得
                //Iniファイルより情報取得
                if (loginbl.ReadConfig() == false)
                {
                    //起動時エラー    DB接続不可能
                    this.Close();
                    System.Environment.Exit(0);
                }

                mse = loginbl.M_Staff_LoginSelect(GetInfo());
                if (mse != null)
                {
                    FrmMenu menuForm = new FrmMenu(mse);
                    this.Hide();
                    menuForm.ShowDialog();
                    this.Close();
                }
                else
                {
                    loginbl.ShowMessage("");
                    txtOperatorCD.Select();
                }
            }
        }
Exemplo n.º 5
0
        public bool M_Staff_Select(M_Staff_Entity mse)
        {
            DataTable dt = msdl.M_Staff_Select(mse);

            if (dt.Rows.Count > 0)
            {
                mse.StaffName             = dt.Rows[0]["StaffName"].ToString();
                mse.StoreCD               = dt.Rows[0]["StoreCD"].ToString();
                mse.StaffKana             = dt.Rows[0]["StaffKana"].ToString();
                mse.BMNCD                 = dt.Rows[0]["BMNCD"].ToString();
                mse.MenuCD                = dt.Rows[0]["MenuCD"].ToString();
                mse.KengenCD              = dt.Rows[0]["AuthorizationsCD"].ToString();
                mse.StoreAuthorizationsCD = dt.Rows[0]["StoreAuthorizationsCD"].ToString();
                mse.PositionCD            = dt.Rows[0]["PositionCD"].ToString();
                mse.JoinDate              = dt.Rows[0]["JoinDate"].ToString();
                mse.LeaveDate             = dt.Rows[0]["LeaveDate"].ToString();
                mse.Password              = dt.Rows[0]["Password"].ToString();
                mse.Remarks               = dt.Rows[0]["Remarks"].ToString();
                mse.DeleteFlg             = dt.Rows[0]["DeleteFlg"].ToString();
                mse.UsedFlg               = dt.Rows[0]["UsedFlg"].ToString();

                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemplo n.º 6
0
        private void Search_Mitsumori_Load(object sender, EventArgs e)
        {
            try
            {
                Scr_Clr();

                //スタッフマスター(M_Staff)に存在すること
                //[M_Staff]
                M_Staff_Entity mse = new M_Staff_Entity
                {
                    StaffCD    = OperatorCD,    //パラメータでオペレータCDをセット
                    ChangeDate = ssbl.GetDate()
                };
                Staff_BL bl  = new Staff_BL();
                bool     ret = bl.M_Staff_Select(mse);
                if (ret)
                {
                    CboStoreCD.SelectedValue = mse.StoreCD;
                    //ScStaff.LabelText = mse.StaffName;
                }
            }
            catch (Exception ex)
            {
                //エラー時共通処理
                MessageBox.Show(ex.Message);
                //EndSec();
            }
        }
 private M_Staff_Entity GetStaffEntity()
 {
     staffdata = new M_Staff_Entity()
     {
         StaffCD               = ScStaff.Code,
         ChangeDate            = ScStaff.ChangeDate,
         StaffName             = txtStaffName.Text,
         StaffKana             = txtStaffKana.Text,
         StoreCD               = ScStore.Code,
         BMNCD                 = cboBMNCD.SelectedValue.ToString(),
         MenuCD                = cboMenu.SelectedValue.ToString(),
         StoreMenuCD           = cboStoreMenu.SelectedValue.ToString(),
         KengenCD              = cboAuthorizations.SelectedValue.ToString(),
         StoreAuthorizationsCD = cboStoreAuthorizations.SelectedValue.ToString(),
         PositionCD            = cboPosition.SelectedValue.ToString(),
         Password              = txtPassword.Text,
         JoinDate              = txtJoinDate.Text,
         LeaveDate             = txtLeaveDate.Text,
         ReceiptPrint          = txtReceiptPrint.Text,
         Remarks               = txtRemark.Text,
         DeleteFlg             = chkDelete.Checked ? "1" : "0",
         ProcessMode           = ModeText,
         Operator              = InOperatorCD,
         ProgramID             = InProgramID,
         Key = ScStaff.Code + " " + ScStaff.ChangeDate,
         PC  = InPcID
     };
     return(staffdata);
 }
        private void Form_Load(object sender, EventArgs e)
        {
            try
            {
                Scr_Clr();

                string ymd = snbl.GetDate();
                snbl = new ShukkaShijiTouroku_BL();
                CboSouko.Bind(ymd);
                CboCarrier.Bind(ymd);

                ScJuchuuNO.Value1 = OperatorCD;
                ScJuchuuNO.Value2 = AllAvailableStores;

                //スタッフマスター(M_Staff)に存在すること
                //[M_Staff]
                M_Staff_Entity mse = new M_Staff_Entity
                {
                    StaffCD    = OperatorCD,
                    ChangeDate = snbl.GetDate()
                };
                Staff_BL bl  = new Staff_BL();
                bool     ret = bl.M_Staff_Select(mse);
                if (ret)
                {
                    //[M_Souko_Search]
                    M_Souko_Entity me = new M_Souko_Entity
                    {
                        StoreCD    = mse.StoreCD,
                        SoukoType  = "3",
                        ChangeDate = ymd,
                        DeleteFlg  = "0"
                    };

                    DataTable mdt = snbl.M_Souko_Search(me);
                    if (mdt.Rows.Count > 0)
                    {
                        CboSouko.SelectedValue = mdt.Rows[0]["SoukoCD"];
                    }
                }

                for (int i = (int)EIndex.DayStart; i <= (int)EIndex.PlanDateEnd; i++)
                {
                    detailControls[i].Text = ymd;
                }
                detailControls[(int)EIndex.StaffCD].Text = OperatorCD;
                ScStaff.LabelText = mse.StaffName;

                detailControls[0].Focus();
            }
            catch (Exception ex)
            {
                //エラー時共通処理
                MessageBox.Show(ex.Message);
                //EndSec();
            }
        }
Exemplo n.º 9
0
 private M_Staff_Entity GetInfo()
 {
     mse = new M_Staff_Entity
     {
         StaffCD  = txtOperatorCD.Text,
         Password = txtPassword.Text
     };
     return(mse);
 }
Exemplo n.º 10
0
        /// <summary>
        /// Select Staff's info
        /// </summary>
        /// <param name="mse">staff info</param>
        /// <returns></returns>
        ///

        public DataTable Check_RegisteredMenu(M_Staff_Entity mse)
        {
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StaffCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.StaffCD
                  } }
            };

            return(SelectData(dic, "Check_RegisteredMenu"));
        }
Exemplo n.º 11
0
        /// <summary>
        ///     共通処理 Operator 確認
        /// </summary>
        /// <param name="mse"></param>
        /// <returns></returns>
        public DataTable M_Staff_InitSelect(M_Staff_Entity mse)
        {
            string sp = "M_Staff_InitSelect";
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StaffCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.StaffCD
                  } }
            };

            return(SelectData(dic, sp));
        }
        public Capitalsports_MainMenu(String SCD, M_Staff_Entity mse)
        {
            mbl = new Menu_BL();

            Staff_CD = SCD;
            this.mse = mse;
            InitializeComponent();
            lblOperatorName.Text = mse.StaffName;
            SetDesignerFunction();

            lblOperatorName.Text = mse.StaffName;
        }
Exemplo n.º 13
0
        private void Form_Load(object sender, EventArgs e)
        {
            try
            {
                base.InProgramID = ProID;
                base.InProgramNM = ProNm;

                this.SetFunctionLabel(EProMode.BATCH);
                this.InitialControlArray();
                base.Btn_F12.Text = "データ出力(F12)";

                //起動時共通処理
                base.StartProgram();

                //コンボボックス初期化
                string ymd = bbl.GetDate();
                CboStoreCD.Bind(ymd);

                mibl = new EDIHacchuu_BL();

                //検索用のパラメータ設定
                string stores = GetAllAvailableStores();
                ScOrderNO.Value1    = InOperatorCD;
                ScOrderNO.Value2    = stores;
                ScEDIOrderNO.Value1 = InOperatorCD;
                ScEDIOrderNO.Value2 = stores;
                ScVendor.Value1     = "1";

                //スタッフマスター(M_Staff)に存在すること
                //[M_Staff]
                M_Staff_Entity mse = new M_Staff_Entity
                {
                    StaffCD    = InOperatorCD,
                    ChangeDate = ymd
                };
                Staff_BL bl  = new Staff_BL();
                bool     ret = bl.M_Staff_Select(mse);
                if (ret)
                {
                    CboStoreCD.SelectedValue = mse.StoreCD;
                }

                SetFuncKeyAll(this, "100001000001");
                Scr_Clr(0);
            }
            catch (Exception ex)
            {
                //エラー時共通処理
                MessageBox.Show(ex.Message);
                EndSec();
            }
        }
Exemplo n.º 14
0
        /// <summary>
        /// For Default Souko Bind
        /// </summary>
        /// <param name="mse"></param>
        /// <returns></returns>
        public M_Staff_Entity M_Souko_InitSelect(M_Staff_Entity mse)
        {
            DataTable dt = msdl.M_Souko_InitSelect(mse);

            if (dt.Rows.Count > 0)
            {
                mse.SysDate = dt.Rows[0]["sysDate"].ToString();
                mse.SoukoCD = dt.Rows[0]["SoukoCD"].ToString();
                Base_DL.iniEntity.DatabaseDate = mse.SysDate;
            }

            return(mse);
        }
Exemplo n.º 15
0
        private bool BindGrid()
        {
            mke = GetEntity();
            DataTable dt = mbl.M_Staff_SelectAll(mke);

            if (dt.Rows.Count == 0)
            {
                return(false);
            }

            dgvDetail.DataSource = dt;
            return(true);
        }
        private void Form_Load(object sender, EventArgs e)
        {
            try
            {
                InProgramID = ProID;
                InProgramNM = ProNm;

                this.SetFunctionLabel(EProMode.SHOW);   //照会プログラムとして起動
                this.InitialControlArray();

                //起動時共通処理
                base.StartProgram();
                Btn_F6.Text = "";

                if (Kidou.Equals(1))
                {
                    //単独起動でない場合、ファンクション名は「戻る」
                    Btn_F1.Text  = "F1:戻る";
                    Btn_F12.Text = "F12:確定";
                }
                //コンボボックス初期化
                string ymd = bbl.GetDate();
                nnbl = new NyuukinNyuuryoku_BL();
                CboStoreCD.Bind(ymd);

                Scr_Clr(0);

                //スタッフマスター(M_Staff)に存在すること
                //[M_Staff]
                M_Staff_Entity mse = new M_Staff_Entity
                {
                    StaffCD    = InOperatorCD,
                    ChangeDate = ymd
                };
                Staff_BL bl  = new Staff_BL();
                bool     ret = bl.M_Staff_Select(mse);
                if (ret)
                {
                    CboStoreCD.SelectedValue = mse.StoreCD;
                }

                detailControls[0].Focus();
            }
            catch (Exception ex)
            {
                //エラー時共通処理
                MessageBox.Show(ex.Message);
                EndSec();
            }
        }
Exemplo n.º 17
0
        public DataTable MH_Staff_LoginSelect(M_Staff_Entity mse)
        {
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StaffCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.StaffCD
                  } },
                { "@Password", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.Password
                  } }
            };

            return(SelectData(dic, "M_StaffAccess"));
        }
        private bool DisplayData(CKM_SearchControl sc)
        {
            //*** Show Data
            staffdata = new M_Staff_Entity
            {
                StaffCD    = sc.Code,
                ChangeDate = sc.ChangeDate
            };

            dtStaff = mstaffBL.StaffDisplay(staffdata);

            if (dtStaff.Rows.Count > 0)
            {
                txtStaffName.Text                    = dtStaff.Rows[0]["StaffName"].ToString();
                txtStaffKana.Text                    = dtStaff.Rows[0]["StaffKana"].ToString();
                ScStore.Code                         = dtStaff.Rows[0]["StoreCD"].ToString();
                ScStore.LabelText                    = dtStaff.Rows[0]["StoreName"].ToString();
                cboBMNCD.SelectedValue               = dtStaff.Rows[0]["BMNCD"].ToString();
                cboMenu.SelectedValue                = dtStaff.Rows[0]["MenuCD"].ToString();
                cboStoreMenu.SelectedValue           = dtStaff.Rows[0]["StoreMenuCD"].ToString();
                cboAuthorizations.SelectedValue      = dtStaff.Rows[0]["AuthorizationsCD"].ToString();
                cboStoreAuthorizations.SelectedValue = dtStaff.Rows[0]["StoreAuthorizationsCD"].ToString();
                cboPosition.SelectedValue            = dtStaff.Rows[0]["PositionCD"].ToString();
                txtPassword.Text                     = dtStaff.Rows[0]["Password"].ToString();
                txtConfirm.Text                      = dtStaff.Rows[0]["Password"].ToString();
                txtJoinDate.Text                     = dtStaff.Rows[0]["JoinDate"].ToString();
                txtLeaveDate.Text                    = dtStaff.Rows[0]["LeaveDate"].ToString();
                txtReceiptPrint.Text                 = dtStaff.Rows[0]["ReceiptPrint"].ToString();
                txtRemark.Text                       = dtStaff.Rows[0]["Remarks"].ToString();
                if (dtStaff.Rows[0]["DeleteFlg"].ToString() == "1")
                {
                    chkDelete.Checked = true;
                }
                else
                {
                    chkDelete.Checked = false;
                }

                ScStaff.SetFocus(1);

                return(true);
            }
            else
            {
                mstaffBL.ShowMessage("E133");
                return(false);
            }

            // return true;
        }
Exemplo n.º 19
0
        public M_Store_Entity M_Store_InitSelect(M_Staff_Entity mse, M_Store_Entity mste)
        {
            DataTable dt = mstoredl.M_Store_InitSelect(mse);

            if (dt.Rows.Count > 0)
            {
                mste.StoreName = dt.Rows[0]["StoreName"].ToString();
                mste.SysDate   = dt.Rows[0]["sysDate"].ToString();
                mste.StoreCD   = dt.Rows[0]["StoreCD"].ToString();
                Base_DL.iniEntity.DatabaseDate = mste.SysDate;
            }

            return(mste);
        }
Exemplo n.º 20
0
        private void Form_Load(object sender, EventArgs e)
        {
            try
            {
                InProgramID = ProID;
                InProgramNM = ProNm;

                this.SetFunctionLabel(EProMode.SHOW);   //照会プログラムとして起動
                this.InitialControlArray();

                //起動時共通処理
                base.StartProgram();
                Btn_F6.Text = "";
                Btn_F9.Text = "";

                //コンボボックス初期化
                string ymd = bbl.GetDate();
                mibl = new MiNyuukinKakuninShoukai_BL();
                CboStoreCD.Bind(ymd);
                Bind(CboPaymentMethodCD, 1);

                Scr_Clr(0);

                //スタッフマスター(M_Staff)に存在すること
                //[M_Staff]
                M_Staff_Entity mse = new M_Staff_Entity
                {
                    StaffCD    = InOperatorCD,
                    ChangeDate = mibl.GetDate()
                };
                Staff_BL bl  = new Staff_BL();
                bool     ret = bl.M_Staff_Select(mse);
                if (ret)
                {
                    CboStoreCD.SelectedValue = mse.StoreCD;
                }

                //detailControls[(int)EIndex.ShippingDateFrom].Text = ymd;
                //detailControls[(int)EIndex.ShippingDateTo].Text = ymd;

                detailControls[(int)EIndex.StoreCD].Focus();
            }
            catch (Exception ex)
            {
                //エラー時共通処理
                MessageBox.Show(ex.Message);
                EndSec();
            }
        }
Exemplo n.º 21
0
        public DataTable M_StaffDisplay(M_Staff_Entity mbe)
        {
            string sp = "M_Staff_Display";

            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StaffCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.StaffCD
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.Date, value2 = mbe.ChangeDate
                  } }
            };

            return(SelectData(dic, sp));
        }
Exemplo n.º 22
0
        public Tennic_MainMenu(String SCD, M_Staff_Entity mse)
        {
            this.mse = mse;
            InitializeComponent();
            SetDesignerFunction();
            Staff_CD          = SCD;
            mbl               = new Menu_BL();
            menu              = new DataTable();
            lblLoginDate.Text = DateTime.Now.ToString("yyyy/MM/dd");
            var dt = mbl.D_MenuMessageSelect(SCD);

            if (dt.Rows.Count > 0)
            {
                txt_Mesaage.Text = dt.Rows[0]["Message"].ToString();
            }
        }
        private void Form_Load(object sender, EventArgs e)
        {
            try
            {
                Scr_Clr();
                detailControls[(int)EIndex.DayStart].Text = snbl.GetDate();
                detailControls[(int)EIndex.DayEnd].Text   = snbl.GetDate();

                string ymd = snbl.GetDate();
                CboSoukoCD.Bind(ymd);

                //スタッフマスター(M_Staff)に存在すること
                //[M_Staff]
                M_Staff_Entity mse = new M_Staff_Entity
                {
                    StaffCD    = OperatorCD,
                    ChangeDate = snbl.GetDate()
                };
                Staff_BL bl  = new Staff_BL();
                bool     ret = bl.M_Staff_Select(mse);
                if (ret)
                {
                    //[M_Souko_Select]
                    M_Souko_Entity me = new M_Souko_Entity
                    {
                        StoreCD    = mse.StoreCD,
                        SoukoType  = "3",
                        ChangeDate = ymd,
                        DeleteFlg  = "0"
                    };

                    DataTable mdt = snbl.M_Souko_SelectForNyuuka(me);
                    if (mdt.Rows.Count > 0)
                    {
                        CboSoukoCD.SelectedValue = mdt.Rows[0]["SoukoCD"];
                    }
                }

                F9Visible = false;
            }
            catch (Exception ex)
            {
                //エラー時共通処理
                MessageBox.Show(ex.Message);
                //EndSec();
            }
        }
Exemplo n.º 24
0
        public M_Staff_Entity M_Staff_LoginSelect(M_Staff_Entity mse)
        {
            DataTable dtStaff = msdl.M_Staff_LoginSelect(mse);

            if (dtStaff.Rows.Count > 0)
            {
                mse.StaffName             = dtStaff.Rows[0]["StaffName"].ToString();
                mse.StoreCD               = dtStaff.Rows[0]["StoreCD"].ToString();
                mse.StaffKana             = dtStaff.Rows[0]["StaffKana"].ToString();
                mse.BMNCD                 = dtStaff.Rows[0]["BMNCD"].ToString();
                mse.MenuCD                = dtStaff.Rows[0]["MenuCD"].ToString();
                mse.KengenCD              = dtStaff.Rows[0]["AuthorizationsCD"].ToString();
                mse.StoreAuthorizationsCD = dtStaff.Rows[0]["StoreAuthorizationsCD"].ToString();
                mse.PositionCD            = dtStaff.Rows[0]["PositionCD"].ToString();
            }
            return(mse);
        }
Exemplo n.º 25
0
        //MH_Staff_LoginSelect

        /// <summary>
        /// For Default Souko Bind
        /// </summary>
        /// <param name="mse"></param>
        /// <returns></returns>
        public DataTable M_Souko_InitSelect(M_Staff_Entity mse)
        {
            string sp = "M_Souko_InitSelect";
            //KTP 2019-0529 全部のFunctionでしなくてもいいように共通のFunctionでやり方を更新しました。
            //command = new SqlCommand(sp, GetConnection());
            //command.CommandType = CommandType.StoredProcedure;
            //command.CommandTimeout = 0;
            //command.Parameters.Add("@StaffCD", SqlDbType.VarChar).Value = mse.StaffCD;
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StaffCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.StaffCD
                  } }
            };

            //return SelectData(sp);
            return(SelectData(dic, sp));
        }
Exemplo n.º 26
0
        public DataTable M_Staff_SelectAll(M_Staff_Entity mbe)
        {
            string sp = "M_Staff_SelectAll";
            //KTP 2019-0529 全部のFunctionでをしなくてもいいように共通のFunctionでやり方を更新しました。
            //command = new SqlCommand(sp, GetConnection());
            //command.CommandType = CommandType.StoredProcedure;
            //command.CommandTimeout = 0;

            //command.Parameters.Add("@DisplayKbn", SqlDbType.TinyInt).Value = mbe.DisplayKbn;
            //command.Parameters.Add("@ChangeDate", SqlDbType.VarChar).Value = mbe.ChangeDate;
            //command.Parameters.Add("@StoreCD", SqlDbType.VarChar).Value = mbe.StoreCD;
            //command.Parameters.Add("@StaffCDFrom", SqlDbType.VarChar).Value = mbe.StaffCDFrom;
            //command.Parameters.Add("@StaffCDTo", SqlDbType.VarChar).Value = mbe.StaffCDTo;
            //command.Parameters.Add("@StaffName", SqlDbType.VarChar).Value = mbe.StaffName;
            //command.Parameters.Add("@StaffKana", SqlDbType.VarChar).Value = mbe.StaffKana;

            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@DisplayKbn", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mbe.DisplayKbn
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.Date, value2 = mbe.ChangeDate
                  } },
                { "@StoreCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.StoreCD
                  } },
                { "@StaffCDFrom", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.StaffCDFrom
                  } },
                { "@StaffCDTo", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.StaffCDTo
                  } },
                { "@StaffName", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.StaffName
                  } },
                { "@StaffKana", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.StaffKana
                  } },
            };

            //return SelectData(sp);
            return(SelectData(dic, sp));
        }
        private void Form_Load(object sender, EventArgs e)
        {
            try
            {
                base.InProgramID = ProID;
                base.InProgramNM = ProNm;

                this.SetFunctionLabel(EProMode.PRINT);
                this.InitialControlArray();
                base.Btn_F9.Text    = "";
                base.Btn_F9.Enabled = false;
                base.Btn_F10.Text   = "";
                base.Btn_F11.Text   = "";

                //起動時共通処理
                base.StartProgram();

                tabl = new Tanaoroshi_BL();
                string ymd = tabl.GetDate();

                //スタッフマスター(M_Staff)に存在すること
                //[M_Staff]
                M_Staff_Entity mse = new M_Staff_Entity
                {
                    StaffCD    = InOperatorCD,
                    ChangeDate = ymd
                };
                Staff_BL bl  = new Staff_BL();
                bool     ret = bl.M_Staff_Select(mse);

                CboSoukoCD.Bind(ymd, mse.StoreCD);

                SetFuncKeyAll(this, "100001000001");
                Scr_Clr(0);
            }
            catch (Exception ex)
            {
                //エラー時共通処理
                MessageBox.Show(ex.Message);
                EndSec();
            }
        }
Exemplo n.º 28
0
        /// <summary>
        /// EXEではなくFormとして起動した場合に必要な処理
        /// </summary>
        public void StartProgramForForm()
        {
            //[M_Staff]
            M_Staff_Entity mse = new M_Staff_Entity
            {
                StaffCD = InOperatorCD
            };

            mse = loginbl.M_Staff_InitSelect(mse);

            this.lblOperatorName.Text = mse.StaffName;

            M_Store_Entity mste = new M_Store_Entity
            {
                SysDate = mse.SysDate
            };

            mste = loginbl.M_Store_InitSelect(mse, mste);
            this.lblStoreName.Text = mste.StoreName;
        }
Exemplo n.º 29
0
        private M_Staff_Entity GetEntity()
        {
            mke             = new M_Staff_Entity();
            mke.DisplayKbn  = radioButton1.Checked ? "0" : "1";
            mke.ChangeDate  = ckM_Label1.Text;
            mke.StoreCD     = detailControls[(int)EIndex.StoreCD].Text;
            mke.StaffCDFrom = detailControls[(int)EIndex.StaffFrom].Text;

            if (detailControls[(int)EIndex.StaffTo].Text == "")
            {
                mke.StaffCDTo = "ZZZ";
            }
            else
            {
                mke.StaffCDTo = detailControls[(int)EIndex.StaffTo].Text;
            }

            mke.StaffName = detailControls[(int)EIndex.StaffName].Text;
            mke.StaffKana = detailControls[(int)EIndex.StaffKana].Text;

            return(mke);
        }
 public bool M_Staff_Delete(M_Staff_Entity staffdata)
 {
     return(StaffDL.M_Staff_Delete(staffdata));
 }