Пример #1
0
        public DataTableResponse GetFileServerInfoByEndPoint(string token, string wcfAddress, string account, string passWord)
        {
            DataTableResponse response = new DataTableResponse();

            DataTable dt = new DataTable();

            try
            {
                bool isPermission = token == ServerConfig.Token;
                if (!isPermission)
                {
                    dt.TableName = "FileServer";
                    dt.Columns.Add("Error", typeof(string));

                    response.IsSuccessful = false;
                    response.ResultMessage = "您没有访问该文件服务器接口的权限!";
                    response.DataTable = dt;
                    return response;
                }

                DbCommand cmd = _dataBaseAccess.CreateCommand();
                cmd.CommandText = "Proc_FileServer_GetByEndPoint";

                DbParameter param = _dataBaseAccess.CreateParameter();
                param.ParameterName = "@WCFAddress";
                param.DbType = DbType.String;
                param.Value = wcfAddress;
                cmd.Parameters.Add(param);

                param = _dataBaseAccess.CreateParameter();
                param.ParameterName = "@Account";
                param.DbType = DbType.String;
                param.Value = account;
                cmd.Parameters.Add(param);

                param = _dataBaseAccess.CreateParameter();
                param.ParameterName = "@PassWord";
                param.DbType = DbType.String;
                param.Value = Tools.MD5Encrypt(passWord);
                cmd.Parameters.Add(param);

                dt = _dataBaseAccess.GetDataTable(cmd);
                dt.TableName = "FileServer";

                response.DataTable = dt;
                if (dt != null && dt.Rows.Count > 0)
                {
                    response.IsSuccessful = true;
                    response.ResultMessage = string.Empty;
                }
                else
                {
                    response.IsSuccessful = false;
                    response.ResultMessage = string.Format("{0}从服务器信息表获取不到内容!", wcfAddress);
                }
            }
            catch (Exception ex)
            {
                dt = new DataTable();
                dt.TableName = "FileServer";
                dt.Columns.Add("Error", typeof(string));

                response.IsSuccessful = false;
                response.ResultMessage = ex.Message;
                response.DataTable = dt;
                Tools.LogWrite(ex.ToString());
            }

            return response;
        }
Пример #2
0
        public DataTableResponse GetCategoryInfo(string token, int fileServerId, string account, string passWord)
        {
            DataTableResponse response = new DataTableResponse();

            DataTable dt = new DataTable();

            try
            {
                bool isPermission = Authentication(token, fileServerId, account, passWord);
                if (!isPermission)
                {
                    dt.TableName = "Category";
                    dt.Columns.Add("Error", typeof(string));

                    response.IsSuccessful = false;
                    response.ResultMessage = "您没有访问该文件服务器接口的权限!";
                    response.DataTable = dt;
                    return response;
                }

                DbCommand cmd = _dataBaseAccess.CreateCommand();
                cmd.CommandText = "Proc_Category_GetAll";
                dt = _dataBaseAccess.GetDataTable(cmd);
                dt.TableName = "Category";

                response.DataTable = dt;
                if (dt != null && dt.Rows.Count > 0)
                {
                    response.IsSuccessful = true;
                    response.ResultMessage = string.Empty;
                }
                else
                {
                    response.IsSuccessful = false;
                    response.ResultMessage = "目录信息表为空!";
                }
            }
            catch (Exception ex)
            {
                dt = new DataTable();
                dt.TableName = "Category";
                dt.Columns.Add("Error", typeof(string));

                response.IsSuccessful = false;
                response.ResultMessage = ex.Message;
                response.DataTable = dt;
                Tools.LogWrite(ex.ToString());
            }

            return response;
        }