public void Delete(DM_QuocTichInfo pDM_QuocTichInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_QuocTichID", SqlDbType.Int, pDM_QuocTichInfo.DM_QuocTichID));
RunProcedure("sp_DM_QuocTich_Delete", colParam);
}
public frmDM_QuocTich(frmQuaTrinhCongTac _frmQuaTrinhCongTac)
{
InitializeComponent();
oBDM_QuocTich = new cBDM_QuocTich();
pDM_QuocTichInfo = new DM_QuocTichInfo();
SetControl(false);
ofrmQuaTrinhCongTac = _frmQuaTrinhCongTac;
}
public DataTable Get(DM_QuocTichInfo pDM_QuocTichInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_QuocTichID", SqlDbType.Int, pDM_QuocTichInfo.DM_QuocTichID));
return(RunProcedureGet("sp_DM_QuocTich_Get", colParam));
}
public int Add(DM_QuocTichInfo pDM_QuocTichInfo)
{
int ID = 0;
ID = oDDM_QuocTich.Add(pDM_QuocTichInfo);
mErrorMessage = oDDM_QuocTich.ErrorMessages;
mErrorNumber = oDDM_QuocTich.ErrorNumber;
return(ID);
}
public void Update(DM_QuocTichInfo pDM_QuocTichInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaNuoc", SqlDbType.NVarChar, pDM_QuocTichInfo.MaNuoc));
colParam.Add(CreateParam("@TenNuoc", SqlDbType.NVarChar, pDM_QuocTichInfo.TenNuoc));
colParam.Add(CreateParam("@DM_QuocTichID", SqlDbType.Int, pDM_QuocTichInfo.DM_QuocTichID));
RunProcedure("sp_DM_QuocTich_Update", colParam);
}
public int Add(DM_QuocTichInfo pDM_QuocTichInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaNuoc", SqlDbType.NVarChar, pDM_QuocTichInfo.MaNuoc));
colParam.Add(CreateParam("@TenNuoc", SqlDbType.NVarChar, pDM_QuocTichInfo.TenNuoc));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_QuocTich_Add", colParam));
}
public List <DM_QuocTichInfo> GetList(DM_QuocTichInfo pDM_QuocTichInfo)
{
List <DM_QuocTichInfo> oDM_QuocTichInfoList = new List <DM_QuocTichInfo>();
DataTable dtb = Get(pDM_QuocTichInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_QuocTichInfo = new DM_QuocTichInfo();
oDM_QuocTichInfo.DM_QuocTichID = int.Parse(dtb.Rows[i]["DM_QuocTichID"].ToString());
oDM_QuocTichInfo.MaNuoc = dtb.Rows[i]["MaNuoc"].ToString();
oDM_QuocTichInfo.TenNuoc = dtb.Rows[i]["TenNuoc"].ToString();
oDM_QuocTichInfoList.Add(oDM_QuocTichInfo);
}
}
return(oDM_QuocTichInfoList);
}
public void ToInfo(ref DM_QuocTichInfo pDM_QuocTichInfo, DataRow dr)
{
pDM_QuocTichInfo.DM_QuocTichID = int.Parse(dr[pDM_QuocTichInfo.strDM_QuocTichID].ToString());
pDM_QuocTichInfo.MaNuoc = dr[pDM_QuocTichInfo.strMaNuoc].ToString();
pDM_QuocTichInfo.TenNuoc = dr[pDM_QuocTichInfo.strTenNuoc].ToString();
}
public void ToDataRow(DM_QuocTichInfo pDM_QuocTichInfo, ref DataRow dr)
{
dr[pDM_QuocTichInfo.strDM_QuocTichID] = pDM_QuocTichInfo.DM_QuocTichID;
dr[pDM_QuocTichInfo.strMaNuoc] = pDM_QuocTichInfo.MaNuoc;
dr[pDM_QuocTichInfo.strTenNuoc] = pDM_QuocTichInfo.TenNuoc;
}
public void Delete(DM_QuocTichInfo pDM_QuocTichInfo)
{
oDDM_QuocTich.Delete(pDM_QuocTichInfo);
mErrorMessage = oDDM_QuocTich.ErrorMessages;
mErrorNumber = oDDM_QuocTich.ErrorNumber;
}
public DataTable Get(DM_QuocTichInfo pDM_QuocTichInfo)
{
return(oDDM_QuocTich.Get(pDM_QuocTichInfo));
}
