Пример #1
0
        /// <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);
        }
Пример #2
0
        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
        }