protected override void ExecDisp()
        {
            //if (CboStoreCD.SelectedValue == null)
            //    return;

            M_StoreClose_Entity me = new M_StoreClose_Entity
            {
                StoreCD      = CboStoreCD.SelectedValue == null ? "": CboStoreCD.SelectedValue.ToString(),
                FiscalYYYYMM = lblChangeDate.Text.Replace("/", ""),
                Operator     = InOperatorCD,
                Mode         = Mode
            };

            if (Mode.Equals(1))
            {
                M_Store_Entity mse = new M_Store_Entity();
                mse.ChangeDate = gsbl.GetDate();
                me.StoreCD     = gsbl.GetHonsha(mse);
            }

            bool ret = gsbl.M_StoreClose_SelectAll(me);

            if (!ret)
            {
                //Insertしたあとに再度Select
                ret = gsbl.M_StoreClose_SelectAll(me);
            }
            if (!string.IsNullOrWhiteSpace(me.FiscalYYYYMM))
            {
                lblChangeDate.Text = me.FiscalYYYYMM.Substring(0, 4) + "/" + me.FiscalYYYYMM.Substring(4, 2);
                lblKakutei.Text    = lblChangeDate.Text;
            }
            SetProperty(me.ClosePosition1, lblUriage, BtnUriage);
            SetProperty(me.ClosePosition3, lblNyukin, BtnNyukin);
            SetProperty(me.ClosePosition2, lblShiire, BtnShiire);
            SetProperty(me.ClosePosition4, lblShiharai, BtnShiharai);
            SetProperty(me.ClosePosition5, lblZaiko, BtnZaiko);

            SetPropertyShukei(me.MonthlyClaimsFLG, lblSaiken, BtnSaiken);
            SetPropertyShukei(me.MonthlyDebtFLG, lblSaimu, BtnSaimu);
            SetPropertyShukei(me.MonthlyStockFLG, lblZaikoShukei, BtnZaikoShukei);

            BtnAllShukei.Text = "まとめて\n計算する";
            BtnKakutei.Text   = "確定する(翌月度へ)";
            BtnKaijo.Text     = "解除する(前月度へ)";

            if (me.ClosePosition1.Equals("1") && me.ClosePosition2.Equals("1") && me.ClosePosition3.Equals("1") && me.ClosePosition4.Equals("1") && me.ClosePosition5.Equals("1") &&
                me.MonthlyClaimsFLG.Equals("1") && me.MonthlyDebtFLG.Equals("1") && me.MonthlyStockFLG.Equals("1"))
            {
                BtnKakutei.BackColor = Color.FromArgb(255, 192, 0);
                BtnKakutei.Enabled   = true;
                BtnKaijo.Enabled     = true;
            }
            else
            {
                BtnKakutei.BackColor = Color.FromArgb(255, 255, 0);
                BtnKakutei.Enabled   = false;
                BtnKaijo.Enabled     = true;
            }
        }
        public DataTable M_Store_Select(M_Store_Entity mbe)
        {
            string sp = "M_Store_Select";

            //command = new SqlCommand(sp, GetConnection());
            //command.CommandType = CommandType.StoredProcedure;
            //command.CommandTimeout = 0;

            //command.Parameters.Add("@StoreCD", SqlDbType.VarChar).Value = mbe.StoreCD;
            //command.Parameters.Add("@ChangeDate", SqlDbType.VarChar).Value = mbe.ChangeDate;

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

            return(SelectData(dic, sp));

            //return SelectData(sp);
        }
