public string get_ma_dat_hang_tiep_theo()
{
string v_output = "";
CStoredProc v_cstore = new CStoredProc("pr_get_ma_don_hang");
SqlParameter v_result = v_cstore.addNVarcharOutputParam("@MA_DON_HANG", v_output);
v_cstore.ExecuteCommand(this);
return(v_result.Value.ToString());
}
public void FillDatasetByID(DS_DM_CHUC_VU op_ds, decimal ip_dc_id, ref string op_str)
{
CStoredProc v_cstore = new CStoredProc("pr_DM_CHUC_VU_filldataset_by_id");
v_cstore.addDecimalInputParam("@ID", ip_dc_id);
SqlParameter v_sql = v_cstore.addNVarcharOutputParam("@TEN", op_str);
v_cstore.fillDataSetByCommand(this, op_ds);
op_str = v_sql.Value.ToString();
}
public void FillDatasetByID(DS_CM_DM_TU_DIEN v_op_ds, decimal ip_dc_id, ref string op_str_ten)
{
CStoredProc v_cstore = new CStoredProc("pr_CM_DM_TU_DIEN_search_by_id");
v_cstore.addDecimalInputParam("@ID", ip_dc_id);
SqlParameter v_sql = v_cstore.addNVarcharOutputParam("@TEN", op_str_ten);
v_cstore.fillDataSetByCommand(this, v_op_ds);
op_str_ten = v_sql.Value.ToString();
}
public string get_ten_nguoi_su_dung(decimal v_id)
{
string v_ten = "";
CStoredProc v_cstore = new CStoredProc("get_ten_nguoi_su_dung");
v_cstore.addNVarcharInputParam("@id", v_id);
SqlParameter v_result = v_cstore.addNVarcharOutputParam("@ten", v_ten);
v_cstore.ExecuteCommand(this);
return((string)v_result.Value);
}
