public HttpResponseMessage GetFindPlayByAddComment(string userid, string comment, string titleid) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { userid = userid == null ? "" : userid; DbCommand cmd = db.GetStoredProcCommond("user_get_GetFindPlayByAddComment"); db.AddInParameter(cmd, "@userid", DbType.String, userid); db.AddInParameter(cmd, "@comment", DbType.String, comment); db.AddInParameter(cmd, "@titleid", DbType.String, titleid); DataTable dt = db.ExecuteDataTable(cmd); flag = true; code = 200; Msg = "操作成功"; String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetFindPlayByAddComment", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public HttpResponseMessage GetFindPlayByCounts(string titleid) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { DbCommand cmd = db.GetStoredProcCommond("user_get_GetFindPlayByCounts"); db.AddInParameter(cmd, "@titleid", DbType.String, titleid); DataTable dt = db.ExecuteDataTable(cmd); int len = dt.Rows.Count; string str = ""; str = "{\"_count\":\"" + dt.Rows[0][0].ToString() + "\",\"_titleid\":\"" + titleid + "\"}"; flag = true; code = 200; Msg = "获取成功"; String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + str.ToString() + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetFindPlay", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + "" + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public HttpResponseMessage DeleteFollows(string userid, string follows) { Boolean flag = false; string Msg = "取消关注失败"; int code = 213; try { userid = userid == null ? "" : userid; DbCommand cmd = db.GetStoredProcCommond("user_delete_Follows"); db.AddInParameter(cmd, "@userid", DbType.String, userid); db.AddInParameter(cmd, "@follows", DbType.String, follows); DataTable dt = db.ExecuteDataTable(cmd); flag = true; code = 200; Msg = "取消关注成功"; String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("DeleteFollows", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public HttpResponseMessage GetCenterByHasRead(string userid) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { userid = userid == null ? "" : userid; DbCommand cmd = db.GetStoredProcCommond("user_get_GetCenterByHasRead"); db.AddInParameter(cmd, "@userid", DbType.String, userid); DataTable dt = db.ExecuteDataTable(cmd); int len = dt.Rows.Count; string str = ""; str += "{\"_total\":\"" + dt.Rows[0]["total"].ToString().Trim() + "\"}"; flag = true; code = 200; Msg = "获取成功"; String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + str.ToString() + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetCenterByMessage()", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + "" + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public HttpResponseMessage DeleteSearchHistory(string userid, string personname) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { userid = userid == null ? "" : userid; DbCommand cmd = db.GetStoredProcCommond("user_delete_ListSearch"); db.AddInParameter(cmd, "@userid", DbType.String, userid); db.AddInParameter(cmd, "@personname", DbType.String, personname); DataTable dt = db.ExecuteDataTable(cmd); flag = true; code = 200; Msg = "删除成功"; String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("SaveSearchHistory(string userid, string personid)", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public HttpResponseMessage InsertRealm(dynamic para) { var le = EFClass.GetEF(); int type = Convert.ToInt32(para.type); if (type == 1) { String RealmDes = Convert.ToString(para.RealmDes); long Sequence = Convert.ToInt64(para.Sequence); String Uri = Convert.ToString(para.Uri); //String ParentID = Convert.ToString(para.ParentID); String AppID = Guid.NewGuid().ToString(); String Security = Guid.NewGuid().ToString(); Realms r = new Realms(); r.RealmID = Guid.NewGuid().ToString(); r.RealmDes = RealmDes; r.Uri = Uri; r.AppID = AppID; r.Sequence = Sequence; r.Security = Security; r.CreatedDate = DateTime.Now; le.Realms.Add(r); return(ToJson.toJson(le.SaveChanges())); } else if (type == 2) { Thread.Sleep(2000); String RealmID = Convert.ToString(para.id); var r = le.Realms.Where(p => p.RealmID == RealmID).FirstOrDefault(); r.Forzen = 1; return(ToJson.toJson(le.SaveChanges())); } return(ToJson.toJson("")); }
public void ItConvertsXmlText() { var text = new XmlText("lorem & ipsum"); var json = ToJson.Convert(text).Stringify(); Assert.AreEqual("\"lorem & ipsum\"", json); }
public HttpResponseMessage GetCenterByClearMessage(string userid) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { userid = userid == null ? "" : userid; DbCommand cmd = db.GetStoredProcCommond("user_delete_UserMessage"); db.AddInParameter(cmd, "@userid", DbType.String, userid); db.ExecuteNonQuery(cmd); flag = true; code = 200; Msg = "操作成功"; String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetCenterByClearMessage()", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public HttpResponseMessage GetFindStarByPersonid(string personid, string userid) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { userid = userid == null ? "" : userid; DbCommand cmd = db.GetStoredProcCommond("user_get_GetFindStarByPersonid"); db.AddInParameter(cmd, "@personid", DbType.String, personid); db.AddInParameter(cmd, "@userid", DbType.String, userid); DataTable dt = db.ExecuteDataTable(cmd); int len = dt.Rows.Count; string str = ""; if (len > 0) { for (int i = 0; i < len; i++) { str += "{\"_personid\":\"" + dt.Rows[i]["personid"].ToString().Trim() + "\",\"_CName\":\"" + dt.Rows[i]["CName"].ToString().Trim() + "\",\"_Gender\":\"" + dt.Rows[i]["Gender"].ToString().Trim() + "\",\"_School\":\"" + dt.Rows[i]["School"].ToString().Trim() + "\",\"_Company\":\"" + dt.Rows[i]["Company"].ToString().Trim() + "\",\"_Height\":\"" + dt.Rows[i]["Height"].ToString().Trim() + "\",\"_RMD\":\"" + dt.Rows[i]["媒体曝光"].ToString().Trim() + "\",\"_rating\":\"" + dt.Rows[i]["人气"].ToString().Trim() + "\",\"_RMOVIE\":\"" + dt.Rows[i]["电影"].ToString().Trim() + "\",\"_RTV\":\"" + dt.Rows[i]["传统媒体"].ToString().Trim() + "\",\"_RF\":\"" + dt.Rows[i]["网络视频指数"].ToString().Trim() + "\",\"_path\":\"" + System.Web.HttpUtility.UrlEncode(dt.Rows[i]["Img_Path"].ToString().Trim()) + "\",\"_Birthday\":\"" + dt.Rows[i]["Birthday"].ToString().Trim().Trim() + "\",\"_flag\":\"" + dt.Rows[i]["是否关注"].ToString().Trim() + "\"}"; } flag = true; code = 200; Msg = "获取成功"; } else { flag = true; code = 202; Msg = "没有查询到数据"; } String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + str.ToString() + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetFindStarByPersonid(string personid, string userid)", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + "" + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public JsonResult GetPressureMeterByAreaUid(Guid areaUid) { JsonResult result = new JsonResult(); result.JsonRequestBehavior = JsonRequestBehavior.AllowGet; //Func<List<FlowMeterStatusAndArea>> fmAndStatusArea = () => flowmeterService.GetFlowMeterStatusByArea(areaUid); //List<FlowMeterStatusAndArea> fmstatusAndAreaList = DBHelper.get<FlowMeterStatusAndArea>(fmAndStatusArea, // ConfigurationManager.AppSettings["FlowMeterStatusByAreaUid"] + areaUid); Func <List <PressureMeterStatusAndArea> > pmAndStatusArea = () => pressuremeterService.GetPressureMeterStatusByArea(areaUid); List <PressureMeterStatusAndArea> pmstatusAndAreaList = DBHelper.get <PressureMeterStatusAndArea>(pmAndStatusArea, ConfigurationManager.AppSettings["PressureMeterStatusByAreaUid"] + areaUid).ToList(); User_t account = UserContext.account; List <PressureMeterStatusAndArea> pms_areas = new List <PressureMeterStatusAndArea>(); List <PressureMeterStatusAndArea> pms_areas_order = new List <PressureMeterStatusAndArea>(); if (account.Usr_Type != 3) { List <Area_t> subarealist = areaService.GetSubArea(areaUid); foreach (var item in subarealist) { Func <List <PressureMeterStatusAndArea> > pmsaFunc = () => pressuremeterService.GetPressureMeterStatusByArea(areaUid); var pmsalist = DBHelper.get <PressureMeterStatusAndArea>(pmsaFunc, ConfigurationManager.AppSettings["PressureMeterStatusByAreaUid"] + areaUid).ToList(); pms_areas.AddRange(pmsalist); } //获取设备访问次数,根据访问次数排序,再将剩余的设备整合 Func <List <VisitCount> > initvisit = () => { return(new List <VisitCount>()); }; List <VisitCount> vclist = DBHelper.getWithNoExpire <List <VisitCount> >(initvisit, UserContext.account.Usr_UId + ConfigurationManager.AppSettings["VisitPressureMeterCount"]); vclist = vclist.OrderByDescending(p => p.count).ToList(); foreach (var item in vclist) { var data = pms_areas.Where(p => p.pressuremeter.PM_UId == Guid.Parse(item.uid)).FirstOrDefault(); if (data != null) { pms_areas_order.Add(data); } } foreach (var item in pms_areas) { if (vclist.Where(p => p.uid == item.pressuremeter.PM_UId.ToString()).Count() == 0) { pms_areas_order.Add(item); } } } //result.Data = pmstatusAndAreaList; string dataresult = ToJson <List <PressureMeterStatusAndArea> > .Obj2Json <List <PressureMeterStatusAndArea> >(pms_areas_order).Replace("\\\\", ""); dataresult = dataresult.Replace("\\\\", ""); result.Data = dataresult; return(result); }
public HttpResponseMessage GetFindStarByWork(string personid, string type, int pagesize, int pageindex) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { DbCommand cmd = db.GetStoredProcCommond("user_get_GetFindStarByWork"); db.AddInParameter(cmd, "@personid", DbType.String, personid); db.AddInParameter(cmd, "@type", DbType.String, type); db.AddInParameter(cmd, "@pagesize", DbType.Int32, pagesize); db.AddInParameter(cmd, "@pageindex", DbType.Int32, pageindex); DataTable dt = db.ExecuteDataTable(cmd); int len = dt.Rows.Count; string str = ""; if (len > 0) { for (int i = 0; i < len; i++) { str += "{\"_personid\":\"" + dt.Rows[i]["personid"].ToString().Trim() + "\",\"_CName\":\"" + dt.Rows[i]["CName"].ToString().Trim() + "\",\"_Gender\":\"" + dt.Rows[i]["Gender"].ToString().Trim() + "\",\"_rolerank\":\"" + dt.Rows[i]["rolerank"].ToString().Trim() + "\",\"_workname\":\"" + dt.Rows[i]["workname"].ToString().Trim() + "\",\"_onair\":\"" + dt.Rows[i]["onair"].ToString().Trim() + "\",\"_gross\":\"" + dt.Rows[i]["gross"].ToString().Trim() + "\",\"_dy\":\"" + dt.Rows[i]["dy"].ToString().Trim() + "\",\"_zy\":\"" + dt.Rows[i]["zy"].ToString().Trim() + "\",\"_worktype\":\"" + dt.Rows[i]["worktype"].ToString().Trim() + "\",\"_type\":\"" + dt.Rows[i]["type"].ToString().Trim() + "\",\"_path\":\"" + System.Web.HttpUtility.UrlEncode(dt.Rows[i]["Img_Path"].ToString().Trim()) + "\"},"; } str = str.Substring(0, str.Length - 1); flag = true; code = 200; Msg = "获取成功"; } else { flag = true; code = 202; Msg = "没有查询到数据"; } String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + str.ToString() + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetFindStarByWork(string personid, string type, int pagesize, int pageindex)", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + "" + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public HttpResponseMessage GetDicRegionList(int page, int limit) { var le = EFClass.GetEF(); var list = le.Dic_Regions.OrderBy(p => p.UpdatedDate).Skip((page - 1) * limit).Take(limit).ToList(); object o = new { code = 0, msg = "", count = list.Count, data = list }; return(ToJson.toJson(o)); }
public ActionResult Find(string ID) { var di = new ToJson().GetDictionary(new Dictionary <string, object>() { { "status", 1 } }); return(Json(di, JsonRequestBehavior.DenyGet)); }
public HttpResponseMessage GetListByRenqi(string type, string gender, string orderby, int pagesize, int pageindex) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { DbCommand cmd = db.GetStoredProcCommond("user_get_GetListByRenqi"); db.AddInParameter(cmd, "@type", DbType.String, type); db.AddInParameter(cmd, "@gender", DbType.String, gender); db.AddInParameter(cmd, "@orderby", DbType.String, orderby); db.AddInParameter(cmd, "@pagesize", DbType.Int32, pagesize); db.AddInParameter(cmd, "@pageindex", DbType.Int32, pageindex); DataTable dt = db.ExecuteDataTable(cmd); int len = dt.Rows.Count; string str = ""; if (len > 0) { for (int i = 0; i < len; i++) { str += "{\"_personid\":\"" + dt.Rows[i]["personid"].ToString().Trim() + "\",\"_CName\":\"" + dt.Rows[i]["姓名"].ToString().Trim() + "\",\"_Gender\":\"" + dt.Rows[i]["性别"].ToString().Trim() + "\",\"_duration\":\"" + dt.Rows[i]["时间粒度"].ToString().Trim() + "\",\"_idx\":\"" + dt.Rows[i]["人气值"].ToString().Trim() + "\",\"_rating\":\"" + dt.Rows[i]["人气指数"].ToString().Trim() + "\",\"_SR\":\"" + dt.Rows[i]["指数变化"].ToString().Trim() + "\",\"_path\":\"" + System.Web.HttpUtility.UrlEncode(dt.Rows[i]["头像路径"].ToString().Trim()) + "\"},"; } str = str.Substring(0, str.Length - 1); flag = true; code = 200; Msg = "获取成功"; } else { flag = true; code = 202; Msg = "没有查询到数据"; } String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + str.ToString() + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetListByRenqi", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + "" + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public HttpResponseMessage GetChooseByTitle(string userid, string title) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { userid = userid == null ? "" : userid; DbCommand cmd = db.GetStoredProcCommond("user_get_GetChooseByTitle"); db.AddInParameter(cmd, "@userid", DbType.String, userid); db.AddInParameter(cmd, "@title", DbType.String, title); DataTable dt = db.ExecuteDataTable(cmd); int len = dt.Rows.Count; string str = ""; if (len > 0) { for (int i = 0; i < len; i++) { str += "{\"_ID\":\"" + dt.Rows[i]["ID"].ToString().Trim() + "\",\"_Title\":\"" + dt.Rows[i]["Title"].ToString().Trim() + "\",\"_StartYear\":\"" + dt.Rows[i]["StartYear"].ToString().Trim() + "\",\"_EndYear\":\"" + dt.Rows[i]["EndYear"].ToString().Trim() + "\",\"_Field\":\"" + dt.Rows[i]["Field"].ToString().Trim() + "\",\"_Lv\":\"" + dt.Rows[i]["Lv"].ToString().Trim() + "\",\"_Gender\":\"" + dt.Rows[i]["Gender"].ToString().Trim() + "\",\"_Country\":\"" + dt.Rows[i]["Country"].ToString().Trim() + "\",\"_Theme\":\"" + dt.Rows[i]["Theme"].ToString().Trim() + "\"},"; } str = str.Substring(0, str.Length - 1); flag = true; code = 200; Msg = "获取成功"; } else { flag = true; code = 202; Msg = "没有查询到数据"; } String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + str.ToString() + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetChooseByTitle(string type, string gender, string orderby, int pagesize, int pageindex)", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + "" + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
/// <summary> /// 输出昨日流量变化幅度从大到小排行的流量计列表 /// </summary> /// <returns></returns> public JsonResult GetLastDayFlowList() { JsonResult result = new JsonResult(); result.JsonRequestBehavior = JsonRequestBehavior.AllowGet; List <FlowMeterData> fmdata_account = new List <FlowMeterData>(); User_t account = UserContext.account; List <FlowMeter_t> fmlist = new List <FlowMeter_t>(); if (account.Usr_Type == 3) { fmlist = flowmeter_Service.GetFlowMetersByUserUid(account.Usr_UId); } else { fmlist = flowmeter_Service.GetAllFlowMeter(); } List <FlowMeterData> fmdatalist = new List <FlowMeterData>(); foreach (var item in fmlist) { if (item.FM_FlowCountLast != null) { Func <FlowMeterData> fmdataFunc = () => flowmeter_Service.GetAnalysisByFlowMeter(item, (DateTime)item.FM_FlowCountLast); var fmdata = DBHelper.getT <FlowMeterData>(fmdataFunc, ConfigurationManager.AppSettings["FlowMeterAnalysisByFMUid"] + item.FM_UId); fmdatalist.Add(fmdata); } } //先剔除“无法计算”的昨日流量比例,按大小排序,再补上“无法计算” var fmdatatemp1 = fmdatalist.Where(p => p.lastday_flow_proportion != "无法计算").ToList(); if (fmdatatemp1.Count >= 0 && fmdatatemp1.Count < 3) { fmdatalist.AddRange(fmdatatemp1); var fmdatatemp2 = fmdatalist.Where(p => p.lastday_flow_proportion == "无法计算").ToList(); if (fmdatatemp2.Count > 0) { fmdata_account.AddRange(fmdatatemp2); fmdata_account = fmdata_account.Take(3).ToList(); } } else if (fmdatatemp1.Count >= 3) { fmdata_account = fmdatatemp1.OrderByDescending(p => p.lastday_flow_proportion).Take(3).ToList(); } string dataresult = ToJson <List <FlowMeterData> > .Obj2Json <List <FlowMeterData> >(fmdata_account).Replace("\\\\", ""); dataresult = dataresult.Replace("\\\\", ""); result.Data = dataresult; return(result); }
public HttpResponseMessage GetFindPlay(string type) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { DbCommand cmd = db.GetStoredProcCommond("user_get_GetFindPlay"); db.AddInParameter(cmd, "@type", DbType.String, type); DataTable dt = db.ExecuteDataTable(cmd); int len = dt.Rows.Count; string str = ""; if (len > 0) { for (int i = 0; i < len; i++) { string _FMpath = dt.Rows[i]["CoverImg_Path"].ToString().Trim(); if (!string.IsNullOrEmpty(_FMpath)) { if (_FMpath.Substring(0, 1) == "~") { _FMpath = _FMpath.Replace("~", ""); } _FMpath = ManagerPath + System.Web.HttpUtility.UrlEncode(_FMpath); } str += "{\"_titleid\":\"" + dt.Rows[i]["Title_ID"].ToString().Trim() + "\",\"_FMpath\":\"" + _FMpath + "\"},"; } str = str.Substring(0, str.Length - 1); flag = true; code = 200; Msg = "获取成功"; } else { flag = true; code = 202; Msg = "没有查询到数据"; } String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + str.ToString() + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetFindPlay", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + "" + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public HttpResponseMessage GetFindStarByPic(string personid, int pagesize, int pageindex) { Boolean flag = false; string Msg = "方法异常"; int code = 205; Common com = new Common(); try { DbCommand cmd = db.GetStoredProcCommond("user_get_GetFindStarByPic"); db.AddInParameter(cmd, "@personid", DbType.String, personid); db.AddInParameter(cmd, "@pagesize", DbType.Int32, pagesize); db.AddInParameter(cmd, "@pageindex", DbType.Int32, pageindex); DataTable dt = db.ExecuteDataTable(cmd); int len = dt.Rows.Count; string str = ""; if (len > 0) { for (int i = 0; i < len; i++) { string _url = dt.Rows[i]["url"].ToString().Trim(); string widthandheight = com.GetWidthAndHeight(_url); string width = widthandheight.Split('-')[0]; string height = widthandheight.Split('-')[1]; str += "{\"_personid\":\"" + dt.Rows[i]["personid"].ToString().Trim() + "\",\"_url\":\"" + System.Web.HttpUtility.UrlEncode(_url) + "\",\"_width\":\"" + width + "\",\"_height\":\"" + height + "\"},"; } str = str.Substring(0, str.Length - 1); flag = true; code = 200; Msg = "获取成功"; } else { flag = true; code = 202; Msg = "没有查询到数据"; } String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + str.ToString() + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetFindStarByPic(string personid, int pagesize, int pageindex)", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + "" + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
/// <summary> /// 执行sql返回json /// </summary> /// <param name="sql">执行的sql语句</param> /// <param name="type">执行类型</param> /// <returns>返回json</returns> public string Json(string sql, CommandType type) { string s = string.Empty; using (DbDataReader dr = ExecuteReader(sql, type)) { s = ToJson.DataReaderToJson(dr); } Close(); return(s); }
/// <summary> /// 获取实体 /// </summary> /// <param name="ID"></param> /// <returns></returns> public Dictionary <string, object> Find(Guid ID) { troles = db.Find <T_Roles>(f => f.uRoles_ID == Tools.getGuid(ID)); var di = new ToJson().GetDictionary(new Dictionary <string, object>() { { "troles", troles }, { "status", 1 } }); return(di); }
/// <summary> /// 获取实体 /// </summary> /// <param name="ID"></param> /// <returns></returns> public Dictionary <string, object> Find(Guid ID) { tf = db.Find <T_Function>(w => w.uFunction_ID == ID.To_Guid()); var di = new ToJson().GetDictionary(new Dictionary <string, object>() { { "tf", tf }, { "status", 1 } }); return(di); }
public void FullTest() { var service = new FakeOrganizationService(); var context = new FakeWorkflowContext(); var setValueAction = new SetValue(); var invoker = new WorkflowInvoker(setValueAction); invoker.Extensions.Add <ITracingService>(() => new FakeTracingService()); invoker.Extensions.Add <IWorkflowContext>(() => context); invoker.Extensions.Add <IOrganizationServiceFactory>(() => new FakeOrganizationServiceFactory(service)); invoker.Invoke(new Dictionary <string, object> { { "DatasetName", "MySet" }, { "VariableName", "MySimpleValue" }, { "VariableValue", "123" } }); invoker.Invoke(new Dictionary <string, object> { { "DatasetName", "MySet" }, { "VariableName", "MyComplexNode.MyComplexValue" }, { "VariableValue", "Value 1" } }); invoker.Invoke(new Dictionary <string, object> { { "DatasetName", "MySet" }, { "VariableName", "MyComplexNode.MyOtherComplexValue" }, { "VariableValue", "Value 2" } }); var toJsonAction = new ToJson(); invoker = new WorkflowInvoker(toJsonAction); invoker.Extensions.Add <ITracingService>(() => new FakeTracingService()); invoker.Extensions.Add <IWorkflowContext>(() => context); invoker.Extensions.Add <IOrganizationServiceFactory>(() => new FakeOrganizationServiceFactory(service)); var result = invoker.Invoke(new Dictionary <string, object> { { "DatasetName", "MySet" } }); Assert.AreEqual(false, result["HasError"]); Assert.IsNull(result["ErrorMessage"]); var json = result["JsonString"].ToString(); var obj = JsonConvert.DeserializeObject <Dictionary <string, object> >(json); Assert.AreEqual("123", obj["MySimpleValue"]); var complex = ((Newtonsoft.Json.Linq.JObject)obj["MyComplexNode"]).ToObject <Dictionary <string, object> >(); Assert.AreEqual("Value 1", complex["MyComplexValue"]); Assert.AreEqual("Value 2", complex["MyOtherComplexValue"]); }
/// <summary> /// 执行存储过程返回json /// </summary> /// <param name="proc">存储过程</param> /// <returns>返回json</returns> public string Json(Proc proc) { string s = string.Empty; using (DbDataReader dr = ExecuteReader(proc)) { s = ToJson.DataReaderToJson(dr); } Close(); return(s); }
public HttpResponseMessage Register(string username, string password, string email, string rancode) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { string newpassword = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(password, "MD5"); DbCommand cmd = db.GetStoredProcCommond("user_register_User"); db.AddInParameter(cmd, "@username", DbType.String, username); db.AddInParameter(cmd, "@password", DbType.String, newpassword); db.AddInParameter(cmd, "@email", DbType.String, email); db.AddInParameter(cmd, "@rancode", DbType.String, rancode); DataTable dt = db.ExecuteDataTable(cmd); flag = true; Msg = dt.Rows[0][0].ToString(); string str = ""; if (dt.Rows[0][0].ToString() == "用户邮箱已存在") { code = 204; } else if (dt.Rows[0][0].ToString() == "用户名已存在") { code = 210; } else if (dt.Rows[0][0].ToString() == "用户名、邮箱已存在") { code = 215; } else if (dt.Rows[0][0].ToString() == "验证码错误") { code = 216; } else if (dt.Rows[0][0].ToString() == "注册成功") { code = 200; str += "{\"_userid\":\"" + dt.Rows[0]["newid"].ToString() + "\"}"; } String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + str + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("Register(string username, string password, string email)", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + "" + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public static string GetStrJson(string strWhere, string orderby, int startIndex, int endIndex) //static有无 { DAL.DALServer dll = new DAL.DALServer(); //C#非静态的字段要求对象引用 DataSet ds = dll.GetListByPage(strWhere, orderby, startIndex, endIndex); int count = dll.GetRecordCount(strWhere); string strJson = ToJson.Dataset2Json(ds, count); return(strJson); //throw new NotImplementedException(); }
public HttpResponseMessage SaveChooseBySearch(string userid, string title, int startyear, int endyear, string field, string lv, string gender, string country, string theme, string orderby) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { startyear = startyear >= 0 ? startyear : 0; endyear = endyear >= 0 ? endyear : 100; field = field == null ? "" : field; lv = lv == null ? "" : lv; gender = gender == null ? "" : gender; country = country == null ? "" : country; theme = theme == null ? "" : theme; orderby = orderby == null ? "zh" : orderby; DbCommand cmd = db.GetStoredProcCommond("user_save_ChooseBySearch"); db.AddInParameter(cmd, "@userid", DbType.String, userid); db.AddInParameter(cmd, "@title", DbType.String, title); db.AddInParameter(cmd, "@startyear", DbType.Int32, startyear); db.AddInParameter(cmd, "@endyear", DbType.Int32, endyear); db.AddInParameter(cmd, "@field", DbType.String, field); db.AddInParameter(cmd, "@lv", DbType.String, lv); db.AddInParameter(cmd, "@gender", DbType.String, gender); db.AddInParameter(cmd, "@country", DbType.String, country); db.AddInParameter(cmd, "@theme", DbType.String, theme); db.AddInParameter(cmd, "@orderby", DbType.String, orderby); DataTable dt = db.ExecuteDataTable(cmd); Msg = dt.Rows[0][0].ToString(); if (Msg == "标题已存在") { flag = true; code = 221; } else { flag = true; code = 200; } String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("SaveChooseBySearch", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }
public void ItConvertsXmlNonPairElement() { var element = new XmlElement("foo", false); element.Attributes.Add(new XmlAttribute("lorem", new XmlText("ipsum"))); var json = ToJson.Convert(element).Stringify(); Assert.AreEqual( @"{""tag"": ""foo"", ""attributes"": {""lorem"": ""ipsum""}, ""pair"": false, ""content"": []}", json ); }
public HttpResponseMessage UpdateRoles(dynamic ro) { var le = EFClass.GetEF(); String rn = Convert.ToString(ro.rolename); String rd = Convert.ToString(ro.roledes); String rid = Convert.ToString(ro.roleid); var roled = le.Roles.Where(p => p.RoleID == rid).FirstOrDefault(); roled.RoleName = rn; roled.RoleDes = rd; return(ToJson.toJson(le.SaveChanges())); }
protected void GetList_Cancel() { LEANJU.BLL.Orders bll = new LEANJU.BLL.Orders(); int pagesize = int.Parse(Request.Form["rows"].ToString().Trim()); int pageindex = int.Parse(Request.Form["page"].ToString().Trim()); DataGridData dgd = new DataGridData(); dgd.total = bll.GetRecordCount("Ostate='已取消'"); dgd.rows = bll.GetListByPage("Ostate='已取消'", "", (pageindex - 1) * pagesize + 1, pageindex * pagesize); WriteMessage("", ToJson.Dataset2Json(dgd.rows, dgd.total)); }
public HttpResponseMessage GetCenterByMessage(string userid, int pagesize, int pageindex) { Boolean flag = false; string Msg = "方法异常"; int code = 205; try { userid = userid == null ? "" : userid; DbCommand cmd = db.GetStoredProcCommond("user_get_GetCenterByMessage"); db.AddInParameter(cmd, "@userid", DbType.String, userid); db.AddInParameter(cmd, "@pagesize", DbType.Int32, pagesize); db.AddInParameter(cmd, "@pageindex", DbType.Int32, pageindex); DataTable dt = db.ExecuteDataTable(cmd); int len = dt.Rows.Count; string str = ""; if (len > 0) { for (int i = 0; i < len; i++) { str += "{\"_ID\":\"" + dt.Rows[i]["ID"].ToString().Trim() + "\",\"_Title\":\"" + dt.Rows[i]["Title"].ToString().Trim() + "\",\"_Context\":\"" + dt.Rows[i]["Context"].ToString().Trim() + "\",\"_Readed\":\"" + dt.Rows[i]["Readed"].ToString().Trim() + "\",\"_DeleteFlag\":\"" + dt.Rows[i]["DeleteFlag"].ToString().Trim() + "\"},"; } str = str.Substring(0, str.Length - 1); flag = true; code = 200; Msg = "获取成功"; } else { flag = true; code = 202; Msg = "没有查询到数据"; } String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + str.ToString() + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } catch (Exception ex) { logger.WriteLogFile("GetCenterByMessage()", ex.Message.ToString()); String returnString = "{\"Success\":\"" + flag.ToString() + "\",\"Msg\":\"" + Msg.ToString() + "\", \"Data\":[" + "" + "],\"Code\":" + code + "}"; String decryptStr = aes.Encrypt(returnString); String ret = "{\"data\":\"" + decryptStr + "\"}"; return(ToJson.toJson(ret.ToString())); } }