WebService 类文件内容 RevitUpload

using BimWeb.DataConnection;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.IO;
using System.Drawing;

namespace BimWeb.BimWebService
{
    /// <summary>
    /// RevitUpload 的摘要说明
    /// </summary>
    [WebService(Namespace = "SxanBimWebService")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消注释以下行。 
    // [System.Web.Script.Services.ScriptService]

    public class RevitUpload : System.Web.Services.WebService
    {

        //连接数据库
        MSSqlHelper MHelper = new MSSqlHelper();
        //web.config中图片文件路径的配置
        public string RevitFileUrl = ConfigurationManager.AppSettings["UploadRevits"].ToString();
        public string ImageFileUrl = ConfigurationManager.AppSettings["UploadImage"].ToString();


        #region 获取表BimWeb_ModelType中的数据,返回datatable
        /// <summary>
        ///  获取表BimWeb_ModelType中的[Id],[Name],[ParentIndexId]
        /// </summary>
        /// <returns></returns>
        [WebMethod]
        public DataTable getCatagories()
        {
            string sqlC = "select Id,Name,ParentIndexId from BimWeb_ModelType ";
            DataTable dtModelType = MHelper.ExecuteDataTable(sqlC, "BimWeb_ModelType");
            return dtModelType;
        }
        #endregion

        #region 获取表BimWeb_ModelSet中的数据,返回datatable
        /// <summary>
        ///  获取表BimWeb_ModelSet中的[Id],[Name]
        /// </summary>
        /// <returns></returns>
        [WebMethod]
        public DataTable getModelSet()
        {
            string sqlModelSet = "select Id,Name from BimWeb_ModelSet ";
            DataTable dtModelSet = MHelper.ExecuteDataTable(sqlModelSet, "BimWeb_ModelSet");
            return dtModelSet;
        }
        #endregion



        #region 上传单个族文件Revit 对应的表： BimWeb_Model
        /// <summary>
        /// 上传单个族文件Revit 对应的表： BimWeb_Model
        /// </summary>
        /// <param name="uniquid">唯一标识UniqueId</param>
        /// <param name="name">Name</param>
        /// <param name="content">RFCModelFilePath</param>
        /// <param name="categoryid">ModelTypeIndexId</param>
        /// <param name="thumb">D3ModelImagePath</param>
        /// <returns></returns>
        [WebMethod]

        public int UploadRevit(string uniquid, string name, byte[] content, int categoryid, int setID, byte[] thumb = null)
        {

            //包括新增和修改（用uniquid区分修改或新增，判断该uniquid是否已存在。如果是修改的话，把BimWeb_ModelInfo和BimWeb_ModelStandard中的相关数据删掉）
            //content  目录 。存库RFCModelFilePath
            //categoryid 对应ModelTypeIndexId
            //thumb 判断有无，存库，对应 D3ModelImagePath


            int backUniqueId = -1;
            //已经存在的文件地址RFCModelFilePath
            string FileName = "";
            string thumbFile = "";
            int BimWeb_ModelID = 0;
            //根据uniquid查询表BimWeb_Model中是否已经存在该数据
            if (uniquid != "" && uniquid != null)
            {
                string sqlModelIsExit = "select * from BimWeb_Model where UniqueId='" + uniquid + "'";
                DataTable dtIsExit = MHelper.ExecuteDataTable(sqlModelIsExit, "BimWeb_Model");
                if (dtIsExit.Rows.Count > 0)
                {
                    backUniqueId = Convert.ToInt16(dtIsExit.Rows[0]["Id"]);
                    FileName = Convert.ToString(dtIsExit.Rows[0]["RFCModelFilePath"]);
                    thumbFile = Convert.ToString(dtIsExit.Rows[0]["D3ModelImagePath"]);
                    BimWeb_ModelID = Convert.ToInt16(dtIsExit.Rows[0]["Id"]);

                    //数据已经存在的文件，删除本地文件RFCModelFilePath
                    if (FileName != "")
                    {

                        //判断该文件是否已存在                      

                     //  string RfaFile =  FileName;
                        string NewFile2 = Server.MapPath("~/" + FileName);
                        if (System.IO.File.Exists(NewFile2)) System.IO.File.Delete(NewFile2);  
                    }

                    string NewFileName2 = uniquid + ".rfa";
                    string RfaFile2 = RevitFileUrl + NewFileName2;
                    string NewFile3 = Server.MapPath("~/" + RevitFileUrl) + NewFileName2;
                    if (System.IO.File.Exists(NewFile3)) System.IO.File.Delete(NewFile3);
                    System.IO.File.WriteAllBytes(NewFile3, content);


                    //D3ModelImagePath数据已存在，删除本地文件
                    //string NewFilethumbName3 = thumbFile;
                    //string ImageFile3 = ImageFileUrl + NewFilethumbName3;
                    string NewFilethumbName4 = uniquid + ".jpg";
                    string ImageFile4 = ImageFileUrl + NewFilethumbName4;
                    if (thumbFile != "")
                    {  
                        //删除文件
                        string NewImageFile2 = Server.MapPath("~/" + thumbFile);
                        if (System.IO.File.Exists(NewImageFile2)) System.IO.File.Delete(NewImageFile2);  

                        //写入文件

                            using (System.IO.MemoryStream mem = new MemoryStream(thumb))
                            {
                                string NewFileJpg = Server.MapPath("~/" + ImageFileUrl) + NewFilethumbName4;
                                System.Drawing.Bitmap bmp = System.Drawing.Bitmap.FromStream(mem) as System.Drawing.Bitmap;
                                bmp.Save(NewFileJpg);
                            }

                    }


                    //数据已存在,则修改表BimWeb_Model中的数据，删除BimWeb_ModelInfo和BimWeb_ModelStandard中的相关数据
                    string UpdateBimWeb_Model = "update BimWeb_Model set Name='" + name + "',RFCModelFilePath='" + RfaFile2 + "',ModelTypeIndexId='" + categoryid + "',D3ModelImagePath='" + ImageFile4 + "',ModelSetIndexId=" + setID + " where  UniqueId='" + uniquid + "';";

                    int backRows = MHelper.ExecuteNonQuery(UpdateBimWeb_Model);
                    if (backRows != -1)
                    {
                        //修改成功后，删除表BimWeb_ModelInfo和BimWeb_ModelStandard中的相关数据
                        string DelBimWeb_ModelInfo = "delete from BimWeb_ModelInfo where ModelIndexId=" + BimWeb_ModelID;
                        int delBack = MHelper.ExecuteNonQuery(DelBimWeb_ModelInfo);
                        if (delBack > 0)
                        {
                            //删除表BimWeb_ModelInfo成功
                        }
                        else
                        {
                            //删除失败
                        }
                        string DelBimWeb_ModelStandard = "delete from BimWeb_ModelStandard where ModelId="+ BimWeb_ModelID;
                        int delBackS = MHelper.ExecuteNonQuery(DelBimWeb_ModelStandard);
                        if (delBackS > 0)
                        {
                            //删除表BimWeb_ModelStandard成功
                        }
                        else
                        {
                            //删除失败
                        }

                    }

                }
                else
                {


                    //将字节流转换成文件保存本地    RFCModelFilePath
                    string NewFileName2 = uniquid + ".rfa";

                    string RfaFile = RevitFileUrl + NewFileName2;

                    string NewFile2 = Server.MapPath("~/" + RevitFileUrl) + NewFileName2;
                    if (System.IO.File.Exists(NewFile2)) System.IO.File.Delete(NewFile2);
                    System.IO.File.WriteAllBytes(NewFile2, content);

                    string NewFilethumbName2 = uniquid + ".jpg";
                    string ImageFile = ImageFileUrl + NewFilethumbName2;
                    if (thumb != null)
                    {
                        using (System.IO.MemoryStream mem = new MemoryStream(thumb))
                        {

                            string NewFileJpg = Server.MapPath("~/" + ImageFileUrl) + NewFilethumbName2;
                            System.Drawing.Bitmap bmp = System.Drawing.Bitmap.FromStream(mem) as System.Drawing.Bitmap;
                            bmp.Save(NewFileJpg);
                        }                      
                    }

                    //数据不存在,新增BimWeb_Model表中的数据
                    string InsertBimWeb_Model = "insert into BimWeb_Model(UniqueId,Name,RFCModelFilePath,ModelTypeIndexId,D3ModelImagePath,ModelSetIndexId) values('" + uniquid + "','" + name + "','" + RfaFile + "'," + categoryid + ",'" + ImageFile + "'," + setID + ");select @@IDENTITY";

                    backUniqueId = MHelper.ExecuteScalerB(InsertBimWeb_Model);
                    if (backUniqueId != -1)
                    {
                        //新增成功

                    }
                    else
                    {
                        //新增失败

                    }
                }
            }
            return backUniqueId;//id 
        }
        #endregion


        #region 上传参数 对应表 BimWeb_ModelInfo
        /// <summary>
        /// ModelIndexId    表对应modelid
        /// </summary>
        /// <param name="modelid"></param>
        /// <param name="key"></param>
        /// <param name="value"></param>
        /// <returns></returns>
        [WebMethod]
        //id上个方法返回的值
        public bool UploadRevitParameters(int modelid, string key, string value)
        {
            string InsertModelInfo = "insert into BimWeb_ModelInfo(ModelIndexId,[Key],Value) values('" + modelid + "','" + key + "','" + value + "')";
            int backValue = MHelper.ExecuteNonQuery(InsertModelInfo);
            //根据ModelIndexIdhe key（列表）
            if (backValue > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        #endregion


        #region 上传 BimWeb_ModelStandard
        /// <summary>
        /// UploadRevit方法返回的ID
        /// </summary>
        /// <param name="zuname"></param>
        /// <param name="zufile"></param>
        /// <param name="categoryid"></param>
        /// <returns></returns>
        [WebMethod]

        public bool UploadRevitTypes(int modelid, string name, byte[] BimWeb_ModelStandard = null)
        {
            //BimWeb_ModelStandard 图片保存到本地，存库。 

            string NewFilethumbName2 = Guid.NewGuid().ToString() + ".jpg";
            string ImageFile = ImageFileUrl + NewFilethumbName2;
            if (BimWeb_ModelStandard != null)
            {
                using (System.IO.MemoryStream mem = new MemoryStream(BimWeb_ModelStandard))
                {

                    string NewFileJpg = Server.MapPath("~/" + ImageFileUrl) + NewFilethumbName2;
                    System.Drawing.Bitmap bmp = System.Drawing.Bitmap.FromStream(mem) as System.Drawing.Bitmap;
                    bmp.Save(NewFileJpg);
                }
            }

            string InsertModelStandard = "insert into BimWeb_ModelStandard(Name,D3ModelImagePath,ModelId) values('" + name + "','" + ImageFile + "','" + modelid + "')";
            if (MHelper.ExecuteNonQuery(InsertModelStandard) > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        #endregion
    }
}