/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="usercid">所属部门</param>
/// <param name="department">所属部门</param>
/// <param name="name">真实姓名</param>
/// <param name="phone">联系电话</param>
/// <param name="weixin">微信号</param>
/// <returns>返回类</returns>
public SpRequestMsg UpdateUser(string department, string name, string phone, string weixin, string usercid)
{
//TODO
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
ISPService service = SpServiceFactory.CreateServiceBase();
try
{
string Uname = "UPDATE p_user SET xm = '" + name + "' WHERE cid = " + usercid + "";
string Uphone = "UPDATE p_user SET dh = " + phone + " WHERE cid = " + usercid + "";
string Uweixin = "UPDATE p_user SET wx = " + weixin + " WHERE cid = " + usercid + "";
ApplicationManager.DefaultConnection.ExcuteData(Uname);
ApplicationManager.DefaultConnection.ExcuteData(Uphone);
ApplicationManager.DefaultConnection.ExcuteData(Uweixin);
pSpRequestMsg.success = true;
pSpRequestMsg.message = "信息修改成功！";
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "信息修改请求异常,详情" + ex.Message;
}
return(pSpRequestMsg);
}
/// <summary>
/// </summary>
/// <param name="data">查询的数据</param>
/// <param name="type">查询的数据</param>
/// <returns></returns>
public SpRequestMsg Selectedata(string data, string type)
{
//TODO
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
try {
MySqlParameter[] parameters = { new MySqlParameter("?data", data) };
//判断用户是否存在
DataTable dtExist = ApplicationManager.DefaultConnection.QueryData("select cid from p_user where " + type + "=?data", parameters, 0).Tables[0];
if (dtExist.Rows[0][0].ToString() != "")
{
pSpRequestMsg.success = false;
if (type == "yx")
{
pSpRequestMsg.message = "该邮箱已注册，请重新输入！";
}
if (type == "dlm")
{
pSpRequestMsg.message = "该名称已注册，请重新输入！";
}
}
else
{
pSpRequestMsg.success = true;
if (type == "yx")
{
pSpRequestMsg.message = "邮箱可用！";
}
if (type == "dlm")
{
pSpRequestMsg.message = "用户名可用！";
}
}
}
catch (Exception ex)
{
pSpRequestMsg.success = true;
if (type == "yx")
{
pSpRequestMsg.message = "邮箱可用！";
}
if (type == "dlm")
{
pSpRequestMsg.message = "用户名可用！";
}
}
return(pSpRequestMsg);
}
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()
{
/////////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();
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()
{
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()
{
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="name">注册用户数据</param>
/// <param name="pwd">注册用户数据</param>
/// <param name="email">注册用户数据</param>
/// <returns></returns>
public SpRequestMsg RegUser(string name, string pwd, string email)
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
try {
string NewPwd = Sp.BaseFrame.Common.Util.AESEncryptionUtils.Encrypt(pwd);//加密新添加密码
string sqlInsert = string.Format("insert into p_user (dlm,mm,yx) values ('{0}','{1}','{2}')", name, NewPwd, email);
ApplicationManager.DefaultConnection.ExcuteData(sqlInsert);
pSpRequestMsg.success = true;
pSpRequestMsg.message = "注册用户成功！";
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "注册用户请求异常,详情" + ex.Message;
}
return(pSpRequestMsg);
}
/// <summary>
/// 查询用户信息数据
/// </summary>
/// <param name="tableName"></param>
/// <param name="fields"></param>
/// <param name="where"></param>
/// <param name="usercid"></param>
/// <returns></returns>
DataTable IUtilService.QueryUserData(string fields, string tableName, string where, string usercid)
{
try{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
DataTable dtResult = new DataTable();
DataTable dtResultcid = new DataTable();
DataTable dtbmcid = new DataTable();
string strSql = string.Empty;
string sqlwhere = "SELECT bmcid FROM p_relation WHERE yhcid = " + usercid + "";
if (string.IsNullOrEmpty(where))
{
strSql = string.Format("SELECT {0} FROM {1}", fields, tableName);
}
else
{
strSql = string.Format("SELECT {0} FROM {1} WHERE {2}", fields, tableName, where);
}
dtResultcid = ApplicationManager.DefaultConnection.QueryData(sqlwhere).Tables[0];//得到的部门cid编号
string bmcid = dtResultcid.Rows[0][0].ToString();
if (bmcid == "")
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "请求异常,该用户未分配部门！";
return(null);
}
else
{
string sqlbmcid = "SELECT mc FROM p_dept WHERE cid = " + bmcid + "";
dtbmcid = ApplicationManager.DefaultConnection.QueryData(sqlbmcid).Tables[0]; //得到的部门名称
dtResult = ApplicationManager.DefaultConnection.QueryData(strSql).Tables[0]; //得到的用户基本信息
dtResult.Columns.Add("bmmc");
dtResult.Rows[0]["bmmc"] = dtbmcid.Rows[0][0].ToString();
}
return(dtResult);
}
catch (Exception ex) { throw ex; }
}
/// <summary>
/// 密码修改
/// </summary>
/// <param name="cid">用户唯一编号</param>
/// <param name="userName">用户名</param>
/// <param name="oldPassword">旧密码</param>
/// <param name="newPassword">新密码</param>
/// <param name="rePassword">重复密码</param>
/// <returns></returns>
public SpRequestMsg UpdatePassword(string cid, string userName, string oldPassword, string newPassword, string rePassword)
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
ISPService service = SpServiceFactory.CreateServiceBase();
try {
string oldPwd = Sp.BaseFrame.Common.Util.AESEncryptionUtils.Encrypt(oldPassword);
MySqlParameter[] parameters = { new MySqlParameter("?mm", oldPwd) };
//判断是否存在
DataTable dtExist = ApplicationManager.DefaultConnection.QueryData("select mm from p_user where mm=?mm", parameters, 0).Tables[0];
if (dtExist.Rows.Count > 0)
{
pSpRequestMsg.success = true;
pSpRequestMsg.message = "密码匹配正确!";
if (newPassword != rePassword)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "前后密码输入不一致!";
}
else
{
string NewPwd = Sp.BaseFrame.Common.Util.AESEncryptionUtils.Encrypt(newPassword);//加密新添加密码
string updata = "UPDATE p_user SET mm = '" + NewPwd + "' WHERE cid = " + cid + " ";
ApplicationManager.DefaultConnection.ExcuteData(updata);
pSpRequestMsg.message = "密码修改成功！";
}
}
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "密码修改请求异常,详情" + ex.Message;
}
return(pSpRequestMsg);
}
/// <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()
{
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("Password") ? dic["Password"] : "";
//if (string.IsNullOrEmpty(dlm))
//{
// pSpRequestMsg.success = false;
// pSpRequestMsg.message = "登录名不能为空!";
// return pSpRequestMsg.ToNormalJson();
//}
//if (string.IsNullOrEmpty(mm))
//{
// pSpRequestMsg.success = false;
// pSpRequestMsg.message = "登录密码不能为空!";
// return pSpRequestMsg.ToNormalJson();
//}
//IUserService userService = SpServiceFactory.CreateUserService();
//pSpRequestMsg = userService.Login(dlm, mm);
//TODO
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "登录请求异常,详情" + ex.Message;
Log.Error("登录请求异常:" + ex.Message.ToString());
}
return(pSpRequestMsg.ToNormalJson());
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="password">密码(未加密)</param>
/// <returns></returns>
public SpRequestMsg Login(string userName, string password)
{
SpRequestMsg pSpRequestMsg = new SpRequestMsg();
pSpRequestMsg.data = "";
try
{
MySqlParameter[] parameters = { new MySqlParameter("?dlm", userName) };
//判断用户是否存在
DataTable dtExist = ApplicationManager.DefaultConnection.QueryData("select cid from p_user where dlm=?dlm", parameters, 0).Tables[0];
if (dtExist.Rows.Count > 0)
{
MySqlParameter[] parameters1 =
{
new MySqlParameter("?dlm", userName),
new MySqlParameter("?mm", Sp.BaseFrame.Common.Util.AESEncryptionUtils.Encrypt(password)) //密码加密
};
//判断用户信息是否合法
DataTable dtUser = ApplicationManager.DefaultConnection.QueryData("select cid,zt,dlm from p_user where dlm=?dlm and mm=?mm", parameters1, 0).Tables[0];
if (dtUser.Rows.Count > 0)
{
var dt = ApplicationManager.DefaultConnection.QueryData("select xtqx from p_user where dlm=?dlm", parameters, 0).Tables[0];//判断用户权限
if (dt.Rows.Count > 0 && string.Format(",{0},", dt.Rows[0].Field <string>("xtqx")).IndexOf(string.Format(",{0},", systemType)) > -1)
{
string strZT = dtUser.Rows[0]["zt"].ToString();
string cid = dtUser.Rows[0]["cid"].ToString();
string username = dtUser.Rows[0]["dlm"].ToString();
string sqlQuery = "SELECT xtqx FROM p_user WHERE cid = " + cid + "";
string ssxt = ApplicationManager.DefaultConnection.ExecuteScalar(sqlQuery);
string logtype = "SELECT rzlx FROM p_user WHERE cid = " + cid + "";
string userxm = "SELECT xm FROM p_user WHERE cid = " + cid + "";
string xm = ApplicationManager.DefaultConnection.ExecuteScalar(userxm);
if (strZT == "2")//禁用
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "该用户已被禁用,请联系管理员!";
}
else
{
pSpRequestMsg.success = true;
pSpRequestMsg.message = "用户登录成功！";
pSpRequestMsg.data = cid + ";" + xm;//返回用户唯一编号cid
InsertLogMes insertlogmes = new InsertLogMes();
insertlogmes.InsertLogMessage(pSpRequestMsg.message, 6, 0, cid);
ValueHelper.pwdcid = cid; //定义全局变量cid
ValueHelper.pwdusername = username; //定义全局变量用户名
}
}
else
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "该用户已没有系统权限！";
}
}
else
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "登录密码错误!";
}
}
else
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "登录名不存在!";
}
}
catch (Exception ex)
{
pSpRequestMsg.success = false;
pSpRequestMsg.message = "登录请求异常,详情" + ex.Message;
}
return(pSpRequestMsg);
}
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));
}
