public DataTable Get(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_QuyenHoaDon_TrinhDoID", SqlDbType.Int, pTC_QuyenHoaDon_TrinhDoInfo.TC_QuyenHoaDon_TrinhDoID));
return(RunProcedureGet("sp_TC_QuyenHoaDon_TrinhDo_Get", colParam));
}
public void Delete(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_QuyenHoaDon_TrinhDoID", SqlDbType.Int, pTC_QuyenHoaDon_TrinhDoInfo.TC_QuyenHoaDon_TrinhDoID));
RunProcedure("sp_TC_QuyenHoaDon_TrinhDo_Delete", colParam);
}
public int Add(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo)
{
int ID = 0;
ID = oDTC_QuyenHoaDon_TrinhDo.Add(pTC_QuyenHoaDon_TrinhDoInfo);
mErrorMessage = oDTC_QuyenHoaDon_TrinhDo.ErrorMessages;
mErrorNumber = oDTC_QuyenHoaDon_TrinhDo.ErrorNumber;
return(ID);
}
public int Add(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDTC_QuyenHoaDon", SqlDbType.Int, pTC_QuyenHoaDon_TrinhDoInfo.IDTC_QuyenHoaDon));
colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pTC_QuyenHoaDon_TrinhDoInfo.IDDM_TrinhDo));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_TC_QuyenHoaDon_TrinhDo_Add", colParam));
}
public List <TC_QuyenHoaDon_TrinhDoInfo> GetList(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo)
{
List <TC_QuyenHoaDon_TrinhDoInfo> oTC_QuyenHoaDon_TrinhDoInfoList = new List <TC_QuyenHoaDon_TrinhDoInfo>();
DataTable dtb = Get(pTC_QuyenHoaDon_TrinhDoInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_QuyenHoaDon_TrinhDoInfo = new TC_QuyenHoaDon_TrinhDoInfo();
oTC_QuyenHoaDon_TrinhDoInfo.TC_QuyenHoaDon_TrinhDoID = int.Parse(dtb.Rows[i][oTC_QuyenHoaDon_TrinhDoInfo.strTC_QuyenHoaDon_TrinhDoID].ToString());
oTC_QuyenHoaDon_TrinhDoInfo.IDTC_QuyenHoaDon = int.Parse(dtb.Rows[i][oTC_QuyenHoaDon_TrinhDoInfo.strIDTC_QuyenHoaDon].ToString());
oTC_QuyenHoaDon_TrinhDoInfo.IDDM_TrinhDo = int.Parse(dtb.Rows[i][oTC_QuyenHoaDon_TrinhDoInfo.strIDDM_TrinhDo].ToString());
oTC_QuyenHoaDon_TrinhDoInfoList.Add(oTC_QuyenHoaDon_TrinhDoInfo);
}
}
return(oTC_QuyenHoaDon_TrinhDoInfoList);
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
cBTC_QuyenHoaDon_TrinhDo oBQuyenHoaDon_Trinhdo = new cBTC_QuyenHoaDon_TrinhDo();
TC_QuyenHoaDon_TrinhDoInfo pQuyenHoaDon_TrinhDo = new TC_QuyenHoaDon_TrinhDoInfo();
if (!Check_Valid())
{
return;
}
try
{
GetInfo();
string[] arrAdd = strAdd.Split(',');
string[] arrDelete = strDelete.Split(',');
if (status == 0)
{
int mQuyenHoaDonID = oBTC_QuyenHoaDon.Add(pTC_QuyenHoaDonInfo);
drQuyenHoaDon = dtQuyenHoaDon.NewRow();
oBTC_QuyenHoaDon.ToDataRow(pTC_QuyenHoaDonInfo, ref drQuyenHoaDon);
drQuyenHoaDon["TC_QuyenHoaDonID"] = mQuyenHoaDonID;
dtQuyenHoaDon.Rows.Add(drQuyenHoaDon);
ThemThanhCong();
// Update Trinh Do
if (arrAdd.Length > 0)
{
for (int i = 0; i < arrAdd.Length - 1; i++)
{
if (arrAdd[i].ToString() != "")
{
pQuyenHoaDon_TrinhDo.IDDM_TrinhDo = int.Parse(arrAdd[i]);
pQuyenHoaDon_TrinhDo.IDTC_QuyenHoaDon = mQuyenHoaDonID;
oBQuyenHoaDon_Trinhdo.Add(pQuyenHoaDon_TrinhDo);
}
}
}
if (arrDelete.Length > 0)
{
for (int i = 0; i < arrDelete.Length - 1; i++)
{
if (arrDelete[i].ToString() != "")
{
pQuyenHoaDon_TrinhDo.TC_QuyenHoaDon_TrinhDoID = int.Parse(arrDelete[i]);
oBQuyenHoaDon_Trinhdo.Delete(pQuyenHoaDon_TrinhDo);
}
}
}
GetTrinhDo();
}
else
{
oBTC_QuyenHoaDon.Update(pTC_QuyenHoaDonInfo);
drQuyenHoaDon[pTC_QuyenHoaDonInfo.strTuSo] = pTC_QuyenHoaDonInfo.TuSo;
drQuyenHoaDon[pTC_QuyenHoaDonInfo.strSoHienTai] = pTC_QuyenHoaDonInfo.SoHienTai;
drQuyenHoaDon[pTC_QuyenHoaDonInfo.strTenQuyenHoaDon] = pTC_QuyenHoaDonInfo.TenQuyenHoaDon;
// Update Trinh Do
for (int i = 0; i < arrAdd.Length - 1; i++)
{
if (arrAdd[i].ToString() != "")
{
pQuyenHoaDon_TrinhDo.IDDM_TrinhDo = int.Parse(arrAdd[i]);
pQuyenHoaDon_TrinhDo.IDTC_QuyenHoaDon = pTC_QuyenHoaDonInfo.TC_QuyenHoaDonID;
oBQuyenHoaDon_Trinhdo.Add(pQuyenHoaDon_TrinhDo);
}
}
for (int i = 0; i < arrDelete.Length - 1; i++)
{
if (arrDelete[i].ToString() != "")
{
pQuyenHoaDon_TrinhDo.TC_QuyenHoaDon_TrinhDoID = int.Parse(arrDelete[i]);
oBQuyenHoaDon_Trinhdo.Delete(pQuyenHoaDon_TrinhDo);
}
}
SuaThanhCong();
panelTop.Visible = false;
}
ClearText();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
public void ToInfo(ref TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo, DataRow dr)
{
pTC_QuyenHoaDon_TrinhDoInfo.TC_QuyenHoaDon_TrinhDoID = int.Parse(dr[oTC_QuyenHoaDon_TrinhDoInfo.strTC_QuyenHoaDon_TrinhDoID].ToString());
pTC_QuyenHoaDon_TrinhDoInfo.IDTC_QuyenHoaDon = int.Parse(dr[oTC_QuyenHoaDon_TrinhDoInfo.strIDTC_QuyenHoaDon].ToString());
pTC_QuyenHoaDon_TrinhDoInfo.IDDM_TrinhDo = int.Parse(dr[oTC_QuyenHoaDon_TrinhDoInfo.strIDDM_TrinhDo].ToString());
}
public void ToDataRow(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo, ref DataRow dr)
{
dr[pTC_QuyenHoaDon_TrinhDoInfo.strTC_QuyenHoaDon_TrinhDoID] = pTC_QuyenHoaDon_TrinhDoInfo.TC_QuyenHoaDon_TrinhDoID;
dr[pTC_QuyenHoaDon_TrinhDoInfo.strIDTC_QuyenHoaDon] = pTC_QuyenHoaDon_TrinhDoInfo.IDTC_QuyenHoaDon;
dr[pTC_QuyenHoaDon_TrinhDoInfo.strIDDM_TrinhDo] = pTC_QuyenHoaDon_TrinhDoInfo.IDDM_TrinhDo;
}
public void Delete(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo)
{
oDTC_QuyenHoaDon_TrinhDo.Delete(pTC_QuyenHoaDon_TrinhDoInfo);
mErrorMessage = oDTC_QuyenHoaDon_TrinhDo.ErrorMessages;
mErrorNumber = oDTC_QuyenHoaDon_TrinhDo.ErrorNumber;
}
public DataTable Get(TC_QuyenHoaDon_TrinhDoInfo pTC_QuyenHoaDon_TrinhDoInfo)
{
return(oDTC_QuyenHoaDon_TrinhDo.Get(pTC_QuyenHoaDon_TrinhDoInfo));
}
