protected override string OnExecute()
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
DataTable dtDetail = null;
try
{
//获取传入参数
var dic = RequestData.FromJson <Dictionary <string, string> >();
string xjjd = dic.ContainsKey("xjjd") ? dic["xjjd"] : "";//序号
string xjwd = dic.ContainsKey("xjwd") ? dic["xjwd"] : "";
string xjguid = dic.ContainsKey("guid") ? dic["guid"] : "";
string xjyh = dic.ContainsKey("xjyh") ? dic["xjyh"] : "";//巡检用户cid
string dateJWD = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (string.IsNullOrEmpty(xjguid))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "巡检返回ID为空";
return(pSpRequestMsg.ToNormalJson());
}
if (string.IsNullOrEmpty(xjjd))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "巡检上报经度坐标为空!";
return(pSpRequestMsg.ToNormalJson());
}
if (string.IsNullOrEmpty(xjwd))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "巡检上报纬度坐标为空!";
return(pSpRequestMsg.ToNormalJson());
}
IUtilService utilService = SpServiceFactory.CreateUtilService();
dtDetail = utilService.QueryInsertJWDData(xjjd, xjwd, xjguid, dateJWD, xjyh);
// pSpRequestMsg.data = dtDetail.ToJson();
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "上报坐标请求异常,详情" + ex.Message;
Log.Error("上报坐标请求异常:" + ex.Message.ToString());
return(pSpRequestMsg.ToNormalJson());
}
return(dtDetail.ToJsonStore(true, dtDetail.Rows.Count));
// return pSpRequestMsg.ToNormalJson();
}
protected override string OnExecute()
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
DataTable dtDetail = null;
string pRequestguid = string.Empty;
HttpContext context = this.SpContext as HttpContext;
string dateStart = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string InspectionGuid = string.Empty;
string sqlSelectguid = "select max(cid) from p_gas_inspection";
DataTable dtGetguid = new DataTable();
dtGetguid = ApplicationManager.DefaultConnection.QueryData(sqlSelectguid).Tables[0];
if (dtGetguid.Rows[0][0].ToString() == "")
{
InspectionGuid = "1";
}
if (dtGetguid.Rows[0][0].ToString() != "")
{
int maxguid = Convert.ToInt32(dtGetguid.Rows[0][0]) + 1;
InspectionGuid = Convert.ToString(maxguid);
}
string xjjd = context.Request["xjjd"] ?? ""; //经度
string xjwd = context.Request["xjwd"] ?? ""; //纬度
string xjdz = context.Request["xjdz"] ?? ""; //巡检地址
string xjyh = context.Request["xjyh"] ?? ""; //巡检用户cid
SpPagingResponse pSpPagingResponse = new SpPagingResponse();
IUtilService service = SpServiceFactory.CreateUtilService();
try
{
dtDetail = service.QueryInspectionData(InspectionGuid, dateStart, xjjd, xjwd, xjdz, xjyh);
pSpRequestMsg.success = true;
pSpRequestMsg.message = "巡检开始成功";
pSpRequestMsg.data = pRequestguid;
pRequestguid = ValueHelper.DataTable2Json(dtDetail);
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "巡检获取异常,详情" + ex.Message;
pSpRequestMsg.data = "";
Log.Error("巡检详情获取异常:" + ex.Message.ToString());
return(pSpRequestMsg.ToNormalJson());
}
return(dtDetail.ToJsonStore(true, dtDetail.Rows.Count));
}
protected override string OnExecute()
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
string pRequestguid = string.Empty;
string pRequestzpwjmc = string.Empty;
var dic = RequestData.FromJson <Dictionary <string, string> >();
pRequestguid = dic.ContainsKey("guid") ? dic["guid"] : "";//序号
pRequestzpwjmc = dic.ContainsKey("image") ? dic["image"] : "";
if (string.IsNullOrEmpty(pRequestguid))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "返回guid为空!";
pSpRequestMsg.data = "";
return(pSpRequestMsg.ToNormalJson());
}
if (string.IsNullOrEmpty(pRequestzpwjmc))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "传入图片为空!";
pSpRequestMsg.data = "";
return(pSpRequestMsg.ToNormalJson());
}
SpPagingResponse pSpPagingResponse = new SpPagingResponse();
IUtilService service = SpServiceFactory.CreateUtilService();
try
{
string NameImg = ValueHelper.ToImage(pRequestzpwjmc);
DataTable dtDetail = service.QueryInsertImage(pRequestguid, NameImg);
pSpRequestMsg.success = true;
pSpRequestMsg.message = "插入图片成功";
pSpRequestMsg.data = dtDetail.ToJson();
pRequestguid = ValueHelper.DataTable2Json(dtDetail);
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "插入信息获取异常,详情" + ex.Message;
pSpRequestMsg.data = "";
Log.Error("插入信息详情获取异常:" + ex.Message.ToString());
}
return(pSpRequestMsg.ToNormalJson());
// return pRequestguid;
}
protected override string OnExecute()
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
SpRequestMsg pSpRequestMsgemail = new SpRequestMsg();
pSpRequestMsg.data = "";
try
{
//获取传入参数
var dic = RequestData.FromJson <Dictionary <string, string> >();
string dlm = dic.ContainsKey("userName") ? dic["userName"] : "";//序号
string mm = dic.ContainsKey("password") ? dic["password"] : "";
string email = dic.ContainsKey("email") ? dic["email"] : "";
string type = dic.ContainsKey("type") ? dic["type"] : "";
string username = dic.ContainsKey("username") ? dic["username"] : "";
string strname = dic.ContainsKey("strName") ? dic["strName"] : "";
string strPassword = dic.ContainsKey("strPassword") ? dic["strPassword"] : "";
string useremail = dic.ContainsKey("useremail") ? dic["useremail"] : "";
IUserService userService = SpServiceFactory.CreateUserService();
if (mm != "")
{
pSpRequestMsg = userService.Login(dlm, mm);
}
if (type == "yx")
{
pSpRequestMsg = userService.Selectedata(email, type);
}
if (type == "dlm")
{
pSpRequestMsg = userService.Selectedata(username, type);
}
if (type == "reg")
{
pSpRequestMsg = userService.RegUser(strname, strPassword, useremail);
}
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "登录请求异常,详情" + ex.Message;
Log.Error("登录请求异常:" + ex.Message.ToString());
return(pSpRequestMsg.ToNormalJson());
}
return(pSpRequestMsg.ToJson());
}
protected override string OnExecute()
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
try
{
//获取传入参数
var dic = RequestData.FromJson <Dictionary <string, string> >();
// string dlm = dic.ContainsKey("UserName") ? dic["UserName"] : "******";//序号
string mm = dic.ContainsKey("oldPassword") ? dic["oldPassword"] : "";
string newmm = dic.ContainsKey("newPassword") ? dic["newPassword"] : "";
string remm = dic.ContainsKey("rePassword") ? dic["rePassword"] : "";
string usercid = dic.ContainsKey("usercid") ? dic["usercid"] : "";
if (string.IsNullOrEmpty(mm))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "原密码不能为空!";
return(pSpRequestMsg.ToNormalJson());
}
if (string.IsNullOrEmpty(newmm))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "新密码不能为空!";
return(pSpRequestMsg.ToNormalJson());
}
if (string.IsNullOrEmpty(remm))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "重复密码不能为空!";
return(pSpRequestMsg.ToNormalJson());
}
IUserService userService = SpServiceFactory.CreateUserService();
pSpRequestMsg = userService.UpdatePassword(usercid, "", mm, newmm, remm);
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "密码输入异常,详情" + ex.Message;
Log.Error("异常:" + ex.Message.ToString());
}
return(pSpRequestMsg.ToNormalJson());
}
protected override string OnExecute()
{
/////////todo
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
try
{
//获取传入参数
var dic = RequestData.FromJson <Dictionary <string, string> >();
string XM = dic.ContainsKey("name") ? dic["name"] : "";
string DH = dic.ContainsKey("phone") ? dic["phone"] : "";
string WX = dic.ContainsKey("weixin") ? dic["weixin"] : "";
string Usercid = dic.ContainsKey("usercid") ? dic["usercid"] : "";
if (string.IsNullOrEmpty(XM))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "真实名字不能为空!";
return(pSpRequestMsg.ToNormalJson());
}
if (string.IsNullOrEmpty(DH))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "电话号码不能为空!";
return(pSpRequestMsg.ToNormalJson());
}
if (string.IsNullOrEmpty(WX))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "微信号不能为空!";
return(pSpRequestMsg.ToNormalJson());
}
IUserService userService = SpServiceFactory.CreateUserService();
pSpRequestMsg = userService.UpdateUser("", XM, DH, WX, Usercid);
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "用户更新请求异常,详情" + ex.Message;
Log.Error("用户更新请求异常:" + ex.Message.ToString());
}
return(pSpRequestMsg.ToNormalJson());
}
protected override string OnExecute()
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
string JsonData = string.Empty;
string tableName = "p_terminal"; //设备表
string fields = "cid,jxh,sbbm,jkfl,sbmc,jd,wd,jdmc,lxdh,ssdw,dwdz,dwlxr"; //返回字段
HttpContext context = this.SpContext as HttpContext;
string cid = context.Request["cid"] ?? "";
if (string.IsNullOrEmpty(cid))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "设备唯一标识不能为空!";
pSpRequestMsg.data = "";
return(pSpRequestMsg.ToNormalJson());
}
string strWhere = string.Format("cid={0}", cid);
ValueHelper.TerminalCid = cid;
SpPagingResponse pSpPagingResponse = new SpPagingResponse();
IUtilService service = SpServiceFactory.CreateUtilService();
DataTable dtDetail = null;
try
{
dtDetail = service.QueryData(fields, tableName, strWhere, cid);
pSpRequestMsg.success = true;
pSpRequestMsg.message = "设备详情获取成功";
pSpRequestMsg.data = JsonData;
JsonData = ValueHelper.DataTable2Json(dtDetail);
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "设备详情获取异常,详情" + ex.Message;
// pSpRequestMsg.data = "";
Log.Error("设备详情获取异常:" + ex.Message.ToString());
return(pSpRequestMsg.ToNormalJson());
}
// return JsonData;//返回json字符串数据
//return pSpRequestMsg.ToNormalJson();
return(dtDetail.ToJsonStore(true, dtDetail.Rows.Count));
}
protected override string OnExecute()
{
HttpContext context = this.SpContext as HttpContext;
try
{
string tableName = "p_terminal"; //设备表
string fields = "cid,sbbm,sbmc,jxh,jd,wd"; //返回字段
string whereClause = context.Request["keyWord"] ?? ""; //where部分
string strPage = context.Request["start"] ?? "1"; //
string strPageSize = context.Request["pageSize"] ?? "15";
string sort = context.Request["sort"] ?? "";
string userName = context.Request["userName"] ?? "";
int page = Convert.ToInt32(strPage);
if (page <= 0)
{
page = 1;
}
if (!string.IsNullOrEmpty(whereClause))
{
whereClause = string.Format("where CONCAT(IFNULL(sbmc,''),' ',IFNULL(sbbm,''),' ',IFNULL(jxh,'')) LIKE '%{0}%'", whereClause);
}
int pageSize = Convert.ToInt32(strPageSize);
SpPagingParam pSpPagingParam = new SpPagingParam()
{
tableName = tableName,
pageSize = pageSize,
page = page,
sort = sort,
whereClause = whereClause,
fields = fields
};
IUtilService utilService = SpServiceFactory.CreateUtilService();
int total = 0;
DataTable dtResult = utilService.QueryPageTable(pSpPagingParam, ref total);
return(this.ToJsonP(dtResult.ToStandardJson(true, total, "分页列表数据")));
}
catch (Exception ex)
{
Log.Error("分页查询异常:" + ex.Message.ToString());
throw ex;
}
}
protected override string OnExecute()
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
SpRequestMsgData pSpRequestMsgdata = new SpRequestMsgData();
DataTable dtDetail = null;
string JsonData = string.Empty;
string tableName = "p_user"; //用户信息
string fields = "xm,dh,wx"; //返回字段
HttpContext context = this.SpContext as HttpContext;
string cid = context.Request["usercid"] ?? "";
// string cid = ValueHelper.pwdcid;
if (string.IsNullOrEmpty(cid))
{
pSpRequestMsgdata.success = false;
pSpRequestMsgdata.message = "唯一标识不能为空!";
pSpRequestMsgdata.Jsondata = "";
return(JsonData);
}
string strWhere = string.Format("cid={0}", cid);
SpPagingResponse pSpPagingResponse = new SpPagingResponse();
IUtilService service = SpServiceFactory.CreateUtilService();
try
{
dtDetail = service.QueryUserData(fields, tableName, strWhere, cid);
pSpRequestMsgdata.success = true;
pSpRequestMsgdata.message = "用户详情获取成功";
JsonData = ValueHelper.DataTable2Json(dtDetail);
pSpRequestMsgdata.Jsondata = JsonData;
}
catch (Exception ex)
{
pSpRequestMsgdata.success = false;
pSpRequestMsgdata.message = "用户详情获取异常,详情" + ex.Message;
pSpRequestMsgdata.Jsondata = "";
Log.Error("用户详情获取异常:" + ex.Message.ToString());
return(pSpRequestMsg.ToNormalJson());
}
// return JsonData;
return(dtDetail.ToJsonStore(true, dtDetail.Rows.Count));
}
protected override string OnExecute()
{
DataTable dtDetail = null;
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
string pRequestguid = string.Empty;
HttpContext context = this.SpContext as HttpContext;
string Inspectguid = context.Request["xjguid"] ?? "";
string xjjd = context.Request["xjjd"] ?? "";
string xjwd = context.Request["xjwd"] ?? "";
string xjdz = context.Request["xjdz"] ?? "";
string xjyh = context.Request["xjyh"] ?? "";//巡检用户cid
string dateStop = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (string.IsNullOrEmpty(Inspectguid))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "返回guid为空!";
pSpRequestMsg.data = "";
return(pSpRequestMsg.ToNormalJson());
}
SpPagingResponse pSpPagingResponse = new SpPagingResponse();
IUtilService service = SpServiceFactory.CreateUtilService();
try
{
dtDetail = service.QueryInsertExitDate(Inspectguid, dateStop, xjjd, xjwd, xjdz, xjyh);
pSpRequestMsg.success = true;
pSpRequestMsg.message = "巡检结束成功";
pSpRequestMsg.data = dtDetail.ToJson();
pRequestguid = ValueHelper.DataTable2Json(dtDetail);
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "巡检获取异常,详情" + ex.Message;
pSpRequestMsg.data = "";
Log.Error("巡检详情获取异常:" + ex.Message.ToString());
return(pSpRequestMsg.ToNormalJson());
}
return(dtDetail.ToJsonStore(true, dtDetail.Rows.Count));
}
/// <summary>
/// </summary>
/// <param name="message">日志内容</param>
/// <param name="subordinateSystem">日志所属系统</param>
/// <param name="logType">日志类型</param>
/// <param name="userCid">用户cid</param>
/// <returns></returns>
public string InsertLogMessage(string message, int subordinateSystem, int logType, string userCid)
{
SpRequestMsg pRequestMsg = new SpRequestMsg();
try
{
string tableName = "p_log";
IUserService service = SpServiceFactory.CreateUserService();
string sqlExists = string.Format("SELECT * FROM p_user WHERE cid ={0}", userCid);
DataTable dt = service.m_AdoDataLoader.QueryData(sqlExists).Tables[0];
string logerName = Convert.ToString(dt.Rows[0]["dlm"]);
string userName = Convert.ToString(dt.Rows[0]["xm"]);
string clientIP = GetIP();
string loginCreateTime = Sp.BaseFrame.Common.Util.Utilitys.GetCurrentTime(); //获取当前时间
DateTime recordTime = Convert.ToDateTime(loginCreateTime);
List <string> listSQL = new List <string>(); //事务语句
string sql = string.Format("insert into {0} (yhcid,dlm,xm,ssxt,rzlx,ipdz,cznr,jlsj) values ('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')",
tableName, userCid, logerName, userName, subordinateSystem, logType, clientIP, message, recordTime);
listSQL.Add(sql);
bool bResult = service.m_AdoDataLoader.ExcuteData(listSQL);
if (bResult)
{
pRequestMsg.success = true;
pRequestMsg.message = "用户日志新增成功！";
}
else
{
pRequestMsg.success = false;
pRequestMsg.message = "用户日志新增失败！";
}
}
catch (Exception ex)
{
Log.Error("添加日志异常，详情：", ex);
pRequestMsg.success = false;
pRequestMsg.message = "添加日志失败！";
}
return(pRequestMsg.ToNormalJson());
}
protected override string OnExecute()
{
//获取传入参数
HttpContext context = this.SpContext as HttpContext;
context.Response.ContentType = "text/html";
Dictionary <string, string> dic = new Dictionary <string, string>();
dic = RequestData.FromJson <Dictionary <string, string> >();
DataTable dtDetail = null;
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
string pRequestguid = string.Empty;
string yhcid = string.Empty;
pRequestguid = dic["guid"] ?? ""; //
string pRequestxjnrjjl = dic["xjnrjjl"] ?? ""; //获取结论上报内容
string datesbsj = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //上报时间
string sqlSelectguid = "select max(cid) from p_gas_inspection_hidden"; //查询出隐患表的最大cid值
DataTable dtGetguid = new DataTable();
dtGetguid = ApplicationManager.DefaultConnection.QueryData(sqlSelectguid).Tables[0];
if (dtGetguid.Rows[0][0].ToString() == "")
{
yhcid = "1";
}
if (dtGetguid.Rows[0][0].ToString() != "")
{
int maxguid = Convert.ToInt32(dtGetguid.Rows[0][0]) + 1;
yhcid = Convert.ToString(maxguid);
}
if (string.IsNullOrEmpty(pRequestguid))
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "返回guid为空!";
pSpRequestMsg.data = "";
return(pSpRequestMsg.ToNormalJson());
}
SpPagingResponse pSpPagingResponse = new SpPagingResponse();
IUtilService service = SpServiceFactory.CreateUtilService();
try
{
SavePicAction savepic = new SavePicAction();
List <string> listImgeName = new List <string>();
listImgeName = savepic.SaveUploadFileList(context, "GasPhoto");
string NameImgs = "";
Log.Info("listImgeName:" + listImgeName.Count);
for (int i = 0; i < listImgeName.Count; i++)
{
if (listImgeName[i].ToString() == "")
{
}
else
{
NameImgs += listImgeName[i].ToString() + ";";
}
}
dtDetail = service.QueryInsertImageList(pRequestguid, NameImgs, pRequestxjnrjjl, datesbsj, yhcid);
pSpRequestMsg.success = true;
pSpRequestMsg.message = "上报信息成功";
pSpRequestMsg.data = dtDetail.ToJson();
pRequestguid = ValueHelper.DataTable2Json(dtDetail);
//Log.Info("结果:上报信息成功");
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "插入信息获取异常,详情" + ex.Message;
pSpRequestMsg.data = "";
Log.Error("插入信息详情获取异常:" + ex.Message.ToString());
return(pSpRequestMsg.ToNormalJson());
}
return(dtDetail.ToJsonStore(true, dtDetail.Rows.Count));
}
