private void GetCFXQ(HttpContext context) { string bsm = context.Request["BSM"]; ReturnObject ro = new ReturnObject(); try { //使用可能有多个 string sqlSYQK = string.Format(@"select * from cf_syqk t where sscfdm='{0}'", bsm); //闲置只有一个 string sqlXZQK = string.Format(@"select * from cf_xzqk t where sscfdm='{0}'", bsm); //配套设置只有一个 string sqlPTSS = string.Format(@"select t2.* from cf t1 left join cf_ptss t2 on t1.sscqdm=t2.bsm where t1.bsm='{0}' ", bsm); DataTable dtSYQK = DBContext.Instance.ExecuteQuery(sqlSYQK); DataTable dtXZQK = DBContext.Instance.ExecuteQuery(sqlXZQK); DataTable dtPTSS = DBContext.Instance.ExecuteQuery(sqlPTSS); ro.AddData("SYQK", dtSYQK); ro.AddData("XZQK", EntityUtilities.DataTableToDict(dtXZQK)); ro.AddData("PTSS", EntityUtilities.DataTableToDict(dtPTSS)); } catch (System.Exception ex) { ro = new ReturnObject(ex.Message); } string rt = Newtonsoft.Json.JsonConvert.SerializeObject(ro); this.ResponseResult(rt); }
/// <summary> /// 将DataTable的第一行转换为 Dictionary。如果第一行为空,则返回空 Dictionary。 /// </summary> /// <param name="dt"></param> /// <returns></returns> public static Dictionary <string, object> DataTableToDict(DataTable dt) { return(EntityUtilities.DataRowToDict(dt == null ? null : (dt.Rows.Count > 0 ? dt.Rows[0] : null))); }