示例#3
0
        private bool CheckDetail(int index)
        {
            switch (index)
            {
            case (int)EIndex.StoreCD:
                //入力なければチェックなし
                if (detailControls[index].Text == "")
                {
                    ScStore.LabelText = "";
                    return(true);
                }
                else
                {
                    //ストアマスタデータチェック
                    Store_BL       mbl = new Store_BL();
                    M_Store_Entity mse = new M_Store_Entity
                    {
                        StoreCD    = detailControls[index].Text,
                        ChangeDate = ckM_Label1.Text
                    };

                    DataTable dt = mbl.M_Store_Select(mse);
                    if (dt.Rows.Count > 0)
                    {
                        ScStore.LabelText = dt.Rows[0]["StoreName"].ToString();
                    }
                    else
                    {
                        //E136
                        mbl.ShowMessage("E136");
                        ScStore.LabelText = "";
                        return(false);
                    }
                }
                break;

            case (int)EIndex.StaffName:

                break;

            case (int)EIndex.StaffTo:
                if (detailControls[index].Text != "")
                {
                    int result = detailControls[index].Text.CompareTo(detailControls[index - 1].Text);
                    if (result < 0)
                    {
                        //E106
                        mbl.ShowMessage("E106");
                        detailControls[index].Focus();
                        return(false);
                    }
                }
                break;
            }

            return(true);
        }
        public DataTable GetHonsha(M_Store_Entity mse)
        {
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.ChangeDate
                  } }
            };

            return(SelectData(dic, "SelectHonshaStore"));
        }
        public DataTable M_Store_BindData(M_Store_Entity mse)
        {
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@Operator", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = ""
                  } }
            };

            return(SelectData(dic, "M_Store_BindData"));
        }
        private DataTable StoreData()
        {
            storedata = new M_Store_Entity()
            {
                StoreCD    = ScStore.Code,
                ChangeDate = ScStore.ChangeDate
            };
            dtStore = mstaffBL.StoreCheck(storedata);

            return(dtStore);
        }
示例#7
0
        /// <summary>
        /// 改定日として有効なレコードで違う店舗で同じAPIKeyがあればTrue
        /// </summary>
        /// <param name="mse"></param>
        /// <returns></returns>
        public bool Store_SelectByApiKey(M_Store_Entity mse)
        {
            DataTable dt = storedl.M_Store_SelectByApiKey(mse);

            if (dt.Rows.Count > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
        public string GetHonsha(M_Store_Entity me)
        {
            M_Store_DL dl = new M_Store_DL();
            DataTable  dt = dl.GetHonsha(me);

            if (dt.Rows.Count > 0)
            {
                me.StoreCD = dt.Rows[0]["StoreCD"].ToString();

                return(me.StoreCD);
            }
            return("");
        }
示例#9
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);
        }
