public DataTable GetCombo(XL_KeHoachKhacInfo pXL_KeHoachKhacInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_XL_KeHoachKhac_GetComboResult>(client.cDXL_KeHoachKhac_GetCombo(GlobalVar.MaXacThuc, pXL_KeHoachKhacInfo)));
}
}
public void Delete(XL_KeHoachKhacInfo pXL_KeHoachKhacInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_KeHoachKhacID", SqlDbType.Int, pXL_KeHoachKhacInfo.XL_KeHoachKhacID));
RunProcedure("sp_XL_KeHoachKhac_Delete", colParam);
}
public DataTable Get(XL_KeHoachKhacInfo pXL_KeHoachKhacInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_KeHoachKhacID", SqlDbType.Int, pXL_KeHoachKhacInfo.XL_KeHoachKhacID));
return(RunProcedureGet("sp_XL_KeHoachKhac_Get", colParam));
}
public int Add(XL_KeHoachKhacInfo pXL_KeHoachKhacInfo)
{
int ID = 0;
ID = oDXL_KeHoachKhac.Add(pXL_KeHoachKhacInfo);
mErrorMessage = oDXL_KeHoachKhac.ErrorMessages;
mErrorNumber = oDXL_KeHoachKhac.ErrorNumber;
return(ID);
}
private void LoadKeHoachKhac()
{
cBXL_KeHoachKhac oBKeHoachKhac = new cBXL_KeHoachKhac();
XL_KeHoachKhacInfo pKeHoachKhacInfo = new XL_KeHoachKhacInfo();
pKeHoachKhacInfo.XL_KeHoachKhacID = 0;
cmbIDKeHoachKhac.Properties.DataSource = oBKeHoachKhac.GetCombo(pKeHoachKhacInfo);
//cmbIDKeHoachKhac.Properties.DisplayMember = "TenKeHoachKhac";
//cmbIDKeHoachKhac.Properties.ValueMember = "XL_KeHoachKhacID";
}
public void Update(XL_KeHoachKhacInfo pXL_KeHoachKhacInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenKeHoachKhac", SqlDbType.NVarChar, pXL_KeHoachKhacInfo.TenKeHoachKhac));
colParam.Add(CreateParam("@TenVietTat", SqlDbType.NVarChar, pXL_KeHoachKhacInfo.TenVietTat));
colParam.Add(CreateParam("@MauNen", SqlDbType.Int, pXL_KeHoachKhacInfo.MauNen));
colParam.Add(CreateParam("@MauChu", SqlDbType.Int, pXL_KeHoachKhacInfo.MauChu));
colParam.Add(CreateParam("@DuLieuChuan", SqlDbType.Bit, pXL_KeHoachKhacInfo.DuLieuChuan));
colParam.Add(CreateParam("@XL_KeHoachKhacID", SqlDbType.Int, pXL_KeHoachKhacInfo.XL_KeHoachKhacID));
RunProcedure("sp_XL_KeHoachKhac_Update", colParam);
}
public int Add(XL_KeHoachKhacInfo pXL_KeHoachKhacInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenKeHoachKhac", SqlDbType.NVarChar, pXL_KeHoachKhacInfo.TenKeHoachKhac));
colParam.Add(CreateParam("@TenVietTat", SqlDbType.NVarChar, pXL_KeHoachKhacInfo.TenVietTat));
colParam.Add(CreateParam("@MauNen", SqlDbType.Int, pXL_KeHoachKhacInfo.MauNen));
colParam.Add(CreateParam("@MauChu", SqlDbType.Int, pXL_KeHoachKhacInfo.MauChu));
colParam.Add(CreateParam("@DuLieuChuan", SqlDbType.Bit, pXL_KeHoachKhacInfo.DuLieuChuan));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_XL_KeHoachKhac_Add", colParam));
}
public frmKeHoachKhac()
{
InitializeComponent();
oBKeHoachKhac = new cBXL_KeHoachKhac();
pKeHoacKhacInfo = new XL_KeHoachKhacInfo();
}