//Обновление строки private void UpdateRecord() { if (dgvGradeAllwnc.CurrentRow == null) { return; } v_RefGradeAllwnc v_allowance = dgvGradeAllwnc.CurrentRow.DataBoundItem as v_RefGradeAllwnc; if (v_allowance == null) { MessageBox.Show("Не знайдений рядок для оновлення", "Помилка"); return; } fmRefGradeAllwncEdit fmEdit = new fmRefGradeAllwncEdit(EnumFormMode.Edit, "Зміна надбавки за класність"); fmEdit.SetData(_refGradeAllwncs.FirstOrDefault(rec => rec.RefGradeAllwnc_Id == v_allowance.RefGradeAllwnc_Id)); if (fmEdit.ShowDialog() == DialogResult.OK) { RefGradeAllwnc allowance = fmEdit.GetData(); string error; if (!_repository.ModifyGradeAllwnc(allowance, out error)) { MessageBox.Show("Помилка оновлення рядка.\nТехнічна інформація: " + error, "Помилка"); return; } RefreshTable(); } }
private void tbCd_Validating(object sender, CancelEventArgs e) { if (_cmbParams.tbCd.Text == string.Empty) { _cmbParams.ClearParams(); return; } RefGradeAllwnc allwnc = _cmbParams.gradeAllwncs.FirstOrDefault(rec => rec.RefGradeAllwnc_Cd == _cmbParams.tbCd.Text); if (allwnc != null) { _cmbParams.RefGradeAllwnc_Id = allwnc.RefGradeAllwnc_Id; if (_cmbParams.tbCd != null) { _cmbParams.tbCd.Text = allwnc.RefGradeAllwnc_Cd; } if (_cmbParams.tbNm != null) { _cmbParams.tbNm.Text = allwnc.RefGradeAllwnc_Nm; } if (_cmbParams.tbPct != null) { _cmbParams.tbPct.Text = allwnc.RefGradeAllwnc_Pct.ToString("0.00"); } } else { _cmbParams.ClearParams(); btn_Click(sender, e); } }
public void ReadCombobox(int id) { if (_cmbParams == null) { return; } if (_cmbParams.gradeAllwncs == null) { return; } RefGradeAllwnc allwnc = _cmbParams.gradeAllwncs.FirstOrDefault(rec => rec.RefGradeAllwnc_Id == id); if (allwnc == null) { _cmbParams.ClearParams(); return; } _cmbParams.RefGradeAllwnc_Id = allwnc.RefGradeAllwnc_Id; if (_cmbParams.tbCd != null) { _cmbParams.tbCd.Text = allwnc.RefGradeAllwnc_Cd; } if (_cmbParams.tbNm != null) { _cmbParams.tbNm.Text = allwnc.RefGradeAllwnc_Nm; } if (_cmbParams.tbPct != null) { _cmbParams.tbPct.Text = allwnc.RefGradeAllwnc_Pct.ToString("0.00"); } }
private void FillDataRec(SqlDataReader reader, RefGradeAllwnc gradeAllwnc) { int resInt = 0; decimal resDecimal = 0; DateTime resDt = DateTime.MinValue; if (int.TryParse(reader["RefGradeAllwnc_Id"].ToString(), out resInt)) { gradeAllwnc.RefGradeAllwnc_Id = resInt; } gradeAllwnc.RefGradeAllwnc_Cd = reader["RefGradeAllwnc_Cd"].ToString(); gradeAllwnc.RefGradeAllwnc_Nm = reader["RefGradeAllwnc_Nm"].ToString(); if (decimal.TryParse(reader["RefGradeAllwnc_Pct"].ToString(), out resDecimal)) { gradeAllwnc.RefGradeAllwnc_Pct = resDecimal; } if (int.TryParse(reader["RefGradeAllwnc_Grade"].ToString(), out resInt)) { gradeAllwnc.RefGradeAllwnc_Grade = resInt; } if (int.TryParse(reader["RefGradeAllwnc_RefDep_Id"].ToString(), out resInt)) { gradeAllwnc.RefGradeAllwnc_RefDep_Id = resInt; } if (int.TryParse(reader["RefGradeAllwnc_Flg"].ToString(), out resInt)) { gradeAllwnc.RefGradeAllwnc_Flg = resInt; } }
public RefGradeAllwnc GetData() { RefGradeAllwnc allwnc = new RefGradeAllwnc(); allwnc.RefGradeAllwnc_Id = _id; allwnc.RefGradeAllwnc_Cd = tbCd.Text; allwnc.RefGradeAllwnc_Nm = tbNm.Text; decimal resDec = 0; if (decimal.TryParse(tbPct.Text, out resDec)) { allwnc.RefGradeAllwnc_Pct = resDec; } int resInt = 0; if (int.TryParse(tbGrade.Text, out resInt)) { allwnc.RefGradeAllwnc_Grade = resInt; } allwnc.RefGradeAllwnc_RefDep_Id = _cmbDepParams.RefDep_Id; if (cbUse.Checked) { allwnc.RefGradeAllwnc_Flg &= ~(int)EnumGradeAllwnc_Flg.ALLWNC_NOTUSE; } else { allwnc.RefGradeAllwnc_Flg |= (int)EnumGradeAllwnc_Flg.ALLWNC_NOTUSE; } return(allwnc); }
//Добавить надбавку public bool AddGradeAllwnc(RefGradeAllwnc allowance, out string error) { error = string.Empty; if (allowance == null) { error = "allowance == null"; return(false); } if (conn == null) { error = "conn == null"; return(false); } SqlCommand command = new SqlCommand(spRefGradeAllwncInsert, conn); command.CommandType = System.Data.CommandType.StoredProcedure; command.Connection = conn; command.Parameters.AddWithValue("@inRefGradeAllwnc_Cd", allowance.RefGradeAllwnc_Cd); command.Parameters.AddWithValue("@inRefGradeAllwnc_Nm", allowance.RefGradeAllwnc_Nm); command.Parameters.AddWithValue("@inRefGradeAllwnc_Pct", allowance.RefGradeAllwnc_Pct); command.Parameters.AddWithValue("@inRefGradeAllwnc_Grade", allowance.RefGradeAllwnc_Grade); command.Parameters.AddWithValue("@inRefGradeAllwnc_RefDep_Id", allowance.RefGradeAllwnc_RefDep_Id == 0 ? Convert.DBNull : allowance.RefGradeAllwnc_RefDep_Id); command.Parameters.AddWithValue("@inRefGradeAllwnc_Flg", allowance.RefGradeAllwnc_Flg); try { command.ExecuteNonQuery(); } catch (Exception ex) { error = ex.Message; return(false); } return(true); }
public RefGradeAllwnc GetData() { if (dgvGradeAllwnc.CurrentRow == null) { return(null); } RefGradeAllwnc allowance = dgvGradeAllwnc.CurrentRow.DataBoundItem as RefGradeAllwnc; return(allowance); }
public void SetData(RefGradeAllwnc allowance) { if (allowance == null) { return; } _id = allowance.RefGradeAllwnc_Id; _cmbDep.ReadCombobox(allowance.RefGradeAllwnc_RefDep_Id); tbCd.Text = allowance.RefGradeAllwnc_Cd; tbNm.Text = allowance.RefGradeAllwnc_Nm; tbPct.Text = allowance.RefGradeAllwnc_Pct.ToString("0.00"); tbGrade.Text = allowance.RefGradeAllwnc_Grade.ToString(); cbUse.Checked = (allowance.RefGradeAllwnc_Flg & (int)EnumGradeAllwnc_Flg.ALLWNC_NOTUSE) > 0 ? false : true; }
//Добавить надбавку public int AddGradeAllwnc(RefGradeAllwnc allowance, out string error) { error = string.Empty; if (allowance == null) { error = "allowance == null"; return(0); } if (conn == null) { error = "conn == null"; return(0); } SqlCommand command = new SqlCommand(spRefGradeAllwncInsert, conn); command.CommandType = System.Data.CommandType.StoredProcedure; command.Connection = conn; command.Parameters.AddWithValue("@inRefGradeAllwnc_Cd", allowance.RefGradeAllwnc_Cd); command.Parameters.AddWithValue("@inRefGradeAllwnc_Nm", allowance.RefGradeAllwnc_Nm); command.Parameters.AddWithValue("@inRefGradeAllwnc_Pct", allowance.RefGradeAllwnc_Pct); command.Parameters.AddWithValue("@inRefGradeAllwnc_Grade", allowance.RefGradeAllwnc_Grade); command.Parameters.AddWithValue("@inRefGradeAllwnc_RefDep_Id", allowance.RefGradeAllwnc_RefDep_Id == 0 ? Convert.DBNull : allowance.RefGradeAllwnc_RefDep_Id); command.Parameters.AddWithValue("@inRefGradeAllwnc_Flg", allowance.RefGradeAllwnc_Flg); // определяем выходной параметр SqlParameter outId = new SqlParameter { ParameterName = "outId", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int }; command.Parameters.Add(outId); try { command.ExecuteNonQuery(); } catch (Exception ex) { error = ex.Message; return(0); } int id = 0; int.TryParse(command.Parameters["outId"].Value.ToString(), out id); return(id); }
//Вставка строки private void InsertRecord() { fmRefGradeAllwncEdit fmEdit = new fmRefGradeAllwncEdit(EnumFormMode.Insert, "Створення доплати"); if (fmEdit.ShowDialog() == DialogResult.OK) { string error; RefGradeAllwnc gradeAllwncs = fmEdit.GetData(); if (!_repository.AddGradeAllwnc(gradeAllwncs, out error)) { MessageBox.Show("Помилка додавання доплати.\nТехнічна інформація: " + error, "Помилка"); return; } RefreshTable(); } }
//Вставка строки private void InsertRecord() { fmRefGradeAllwncEdit fmEdit = new fmRefGradeAllwncEdit(EnumFormMode.Insert, "Створення надбавки за класність"); if (fmEdit.ShowDialog() == DialogResult.OK) { string error; RefGradeAllwnc gradeAllwncs = fmEdit.GetData(); int id = _repository.AddGradeAllwnc(gradeAllwncs, out error); if (id == 0) { MessageBox.Show("Помилка додавання рядка.\nТехнічна інформація: " + error, "Помилка"); return; } RefreshTable(); dgvGradeAllwnc.SetPositionRow <v_RefGradeAllwnc>("RefGradeAllwnc_Id", id.ToString()); } }
////Получить надбавки public List <RefGradeAllwnc> GetAllGradeAllwnc(out string error) { error = string.Empty; List <RefGradeAllwnc> allowances = new List <RefGradeAllwnc>(); if (conn == null) { error = "conn == null"; return(allowances); } SqlCommand command = new SqlCommand(spRefGradeAllwncSelect, conn); command.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader reader = null; try { reader = command.ExecuteReader(); while (reader.Read()) { RefGradeAllwnc allowance = new RefGradeAllwnc(); FillDataRec(reader, allowance); allowances.Add(allowance); } } catch (Exception exc) { error = exc.Message; } finally { if (reader != null) { reader.Close(); } } return(allowances); }
//Получить надбавку по id public RefGradeAllwnc GetGradeAllwncById(int id, out string error) { error = string.Empty; RefGradeAllwnc allowance = null; if (conn == null) { error = "conn == null"; return(null); } SqlCommand command = new SqlCommand(spRefGradeAllwncSelect, conn); command.CommandType = System.Data.CommandType.StoredProcedure; command.Connection = conn; command.Parameters.AddWithValue("@inRefGradeAllwnc_Id", id); SqlDataReader reader = null; try { reader = command.ExecuteReader(); if (reader.HasRows) { reader.Read(); allowance = new RefGradeAllwnc(); FillDataRec(reader, allowance); } } catch (Exception ex) { error = ex.Message; } finally { if (reader != null) { reader.Close(); } } return(allowance); }
private void btn_Click(object sender, EventArgs e) { fmCmbGradeAllwnc fmCmbAllwnc = new fmCmbGradeAllwnc(_cmbParams.gradeAllwncs); if (fmCmbAllwnc.ShowDialog() == DialogResult.OK) { RefGradeAllwnc allwnc = fmCmbAllwnc.GetData(); _cmbParams.RefGradeAllwnc_Id = allwnc.RefGradeAllwnc_Id; if (_cmbParams.tbCd != null) { _cmbParams.tbCd.Text = allwnc.RefGradeAllwnc_Cd; } if (_cmbParams.tbPct != null) { _cmbParams.tbPct.Text = allwnc.RefGradeAllwnc_Pct.ToString("0.00"); } if (_cmbParams.tbNm != null) { _cmbParams.tbNm.Text = allwnc.RefGradeAllwnc_Nm; } } }