public void Xoa(DOLoaiCongViec doLoaiCV) { string sql = "DELETE FROM LOAI_CONG_VIEC WHERE LCV_ID = @LCV_ID"; DatabaseFB db = DABase.getDatabase(); DbCommand cmd = db.GetSQLStringCommand(sql); db.AddInParameter(cmd, "@LCV_ID", DbType.Int64, doLoaiCV.LCV_ID); db.ExecuteNonQuery(cmd); }
public void Them(bool a, DOLoaiCongViec doLoaiCV) { string sql; if (a) { sql = "insert into LOAI_CONG_VIEC (LCV_ID, MA_LCV, NAME, MO_TA, VISIBLE_BIT) values (@LCV_ID, @MA_LCV, @NAME, @MO_TA, @VISIBLE_BIT)"; } else { sql = "update LOAI_CONG_VIEC set MA_LCV = @MA_LCV, NAME = @NAME, MO_TA = @MO_TA, VISIBLE_BIT = @VISIBLE_BIT where LCV_ID = @LCV_ID"; } DatabaseFB db = DABase.getDatabase(); DbCommand cmd = db.GetSQLStringCommand(sql); db.AddInParameter(cmd, "@LCV_ID", DbType.Int64, doLoaiCV.LCV_ID); db.AddInParameter(cmd, "@MA_LCV", DbType.String, doLoaiCV.MA_LCV); db.AddInParameter(cmd, "@NAME", DbType.String, doLoaiCV.NAME); db.AddInParameter(cmd, "@MO_TA", DbType.String, doLoaiCV.MO_TA); db.AddInParameter(cmd, "@VISIBLE_BIT", DbType.String, doLoaiCV.VISIBLE_BIT); db.ExecuteNonQuery(cmd); }
private void btnLuu_Click(object sender, EventArgs e) { try { daLoaiCV = new DALoaiCongViec(); DataSet ds1 = daLoaiCV.Load(); int i = 0; foreach (DataRow row in ((DataTable)gridControl1.DataSource).Rows) { if (row.RowState == DataRowState.Modified) { doLoaiCV = new DOLoaiCongViec(); doLoaiCV.LCV_ID = long.Parse(row["LCV_ID"].ToString()); doLoaiCV.MA_LCV = row["MA_LCV"].ToString(); doLoaiCV.NAME = row["NAME"].ToString(); doLoaiCV.MO_TA = row["MO_TA"].ToString(); doLoaiCV.VISIBLE_BIT = row["VISIBLE_BIT"].ToString(); daLoaiCV.Them(false, doLoaiCV); } if (row.RowState == DataRowState.Added) { doLoaiCV = new DOLoaiCongViec(); doLoaiCV.LCV_ID = long.Parse(row["LCV_ID"].ToString()); doLoaiCV.MA_LCV = row["MA_LCV"].ToString(); doLoaiCV.NAME = row["NAME"].ToString(); doLoaiCV.MO_TA = row["MO_TA"].ToString(); doLoaiCV.VISIBLE_BIT = row["VISIBLE_BIT"].ToString(); daLoaiCV.Them(true, doLoaiCV); } if (row.RowState == DataRowState.Deleted) { doLoaiCV = new DOLoaiCongViec(); doLoaiCV.LCV_ID = long.Parse(ds1.Tables[0].Rows[i]["LCV_ID"].ToString()); daLoaiCV.Xoa(doLoaiCV); } i++; } Load(); btnLuu.Enabled = false; btnKhongLuu.Enabled = false; } catch (Exception ex) { PLMessageBox.ShowNotificationMessage(ex.Message); } }