public void ToInfo(ref HT_PhanHeInfo pHT_PhanHeInfo, DataRow dr)
{
pHT_PhanHeInfo.HT_PhanHeID = int.Parse(dr[pHT_PhanHeInfo.strHT_PhanHeID].ToString());
pHT_PhanHeInfo.MaPhanHe = dr[pHT_PhanHeInfo.strMaPhanHe].ToString();
pHT_PhanHeInfo.TenPhanHe = dr[pHT_PhanHeInfo.strTenPhanHe].ToString();
pHT_PhanHeInfo.MoTa = dr[pHT_PhanHeInfo.strMoTa].ToString();
pHT_PhanHeInfo.SapXep = int.Parse(dr[pHT_PhanHeInfo.strSapXep].ToString());
}
public void Delete(HT_PhanHeInfo pHT_PhanHeInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_PhanHeID", SqlDbType.Int, pHT_PhanHeInfo.HT_PhanHeID));
RunProcedure("sp_HT_PhanHe_Delete", colParam);
}
public void ToDataRow(HT_PhanHeInfo pHT_PhanHeInfo, ref DataRow dr)
{
dr[pHT_PhanHeInfo.strHT_PhanHeID] = pHT_PhanHeInfo.HT_PhanHeID;
dr[pHT_PhanHeInfo.strMaPhanHe] = pHT_PhanHeInfo.MaPhanHe;
dr[pHT_PhanHeInfo.strTenPhanHe] = pHT_PhanHeInfo.TenPhanHe;
dr[pHT_PhanHeInfo.strMoTa] = pHT_PhanHeInfo.MoTa;
dr[pHT_PhanHeInfo.strSapXep] = pHT_PhanHeInfo.SapXep;
}
public DataTable Get(HT_PhanHeInfo pHT_PhanHeInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_PhanHeID", SqlDbType.Int, pHT_PhanHeInfo.HT_PhanHeID));
return(RunProcedureGet("sp_HT_PhanHe_Get", colParam));
}
public int Add(HT_PhanHeInfo pHT_PhanHeInfo)
{
int ID = 0;
ID = oDHT_PhanHe.Add(pHT_PhanHeInfo);
mErrorMessage = oDHT_PhanHe.ErrorMessages;
mErrorNumber = oDHT_PhanHe.ErrorNumber;
return(ID);
}
public void Update(HT_PhanHeInfo pHT_PhanHeInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaPhanHe", SqlDbType.NVarChar, pHT_PhanHeInfo.MaPhanHe));
colParam.Add(CreateParam("@TenPhanHe", SqlDbType.NVarChar, pHT_PhanHeInfo.TenPhanHe));
colParam.Add(CreateParam("@MoTa", SqlDbType.NText, pHT_PhanHeInfo.MoTa));
colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pHT_PhanHeInfo.SapXep));
colParam.Add(CreateParam("@HT_PhanHeID", SqlDbType.Int, pHT_PhanHeInfo.HT_PhanHeID));
RunProcedure("sp_HT_PhanHe_Update", colParam);
}
public int Add(HT_PhanHeInfo pHT_PhanHeInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaPhanHe", SqlDbType.NVarChar, pHT_PhanHeInfo.MaPhanHe));
colParam.Add(CreateParam("@TenPhanHe", SqlDbType.NVarChar, pHT_PhanHeInfo.TenPhanHe));
colParam.Add(CreateParam("@MoTa", SqlDbType.NText, pHT_PhanHeInfo.MoTa));
colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pHT_PhanHeInfo.SapXep));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_HT_PhanHe_Add", colParam));
}
public frmTraCuuLog()
{
InitializeComponent();
oBPhanHe = new cBHT_PhanHe();
pPhanHeInfo = new HT_PhanHeInfo();
oBChucNang = new cBHT_ChucNang();
pChucNangInfo = new HT_ChucNangInfo();
pHT_LogInfo = new HT_LogInfo();
oBHT_Log = new cBHT_Log();
pHT_UserInfo = new HT_UserInfo();
oBHT_User = new cBHT_User();
}
private void LoadPhanHe()
{
cBHT_PhanHe oBHT_PhanHe = new cBHT_PhanHe();
HT_PhanHeInfo pHT_PhanHeInfo = new HT_PhanHeInfo();
pHT_PhanHeInfo.HT_PhanHeID = 0;
DataTable dt = oBHT_PhanHe.Get(pHT_PhanHeInfo);
cmbPhanHe.Properties.DataSource = dt;
if (dt.Rows.Count > 0)
{
cmbPhanHe.ItemIndex = 0;
}
}
public List <HT_PhanHeInfo> GetList(HT_PhanHeInfo pHT_PhanHeInfo)
{
List <HT_PhanHeInfo> oHT_PhanHeInfoList = new List <HT_PhanHeInfo>();
DataTable dtb = Get(pHT_PhanHeInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oHT_PhanHeInfo = new HT_PhanHeInfo();
oHT_PhanHeInfo.HT_PhanHeID = int.Parse(dtb.Rows[i]["HT_PhanHeID"].ToString());
oHT_PhanHeInfo.MaPhanHe = dtb.Rows[i]["MaPhanHe"].ToString();
oHT_PhanHeInfo.TenPhanHe = dtb.Rows[i]["TenPhanHe"].ToString();
oHT_PhanHeInfo.MoTa = dtb.Rows[i]["MoTa"].ToString();
oHT_PhanHeInfo.SapXep = int.Parse(dtb.Rows[i]["SapXep"].ToString());
oHT_PhanHeInfoList.Add(oHT_PhanHeInfo);
}
}
return(oHT_PhanHeInfoList);
}
public void Delete(HT_PhanHeInfo pHT_PhanHeInfo)
{
oDHT_PhanHe.Delete(pHT_PhanHeInfo);
mErrorMessage = oDHT_PhanHe.ErrorMessages;
mErrorNumber = oDHT_PhanHe.ErrorNumber;
}
public DataTable Get(HT_PhanHeInfo pHT_PhanHeInfo)
{
return(oDHT_PhanHe.Get(pHT_PhanHeInfo));
}
