private async void doSearchTiXing(string strUrl, string strJsonPar) { try { List <TiXingEntity> listTiXing = new List <TiXingEntity>(); var stringContent = new StringContent(strJsonPar, Encoding.UTF8, "application/json"); var response = await client.PostAsync(strUrl, stringContent); if (response.IsSuccessStatusCode) { string strJsonRtn = response.Content.ReadAsStringAsync().Result; ReturnResultEntity <List <TiXingEntity> > returnResultEntity = JsonHelper.FromJson <ReturnResultEntity <List <TiXingEntity> > >(strJsonRtn); if (returnResultEntity != null) { if (returnResultEntity.success) { listTiXing = returnResultEntity.data; } else { MessageBox.Show("查询失败," + returnResultEntity.errorMsg); } } } else { MessageBox.Show("Post查询全部题型失败,调用WebApi出错了"); } TiXingEntity tiXingRoot = new TiXingEntity(); tiXingRoot.tiXingName = "全部"; tiXingRoot.tiXingValue = "全部"; listTiXing.Insert(0, tiXingRoot); cmbTiXing.DataSource = listTiXing; cmbTiXing.DisplayMember = "tiXingName"; cmbTiXing.ValueMember = "tiXingValue"; } catch (Exception ex) { MessageBox.Show("查询全部题型异常," + ex.Message); } }
public ReturnResultEntity <List <TiXingEntity> > GetAllTiXing(ShiTiSearchEntity shiTiSearchEntity) { ReturnResultEntity <List <TiXingEntity> > returnMessageEntity = new ReturnResultEntity <List <TiXingEntity> >(); if (shiTiSearchEntity == null) { returnMessageEntity.success = false; returnMessageEntity.errorMsg = "传入参数为null"; return(returnMessageEntity); } try { List <TiXingEntity> listTiXing = new List <TiXingEntity>(); string strSql = string.Format("select distinct ti_xing from shi_ti where shi_juan_id={0}", shiTiSearchEntity.shiJuanId); DataTable dtTiXing = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteTable(strSql); if (dtTiXing != null && dtTiXing.Rows.Count > 0) { foreach (DataRow dr in dtTiXing.Rows) { string tiXing = dr["ti_xing"] == DBNull.Value ? string.Empty : dr["ti_xing"].ToString(); if (string.IsNullOrEmpty(tiXing)) { continue; } TiXingEntity tiXingEntity = new TiXingEntity(); tiXingEntity.tiXingName = tiXing; tiXingEntity.tiXingValue = tiXing; listTiXing.Add(tiXingEntity); } } returnMessageEntity.success = true; returnMessageEntity.data = listTiXing; return(returnMessageEntity); }catch (Exception ex) { returnMessageEntity.success = false; returnMessageEntity.errorMsg = "获取题型失败," + ex.Message; return(returnMessageEntity); } }