public void Delete(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_KeHoachThucHanhChiTietID", SqlDbType.BigInt, pXL_KeHoachThucHanhChiTietInfo.XL_KeHoachThucHanhChiTietID));
RunProcedure("sp_XL_KeHoachThucHanhChiTiet_Delete", colParam);
}
public DataTable Get(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_KeHoachThucHanhChiTietID", SqlDbType.BigInt, pXL_KeHoachThucHanhChiTietInfo.XL_KeHoachThucHanhChiTietID));
return(RunProcedureGet("sp_XL_KeHoachThucHanhChiTiet_Get", colParam));
}
public void ToInfo(ref XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo, DataRow dr)
{
pXL_KeHoachThucHanhChiTietInfo.XL_KeHoachThucHanhChiTietID = long.Parse(dr[pXL_KeHoachThucHanhChiTietInfo.strXL_KeHoachThucHanhChiTietID].ToString());
pXL_KeHoachThucHanhChiTietInfo.IDXL_KeHoachThucHanh = int.Parse(dr[pXL_KeHoachThucHanhChiTietInfo.strIDXL_KeHoachThucHanh].ToString());
pXL_KeHoachThucHanhChiTietInfo.IDXL_Tuan = long.Parse(dr[pXL_KeHoachThucHanhChiTietInfo.strIDXL_Tuan].ToString());
pXL_KeHoachThucHanhChiTietInfo.CaHoc = int.Parse(dr[pXL_KeHoachThucHanhChiTietInfo.strCaHoc].ToString());
pXL_KeHoachThucHanhChiTietInfo.ToThucHanh = int.Parse(dr[pXL_KeHoachThucHanhChiTietInfo.strToThucHanh].ToString());
pXL_KeHoachThucHanhChiTietInfo.NgayThucHanh = DateTime.Parse(dr[pXL_KeHoachThucHanhChiTietInfo.strNgayThucHanh].ToString());
}
public void ToDataRow(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo, ref DataRow dr)
{
dr[pXL_KeHoachThucHanhChiTietInfo.strXL_KeHoachThucHanhChiTietID] = pXL_KeHoachThucHanhChiTietInfo.XL_KeHoachThucHanhChiTietID;
dr[pXL_KeHoachThucHanhChiTietInfo.strIDXL_KeHoachThucHanh] = pXL_KeHoachThucHanhChiTietInfo.IDXL_KeHoachThucHanh;
dr[pXL_KeHoachThucHanhChiTietInfo.strIDXL_Tuan] = pXL_KeHoachThucHanhChiTietInfo.IDXL_Tuan;
dr[pXL_KeHoachThucHanhChiTietInfo.strCaHoc] = pXL_KeHoachThucHanhChiTietInfo.CaHoc;
dr[pXL_KeHoachThucHanhChiTietInfo.strToThucHanh] = pXL_KeHoachThucHanhChiTietInfo.ToThucHanh;
dr[pXL_KeHoachThucHanhChiTietInfo.strNgayThucHanh] = pXL_KeHoachThucHanhChiTietInfo.NgayThucHanh;
}
public int Add(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo)
{
int ID = 0;
ID = oDXL_KeHoachThucHanhChiTiet.Add(pXL_KeHoachThucHanhChiTietInfo);
mErrorMessage = oDXL_KeHoachThucHanhChiTiet.ErrorMessages;
mErrorNumber = oDXL_KeHoachThucHanhChiTiet.ErrorNumber;
return(ID);
}
public frmKeHoachThucHanh()
{
InitializeComponent();
oBXL_KeHoachThucHanh = new cBXL_KeHoachThucHanh();
oBXL_KeHoachThucHanhChiTiet = new cBXL_KeHoachThucHanhChiTiet();
pXL_KeHoachThucHanhChiTietInfo = new XL_KeHoachThucHanhChiTietInfo();
oBDM_PhongHoc = new cBDM_PhongHoc();
clsdt = new Lib.clsDataTableHelper();
}
public void Update(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDXL_KeHoachThucHanh", SqlDbType.Int, pXL_KeHoachThucHanhChiTietInfo.IDXL_KeHoachThucHanh));
colParam.Add(CreateParam("@IDXL_Tuan", SqlDbType.BigInt, pXL_KeHoachThucHanhChiTietInfo.IDXL_Tuan));
colParam.Add(CreateParam("@CaHoc", SqlDbType.Int, pXL_KeHoachThucHanhChiTietInfo.CaHoc));
colParam.Add(CreateParam("@ToThucHanh", SqlDbType.Int, pXL_KeHoachThucHanhChiTietInfo.ToThucHanh));
colParam.Add(CreateParam("@NgayThucHanh", SqlDbType.DateTime, pXL_KeHoachThucHanhChiTietInfo.NgayThucHanh));
colParam.Add(CreateParam("@XL_KeHoachThucHanhChiTietID", SqlDbType.BigInt, pXL_KeHoachThucHanhChiTietInfo.XL_KeHoachThucHanhChiTietID));
RunProcedure("sp_XL_KeHoachThucHanhChiTiet_Update", colParam);
}
public int Add(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDXL_KeHoachThucHanh", SqlDbType.Int, pXL_KeHoachThucHanhChiTietInfo.IDXL_KeHoachThucHanh));
colParam.Add(CreateParam("@IDXL_Tuan", SqlDbType.BigInt, pXL_KeHoachThucHanhChiTietInfo.IDXL_Tuan));
colParam.Add(CreateParam("@CaHoc", SqlDbType.Int, pXL_KeHoachThucHanhChiTietInfo.CaHoc));
colParam.Add(CreateParam("@ToThucHanh", SqlDbType.Int, pXL_KeHoachThucHanhChiTietInfo.ToThucHanh));
colParam.Add(CreateParam("@NgayThucHanh", SqlDbType.DateTime, pXL_KeHoachThucHanhChiTietInfo.NgayThucHanh));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_XL_KeHoachThucHanhChiTiet_Add", colParam));
}
public List <XL_KeHoachThucHanhChiTietInfo> GetList(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo)
{
List <XL_KeHoachThucHanhChiTietInfo> oXL_KeHoachThucHanhChiTietInfoList = new List <XL_KeHoachThucHanhChiTietInfo>();
DataTable dtb = Get(pXL_KeHoachThucHanhChiTietInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oXL_KeHoachThucHanhChiTietInfo = new XL_KeHoachThucHanhChiTietInfo();
oXL_KeHoachThucHanhChiTietInfo.XL_KeHoachThucHanhChiTietID = long.Parse(dtb.Rows[i]["XL_KeHoachThucHanhChiTietID"].ToString());
oXL_KeHoachThucHanhChiTietInfo.IDXL_KeHoachThucHanh = int.Parse(dtb.Rows[i]["IDXL_KeHoachThucHanh"].ToString());
oXL_KeHoachThucHanhChiTietInfo.IDXL_Tuan = long.Parse(dtb.Rows[i]["IDXL_Tuan"].ToString());
oXL_KeHoachThucHanhChiTietInfo.CaHoc = int.Parse(dtb.Rows[i]["CaHoc"].ToString());
oXL_KeHoachThucHanhChiTietInfo.ToThucHanh = int.Parse(dtb.Rows[i]["ToThucHanh"].ToString());
oXL_KeHoachThucHanhChiTietInfo.NgayThucHanh = DateTime.Parse(dtb.Rows[i]["NgayThucHanh"].ToString());
oXL_KeHoachThucHanhChiTietInfoList.Add(oXL_KeHoachThucHanhChiTietInfo);
}
}
return(oXL_KeHoachThucHanhChiTietInfoList);
}
public void Delete(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo)
{
oDXL_KeHoachThucHanhChiTiet.Delete(pXL_KeHoachThucHanhChiTietInfo);
mErrorMessage = oDXL_KeHoachThucHanhChiTiet.ErrorMessages;
mErrorNumber = oDXL_KeHoachThucHanhChiTiet.ErrorNumber;
}
public DataTable Get(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo)
{
return(oDXL_KeHoachThucHanhChiTiet.Get(pXL_KeHoachThucHanhChiTietInfo));
}
private void UpdateKeHoachThucHanhChiTiet(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo)
{
oBXL_KeHoachThucHanhChiTiet.Update(pXL_KeHoachThucHanhChiTietInfo);
}
private void InsertKeHoachThucHanhChiTiet(XL_KeHoachThucHanhChiTietInfo pXL_KeHoachThucHanhChiTietInfo)
{
oBXL_KeHoachThucHanhChiTiet.Add(pXL_KeHoachThucHanhChiTietInfo);
}
private void barbtnLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
int IDTuan, c, IDDM_Lop;
for (int r = RowBegin + 1; r <= fg.Rows.Count - 1; r++)
{
if ("" + fg[r, 0] != "")
{
IDDM_Lop = int.Parse(fg[r, 4].ToString());
c = ColBegin;
while (c <= fg.Cols.Count - 1)
{
CellRange rg = fg.GetCellRange(r, c);
if (rg.UserData != null)
{
IDTuan = int.Parse(fg[0, c].ToString());
Cell_KeHoach objCellData = (Cell_KeHoach)rg.UserData;
if (rg.UserData != null)
{
if (objCellData.IDXL_KeHoachThucHanhKyHieu == -1)
{
if (objCellData.XL_KeHoachThucHanhChiTietID > 0)
{
DeleteKeHoachThucHanhChiTiet(objCellData.XL_KeHoachThucHanhChiTietID);
}
}
else
{
if (objCellData.Changed)
{
// Nếu có sự thay đổi trong kế hoạch và từ ca học -> nghỉ hoặc từ nghỉ -> ca học hoặc nghỉ -> nghỉ khác
// Từ nghỉ -> nghỉ khác thì update vào
if (objCellData.XL_KeHoachThucHanhChiTietID > 0)
{
// Nếu được thay thế bởi Kế hoạch nghỉ khác thì update
//if (objCellData.IDKeHoachKhac > 0)
//{
pXL_KeHoachThucHanhChiTietInfo = new XL_KeHoachThucHanhChiTietInfo();
pXL_KeHoachThucHanhChiTietInfo.XL_KeHoachThucHanhChiTietID = objCellData.XL_KeHoachThucHanhChiTietID;
pXL_KeHoachThucHanhChiTietInfo.IDXL_KeHoachThucHanh = objCellData.IDXL_KeHoachThucHanh;
pXL_KeHoachThucHanhChiTietInfo.IDXL_Tuan = IDTuan;
pXL_KeHoachThucHanhChiTietInfo.CaHoc = (int)objCellData.CaHoc;
pXL_KeHoachThucHanhChiTietInfo.NgayThucHanh = objCellData.NgayHoc;
pXL_KeHoachThucHanhChiTietInfo.ToThucHanh = objCellData.To;
UpdateKeHoachThucHanhChiTiet(pXL_KeHoachThucHanhChiTietInfo);
//}
}
// Còn lại là Insert vào
else
{
pXL_KeHoachThucHanhChiTietInfo = new XL_KeHoachThucHanhChiTietInfo();
pXL_KeHoachThucHanhChiTietInfo.IDXL_KeHoachThucHanh = objCellData.IDXL_KeHoachThucHanh;
pXL_KeHoachThucHanhChiTietInfo.IDXL_Tuan = IDTuan;
pXL_KeHoachThucHanhChiTietInfo.CaHoc = (int)objCellData.CaHoc;
pXL_KeHoachThucHanhChiTietInfo.NgayThucHanh = objCellData.NgayHoc;
pXL_KeHoachThucHanhChiTietInfo.ToThucHanh = objCellData.To;
InsertKeHoachThucHanhChiTiet(pXL_KeHoachThucHanhChiTietInfo);
}
objCellData.Changed = false;
rg.UserData = objCellData;
// Nếu lớp chỉ có 1 tổ thực hành thì cập nhật trạng thái cho cả ô dưới nó
if (pXL_KeHoachThucHanhChiTietInfo.ToThucHanh == 0)
{
rg = fg.GetCellRange(r + 1, c);
if (rg.UserData != null)
{
objCellData = (Cell_KeHoach)rg.UserData;
objCellData.Changed = false;
rg.UserData = objCellData;
}
}
}
}
}
}
c++;
}
}
}
LuuThanhCong();
}
catch (Exception ex)
{
ThongBaoLoi(ex.Message);
}
}
