public void FillDatasetSapKetThuc(DS_DM_DU_AN op_ds_dm_da, DateTime i_dat_now)
{
CStoredProc v_sp = new CStoredProc("pr_DM_DU_AN_sap_ket_thuc");
v_sp.addDatetimeInputParam("@DAT_NOW", i_dat_now);
v_sp.fillDataSetByCommand(this, op_ds_dm_da);
}
public void FillDatasetByIDQuyetDinh(DS_DM_DU_AN op_ds_dm_da, decimal ip_dc_id_quyet_dinh)
{
CStoredProc v_sp = new CStoredProc("pr_DM_DU_AN_select_by_id_quyet_dinh");
v_sp.addDecimalInputParam("@id_quyet_dinh", ip_dc_id_quyet_dinh);
v_sp.fillDataSetByCommand(this, op_ds_dm_da);
}
public void FillDatasetByID(DS_DM_DU_AN op_ds_dm_da, decimal i_dc_id)
{
CStoredProc v_sp = new CStoredProc("pr_DM_DU_AN_select_by_ID");
v_sp.addDecimalInputParam("@ID", i_dc_id);
v_sp.fillDataSetByCommand(this, op_ds_dm_da);
}
public void FillDataset_search_by_ma_da(DS_DM_DU_AN op_ds_dm_da, string i_str_id)
{
CStoredProc v_sp = new CStoredProc("pr_DM_DU_AN_select_by_ma_da");
v_sp.addNVarcharInputParam("@MA_DA", i_str_id);
v_sp.fillDataSetByCommand(this, op_ds_dm_da);
}
public void DeleteDuAnById(DS_DM_DU_AN v_ds_dm_du_an, decimal i_dc_id)
{
CStoredProc v_sp = new CStoredProc("pr_DM_DU_AN_Delete");
v_sp.addDecimalInputParam("@ID", i_dc_id);
v_sp.fillDataSetByCommand(this, v_ds_dm_du_an);
}
private void m_txt_ma_du_an_TextChanged(object sender, EventArgs e)
{
US_DM_DU_AN v_us = new US_DM_DU_AN();
DS_DM_DU_AN v_ds = new DS_DM_DU_AN();
v_us.FillDataset_search_by_ma_da(v_ds, m_txt_ma_du_an.Text);
if (v_ds.Tables[0].Rows.Count > 0)
{
DataRow dr = v_ds.Tables[0].Rows[0];
m_us.dcID_DU_AN = CIPConvert.ToDecimal(dr["ID"].ToString());
}
}
private void load_data_2_custom_source_ma_du_an()
{
US_DM_DU_AN v_us = new US_DM_DU_AN();
DS_DM_DU_AN v_ds = new DS_DM_DU_AN();
v_us.FillDataset(v_ds);
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
DataRow dr = v_ds.Tables[0].Rows[i];
m_txt_ma_du_an.AutoCompleteCustomSource.Add(dr["MA_DU_AN"].ToString());
}
}
public US_DM_DU_AN(decimal i_dbID)
{
pm_objDS = new DS_DM_DU_AN();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
public US_DM_DU_AN()
{
pm_objDS = new DS_DM_DU_AN();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
