public List <DAL_PHANCONG> GetDSPC()
{
DataTable dt = cn.LoadTable("Select * from PHANCONG");
List <DAL_PHANCONG> DSPC = new List <DAL_PHANCONG>();
foreach (DataRow dr in dt.Rows)
{
DAL_PHANCONG bm = new DAL_PHANCONG(dr);
DSPC.Add(bm);
}
return(DSPC);
}
private void phancong(FormPC pc)
{
string mahp = "";
int sotiet = 0;
if (dataPC.GetRowCellValue(dataPC.FocusedRowHandle, "F2").ToString() == "")
{
int cur = dataPC.FocusedRowHandle;
while (dataPC.GetRowCellValue(cur, "F2").ToString() == "")
{
cur--;
}
mahp = dataPC.GetRowCellValue(cur, "F2").ToString();
sotiet = Convert.ToInt32(dataPC.GetRowCellValue(cur, "F6"));
}
else
{
mahp = dataPC.GetRowCellValue(dataPC.FocusedRowHandle, "F2").ToString();
sotiet = Convert.ToInt32(dataPC.GetRowCellValue(dataPC.FocusedRowHandle, "F6"));
}
string magv1 = pc.GetMAGV1();
string magv2 = pc.GetMAGV2();
string kip = dataPC.GetRowCellValue(dataPC.FocusedRowHandle, "F8").ToString();
string malop = GetMALHP(mahp, dataPC.GetRowCellValue(dataPC.FocusedRowHandle, "F10").ToString());
string diadiem = dataPC.GetRowCellValue(dataPC.FocusedRowHandle, "F11").ToString();
string ky = dataPC.GetRowCellValue(2, "BẢNG PHÂN CÔNG GIẢNG DẠY").ToString();
string nam = dataPC.GetRowCellValue(2, "F6").ToString();
DAL_PHANCONG phancong = new DAL_PHANCONG(malop, magv1, magv2, kip, diadiem, sotiet, ky, nam);
DAO_PC.Delete_PC(phancong);
int dem = 0;
try
{
int check2 = DAO_PC.Insert_PC(phancong);
if (check2 == 0)
{
MessageBox.Show("Không thêm được dòng này");
dem++;
}
}
catch
{
MessageBox.Show("Lỗi cập nhật");
dem++;
}
finally
{
Display_sotietday();
}
}
public int Delete_PC(DAL_PHANCONG pc)
{
string[] para = new string[1] {
"@malop"
};
object[] values = new object[1] {
pc.MALOP
};
int check = 0;
try
{
check = cn.Excute_Sql("XoaPC", CommandType.StoredProcedure, para, values);
}
catch
{ }
return(check);
}
public int Update_PC(DAL_PHANCONG pc)
{
string[] para = new string[8] {
"@malop", "@magv1", "@magv2", "@kip", "@diadiem", "@sotiet", "@ky", "@nam"
};
object[] values = new object[8] {
pc.MALOP, pc.MAGV1, pc.MAGV2, pc.KIPHOC, pc.DIADIEM, pc.Sotiet, pc.Kyhoc, pc.Namhoc
};
int check = 0;
try
{
check = cn.Excute_Sql("SuaPC", CommandType.StoredProcedure, para, values);
}
catch
{ }
return(check);
}
