public DataTable Get(HT_DongBoInfo pHT_DongBoInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_HT_DongBo_GetResult>(client.cDHT_DongBo_Get(GlobalVar.MaXacThuc, pHT_DongBoInfo)));
}
}
public void Delete(HT_DongBoInfo pHT_DongBoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_DongBoID", SqlDbType.BigInt, pHT_DongBoInfo.HT_DongBoID));
RunProcedure("sp_HT_DongBo_Delete", colParam);
}
public DataTable Get(HT_DongBoInfo pHT_DongBoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_DongBoID", SqlDbType.BigInt, pHT_DongBoInfo.HT_DongBoID));
return(RunProcedureGet("sp_HT_DongBo_Get", colParam));
}
public int Add(HT_DongBoInfo pHT_DongBoInfo)
{
int ID = 0;
ID = oDHT_DongBo.Add(pHT_DongBoInfo);
mErrorMessage = oDHT_DongBo.ErrorMessages;
mErrorNumber = oDHT_DongBo.ErrorNumber;
return(ID);
}
public void ToInfo(ref HT_DongBoInfo pHT_DongBoInfo, DataRow dr)
{
pHT_DongBoInfo.HT_DongBoID = long.Parse(dr[pHT_DongBoInfo.strHT_DongBoID].ToString());
pHT_DongBoInfo.TenBang = dr[pHT_DongBoInfo.strTenBang].ToString();
pHT_DongBoInfo.IDThayDoi = long.Parse(dr[pHT_DongBoInfo.strIDThayDoi].ToString());
pHT_DongBoInfo.ThaoTac = dr[pHT_DongBoInfo.strThaoTac].ToString();
pHT_DongBoInfo.DaDongBo = bool.Parse(dr[pHT_DongBoInfo.strDaDongBo].ToString());
pHT_DongBoInfo.CreatedTime = DateTime.Parse(dr[pHT_DongBoInfo.strCreatedTime].ToString());
}
public void ToDataRow(HT_DongBoInfo pHT_DongBoInfo, ref DataRow dr)
{
dr[pHT_DongBoInfo.strHT_DongBoID] = pHT_DongBoInfo.HT_DongBoID;
dr[pHT_DongBoInfo.strTenBang] = pHT_DongBoInfo.TenBang;
dr[pHT_DongBoInfo.strIDThayDoi] = pHT_DongBoInfo.IDThayDoi;
dr[pHT_DongBoInfo.strThaoTac] = pHT_DongBoInfo.ThaoTac;
dr[pHT_DongBoInfo.strDaDongBo] = pHT_DongBoInfo.DaDongBo;
dr[pHT_DongBoInfo.strCreatedTime] = pHT_DongBoInfo.CreatedTime;
}
public void Delete(HT_DongBoInfo pHT_DongBoInfo)
{
var client = new UnimOsServiceClient();
client.cDHT_DongBo_Delete(GlobalVar.MaXacThuc, pHT_DongBoInfo);
client.Close();
mErrorMessage = oDHT_DongBo.ErrorMessages;
mErrorNumber = oDHT_DongBo.ErrorNumber;
}
public int Add(HT_DongBoInfo pHT_DongBoInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDHT_DongBo_Add(GlobalVar.MaXacThuc, pHT_DongBoInfo);
client.Close();
mErrorMessage = oDHT_DongBo.ErrorMessages;
mErrorNumber = oDHT_DongBo.ErrorNumber;
return(ID);
}
public void Update(HT_DongBoInfo pHT_DongBoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenBang", SqlDbType.NVarChar, pHT_DongBoInfo.TenBang));
colParam.Add(CreateParam("@IDThayDoi", SqlDbType.BigInt, pHT_DongBoInfo.IDThayDoi));
colParam.Add(CreateParam("@ThaoTac", SqlDbType.NChar, pHT_DongBoInfo.ThaoTac));
colParam.Add(CreateParam("@DaDongBo", SqlDbType.Bit, pHT_DongBoInfo.DaDongBo));
colParam.Add(CreateParam("@CreatedTime", SqlDbType.DateTime, pHT_DongBoInfo.CreatedTime));
colParam.Add(CreateParam("@HT_DongBoID", SqlDbType.BigInt, pHT_DongBoInfo.HT_DongBoID));
RunProcedure("sp_HT_DongBo_Update", colParam);
}
public int Add(HT_DongBoInfo pHT_DongBoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenBang", SqlDbType.NVarChar, pHT_DongBoInfo.TenBang));
colParam.Add(CreateParam("@IDThayDoi", SqlDbType.BigInt, pHT_DongBoInfo.IDThayDoi));
colParam.Add(CreateParam("@ThaoTac", SqlDbType.NChar, pHT_DongBoInfo.ThaoTac));
colParam.Add(CreateParam("@DaDongBo", SqlDbType.Bit, pHT_DongBoInfo.DaDongBo));
colParam.Add(CreateParam("@CreatedTime", SqlDbType.DateTime, pHT_DongBoInfo.CreatedTime));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_HT_DongBo_Add", colParam));
}
public List <HT_DongBoInfo> GetList(HT_DongBoInfo pHT_DongBoInfo)
{
List <HT_DongBoInfo> oHT_DongBoInfoList = new List <HT_DongBoInfo>();
DataTable dtb = Get(pHT_DongBoInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oHT_DongBoInfo = new HT_DongBoInfo();
oHT_DongBoInfo.HT_DongBoID = long.Parse(dtb.Rows[i]["HT_DongBoID"].ToString());
oHT_DongBoInfo.TenBang = dtb.Rows[i]["TenBang"].ToString();
oHT_DongBoInfo.IDThayDoi = long.Parse(dtb.Rows[i]["IDThayDoi"].ToString());
oHT_DongBoInfo.ThaoTac = dtb.Rows[i]["ThaoTac"].ToString();
oHT_DongBoInfo.DaDongBo = bool.Parse(dtb.Rows[i]["DaDongBo"].ToString());
oHT_DongBoInfo.CreatedTime = DateTime.Parse(dtb.Rows[i]["CreatedTime"].ToString());
oHT_DongBoInfoList.Add(oHT_DongBoInfo);
}
}
return(oHT_DongBoInfoList);
}
public void Delete(HT_DongBoInfo pHT_DongBoInfo)
{
oDHT_DongBo.Delete(pHT_DongBoInfo);
mErrorMessage = oDHT_DongBo.ErrorMessages;
mErrorNumber = oDHT_DongBo.ErrorNumber;
}
public DataTable Get(HT_DongBoInfo pHT_DongBoInfo)
{
return(oDHT_DongBo.Get(pHT_DongBoInfo));
}
public frmDongBoDuLieu()
{
InitializeComponent();
oBHT_DongBo = new cBHT_DongBo();
pHT_DongBoInfo = new HT_DongBoInfo();
}