public void Delete(GG_DinhMucTheoChucDanhInfo pGG_DinhMucTheoChucDanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@GG_DinhMucTheoChucDanhID", SqlDbType.Int, pGG_DinhMucTheoChucDanhInfo.GG_DinhMucTheoChucDanhID));
RunProcedure("sp_GG_DinhMucTheoChucDanh_Delete", colParam);
}
public DataTable Get(GG_DinhMucTheoChucDanhInfo pGG_DinhMucTheoChucDanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@GG_DinhMucTheoChucDanhID", SqlDbType.Int, pGG_DinhMucTheoChucDanhInfo.GG_DinhMucTheoChucDanhID));
return(RunProcedureGet("sp_GG_DinhMucTheoChucDanh_Get", colParam));
}
public void ToInfo(ref GG_DinhMucTheoChucDanhInfo pGG_DinhMucTheoChucDanhInfo, DataRow dr)
{
pGG_DinhMucTheoChucDanhInfo.GG_DinhMucTheoChucDanhID = int.Parse(dr[pGG_DinhMucTheoChucDanhInfo.strGG_DinhMucTheoChucDanhID].ToString());
pGG_DinhMucTheoChucDanhInfo.IDDM_ChucDanh = int.Parse(dr[pGG_DinhMucTheoChucDanhInfo.strIDDM_ChucDanh].ToString());
pGG_DinhMucTheoChucDanhInfo.HeSo = double.Parse(dr[pGG_DinhMucTheoChucDanhInfo.strHeSo].ToString());
pGG_DinhMucTheoChucDanhInfo.HeSoGioChuan = double.Parse(dr[pGG_DinhMucTheoChucDanhInfo.strHeSoGioChuan].ToString());
pGG_DinhMucTheoChucDanhInfo.GioLamViec = double.Parse(dr[pGG_DinhMucTheoChucDanhInfo.strGioLamViec].ToString());
pGG_DinhMucTheoChucDanhInfo.GioChuanGiang = double.Parse(dr[pGG_DinhMucTheoChucDanhInfo.strGioChuanGiang].ToString());
}
public void ToDataRow(GG_DinhMucTheoChucDanhInfo pGG_DinhMucTheoChucDanhInfo, ref DataRow dr)
{
dr[pGG_DinhMucTheoChucDanhInfo.strGG_DinhMucTheoChucDanhID] = pGG_DinhMucTheoChucDanhInfo.GG_DinhMucTheoChucDanhID;
dr[pGG_DinhMucTheoChucDanhInfo.strIDDM_ChucDanh] = pGG_DinhMucTheoChucDanhInfo.IDDM_ChucDanh;
dr[pGG_DinhMucTheoChucDanhInfo.strHeSo] = pGG_DinhMucTheoChucDanhInfo.HeSo;
dr[pGG_DinhMucTheoChucDanhInfo.strHeSoGioChuan] = pGG_DinhMucTheoChucDanhInfo.HeSoGioChuan;
dr[pGG_DinhMucTheoChucDanhInfo.strGioLamViec] = pGG_DinhMucTheoChucDanhInfo.GioLamViec;
dr[pGG_DinhMucTheoChucDanhInfo.strGioChuanGiang] = pGG_DinhMucTheoChucDanhInfo.GioChuanGiang;
}
public int Add(GG_DinhMucTheoChucDanhInfo pGG_DinhMucTheoChucDanhInfo)
{
int ID = 0;
ID = oDGG_DinhMucTheoChucDanh.Add(pGG_DinhMucTheoChucDanhInfo);
mErrorMessage = oDGG_DinhMucTheoChucDanh.ErrorMessages;
mErrorNumber = oDGG_DinhMucTheoChucDanh.ErrorNumber;
return(ID);
}
private void btnThem_Click(object sender, EventArgs e)
{
Info = new GG_DinhMucTheoChucDanhInfo();
dlgDinhMucTheoChucDanh dlg = new dlgDinhMucTheoChucDanh(Info, "");
if (dlg.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
private GG_DinhMucTheoChucDanhInfo GetInfo()
{
Info = new GG_DinhMucTheoChucDanhInfo();
DataRow dr = grvDinhMucTheoChucDanh.GetDataRow(grvDinhMucTheoChucDanh.FocusedRowHandle);
Info.GG_DinhMucTheoChucDanhID = (int)dr["GG_DinhMucTheoChucDanhID"];
Info.IDDM_ChucDanh = (int)dr["IDDM_ChucDanh"];
Info.GioChuanGiang = (double)dr["GioChuanGiang"];
Info.GioLamViec = (double)dr["GioLamViec"];
Info.HeSo = (double)dr["HeSo"];
Info.HeSoGioChuan = (double)dr["HeSoGioChuan"];
return(Info);
}
public void Update(GG_DinhMucTheoChucDanhInfo pGG_DinhMucTheoChucDanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_ChucDanh", SqlDbType.Int, pGG_DinhMucTheoChucDanhInfo.IDDM_ChucDanh));
colParam.Add(CreateParam("@HeSo", SqlDbType.Float, pGG_DinhMucTheoChucDanhInfo.HeSo));
colParam.Add(CreateParam("@HeSoGioChuan", SqlDbType.Float, pGG_DinhMucTheoChucDanhInfo.HeSoGioChuan));
colParam.Add(CreateParam("@GioLamViec", SqlDbType.Float, pGG_DinhMucTheoChucDanhInfo.GioLamViec));
colParam.Add(CreateParam("@GioChuanGiang", SqlDbType.Float, pGG_DinhMucTheoChucDanhInfo.GioChuanGiang));
colParam.Add(CreateParam("@GG_DinhMucTheoChucDanhID", SqlDbType.Int, pGG_DinhMucTheoChucDanhInfo.GG_DinhMucTheoChucDanhID));
RunProcedure("sp_GG_DinhMucTheoChucDanh_Update", colParam);
}
public int Add(GG_DinhMucTheoChucDanhInfo pGG_DinhMucTheoChucDanhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_ChucDanh", SqlDbType.Int, pGG_DinhMucTheoChucDanhInfo.IDDM_ChucDanh));
colParam.Add(CreateParam("@HeSo", SqlDbType.Float, pGG_DinhMucTheoChucDanhInfo.HeSo));
colParam.Add(CreateParam("@HeSoGioChuan", SqlDbType.Float, pGG_DinhMucTheoChucDanhInfo.HeSoGioChuan));
colParam.Add(CreateParam("@GioLamViec", SqlDbType.Float, pGG_DinhMucTheoChucDanhInfo.GioLamViec));
colParam.Add(CreateParam("@GioChuanGiang", SqlDbType.Float, pGG_DinhMucTheoChucDanhInfo.GioChuanGiang));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_GG_DinhMucTheoChucDanh_Add", colParam));
}
public dlgDinhMucTheoChucDanh(GG_DinhMucTheoChucDanhInfo _info, string ChucDanh)
{
InitializeComponent();
info = _info;
cmbChucDanh.Properties.DataSource = oBDM_ChucDanh.GetChucDanhChuaDinhMuc();
if (info.GG_DinhMucTheoChucDanhID > 0)
{
cmbChucDanh.Properties.NullText = ChucDanh;
cmbChucDanh.Properties.ReadOnly = true;
//cmbChucDanh.Enabled = false;
txtGioLamViec.Text = info.GioLamViec.ToString();
txtHeSo.Text = info.HeSo.ToString();
txtHeSoQuyDoi.Text = info.HeSoGioChuan.ToString();
txtSoGioChuan.Text = info.GioChuanGiang.ToString();
}
}
public List <GG_DinhMucTheoChucDanhInfo> GetList(GG_DinhMucTheoChucDanhInfo pGG_DinhMucTheoChucDanhInfo)
{
List <GG_DinhMucTheoChucDanhInfo> oGG_DinhMucTheoChucDanhInfoList = new List <GG_DinhMucTheoChucDanhInfo>();
DataTable dtb = Get(pGG_DinhMucTheoChucDanhInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oGG_DinhMucTheoChucDanhInfo = new GG_DinhMucTheoChucDanhInfo();
oGG_DinhMucTheoChucDanhInfo.GG_DinhMucTheoChucDanhID = int.Parse(dtb.Rows[i]["GG_DinhMucTheoChucDanhID"].ToString());
oGG_DinhMucTheoChucDanhInfo.IDDM_ChucDanh = int.Parse(dtb.Rows[i]["IDDM_ChucDanh"].ToString());
oGG_DinhMucTheoChucDanhInfo.HeSo = double.Parse(dtb.Rows[i]["HeSo"].ToString());
oGG_DinhMucTheoChucDanhInfo.HeSoGioChuan = double.Parse(dtb.Rows[i]["HeSoGioChuan"].ToString());
oGG_DinhMucTheoChucDanhInfo.GioLamViec = double.Parse(dtb.Rows[i]["GioLamViec"].ToString());
oGG_DinhMucTheoChucDanhInfo.GioChuanGiang = double.Parse(dtb.Rows[i]["GioChuanGiang"].ToString());
oGG_DinhMucTheoChucDanhInfoList.Add(oGG_DinhMucTheoChucDanhInfo);
}
}
return(oGG_DinhMucTheoChucDanhInfoList);
}
public void Delete(GG_DinhMucTheoChucDanhInfo pGG_DinhMucTheoChucDanhInfo)
{
oDGG_DinhMucTheoChucDanh.Delete(pGG_DinhMucTheoChucDanhInfo);
mErrorMessage = oDGG_DinhMucTheoChucDanh.ErrorMessages;
mErrorNumber = oDGG_DinhMucTheoChucDanh.ErrorNumber;
}
public DataTable Get(GG_DinhMucTheoChucDanhInfo pGG_DinhMucTheoChucDanhInfo)
{
return(oDGG_DinhMucTheoChucDanh.Get(pGG_DinhMucTheoChucDanhInfo));
}