示例#10
0
        public bool M_Store_SelectByKbn(M_Store_Entity me)
        {
            M_Store_DL dl = new M_Store_DL();
            DataTable  dt = dl.M_Store_SelectByKbn(me);

            if (dt.Rows.Count > 0)
            {
                me.StoreCD = dt.Rows[0]["StoreCD"].ToString();
                return(true);
            }
            else
            {
                return(false);
            }
        }
        public DataTable M_Store_SelectAll(M_Store_Entity mbe)
        {
            string sp = "M_Store_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("@StoreCDFrom", SqlDbType.VarChar).Value = mbe.StoreCDFrom;
            //command.Parameters.Add("@StoreCDTo", SqlDbType.VarChar).Value = mbe.StoreCDTo;
            //command.Parameters.Add("@StoreName", SqlDbType.VarChar).Value = mbe.StoreName;
            //command.Parameters.Add("@StoreKBN1", SqlDbType.TinyInt).Value = mbe.StoreKBN1;
            //command.Parameters.Add("@StoreKBN2", SqlDbType.TinyInt).Value = mbe.StoreKBN2;
            //command.Parameters.Add("@StoreKBN3", SqlDbType.TinyInt).Value = mbe.StoreKBN3;
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@DisplayKbn", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mbe.DisplayKbn
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.ChangeDate
                  } },
                { "@StoreCDFrom", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.StoreCDFrom
                  } },
                { "@StoreCDTo", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.StoreCDTo
                  } },
                { "@StoreName", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.StoreName
                  } },
                { "@StoreKBN1", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mbe.StoreKBN1
                  } },
                { "@StoreKBN2", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mbe.StoreKBN2
                  } },
                { "@StoreKBN3", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mbe.StoreKBN3
                  } },
            };

            //return SelectData(sp);
            return(SelectData(dic, sp));
        }
        /// <summary>
        /// Select Store's info
        /// StoreKBN IN 1のStore情報をBind
        /// </summary>
        /// <param name="mse">staff info</param>
        /// <returns></returns>
        public DataTable M_Store_Bind_Juchu(M_Store_Entity mse)
        {
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StoreCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.StoreCD
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.Date, value2 = mse.ChangeDate
                  } },
                { "@DeleteFlg", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg
                  } }
            };

            return(SelectData(dic, "M_Store_Bind_Juchu"));
        }
        public DataTable M_Store_SelectByApiKey(M_Store_Entity mse)
        {
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StoreCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.StoreCD
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mse.ChangeDate
                  } },
                { "@APIKey", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mse.APIKey
                  } }
            };

            return(SelectData(dic, "M_Store_SelectByApiKey"));
        }
        /// <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;
        }
        /// Select Store's info
        /// StoreKBN,StorePlaceKBNの条件でStore情報を取得
        /// </summary>
        /// <param name="mse">store info</param>
        /// <returns></returns>
        public DataTable M_Store_SelectByKbn(M_Store_Entity mse)
        {
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StoreKBN", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mse.StoreKBN
                  } },
                { "@StorePlaceKBN", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mse.StorePlaceKBN
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.Date, value2 = mse.ChangeDate
                  } },
                { "@DeleteFlg", new ValuePair {
                      value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg
                  } }
            };

            return(SelectData(dic, "M_Store_SelectByKbn"));
        }
        /// <summary>
        /// 店舗マスタ取得処理
        /// MasterTouroku_Tempoよりデータ抽出時に使用
        /// </summary>
        public DataTable M_Store_SelectData(M_Store_Entity mbe)
        {
            string sp = "M_Store_SelectData";
            //KTP 2019-0529 全部のFunctionでをしなくてもいいように共通のFunctionでやり方を更新しました。
            //command = new SqlCommand(sp, GetConnection());
            //command.CommandType = CommandType.StoredProcedure;
            //command.CommandTimeout = 0;

            //command.Parameters.Add("@StoreCD", SqlDbType.VarChar).Value = mbe.StoreCD;
            //command.Parameters.Add("@ChangeDate", SqlDbType.VarChar).Value = mbe.ChangeDate;
            Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
            {
                { "@StoreCD", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.StoreCD
                  } },
                { "@ChangeDate", new ValuePair {
                      value1 = SqlDbType.VarChar, value2 = mbe.ChangeDate
                  } }
            };

            //return SelectData(sp);
            return(SelectData(dic, sp));
        }
