C#WebService实战篇

最新推荐文章于 2023-01-05 17:38:16 发布

weixin_30372371

最新推荐文章于 2023-01-05 17:38:16 发布

阅读量81

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/bantongshui/p/3237820.html

版权

以下仅是本人学习用，欢迎大家指正。

目的：构建对外接口，验证成功后方能返回数据

WebService对外接口不是全部对外公开，用户密码凭以下信息来来验证身份。

调用ID	用户名	密码	数据库	说明
1001	test	123321	A	查询订单数据
1002	admin	111111	C	查询对账单

先根据ID，用户，密码来验证身份，如果身份通过，则自动匹配数据库A，然后返回相应的数据集，如果没通过，则返回异常代码或空结果。

 [WebMethod]
        public byte[] GET_CUSTOMER_TEST(string companyid, string userid, string userpwd)
        {
            string database = GetDatabase(companyid, userid, userpwd);
            if (database.Length>0)
            {
                try
                {
                    using (DataSet ds = SqlDataAdapter(server, database, "你的存储过程", CommandType.StoredProcedure, null))
                    {
                        if (ds != null)
                            return GetDataSetSurrogateZipBytes(ds);
                        else return null;
                    }
                }
                catch
                {
                    return null;
                }
            }
           else return null;
        }

因为是根据前台输入的ID号，来指定库名，所以：

 private string GetDatabase(string companyid, string userid, string userpwd)
        {
            try
            {
                SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@companyid", companyid) ,
             new SqlParameter("@userid", userid) ,
             new SqlParameter("@userpwd", userpwd)        };
                using (DataSet ds = SqlDataAdapter("(local)", "study", "select dbs from users where @companyid=companyid and @userid=userid and @userpwd=userpwd", CommandType.Text, sp))
                {
                    if ((ds != null) && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                    {

                        return ValidDBS = ds.Tables[0].Rows[0]["DBS"].ToString();
                    }
                    else
                    {
                        return "";
                    }

                }
            }
            catch (Exception ex)
            {
                return ex.Message;
            }
        }

 private byte[] GetDataSetSurrogateZipBytes(DataSet ds)
        {
            DataSetSurrogate dss = new DataSetSurrogate(ds);
            BinaryFormatter bf = new BinaryFormatter();
            MemoryStream ms = new MemoryStream();
            bf.Serialize(ms, dss);
            byte[] buffer = ms.ToArray();
            byte[] Zipbuffer = Compress(buffer);
            return Zipbuffer;
        }
        //压缩压缩后的字节数组
        private byte[] Compress(byte[] data)
        {
            using (MemoryStream ms = new MemoryStream())
            {
                using (Stream zipStream = new GZipStream(ms, CompressionMode.Compress, true))
                {
                    zipStream.Write(data, 0, data.Length);
                    zipStream.Close();
                    ms.Position = 0;
                    byte[] buffer = new byte[ms.Length];
                    ms.Read(buffer, 0, int.Parse(ms.Length.ToString()));
                    return buffer;
                }
            }
        }

 private SqlConnection GetCon(string server, string database)
        {
            try
            {
                uid = "sa";
                pwd = "XXXX";
                return new SqlConnection("server=" + server + ";database=" + database + ";uid=" + uid + ";pwd=" + pwd + ";Pooling=true;Min Pool Size=0;Max Pool Size=300");

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

   private DataSet SqlDataAdapter(string server, string database, string Query, CommandType cmdtype, SqlParameter[] sp)
        {
            using (SqlConnection Conn = this.GetCon(server, database))
            {
                using (SqlCommand command = new SqlCommand(Query, Conn))
                {
                    command.CommandType = cmdtype;
                    if (sp != null && sp.Length > 0)
                    {
                        command.Parameters.AddRange(sp);
                    }
                    using (SqlDataAdapter adp = new SqlDataAdapter())
                    {
                        using (DataSet dataset = new DataSet())
                        {
                            try
                            {
                                adp.SelectCommand = command;
                                Conn.Open();
                                adp.Fill(dataset);
                                Conn.Close();
                                return dataset;
                            }
                            catch
                            {
                                Conn.Close();
                                dataset.Dispose();
                                adp.Dispose();
                                command.Dispose();
                                return null;
                            }
                            finally
                            {
                                Conn.Close();
                                dataset.Dispose();
                                adp.Dispose();
                                command.Dispose();
                            }
                        }
                    }
                }
            }
        }

这样服务器端就架设好了，前台代码如下：

  private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                string companyid = this.textBox1.Text.Trim();
                string userid = this.textBox2.Text.Trim();
                string userpwd = this.textBox3.Text.Trim();
                 
                gridControl1.DataSource = new Class1().GetDsTest(companyid, userid, userpwd).Tables[0].DefaultView;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

 public DataSet GetDsTest(string companyid, string userid, string userpwd)
        {
            try
            {
                byte[] zipbytes = WS.QSP_GET_CUSTOMER_TEST(companyid, userid, userpwd);
                if (zipbytes != null)
                    return ConvertToDataSet(zipbytes);
                else return NullDs();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

 MYNWS.SviceInterface WS = new 我的WS.MYNWS.SviceInterface();
         public static byte[] Decompress(byte[] data)
         {
             try
             {
                 using (MemoryStream ms = new MemoryStream(data))
                 {
                     Stream zipStream = null;
                     zipStream = new GZipStream(ms, CompressionMode.Decompress);
                     byte[] dc_data = null;
                     dc_data = ExtractBytesFromStream(zipStream, data.Length);
                     return dc_data;
                 }
                 ///返回解压后的二进制数组
             }
             catch
             {
                 return null;
             }
         }

        public static byte[] ExtractBytesFromStream(Stream zipStream, int dataBlock)
        {
            try
            {
                byte[] data = null;
                int totalBytesRead = 0;
                while (true)
                {
                    Array.Resize(ref data, totalBytesRead + dataBlock + 1);
                    int bytesRead = zipStream.Read(data, totalBytesRead, dataBlock);
                    if (bytesRead == 0)
                    {
                        break;
                    }
                    totalBytesRead += bytesRead;
                }
                Array.Resize(ref data, totalBytesRead);
                return data;
            }
            catch
            {
                return null;
            }
        }
        public static DataSet ConvertToDataSet(byte[] ZipByte)
        {          
            try
            {               
                if (ZipByte != null)
                {
                    byte[] buffer = Decompress(ZipByte);
                    BinaryFormatter bf = new BinaryFormatter();
                    DataSetSurrogate dss= bf.Deserialize(new MemoryStream(buffer)) as DataSetSurrogate;
                    using (DataSet ds = dss.ConvertToDataSet())
                    {
                        return ds;
                    }
                }
                else { return null; }
            }
            catch (Exception ex) { throw ex; }
        }

        private DataSet NullDs()
        {
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            DataColumn cl = dt.Columns.Add("id", typeof(string));
            DataRow dr = dt.NewRow();
            dr["id"] = "没有找到";
            dt.Rows.Add(dr);
            ds.Tables.Add(dt);
            return ds;
        }