public void Delete(DM_TonGiaoInfo pDM_TonGiaoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_TonGiaoID", SqlDbType.Int, pDM_TonGiaoInfo.DM_TonGiaoID));
RunProcedure("sp_DM_TonGiao_Delete", colParam);
}
public DataTable Get(DM_TonGiaoInfo pDM_TonGiaoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_TonGiaoID", SqlDbType.Int, pDM_TonGiaoInfo.DM_TonGiaoID));
return(RunProcedureGet("sp_DM_TonGiao_Get", colParam));
}
public frmTonGiao()
{
InitializeComponent();
oBTonGiao = new cBDM_TonGiao();
pDM_TonGiaoInfo = new DM_TonGiaoInfo();
LstTonGiao = new List <DM_TonGiaoInfo>();
LstTonGiao = oBTonGiao.GetList(pDM_TonGiaoInfo);
}
public int Add(DM_TonGiaoInfo pDM_TonGiaoInfo)
{
int ID = 0;
ID = oDDM_TonGiao.Add(pDM_TonGiaoInfo);
mErrorMessage = oDDM_TonGiao.ErrorMessages;
mErrorNumber = oDDM_TonGiao.ErrorNumber;
return(ID);
}
public void Update(DM_TonGiaoInfo pDM_TonGiaoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaTonGiao", SqlDbType.NVarChar, pDM_TonGiaoInfo.MaTonGiao));
colParam.Add(CreateParam("@TenTonGiao", SqlDbType.NVarChar, pDM_TonGiaoInfo.TenTonGiao));
colParam.Add(CreateParam("@DM_TonGiaoID", SqlDbType.Int, pDM_TonGiaoInfo.DM_TonGiaoID));
RunProcedure("sp_DM_TonGiao_Update", colParam);
}
public int Add(DM_TonGiaoInfo pDM_TonGiaoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaTonGiao", SqlDbType.NVarChar, pDM_TonGiaoInfo.MaTonGiao));
colParam.Add(CreateParam("@TenTonGiao", SqlDbType.NVarChar, pDM_TonGiaoInfo.TenTonGiao));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_TonGiao_Add", colParam));
}
public List <DM_TonGiaoInfo> GetList(DM_TonGiaoInfo pDM_TonGiaoInfo)
{
List <DM_TonGiaoInfo> oDM_TonGiaoInfoList = new List <DM_TonGiaoInfo>();
DataTable dtb = Get(pDM_TonGiaoInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_TonGiaoInfo = new DM_TonGiaoInfo();
oDM_TonGiaoInfo.DM_TonGiaoID = int.Parse(dtb.Rows[i]["DM_TonGiaoID"].ToString());
oDM_TonGiaoInfo.MaTonGiao = dtb.Rows[i]["MaTonGiao"].ToString();
oDM_TonGiaoInfo.TenTonGiao = dtb.Rows[i]["TenTonGiao"].ToString();
oDM_TonGiaoInfoList.Add(oDM_TonGiaoInfo);
}
}
return(oDM_TonGiaoInfoList);
}
public void Delete(DM_TonGiaoInfo pDM_TonGiaoInfo)
{
oDDM_TonGiao.Delete(pDM_TonGiaoInfo);
mErrorMessage = oDDM_TonGiao.ErrorMessages;
mErrorNumber = oDDM_TonGiao.ErrorNumber;
}
public DataTable Get(DM_TonGiaoInfo pDM_TonGiaoInfo)
{
return(oDDM_TonGiao.Get(pDM_TonGiaoInfo));
}
