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);
}
}
