/// <summary> /// 删除用户sql /// </summary> /// <param name="request"></param> /// <returns></returns> private static string getDeleteUserSqlString(ReqDeleteUser request) { string temp = String.Empty; if (request.user_id != null && request.user_id != String.Empty) { temp = " delete from PatrolUserInfo "; temp += " where UserCD = '" + request.user_id + "'"; temp += " ; "; } return(temp); }
public Stream DeleteUser(Stream data) { #region 查找数据 ResDeleteUser response = new ResDeleteUser(); bool success = true; try { DataContractJsonSerializer json = new DataContractJsonSerializer(typeof(ReqDeleteUser)); //读取器 StreamReader sr = new StreamReader(data); string dataString = String.Empty; while (!sr.EndOfStream) { dataString = sr.ReadToEnd(); Console.WriteLine(dataString); #region 日志输出 CommonInfo.Log(dataString); #endregion //反序列化json为对象注意顺序很重要 ReqDeleteUser request = new ReqDeleteUser(); MemoryStream temp = new MemoryStream(Encoding.UTF8.GetBytes(dataString)); request = json.ReadObject(temp) as ReqDeleteUser; //关闭临时流 temp.Close(); //调用用户更新密码接口 if (request != null) { //**********(此处加入代码) 根据查询条件 加入业务逻辑代码************* if (request.account != null && request.account != String.Empty && request.token != null && request.token != String.Empty) { string user = getDeleteUserSqlString(request); success = UserEntity.deleteUser(user); } } } sr.Close(); Console.WriteLine(data); } catch (Exception ex) { Console.WriteLine(ex.Message); #region 日志输出 CommonInfo.Error("获取特巡列表数据错误" + ex.Message); #endregion } //返回消息体 if (success) { response.SetSuccess(); } else { ////默认是失败 //response.SetFailed(); } //将消息序列化为Json格式数据 DataContractJsonSerializer obj2Json = new DataContractJsonSerializer(typeof(ResDeleteUser)); MemoryStream ms = new MemoryStream(); obj2Json.WriteObject(ms, response); //注意一定要设置流的位置到开始位置,否则没有消息输出 ms.Position = 0; return(ms); #endregion }