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()));
}
}