示例#17
0
 /// <summary>
 /// 店舗マスタ取得処理
 /// MasterTouroku_Tempoよりデータ抽出時に使用
 /// </summary>
 public DataTable Store_SelectData(M_Store_Entity mse)
 {
     return(storedl.M_Store_SelectData(mse));
 }
 public DataTable BindStore(M_Store_Entity storedata)
 {
     return(SimpleSelect1("25", storedata.ChangeDate));
 }
        /// <summary>
        /// 画面クリア(0:全項目、1:KEY部以外)
        /// </summary>
        /// <param name="Kbn"></param>
        private void Scr_Clr(short Kbn)
        {
            foreach (Control ctl in detailControls)
            {
                if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_RadioButton)))
                {
                    ((RadioButton)ctl).Checked = false;
                }
                else if (ctl.GetType().Equals(typeof(Panel)))
                {
                }
                else if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_ComboBox)))
                {
                    ((CKM_Controls.CKM_ComboBox)ctl).SelectedIndex = -1;
                }
                else
                {
                    ctl.Text = "";
                }
            }

            //初期値セット
            string ymd = nnbl.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);

            if (ret)
            {
                CboStoreCD.SelectedValue = mse.StoreCD;
                //パラメータ 基準日:Form.日付,店舗:Form.店舗	,得意先区分:3
                ScCustomer.Value2 = mse.StoreCD;
            }

            //[M_Store]
            M_Store_Entity mse2 = new M_Store_Entity
            {
                StoreCD    = mse.StoreCD,
                ChangeDate = ymd
            };
            Store_BL  sbl = new Store_BL();
            DataTable dt  = sbl.M_Store_Select(mse2);

            if (dt.Rows.Count > 0)
            {
            }
            else
            {
                bbl.ShowMessage("E133");
                EndSec();
            }

            ((RadioButton)detailControls[(int)EIndex.RdoZan]).Checked = true;

            GvDetail.DataSource = null;
            GvDetail.Enabled    = false;
        }
        /// <summary>
        /// 起動時共通処理
        ///
        /// check Authorization
        /// insert to log(form open)
        /// </summary>
        /// <remarks>プログラム起動時に呼び出してください</remarks>
        protected void StartProgram()
        {
            //共通処理 受取パラメータ、接続情報
            //コマンドライン引数より情報取得
            //Iniファイルより情報取得
            //this.GetCmdLine() == false ||

            if (this.GetCmdLine() == false || loginbl.ReadConfig() == false)
            {
                //起動時エラー    DB接続不可能
                this.Close();
                System.Environment.Exit(0);
            }


            //共通処理 Operator 確認
            //[M_Staff]
            M_Staff_Entity mse = new M_Staff_Entity
            {
                StaffCD = InOperatorCD
            };

            mse = loginbl.M_Staff_InitSelect(mse);

            // MessageBox.Show(bbl.GetConnectionString());

            this.lblOperatorName.Text = mse.StaffName;
            //this.lblLoginDate.Text = mse.SysDate;
            DataTable dtShopName = bbl.SimpleSelect1("42", null, "222", "1");

            this.lblShopName.Text = dtShopName.Rows[0]["Char1"].ToString();

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

            mste = loginbl.M_Store_InitSelect(mse, mste);
            this.lblStoreName.Text = mste.StoreName;
            StoreCD    = mste.StoreCD;
            ChangeDate = mste.SysDate;

            //共通処理 プログラム
            //KTP - 2019-05-29 ProgramのチェックはM_Authorizations_AccessCheck にやっています。
            //[M_Program]
            //mpe = new M_Program_Entity
            //{
            //    ProgramID = InProgramID,
            //    Type = "1"  //仮
            //};

            //bool ret = loginbl.M_Program_InitSelect(mpe);
            //if (ret == false)
            //{
            //    //S012
            //    bbl.ShowMessage("S012");
            //    //起動時エラー
            //    this.Close();
            //    System.Environment.Exit(0);
            //}

            //Authorizations判断
            M_Authorizations_Entity mae;

            mae = new M_Authorizations_Entity
            {
                ProgramID = this.InProgramID,
                StaffCD   = InOperatorCD,
                PC        = InPcID
            };

            made = bbl.M_Authorizations_AccessCheck(mae);

            if (made == null)
            {
                bbl.ShowMessage(mae.MessageID);
                //起動時エラー
                this.Close();
                System.Environment.Exit(0);
            }

            //KTP 2019-05-29 Set ProgrameName, ProgramID
            this.Text = made.ProgramID;
            //lblHeaderTitle.Text = made.ProgramName;

            //KTP 2019-05-29 M_Authorizations_AccessCheckにやっています。 line no 513 to 521
            //Program type判断
            //switch (mpe.Type)
            //{
            //    case "1":

            //        if (made.Insertable == "0" && made.Updatable == "0" && made.Deletable == "0" && made.Inquirable == "0")
            //        {
            //            //S003
            //            bbl.ShowMessage("S003");
            //            //起動時エラー
            //            this.Close();
            //            System.Environment.Exit(0);
            //        }
            //        break;

            //    case "2":
            //        if (made.Printable == "0")
            //        {
            //            //S003
            //            bbl.ShowMessage("S003");
            //            //起動時エラー
            //            this.Close();
            //            System.Environment.Exit(0);
            //        }
            //        break;

            //    case "3":
            //        if (made.Printable == "0" && made.Outputable == "0")
            //        {
            //            //S003
            //            bbl.ShowMessage("S003");
            //            //起動時エラー
            //            this.Close();
            //            System.Environment.Exit(0);
            //        }
            //        break;

            //    case "4":
            //        if (made.Outputable == "0")
            //        {
            //            //S003
            //            bbl.ShowMessage("S003");
            //            //起動時エラー
            //            this.Close();
            //            System.Environment.Exit(0);
            //        }
            //        break;

            //    case "5":
            //        if (made.Inquirable == "0")
            //        {
            //            //S003
            //            bbl.ShowMessage("S003");
            //            //起動時エラー
            //            this.Close();
            //            System.Environment.Exit(0);
            //        }
            //        break;

            //    case "6":
            //        if (made.Runable == "0")
            //        {
            //            //S003
            //            bbl.ShowMessage("S003");
            //            //起動時エラー
            //            this.Close();
            //            System.Environment.Exit(0);
            //        }
            //        break;
            //}

            //処理可能店舗
            //[M_StoreAuthorizations]
            M_StoreAuthorizations_Entity msa = new M_StoreAuthorizations_Entity();

            msa.StoreAuthorizationsCD = made.StoreAuthorizationsCD;

            DataTable dt = bbl.M_StoreAuthorizations_Select(msa);

            if (dt.Rows.Count > 0)
            {
                availableStores = new string[dt.Rows.Count];
                int i = 0;
                foreach (DataRow row in dt.Rows)
                {
                    availableStores[i] = row["StoreCD"].ToString();
                    i++;
                }
            }
            ///Added by ETZ ,To close when StoreAuthorization isn't accessed
            else
            {
                bbl.ShowMessage(mae.MessageID);
                //起動時エラー
                this.Close();
                System.Environment.Exit(0);
            }

            //プログラム起動履歴
            //InsertLog(Get_L_Log_Entity(true));

            //KTP 2019-05-29 Program Type Select from M_Authorizations_AccessCheck function
            //Todo:入力プログラム以外を考慮
            //switch (mpe.Type)
            //switch (made.ProgramType)
            //{
            //    case "1":
            //        if (made.Insertable == "1")
            //        {
            //            // 新規ボタン押下処理
            //            FunctionProcess((int)EOperationMode.INSERT);
            //        }
            //        else if (made.Updatable == "1")
            //        {
            //            // 修正ボタン押下処理
            //            FunctionProcess((int)EOperationMode.UPDATE);
            //        }
            //        else if (made.Deletable == "1")
            //        {
            //            // 削除ボタン押下処理
            //            FunctionProcess((int)EOperationMode.DELETE);
            //        }
            //        else
            //        {
            //            // 照会ボタン押下処理
            //            FunctionProcess((int)EOperationMode.SHOW);
            //        }
            //        break;
            //}
        }
 public DataTable M_Store_Bind(M_Store_Entity mse)
 {
     return(msdl.M_Store_Bind(mse));
 }
