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(); } } }
/// <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(); } } }
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); } }
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(); } }
private M_Staff_Entity GetInfo() { mse = new M_Staff_Entity { StaffCD = txtOperatorCD.Text, Password = txtPassword.Text }; return(mse); }
/// <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")); }
/// <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; }
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(); } }
/// <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); }
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(); } }
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; }
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); }
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(); } }
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)); }
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(); } }
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); }
//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)); }
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(); } }
/// <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; }
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)); }