public DataTable Get(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_TinhHuyenXaID", SqlDbType.Int, pDM_TinhHuyenXaInfo.DM_TinhHuyenXaID));
return(RunProcedureGet("sp_DM_TinhHuyenXa_Get", colParam));
}
public void Delete(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_TinhHuyenXaID", SqlDbType.Int, pDM_TinhHuyenXaInfo.DM_TinhHuyenXaID));
RunProcedure("sp_DM_TinhHuyenXa_Delete", colParam);
}
public int AddByImport(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo, string MaCha)
{
int ID = 0;
ID = oDDM_TinhHuyenXa.AddByImport(pDM_TinhHuyenXaInfo, MaCha);
mErrorMessage = oDDM_TinhHuyenXa.ErrorMessages;
mErrorNumber = oDDM_TinhHuyenXa.ErrorNumber;
return(ID);
}
public int Add(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
{
int ID = 0;
ID = oDDM_TinhHuyenXa.Add(pDM_TinhHuyenXaInfo);
mErrorMessage = oDDM_TinhHuyenXa.ErrorMessages;
mErrorNumber = oDDM_TinhHuyenXa.ErrorNumber;
return(ID);
}
//public int Add(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDDM_TinhHuyenXa_Add(GlobalVar.MaXacThuc, pDM_TinhHuyenXaInfo);
// client.Close();
// mErrorMessage = oDDM_TinhHuyenXa.ErrorMessages;
// mErrorNumber = oDDM_TinhHuyenXa.ErrorNumber;
// return ID;
//}
public int AddByImport(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo, string MaCha)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDDM_TinhHuyenXa_AddByImport(GlobalVar.MaXacThuc, pDM_TinhHuyenXaInfo, MaCha);
client.Close();
mErrorMessage = oDDM_TinhHuyenXa.ErrorMessages;
mErrorNumber = oDDM_TinhHuyenXa.ErrorNumber;
return(ID);
}
public dlgCapNhatTinhHuyenXa(frmTinhHuyenXa _frm, DM_TinhHuyenXaInfo _pTinhHuyenXaInfo)
{
InitializeComponent();
oBTinhHuyenXa = new cBDM_TinhHuyenXa();
pTinhHuyenXaInfo = new DM_TinhHuyenXaInfo();
LstTHX = new List <DM_TinhHuyenXaInfo>();
pTinhHuyenXaInfo.DM_TinhHuyenXaID = 0;
LstTHX = oBTinhHuyenXa.GetList(pTinhHuyenXaInfo);
pTinhHuyenXaInfo = _pTinhHuyenXaInfo;
frm = _frm;
}
public int AddByImport(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo, string MaCha)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@Ma", SqlDbType.NVarChar, pDM_TinhHuyenXaInfo.Ma));
colParam.Add(CreateParam("@Ten", SqlDbType.NVarChar, pDM_TinhHuyenXaInfo.Ten));
colParam.Add(CreateParam("@MaCha", SqlDbType.NVarChar, MaCha));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_TinhHuyenXa_AddByImport", colParam));
}
public dlgCapNhatTinhHuyenXa(frmTinhHuyenXa _frm, int _ID, int _Level)
{
InitializeComponent();
oBTinhHuyenXa = new cBDM_TinhHuyenXa();
pTinhHuyenXaInfo = new DM_TinhHuyenXaInfo();
LstTHX = new List <DM_TinhHuyenXaInfo>();
pTinhHuyenXaInfo.DM_TinhHuyenXaID = 0;
LstTHX = oBTinhHuyenXa.GetList(pTinhHuyenXaInfo);
ID = _ID;
Level = _Level;
frm = _frm;
}
public void Update(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@Ma", SqlDbType.NVarChar, pDM_TinhHuyenXaInfo.Ma));
colParam.Add(CreateParam("@Ten", SqlDbType.NVarChar, pDM_TinhHuyenXaInfo.Ten));
colParam.Add(CreateParam("@ParentID", SqlDbType.Int, pDM_TinhHuyenXaInfo.ParentID));
colParam.Add(CreateParam("@Level", SqlDbType.Int, pDM_TinhHuyenXaInfo.Level));
colParam.Add(CreateParam("@DM_TinhHuyenXaID", SqlDbType.Int, pDM_TinhHuyenXaInfo.DM_TinhHuyenXaID));
RunProcedure("sp_DM_TinhHuyenXa_Update", colParam);
}
public int Add(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@Ma", SqlDbType.NVarChar, pDM_TinhHuyenXaInfo.Ma));
colParam.Add(CreateParam("@Ten", SqlDbType.NVarChar, pDM_TinhHuyenXaInfo.Ten));
colParam.Add(CreateParam("@ParentID", SqlDbType.Int, pDM_TinhHuyenXaInfo.ParentID));
colParam.Add(CreateParam("@Level", SqlDbType.Int, pDM_TinhHuyenXaInfo.Level));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_TinhHuyenXa_Add", colParam));
}
public List <DM_TinhHuyenXaInfo> GetList(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
{
List <DM_TinhHuyenXaInfo> oDM_TinhHuyenXaInfoList = new List <DM_TinhHuyenXaInfo>();
DataTable dtb = Get(pDM_TinhHuyenXaInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_TinhHuyenXaInfo = new DM_TinhHuyenXaInfo();
oDM_TinhHuyenXaInfo.DM_TinhHuyenXaID = int.Parse(dtb.Rows[i]["DM_TinhHuyenXaID"].ToString());
oDM_TinhHuyenXaInfo.Ma = dtb.Rows[i]["Ma"].ToString();
oDM_TinhHuyenXaInfo.Ten = dtb.Rows[i]["Ten"].ToString();
oDM_TinhHuyenXaInfo.ParentID = int.Parse(dtb.Rows[i]["ParentID"].ToString());
oDM_TinhHuyenXaInfo.Level = int.Parse(dtb.Rows[i]["Level"].ToString());
oDM_TinhHuyenXaInfoList.Add(oDM_TinhHuyenXaInfo);
}
}
return(oDM_TinhHuyenXaInfoList);
}
//private int Index;
public frmTinhHuyenXa()
{
InitializeComponent();
oBTinhHuyenXa = new cBDM_TinhHuyenXa();
pTinhHuyenXaInfo = new DM_TinhHuyenXaInfo();
}
public void Delete(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
{
oDDM_TinhHuyenXa.Delete(pDM_TinhHuyenXaInfo);
mErrorMessage = oDDM_TinhHuyenXa.ErrorMessages;
mErrorNumber = oDDM_TinhHuyenXa.ErrorNumber;
}
public DataTable Get(DM_TinhHuyenXaInfo pDM_TinhHuyenXaInfo)
{
return(oDDM_TinhHuyenXa.Get(pDM_TinhHuyenXaInfo));
}