示例#22
0
 /// <summary>
 /// StoreKBN IN 1のStore情報をBind
 /// </summary>
 /// <param name="mse"></param>
 /// <returns></returns>
 public DataTable M_Store_Bind_Juchu(M_Store_Entity mse)
 {
     return(storedl.M_Store_Bind_Juchu(mse));
 }
示例#23
0
        /// <summary>
        /// 画面クリア(0:全項目、1:KEY部以外)
        /// </summary>
        /// <param name="Kbn"></param>
        private void Scr_Clr(short Kbn)
        {
            foreach (Control ctl in detailControls)
            {
                if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_CheckBox)))
                {
                    ((CheckBox)ctl).Checked = false;
                }
                else if (ctl.GetType().Equals(typeof(Panel)))
                {
                }
                else if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_ComboBox)))
                {
                    ((CKM_Controls.CKM_ComboBox)ctl).SelectedIndex = -1;
                }
                else
                {
                    ctl.Text = "";
                }
            }

            ScVendor.LabelText = "";
            //foreach (Control ctl in detailLabels)
            //{
            //    ((CKM_SearchControl)ctl).LabelText = "";
            //}


            //初期値セット
            string ymd = ssbl.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);

            if (ret)
            {
                CboStoreCD.SelectedValue = mse.StoreCD;
            }

            //[M_Store]
            M_Store_Entity mse2 = new M_Store_Entity
            {
                StoreCD    = mse.StoreCD,
                ChangeDate = ymd
            };
            Store_BL  sbl = new Store_BL();
            DataTable dt  = sbl.M_Store_Select(mse2);

            if (dt.Rows.Count > 0)
            {
            }
            else
            {
                bbl.ShowMessage("E133");
                EndSec();
            }

            ((CheckBox)detailControls[(int)EIndex.ChkMiNyuka]).Checked   = true;
            ((CheckBox)detailControls[(int)EIndex.ChkNyukaZumi]).Checked = true;

            for (int i = (int)EIndex.ChkJuchuAri; i <= (int)EIndex.ChkEdi; i++)
            {
                if (detailControls[i].GetType().Equals(typeof(CKM_Controls.CKM_CheckBox)))
                {
                    ((CheckBox)detailControls[i]).Checked = true;
                }
            }

            GvDetail.DataSource = null;
            GvDetail.Enabled    = false;
            Btn_F10.Enabled     = false;

            detailControls[0].Focus();
        }
