public frmKyHieuThucHanh()
{
InitializeComponent();
oBXL_KeHoachThucHanhKyHieu = new cBXL_KeHoachThucHanhKyHieu();
pXL_KeHoachThucHanhKyHieuInfo = new XL_KeHoachThucHanhKyHieuInfo();
panelTop.Visible = false;
}
protected void FlexColor()
{
cBXL_KeHoachThucHanhKyHieu oBXL_KeHoachThucHanhKyHieu = new cBXL_KeHoachThucHanhKyHieu();
XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo = new XL_KeHoachThucHanhKyHieuInfo();
DataTable mdtThucHanh = oBXL_KeHoachThucHanhKyHieu.Get(pXL_KeHoachThucHanhKyHieuInfo);
CellStyle objCellStyle;
// Định nghĩa các Style theo kế hoạch người dùng chọn
foreach (DataRow dr in mdtThucHanh.Rows)
{
objCellStyle = fg.Styles.Add("Style_" + dr["XL_KeHoachThucHanhKyHieuID"].ToString());
objCellStyle.Font = new Font("Arial", 7);
objCellStyle.BackColor = Color.FromArgb(int.Parse(dr["MauNen"].ToString()));
objCellStyle.ForeColor = Color.FromArgb(int.Parse(dr["MauChu"].ToString()));
htbThucHanhStyle.Add("Style_" + dr["XL_KeHoachThucHanhKyHieuID"].ToString(), objCellStyle);
}
// Style lớp
objCellStyle = fg.Styles.Add("MyCellStyleLop");
//objCellStyle.Font = new Font("Arial", 10);
objCellStyle.BackColor = Color.Tan;
objCellStyle.ForeColor = Color.Black;
htbThucHanhStyle.Add("MyCellStyleLop", objCellStyle);
// Style chuẩn
objCellStyle = fg.Styles.Add("MyCellStyle");
objCellStyle.Font = new Font("Arial", 8);
objCellStyle.BackColor = Color.White;
objCellStyle.ForeColor = Color.Black;
htbThucHanhStyle.Add("MyCellStyle", objCellStyle);
// Ca học sáng
objCellStyle = fg.Styles.Add("MyCellStyleSang");
objCellStyle.Font = new Font("Arial", 8);
objCellStyle.BackColor = Color.SkyBlue;
objCellStyle.ForeColor = Color.Maroon;
htbThucHanhStyle.Add("MyCellStyleSang", objCellStyle);
// Ca học chiều
objCellStyle = fg.Styles.Add("MyCellStyleChieu");
objCellStyle.Font = new Font("Arial", 8);
objCellStyle.BackColor = Color.Gainsboro;
objCellStyle.ForeColor = Color.DodgerBlue;
htbThucHanhStyle.Add("MyCellStyleChieu", objCellStyle);
// Ca học tối
objCellStyle = fg.Styles.Add("MyCellStyleToi");
objCellStyle.Font = new Font("Arial", 8);
objCellStyle.BackColor = Color.DarkSeaGreen;
objCellStyle.ForeColor = Color.Gold;
htbThucHanhStyle.Add("MyCellStyleToi", objCellStyle);
// Giáo viên
objCellStyle = fg.Styles.Add("MyCellStyleGiaoVien");
objCellStyle.Font = new Font("Arial", 8);
objCellStyle.BackColor = Color.LemonChiffon;
objCellStyle.ForeColor = Color.Blue;
htbThucHanhStyle.Add("MyCellStyleGiaoVien", objCellStyle);
// Row TongHop
objCellStyle = fg.Styles.Add("MyCellStyleTongHop");
objCellStyle.Font = new Font("Arial", 8);
objCellStyle.BackColor = Color.Silver;
objCellStyle.ForeColor = Color.Blue;
htbThucHanhStyle.Add("MyCellStyleTongHop", objCellStyle);
}
public void Delete(XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_KeHoachThucHanhKyHieuID", SqlDbType.Int, pXL_KeHoachThucHanhKyHieuInfo.XL_KeHoachThucHanhKyHieuID));
RunProcedure("sp_XL_KeHoachThucHanhKyHieu_Delete", colParam);
}
public DataTable Get(XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_KeHoachThucHanhKyHieuID", SqlDbType.Int, pXL_KeHoachThucHanhKyHieuInfo.XL_KeHoachThucHanhKyHieuID));
return(RunProcedureGet("sp_XL_KeHoachThucHanhKyHieu_Get", colParam));
}
public void ToInfo(ref XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo, DataRow dr)
{
pXL_KeHoachThucHanhKyHieuInfo.XL_KeHoachThucHanhKyHieuID = int.Parse(dr[pXL_KeHoachThucHanhKyHieuInfo.strXL_KeHoachThucHanhKyHieuID].ToString());
pXL_KeHoachThucHanhKyHieuInfo.IDDM_MonHoc = int.Parse(dr[pXL_KeHoachThucHanhKyHieuInfo.strIDDM_MonHoc].ToString());
pXL_KeHoachThucHanhKyHieuInfo.KyHieu = dr[pXL_KeHoachThucHanhKyHieuInfo.strKyHieu].ToString();
pXL_KeHoachThucHanhKyHieuInfo.MauChu = int.Parse(dr[pXL_KeHoachThucHanhKyHieuInfo.strMauChu].ToString());
pXL_KeHoachThucHanhKyHieuInfo.MauNen = int.Parse(dr[pXL_KeHoachThucHanhKyHieuInfo.strMauNen].ToString());
}
public void ToDataRow(XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo, ref DataRow dr)
{
dr[pXL_KeHoachThucHanhKyHieuInfo.strXL_KeHoachThucHanhKyHieuID] = pXL_KeHoachThucHanhKyHieuInfo.XL_KeHoachThucHanhKyHieuID;
dr[pXL_KeHoachThucHanhKyHieuInfo.strIDDM_MonHoc] = pXL_KeHoachThucHanhKyHieuInfo.IDDM_MonHoc;
dr[pXL_KeHoachThucHanhKyHieuInfo.strKyHieu] = pXL_KeHoachThucHanhKyHieuInfo.KyHieu;
dr[pXL_KeHoachThucHanhKyHieuInfo.strMauChu] = pXL_KeHoachThucHanhKyHieuInfo.MauChu;
dr[pXL_KeHoachThucHanhKyHieuInfo.strMauNen] = pXL_KeHoachThucHanhKyHieuInfo.MauNen;
}
public int Add(XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo)
{
int ID = 0;
ID = oDXL_KeHoachThucHanhKyHieu.Add(pXL_KeHoachThucHanhKyHieuInfo);
mErrorMessage = oDXL_KeHoachThucHanhKyHieu.ErrorMessages;
mErrorNumber = oDXL_KeHoachThucHanhKyHieu.ErrorNumber;
return(ID);
}
public void Update(XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pXL_KeHoachThucHanhKyHieuInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@KyHieu", SqlDbType.NVarChar, pXL_KeHoachThucHanhKyHieuInfo.KyHieu));
colParam.Add(CreateParam("@MauChu", SqlDbType.Int, pXL_KeHoachThucHanhKyHieuInfo.MauChu));
colParam.Add(CreateParam("@MauNen", SqlDbType.Int, pXL_KeHoachThucHanhKyHieuInfo.MauNen));
colParam.Add(CreateParam("@XL_KeHoachThucHanhKyHieuID", SqlDbType.Int, pXL_KeHoachThucHanhKyHieuInfo.XL_KeHoachThucHanhKyHieuID));
RunProcedure("sp_XL_KeHoachThucHanhKyHieu_Update", colParam);
}
public int Add(XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pXL_KeHoachThucHanhKyHieuInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@KyHieu", SqlDbType.NVarChar, pXL_KeHoachThucHanhKyHieuInfo.KyHieu));
colParam.Add(CreateParam("@MauChu", SqlDbType.Int, pXL_KeHoachThucHanhKyHieuInfo.MauChu));
colParam.Add(CreateParam("@MauNen", SqlDbType.Int, pXL_KeHoachThucHanhKyHieuInfo.MauNen));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_XL_KeHoachThucHanhKyHieu_Add", colParam));
}
private void LoadKyHieuThucHanh()
{
cBXL_KeHoachThucHanhKyHieu oB = new cBXL_KeHoachThucHanhKyHieu();
XL_KeHoachThucHanhKyHieuInfo pInfo = new XL_KeHoachThucHanhKyHieuInfo();
DataTable dt = oB.Get(pInfo);
cmbHienThi.Properties.DataSource = dt;
if (edit == EDIT_MODE.THEM && !Loaded)
{
DataRow[] arrDr = dt.Select("IDDM_MonHoc = " + drMonKy["IDDM_MonHoc"]);
if (arrDr.Length > 0)
{
cmbHienThi.EditValue = arrDr[0]["XL_KeHoachThucHanhKyHieuID"];
}
}
}
public List <XL_KeHoachThucHanhKyHieuInfo> GetList(XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo)
{
List <XL_KeHoachThucHanhKyHieuInfo> oXL_KeHoachThucHanhKyHieuInfoList = new List <XL_KeHoachThucHanhKyHieuInfo>();
DataTable dtb = Get(pXL_KeHoachThucHanhKyHieuInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oXL_KeHoachThucHanhKyHieuInfo = new XL_KeHoachThucHanhKyHieuInfo();
oXL_KeHoachThucHanhKyHieuInfo.XL_KeHoachThucHanhKyHieuID = int.Parse(dtb.Rows[i]["XL_KeHoachThucHanhKyHieuID"].ToString());
oXL_KeHoachThucHanhKyHieuInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
oXL_KeHoachThucHanhKyHieuInfo.KyHieu = dtb.Rows[i]["KyHieu"].ToString();
oXL_KeHoachThucHanhKyHieuInfo.MauChu = int.Parse(dtb.Rows[i]["MauChu"].ToString());
oXL_KeHoachThucHanhKyHieuInfo.MauNen = int.Parse(dtb.Rows[i]["MauNen"].ToString());
oXL_KeHoachThucHanhKyHieuInfoList.Add(oXL_KeHoachThucHanhKyHieuInfo);
}
}
return(oXL_KeHoachThucHanhKyHieuInfoList);
}
public void Delete(XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo)
{
oDXL_KeHoachThucHanhKyHieu.Delete(pXL_KeHoachThucHanhKyHieuInfo);
mErrorMessage = oDXL_KeHoachThucHanhKyHieu.ErrorMessages;
mErrorNumber = oDXL_KeHoachThucHanhKyHieu.ErrorNumber;
}
public DataTable Get(XL_KeHoachThucHanhKyHieuInfo pXL_KeHoachThucHanhKyHieuInfo)
{
return(oDXL_KeHoachThucHanhKyHieu.Get(pXL_KeHoachThucHanhKyHieuInfo));
}
