private void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { int selectrow = GridItemdetail.FocusedRowHandle; if (selectrow > 0) { DataRow drow = GridItemdetail.GetDataRow(selectrow); string _value = drow["PositionCode"].ToString(); if (Class.App.ConfirmDeletion() == DialogResult.No) { return; } Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu(); dmcv.PositionCode = _value; if (dmcv.Delete()) { Class.App.DeleteSuccessfully(); GetAllList_Position(); } else { Class.App.DeleteNotSuccessfully(); } } }
private void Call_info_toCBO() { Class.DanhMuc_ChiNhanh cn = new Class.DanhMuc_ChiNhanh(); DataTable dtcn = cn.Danhsachchinhanh(); cboOldBranch.Properties.DataSource = dtcn; cboOldBranch.Properties.ValueMember = "BranchCode"; cboOldBranch.Properties.DisplayMember = "BranchName"; cboNewBranch.Properties.DataSource = dtcn; cboNewBranch.Properties.ValueMember = "BranchCode"; cboNewBranch.Properties.DisplayMember = "BranchName"; Class.DanhMuc_PhongBan pb = new Class.DanhMuc_PhongBan(); DataTable dtpb = pb.GetAllList_DEPARTMENT(); cboOldDepartment.Properties.DataSource = dtpb; cboOldDepartment.Properties.ValueMember = "DepartmentCode"; cboOldDepartment.Properties.DisplayMember = "DepartmentName"; // cboNewDepartment.Properties.DataSource = dtpb; // cboNewDepartment.Properties.ValueMember = "DepartmentCode"; // cboNewDepartment.Properties.DisplayMember = "DepartmentName"; Class.Danhmuc_Chucvu cv = new Class.Danhmuc_Chucvu(); DataTable dtcv = cv.GetAlllist_Position();; txtNewPosition.Properties.Items.Clear(); txtOldPosition.Properties.Items.Clear(); for (int i = 0; i < dtcv.Rows.Count; i++) { txtNewPosition.Properties.Items.Add(dtcv.Rows[i]["PositionName"].ToString()); txtOldPosition.Properties.Items.Add(dtcv.Rows[i]["PositionName"].ToString()); } }
private void Update_ChucVu() { Class.Danhmuc_Chucvu dm = new Class.Danhmuc_Chucvu(); dm.PositionCode = txtCode.Text; dm.PositionName = txtName.Text; dm.IsManager = checkActive.Checked; dm.Description = txtDescription.Text; dm.Active = checkActive.Checked; if (txtCode.Enabled == true) { if (dm.Insert()) { Class.App.SaveSuccessfully(); } else { Class.App.SaveNotSuccessfully(); } } else { if (dm.Update()) { Class.App.SaveSuccessfully(); } else { Class.App.SaveNotSuccessfully(); } } if (_reCallFunction == "frmDanhMuc_ChucVu") { (this.Owner as frmDanhMuc_ChucVu).GetAllList_Position(); } }
private void call_info(string Form_name, string code) { Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu(); DataTable dt = dmcv.GetPositionByCode(code); txtCode.Text = dt.Rows[0]["PositionCode"].ToString(); txtName.Text = dt.Rows[0]["PositionName"].ToString(); checkIsManager.Checked = (bool)dt.Rows[0]["IsManager"]; txtDescription.Text = dt.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dt.Rows[0]["Active"]; }
public void GetList_Position() { Class.Danhmuc_Chucvu dm = new Class.Danhmuc_Chucvu(); DataTable dt = dm.GetAlllist_Position(); txtPosition.Properties.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { txtPosition.Properties.Items.Add(dt.Rows[i]["PositionName"].ToString()); } }
private void btnUpdateNew_Click(object sender, EventArgs e) { if (txtName.Text.Length < 1) { Class.App.InputNotAccess(); return; } Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu(); dmcv.PositionCode = txtCode.Text; dmcv.PositionName = txtName.Text; dmcv.IsManager = checkIsManager.Checked; dmcv.Description = txtDescription.Text; dmcv.Active = checkActive.Checked; if (txtCode.Enabled == true) { if (dmcv.Insert()) { Class.App.SaveSuccessfully(); } else { Class.App.SaveNotSuccessfully(); } } else { if (dmcv.Update()) { Class.App.SaveSuccessfully(); } else { Class.App.SaveNotSuccessfully(); } } // xac dinh du lieu co thay doi de reload form danh muc. (this.Owner as frmDanhMuc_ChucVu).GetAllList_Position(); txtCode.Enabled = true; txtName.Text = ""; txtDescription.Text = ""; this.Text = "Thêm chức vụ"; txtCode.Text = call_Code_New(); }
private void btnUpdate_Click(object sender, EventArgs e) { if (txtName.Text.Length < 1) { Class.App.InputNotAccess(); return; } Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu(); dmcv.PositionCode = txtCode.Text; dmcv.PositionName = txtName.Text; dmcv.IsManager = checkIsManager.Checked; dmcv.Description = txtDescription.Text; dmcv.Active = checkActive.Checked; if (txtCode.Enabled == true) { if (dmcv.Insert()) { Class.App.SaveSuccessfully(); } else { Class.App.SaveNotSuccessfully(); } if (dmcv.Update()) { Class.App.SaveSuccessfully(); } else { Class.App.SaveNotSuccessfully(); } (this.Owner as frmDanhMuc_ChucVu).GetAllList_Position(); this.Close(); } }
private string call_Code_New() { Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu(); return(dmcv.GetNewCode()); }
public void GetAllList_Position() { Class.Danhmuc_Chucvu dm = new Class.Danhmuc_Chucvu(); Griditem.DataSource = dm.GetAlllist_Position(); }
private string Call_Code_New(string Form_Name) { string code = ""; switch (Form_Name) { case "TT": Class.CT_Provice dmtt = new Class.CT_Provice(); code = dmtt.GetNewCode(); break; case "HV": Class.Danhmuc_Hocvan dmhv = new Class.Danhmuc_Hocvan(); code = dmhv.GetNewCode(); break; case "BC": Class.Danhmuc_Hocvan dmbc = new Class.Danhmuc_Hocvan(); code = dmbc.GetNewCode(); break; case "CV": Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu(); code = dmcv.GetNewCode(); break; case "CM": Class.DanhMuc_ChuyenMon dmcm = new Class.DanhMuc_ChuyenMon(); code = dmcm.GetNewCode(); break; case "QG": Class.DanhMuc_QuocGia dmqg = new Class.DanhMuc_QuocGia(); code = dmqg.GetNewCode(); break; case "DT": Class.DanhMuc_DanToc dmdt = new Class.DanhMuc_DanToc(); code = dmdt.GetNewCode(); break; case "TG": Class.DanhMuc_TonGiao dmtg = new Class.DanhMuc_TonGiao(); code = dmtg.GetNewCode(); break; case "QHGD": Class.DanhMuc_GiaDinh dmgd = new Class.DanhMuc_GiaDinh(); code = dmgd.GetNewCode(); break; case "TH": Class.DanhMuc_TinHoc dmth = new Class.DanhMuc_TinHoc(); code = dmth.GetNewCode(); break; case "NN": Class.DanhMuc_NgoaiNgu dmnn = new Class.DanhMuc_NgoaiNgu(); code = dmnn.GetNewCode(); break; case "KN": Class.DanhMuc_KyNang dmkn = new Class.DanhMuc_KyNang(); code = dmkn.GetNewCode(); break; } return(code); }
private void call_info(string Form_Name, string code) { switch (Form_Name) { case "TH": Class.DanhMuc_TinHoc dmth = new Class.DanhMuc_TinHoc(); DataTable dtth = dmth.GetInformaticByCode(code); txtCode.Text = dtth.Rows[0]["InformaticCode"].ToString(); txtName.Text = dtth.Rows[0]["InformaticName"].ToString(); txtDescription.Text = dtth.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtth.Rows[0]["Active"]; break; case "NN": Class.DanhMuc_NgoaiNgu dmnn = new Class.DanhMuc_NgoaiNgu(); DataTable dtnn = dmnn.GetLanguageByCode(code); txtCode.Text = dtnn.Rows[0]["LanguageCode"].ToString(); txtName.Text = dtnn.Rows[0]["LanguageName"].ToString(); txtDescription.Text = dtnn.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtnn.Rows[0]["Active"]; break; case "KN": Class.DanhMuc_KyNang dmkn = new Class.DanhMuc_KyNang(); DataTable dtkn = dmkn.GetSkillByCode(code); txtCode.Text = dtkn.Rows[0]["SkillCode"].ToString(); txtName.Text = dtkn.Rows[0]["SkillName"].ToString(); txtDescription.Text = dtkn.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtkn.Rows[0]["Active"]; break; case "TT": Class.CT_Provice dmtt = new Class.CT_Provice(); DataTable dttt = dmtt.GetProvinceByCode(code); txtCode.Text = dttt.Rows[0]["ProvinceCode"].ToString(); txtName.Text = dttt.Rows[0]["ProvinceName"].ToString(); txtDescription.Text = dttt.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dttt.Rows[0]["Active"]; break; case "HV": Class.Danhmuc_Hocvan dmhv = new Class.Danhmuc_Hocvan(); DataTable dthv = dmhv.GetEducationByCode(code); txtCode.Text = dthv.Rows[0]["EducationCode"].ToString(); txtName.Text = dthv.Rows[0]["EducationName"].ToString(); txtDescription.Text = dthv.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dthv.Rows[0]["Active"]; break; case "BC": Class.DanhMuc_BangCap dmbc = new Class.DanhMuc_BangCap(); DataTable dtbc = dmbc.GetDegreeByCode(code); txtCode.Text = dtbc.Rows[0]["DegreeCode"].ToString(); txtName.Text = dtbc.Rows[0]["DegreeName"].ToString(); txtDescription.Text = dtbc.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtbc.Rows[0]["Active"]; break; case "CV": Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu(); DataTable dtcv = dmcv.GetPositionByCode(code); txtCode.Text = dtcv.Rows[0]["PositionCode"].ToString(); txtName.Text = dtcv.Rows[0]["PositionName"].ToString(); txtDescription.Text = dtcv.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtcv.Rows[0]["Active"]; break; case "CM": Class.DanhMuc_ChuyenMon dmcm = new Class.DanhMuc_ChuyenMon(); DataTable dtcm = dmcm.GetProfessionalByCode(code); txtCode.Text = dtcm.Rows[0]["ProfessionalCode"].ToString(); txtName.Text = dtcm.Rows[0]["ProfessionalName"].ToString(); txtDescription.Text = dtcm.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtcm.Rows[0]["Active"]; break; case "QG": Class.DanhMuc_QuocGia dmqg = new Class.DanhMuc_QuocGia(); DataTable dtqg = dmqg.GetNationalityByCode(code); txtCode.Text = dtqg.Rows[0]["NationalityCode"].ToString(); txtName.Text = dtqg.Rows[0]["NationalityName"].ToString(); txtDescription.Text = dtqg.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtqg.Rows[0]["Active"]; break; case "DT": Class.DanhMuc_DanToc dmdt = new Class.DanhMuc_DanToc(); DataTable dtdt = dmdt.GetEthnicByCode(code); txtCode.Text = dtdt.Rows[0]["EthnicCode"].ToString(); txtName.Text = dtdt.Rows[0]["EthnicName"].ToString(); txtDescription.Text = dtdt.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtdt.Rows[0]["Active"]; break; case "TG": Class.DanhMuc_TonGiao dmtg = new Class.DanhMuc_TonGiao(); DataTable dttg = dmtg.GetReligionByCode(code); txtCode.Text = dttg.Rows[0]["ReligionCode"].ToString(); txtDescription.Text = dttg.Rows[0]["ReligionName"].ToString(); txtName.Text = dttg.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dttg.Rows[0]["Active"]; break; case "QHGD": Class.DanhMuc_GiaDinh dmgd = new Class.DanhMuc_GiaDinh(); DataTable dtgd = dmgd.GetRelativeByCode(code); txtCode.Text = dtgd.Rows[0]["RelativeCode"].ToString(); txtDescription.Text = dtgd.Rows[0]["RelativeName"].ToString(); txtName.Text = dtgd.Rows[0]["Description"].ToString(); checkActive.Checked = (bool)dtgd.Rows[0]["Active"]; break; } }