示例#24
0
 /// <summary>
 /// 店舗マスタ更新処理
 /// MasterTouroku_Tempoより更新時に使用
 /// </summary>
 public bool Store_Exec(M_Store_Entity mse, short operationMode, string operatorNm, string pc)
 {
     return(storedl.M_Store_Exec(mse, operationMode, operatorNm, pc));
 }
示例#25
0
 public DataTable M_Store_SelectAll(M_Store_Entity mse)
 {
     return(storedl.M_Store_SelectAll(mse));
 }
示例#26
0
 /// <summary>
 /// StoreKBN NOT IN 2のStore情報をBind(権限のある店舗のみ)
 /// </summary>
 /// <param name="mse"></param>
 /// <returns></returns>
 public DataTable M_Store_Bind_Getsuji(M_Store_Entity mse)
 {
     return(storedl.M_Store_Bind_Getsuji(mse));
 }
        /// <summary>
        /// 画面クリア(0:全項目、1:KEY部以外)
        /// </summary>
        /// <param name="Kbn"></param>
        private void Scr_Clr(short Kbn)
        {
            foreach (Control ctl in detailControls)
            {
                if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_CheckBox)))
                {
                    ((CheckBox)ctl).Checked = false;
                }
                else if (ctl.GetType().Equals(typeof(Panel)))
                {
                }
                else if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_ComboBox)))
                {
                    ((CKM_Controls.CKM_ComboBox)ctl).SelectedIndex = -1;
                }
                else
                {
                    ctl.Text = "";
                }
            }

            foreach (Control ctl in detailLabels)
            {
                ((CKM_SearchControl)ctl).LabelText = "";
            }


            //初期値セット
            string ymd = mibl.GetDate();

            //スタッフマスター(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;
            }

            //[M_Store]
            M_Store_Entity mse2 = new M_Store_Entity
            {
                StoreCD    = mse.StoreCD,
                ChangeDate = ymd
            };
            Store_BL  sbl = new Store_BL();
            DataTable dt  = sbl.M_Store_Select(mse2);

            if (dt.Rows.Count > 0)
            {
            }
            else
            {
                bbl.ShowMessage("E133");
                EndSec();
            }

            CboSoukoName.Enabled = false;
            detailControls[1].Focus();
        }
示例#28
0
 public DataTable BindStore(M_Store_Entity mse)// Bind datat to comboBox
 {
     return(storedl.M_Store_Bind(mse));
     //return storedl.SimpleSelect("StoreName,StoreCD", "F_Store ('" + changedate + "')","DeleteFlg = 0 And (StoreKBN = 2 OR StoreKBN = 3) Order By StoreCD");
 }
 public DataTable StoreCheck(M_Store_Entity storedata)
 {
     return(SimpleSelect1("17", storedata.ChangeDate, storedata.StoreCD));
 }
示例#30
0
 public DataTable BindData(M_Store_Entity mse)
 {
     return(storedl.M_Store_BindData(mse));
 }