Exemple #1
0
        private DownFileResult SoftUpDate(FileAdr Adress)
        {
            DownFileResult message = new DownFileResult();

            try
            {
                string sqlType = Adress.sqlType;
                Stream Content;
                GetConfig(ref sqlType);
                Byte[]  blob    = null;
                DataSet dataSet = new DataSet();
                string  strSql  = "select " + Adress.blobCont + " from " + Adress.dbName + " where " + Adress.primaryKey + " = " + Adress.keyValues;
                long    num     = 0;
                switch (sqlType.Trim().ToUpper())
                {
                case "SQLSERVER":
                    SvrCon.Open();
                    SqlCommand    svrcmd = new SqlCommand(strSql, SvrCon);
                    SqlDataReader svrsdr = svrcmd.ExecuteReader();
                    SvrCon.Close();
                    bool svrRead = svrsdr.Read();
                    blob = new Byte[(svrsdr.GetBytes(0, 0, null, 0, int.MaxValue))];
                    num  = svrsdr.GetBytes(0, 0, blob, 0, blob.Length);
                    svrsdr.Close();
                    if (num > 0)
                    {
                        Content            = new MemoryStream(blob);
                        message.FileStream = Content;
                        message.FileSize   = Content.Length;
                        message.Message    = num.ToString();
                        message.IsSuccess  = true;
                    }
                    else
                    {
                        Content           = null;
                        message.Message   = num.ToString();
                        message.IsSuccess = false;
                    }
                    break;

                case "ORACLE":
                    OraCon.Open();
                    OracleCommand    oracmd = new OracleCommand(strSql, OraCon);
                    OracleDataReader orasdr = oracmd.ExecuteReader();
                    OraCon.Close();
                    bool oraRead = orasdr.Read();
                    blob = new Byte[(orasdr.GetBytes(0, 0, null, 0, int.MaxValue))];
                    num  = orasdr.GetBytes(0, 0, blob, 0, blob.Length);
                    orasdr.Close();
                    if (num > 0)
                    {
                        Content            = new MemoryStream(blob);
                        message.FileStream = Content;
                        message.FileSize   = Content.Length;
                        message.Message    = num.ToString();
                        message.IsSuccess  = true;
                    }
                    else
                    {
                        Content           = null;
                        message.Message   = num.ToString();
                        message.IsSuccess = false;
                    }
                    break;

                default:
                    message.Message   = "找不到所需的数据库连接类型";
                    message.IsSuccess = false;
                    break;
                }
                return(message);
            }
            catch (Exception e)
            {
                error             = e.Message;
                message.IsSuccess = false;
                message.Message   = error;
                return(message);
            }
        }
Exemple #2
0
 /// <summary>
 /// 数据库byte下载
 /// </summary>
 /// <param name="dbName">数据库名称</param>
 /// <param name="blobCont">获取数据列名</param>
 /// <param name="primaryKey">主键ID</param>
 /// <param name="keyValues">匹配值</param>
 /// <param name="sqlType">连接类型</param>
 /// <returns></returns>
 public DownFileResult softUpDate(FileAdr Adress)
 {
     return(SoftUpDate(Adress));
 }