public static bool UpdateCTCB(CTCB cTCB)
{
string cmdText = string.Format("UPDATE CTCB SET TGDung= {0},GhiChu= N'{1}' WHERE MaCB = {2} and MaSBTG = {3}", cTCB.TGDung, cTCB.GhiChu, cTCB.maCB, cTCB.SBTG);
bool update = DataProvider.ExecuteNonQuery(cmdText);
return(update);
}
public static bool InsertCTCB(CTCB cTCB, int maCB)
{
string cmdText = string.Format("INSERT INTO CTCB(MaCB,MaSBTG,TGDung,GhiChu) VALUES ({0},'{1}',{2},N'{3}')", maCB, cTCB.SBTG.maSB, cTCB.TGDung, cTCB.GhiChu);
bool insert = DataProvider.ExecuteNonQuery(cmdText);
return(insert);
}
public static List <CTCB> SearchMaCB(int maCB)
{
string cmdText = String.Format("select * from CTCB where MaCB = %{0}%", maCB);
DataTable dt = DataProvider.ExecuteReader(cmdText);
if (dt != null && dt.Rows.Count > 0)
{
List <CTCB> cTCB = new List <CTCB>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CTCB ctcb = new CTCB((int)dt.Rows[i]["MaCB"], (SanBay)dt.Rows[i]["MaSBTG"], (int)dt.Rows[i]["TGDung"], dt.Rows[i]["GhiChu"].ToString());
cTCB.Add(ctcb);
}
return(cTCB);
}
return(null);
}
private void dgvCTCB_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.ColumnIndex == 0 && state == Actions.NOTHING)
{
state = Actions.EDIT;
activeEdit();
}
else if (e.ColumnIndex == 1 && state == Actions.NOTHING)
{
int x = e.RowIndex;
CTCB y = ctcbs[x];
ctcbs.Remove(ctcbs[x]);
List <CTCB> listctcb = new List <CTCB>();
listctcb.AddRange(ctcbs);
ctcbs = listctcb;
dgvCTCB.DataSource = ctcbs;
}
}
public static bool UpdateCTCB(CTCB cTCB)
{
return(DAL_CTCB.UpdateCTCB(cTCB));
}
public static bool InsertCTCB(CTCB cTCB, int maCB)
{
return(DAL_CTCB.InsertCTCB(cTCB, maCB));
}
