private MasterTourokuStaff GetInsertStaff() { MasterTourokuStaff obj = new MasterTourokuStaff(); obj.StaffCD = txt_Staff.Text.ToString(); obj.ChangeDate = txtStaff_CDate.Text.ToString(); obj.StaffName = txtStaff_Name.Text.ToString(); obj.KanaName = txtStaff_KanaName.Text.ToString(); int int_val = 0; int.TryParse(txtStaff_Search.Text, NumberStyles.Any, CultureInfo.CurrentCulture, out int_val); obj.KensakuHyouziJun = int_val.ToString(); obj.MenuCD = cboStaff_Menu.SelectedValue.ToString(); obj.AuthorizationsCD = cboStaff_authority.SelectedValue.ToString(); obj.PositionCD = string.IsNullOrEmpty(cboStaff_Position.Text.ToString()) ? "" : cboStaff_Position.SelectedValue.ToString(); obj.JoinDate = txtStaff_JDate.Text.ToString(); obj.LeaveDate = txtStaff_LDate.Text.ToString(); obj.Passward = txtStaff_Passward.Text; obj.Remarks = txtStaff_Remark.Text; obj.UsedFlg = 0; obj.InsertOperator = base_Entity.OperatorCD; obj.UpdateOperator = base_Entity.OperatorCD; //for log table obj.ProgramID = base_Entity.ProgramID; obj.KeyItem = txt_Staff.Text.ToString() + " " + txtStaff_CDate.Text; obj.PC = base_Entity.PC; return(obj); }
public DataTable Staff_Search(MasterTourokuStaff obj) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[6]; parameters[0] = new SqlParameter("@StaffCD1", SqlDbType.VarChar) { Value = obj.StaffCD }; parameters[1] = new SqlParameter("@StaffCD2", SqlDbType.VarChar) { Value = obj.Passward }; parameters[2] = new SqlParameter("@StaffName", SqlDbType.VarChar) { Value = obj.StaffName }; parameters[3] = new SqlParameter("@KanaName", SqlDbType.VarChar) { Value = obj.KanaName }; parameters[4] = new SqlParameter("@RadioCheck", SqlDbType.VarChar) { Value = obj.Remarks }; parameters[5] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = obj.ChangeDate }; DataTable dt = ckmdl.SelectDatatable("Staff_Search", GetConnectionString(), parameters); return(dt); }
private void DoDelete(MasterTourokuStaff obj) { StaffBL objMethod = new StaffBL(); string return_Bl = objMethod.M_Staff_CUD(obj); if (return_Bl == "true") { bbl.ShowMessage("I102"); } }
public DataTable MH_Staff_LoginSelect(MasterTourokuStaff mts) { CKMDL ckmdl = new CKMDL(); mts.Sqlprms = new SqlParameter[2]; mts.Sqlprms[0] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = mts.StaffCD }; mts.Sqlprms[1] = new SqlParameter("@Password", SqlDbType.VarChar) { Value = mts.Passward }; return(ckmdl.SelectDatatable("M_StaffAccess", GetConnectionString(), mts.Sqlprms)); }
public DataTable D_MenuMessageSelect(string SCD) { MasterTourokuStaff mts = new MasterTourokuStaff() { StaffCD = SCD }; // return mdl.D_MenuMessageSelect(SCD); CKMDL ckmdl = new CKMDL(); mts.Sqlprms = new SqlParameter[1]; mts.Sqlprms[0] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = mts.StaffCD }; return(ckmdl.SelectDatatable("SMENU", GetConnectionString(), mts.Sqlprms)); }
private void DataGridviewBind() { MasterTourokuStaff obj = new MasterTourokuStaff(); obj.ChangeDate = changeDate_Access; obj.StaffCD = txtStaff1.Text; obj.Passward = txtStaff2.Text;//using tempory for assign data obj.StaffName = txtStaffName.Text; obj.KanaName = txtKanaName.Text; obj.Remarks = string.Empty; if (rdo_Date.Checked) { obj.Remarks = "RevisionDate"; } if (rdo_All.Checked) { obj.Remarks = "All"; } StaffBL objMethod = new StaffBL(); DataTable dt = objMethod.Staff_Search(obj); if (dt.Columns.Contains("CurrentDay")) { if (dt.Rows.Count > 0) { lbl_Date.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDay"]); //dt.Columns.Remove("CurrentDay"); } else { ClearSession(); //HET } } else { if (dt.Rows.Count == 0) //HET { ClearSession(); } } // dt.Columns.Remove("CurrentDay"); gvStaff.DataSource = dt; }
private void DBProcess() { MasterTourokuStaff entity = GetInsertStaff(); if (cboMode.SelectedValue.Equals("1")) { entity.Mode = "New"; DoInsert(entity); } else if (cboMode.SelectedValue.Equals("2")) { entity.Mode = "Update"; DoUpdate(entity); } else if (cboMode.SelectedValue.Equals("3")) { entity.Mode = "Delete"; DoDelete(entity); } }
private void Login_Click() { StartProg(); if (ErrorCheck()) { MasterTourokuStaff mts = new MasterTourokuStaff() { StaffCD = OperatorCD, Passward = txtPassword.Text }; var mse = loginbl.MH_Staff_LoginSelect(mts); if (mse.Rows.Count > 0) { if (mse.Rows[0]["MessageID"].ToString() == "Allow") { if (loginbl.D_MenuMessageSelect(OperatorCD).Rows.Count == 0) { loginbl.ShowMessage("S013"); txtOperatorCD.Select(); return; } ShinyohMenu menuForm = new ShinyohMenu(OperatorCD, BaseBL.IEntity.Version); this.Hide(); menuForm.ShowDialog(); this.Close(); } else { loginbl.ShowMessage(mse.Rows[0]["MessageID"].ToString()); txtOperatorCD.Select(); } } else { loginbl.ShowMessage("E101"); txtOperatorCD.Select(); } } }
public string M_Staff_CUD(MasterTourokuStaff obj) { CKMDL ckmdl = new CKMDL(); ckmdl.UseTran = true; obj.Sqlprms = new SqlParameter[18]; obj.Sqlprms[0] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = obj.StaffCD }; obj.Sqlprms[1] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = obj.ChangeDate }; obj.Sqlprms[2] = new SqlParameter("@StaffName", SqlDbType.VarChar) { Value = obj.StaffName }; obj.Sqlprms[3] = new SqlParameter("@KanaName", SqlDbType.VarChar) { Value = obj.KanaName }; obj.Sqlprms[4] = new SqlParameter("@KensakuHyouziJun", SqlDbType.VarChar) { Value = obj.KensakuHyouziJun }; obj.Sqlprms[5] = new SqlParameter("@MenuCD", SqlDbType.VarChar) { Value = obj.MenuCD }; obj.Sqlprms[6] = new SqlParameter("@AuthorizationsCD", SqlDbType.VarChar) { Value = obj.AuthorizationsCD }; obj.Sqlprms[7] = new SqlParameter("@PositionCD", SqlDbType.VarChar) { Value = obj.PositionCD }; obj.Sqlprms[8] = new SqlParameter("@JoinDate", SqlDbType.VarChar) { Value = obj.JoinDate }; obj.Sqlprms[9] = new SqlParameter("@LeaveDate", SqlDbType.VarChar) { Value = obj.LeaveDate }; obj.Sqlprms[10] = new SqlParameter("@Passward", SqlDbType.VarChar) { Value = obj.Passward }; obj.Sqlprms[11] = new SqlParameter("@Remarks", SqlDbType.VarChar) { Value = obj.Remarks }; //obj.Sqlprms[12] = new SqlParameter("@UsedFlg", SqlDbType.VarChar) { Value = obj.UsedFlg }; obj.Sqlprms[12] = new SqlParameter("@InsertOperator", SqlDbType.VarChar) { Value = obj.InsertOperator }; obj.Sqlprms[13] = new SqlParameter("@UpdateOperator", SqlDbType.VarChar) { Value = obj.UpdateOperator }; obj.Sqlprms[14] = new SqlParameter("@Mode", SqlDbType.VarChar) { Value = obj.Mode }; obj.Sqlprms[15] = new SqlParameter("@Program", SqlDbType.VarChar) { Value = obj.ProgramID }; obj.Sqlprms[16] = new SqlParameter("@PC", SqlDbType.VarChar) { Value = obj.PC }; obj.Sqlprms[17] = new SqlParameter("@KeyItem", SqlDbType.VarChar) { Value = obj.KeyItem }; //obj.Sqlprms[19] = new SqlParameter("@YuubinNO1", SqlDbType.VarChar) { Value = obj.YuubinNO1 }; //obj.Sqlprms[20] = new SqlParameter("@YuubinNO2", SqlDbType.VarChar) { Value = obj.YuubinNO2}; return(ckmdl.InsertUpdateDeleteData("M_Staff_CUD", GetConnectionString(), obj.Sqlprms)); }