Exemple #1
0
        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);
            }
        }