Excel操作~~

using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using MainOneProduct.Mobile.BLL;
using MainOneProduct.Mobile.Model;
using System.Collections.Generic;
using MainOneProduct.Utility;
using MainOneProduct.Trade.Model;
using MainOneProduct.Trade.BLL;
namespace MainOneProduct.App_Code
{
    /// <summary>
    /// TransData 的摘要说明
    /// </summary>
    public class TransData
    {
        public TransData()
        {
        }
        public static HttpRequest Request
        {
            get
            {
                return HttpContext.Current.Request;
            }
        }
        public static HttpResponse Response
        {
            get
            {
                return HttpContext.Current.Response;
            }
        }
        /// <summary>
        /// 下载文件
        /// </summary>
        /// <param name="FileName"></param>
        public static void DownExcelModel(string FileName)
        {
            //打开要下载的文件
            System.IO.FileStream r = new System.IO.FileStream(FileName, System.IO.FileMode.Open);
            //设置基本信息
            Response.Buffer = false;
            Response.AddHeader("Connection", "Keep-Alive");
            Response.ContentType = "application/octet-stream";
            Response.AddHeader("Content-Disposition", "attachment;filename=" + System.IO.Path.GetFileName(FileName));
            Response.AddHeader("Content-Length", r.Length.ToString());

            while (true)
            {
                //开辟缓冲区空间
                byte[] buffer = new byte[1024];
                //读取文件的数据
                int leng = r.Read(buffer, 0, 1024);
                if (leng == 0)//到文件尾，结束
                    break;
                if (leng == 1024)//读出的文件数据长度等于缓冲区长度，直接将缓冲区数据写入
                    Response.BinaryWrite(buffer);
                else
                {
                    //读出文件数据比缓冲区小，重新定义缓冲区大小，只用于读取文件的最后一个数据块
                    byte[] b = new byte[leng];
                    for (int i = 0; i < leng; i++)
                        b[i] = buffer[i];
                    Response.BinaryWrite(b);
                }
            }
            r.Close();//关闭下载文件
            Response.End();//结束文件下载
        }
        /// <summary>
        /// 删除服务器上的文件
        /// </summary>
        /// <param name="FileName">文件的服务器路径</param>
        public static void DelExcel(string FileName)
        {
            if (File.Exists(FileName))
                File.Delete(FileName);
        }
        /// <summary>
        /// 上传 Excel 文件
        /// </summary>
        /// <param name="Fileup">控件</param>
        /// <param name="CompanyID">公司ID</param>
        /// <param name="UserID">用户ID</param>
        /// <returns>string[] 0:服务器路径-用来读取和删除文件 1:上传结果-分3中状态(成功,失败,文件类型出错)</returns>
        public static string[] UpExcel(System.Web.UI.HtmlControls.HtmlInputFile Fileup, string CompanyID, string UserID)
        {
            string strfileoldpath = MainOneProduct.Other.BLL.Config.Domain.GetByName("OPmanageFile").strPath + "/excel/";//System.Configuration.ConfigurationManager.AppSettings["ExcelSavePath"].ToString(); //上传文件的保存路径
            string strfileoldname = "";//服务器端生成的名称

            string fileName; //本地文件名称
            string fileExtension; //文件扩展名
            string filetype; //上传文件类型

            string[] arrayImageUrl = new string[2] { "", "" };

            //try
            //{
            //没有文件上传
            if (Fileup.PostedFile.FileName == "")
            {
                arrayImageUrl[1] = "请选择要上传得文件，路经不能用手输入！";
                return arrayImageUrl;
            }
            HttpPostedFile postedFile = Fileup.PostedFile;
            fileName = System.IO.Path.GetFileName(postedFile.FileName);
            if (fileName == "")
            {
                arrayImageUrl[1] = "请选择要上传得文件，路经不能用手输入！";
                return arrayImageUrl;
            }
            fileExtension = System.IO.Path.GetExtension(fileName);

            //判断是否大小超过上限
            int iMaxSize = 1;//System.Configuration.ConfigurationManager.AppSettings["ExcelMaxSize"]); //上传文件大小
            int MaxFile = 0;
            MaxFile = Fileup.PostedFile.ContentLength;
            if (MaxFile > (iMaxSize * 1024 * 1024))
            {
                arrayImageUrl[1] = String.Format("文件大小不能超过{0}兆", iMaxSize.ToString());
                return arrayImageUrl;
            }

            //检查保存文件的目录是否存在,否则创建 
            //strfileoldpath = HttpContext.Current.Server.MapPath("." + "//" + strfileoldpath);
            //if (!System.IO.Directory.Exists(strfileoldpath))
            //{
            //    System.IO.Directory.CreateDirectory(strfileoldpath);
            //}

            while (System.IO.File.Exists(strfileoldpath) || strfileoldname == "")
            {
                //为文件命名,然后保存
                strfileoldname = NewName(CompanyID, UserID, fileExtension);
                //检查保存文件是否存在,否则创建 
                strfileoldpath += "//" + strfileoldname;
            }
            //保存文件
            postedFile.SaveAs(strfileoldpath);
            arrayImageUrl[0] = strfileoldpath;
            arrayImageUrl[1] = "上传成功！";
            return arrayImageUrl;
            //}
            //catch
            //{
            //    arrayImageUrl[1] = "上传失败！";
            //    return arrayImageUrl;
            //}
        }

        /// <summary>
        /// 为文件命名
        /// </summary>
        /// <param name="CompanyID">公司ID</param>
        /// <param name="UserID">用户ID</param>
        /// <param name="fileExtension">后缀名</param>
        /// <returns></returns>
        private static string NewName(string CompanyID, string UserID, string fileExtension)
        {
            //为文件命名,然后保存
            Random ra = new Random();
            string NameStr = CompanyID + "-" + UserID + "-" + DateTime.Now.Ticks.ToString() + "-" + ra.Next(100000, 999999).ToString() + fileExtension;
            return NameStr;
        }
        /// <summary>
        /// 读取Excel文件
        /// </summary>
        /// <param name="strFileDir">文件服务器路径</param>
        /// <returns>DataSet</returns>
        public static DataSet ReadFromExcel(string strFileDir)
        {
            string strConn;
            //strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileDir + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
            strConn = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFileDir + ";Extended Properties=/"Excel 12.0;HDR=YES/"";
            OleDbConnection OleConn = new OleDbConnection(strConn);
            OleConn.Open();
            DataTable dt = OleConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            string tableName = dt.Rows[0][2].ToString().Trim();

            string sql = string.Format("SELECT * FROM [{0}]", tableName);
            OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
            DataSet OleDsExcle = new DataSet();
            OleDaExcel.Fill(OleDsExcle, "aa");
            OleConn.Close();
            return OleDsExcle;
        }
        /// <summary>
        /// 插入数据
        /// </summary>
        /// <param name="ds"></param>
        /// <returns></returns>
        public static string[] InserData(DataSet ds)
        {
            //信息
            string Mess = "";
            //信息模板
            string MessModel = "正在导入客户：{0}　{1}！{2}</font><br/>";
            //成功信息
            string MessSus = "<font color=''>导入成功";
            //失败信息
            string MessMis = "<font color='red'>导入失败";
            //输出信息　
            string[] str = new string[2] { "", "" };
            DataTable dt = ds.Tables[0];
            if (dt.Rows.Count == 0)
            {
                Mess += String.Format(MessModel, "<font color='red'>至少填入1行数据", "", "");
            }
            foreach (DataRow row in dt.Rows)
            {
                /**************判断重复的先注释*************/

                //判断该客户是否已经存在
                //if (row[0].ToString() != "")
                //{
                //    if (Customer.IsExist(row[0].ToString(), APP_User.CurrentCompanyID))
                //    {
                //        NextCustomer = false; //表示公司插入失败!^_^
                //        Mess += String.Format(MessModel, "", MessMis, "该客户已经存在,不能再次录入");
                //        continue;
                //    }
                //}
                /********************************************/

                //====================应付模板出现问题时读取空数据行出现错误提示
                if (row[0].ToString() == "" && row[1].ToString() == "" && row[2].ToString() == "" && row[3].ToString() == "" && row[4].ToString() == "")
                {
                    continue;
                }

                if (row[0].ToString() == "")
                {
                    Mess += String.Format(MessModel, "联系人：空", MessMis, "联系人姓名不能为空");
                    continue;
                }
                else
                {
                    if (row[0].ToString().Length > 30)
                    {
                        Mess += String.Format(MessModel, "联系人：" + row[0].ToString(), MessMis, "联系人姓名长度应该小于30字");
                        continue;
                    }
                }

                if (row[1].ToString() == "")
                {
                    Mess += String.Format(MessModel, "联系人：" + row[0].ToString(), MessMis, "公司名称不能为空");
                    continue;
                }
                else
                {
                    if (row[1].ToString().Length > 30)
                    {
                        Mess += String.Format(MessModel, "联系人：" + row[0].ToString(), MessMis, "公司名称长度应该小于30字");
                        continue;
                    }
                }

                if (row[2].ToString() == "")
                {
                    Mess += String.Format(MessModel, "联系人：" + row[0].ToString(), MessMis, "手机号不能为空");
                    continue;
                }
                else
                {
                    if (row[2].ToString().Length != 11)
                    {
                        Mess += String.Format(MessModel, "联系人：" + row[0].ToString(), MessMis, "手机号长度应该是11位");
                        continue;
                    }
                }

                if (row[3].ToString() == "")
                {
                    Mess += String.Format(MessModel, "联系人：" + row[0].ToString(), MessMis, "联系人性别不能为空");
                    continue;
                }
                else
                {
                    if (row[3].ToString().Trim() != "0" && row[3].ToString().Trim() != "1")
                    {
                        Mess += String.Format(MessModel, "　联系人：" + row[0].ToString(), MessMis, "联系人性别只能填数字1和0");
                        continue;
                    }
                }

                Mobile_ContactInfo ConInfo = GetContactInfoByDataRow(row);
                Mobile_Contact.Insert(ConInfo);
                Mess += String.Format(MessModel, "联系人：" + row[0].ToString(), MessSus, "");

            }
            str[0] = "";
            str[1] = Mess;
            return str;
        }

        private static Mobile_ContactInfo GetContactInfoByDataRow(DataRow row)
        {
            Mobile_ContactInfo ci = new  Mobile_ContactInfo();
            ci.UserID = MainOneProduct.Member.BLL.User.CurrentUserID;
            ci.ContactName  = row[0].ToString().Trim();
            ci.CompanyName  = row[1].ToString().Trim();
            ci.MobilePhone  = row[2].ToString().Trim();
            ci.Sex          = (bool)(row[3].ToString().Trim()=="1")?true:false;
            ci.Remark       = row[4].ToString();
            ci.CategoryID   = -1;
            return ci;
        }

        /// <summary>
        /// 批量新增产品插入数据
        /// </summary>
        /// <param name="ds"></param>
        /// <returns></returns>
        public static string[] InserDataTrades(DataSet ds, int intTradeID, int intInfoCategory,int type)
        {
            //信息
            string Mess = "";
            string nullMess = "";
            int rowCount=0;
            double doubleError=0;
            int intError=0;
            int nullCount = 0;
            DataTable dp = null;
            //信息模板
            string MessModel = "正在导入数据：{0}　{1}！{2}<br/>";
            //成功信息
            string MessSus = "导入成功";
            //失败信息
            string MessMis = "导入失败";
            //输出信息　
            string[] str = new string[2] { "", "" };
          
            DataTable dt = ds.Tables[0];
            dp = new DataTable();
            if (dt.Rows.Count > 100)
            {
                Mess += String.Format(MessModel, "数据总数不能超过100行", "", "");
            }
            foreach (DataRow row in dt.Rows)
            {
                /**************判断重复的先注释*************/

                //判断该客户是否已经存在
                //if (row[0].ToString() != "")
                //{
                //    if (Customer.IsExist(row[0].ToString(), APP_User.CurrentCompanyID))
                //    {
                //        NextCustomer = false; //表示公司插入失败!^_^
                //        Mess += String.Format(MessModel, "", MessMis, "该客户已经存在,不能再次录入");
                //        continue;
                //    }
                //}
                /********************************************/

                //====================应付模板出现问题时读取空数据行出现错误提示

                if (type == 0)
                {
                    if (row[0].ToString() == "" && row[2].ToString() == "" && row[9].ToString() == "" && row[11].ToString() == "")
                    {
                        nullCount++;
                        continue;
                    }

                    if (row[0].ToString() == "")
                    {
                        Mess += String.Format(MessModel, "产品名称：空", MessMis, "产品名称不能为空");
                        continue;
                    }
                    else
                    {
                        if (row[0].ToString().Length > 100)
                        {
                            Mess += String.Format(MessModel, "产品名称：" + row[0].ToString(), MessMis, "产品名称长度应该小于100字");
                            continue;
                        }
                    }

                    if (row[2].ToString() == "")
                    {
                        Mess += String.Format(MessModel, "产品名称：" + row[0].ToString(), MessMis, "关键字1不能为空");
                        continue;
                    }
                    else
                    {
                        if (row[2].ToString().Length > 20)
                        {
                            Mess += String.Format(MessModel, "产品名称：" + row[0].ToString(), MessMis, "关键字1长度应该小于20字");
                            continue;
                        }

                        if (row[3].ToString().Length > 20)
                        {
                            Mess += String.Format(MessModel, "产品名称：" + row[0].ToString(), MessMis, "关键字2长度应该小于20字");
                            continue;
                        }

                        if (row[4].ToString().Length > 20)
                        {
                            Mess += String.Format(MessModel, "产品名称：" + row[0].ToString(), MessMis, "关键字3长度应该小于20字");
                            continue;
                        }
                    }

                    if (row[9].ToString() == "")
                    {
                        Mess += String.Format(MessModel, "产品名称:" + row[0].ToString(), MessMis, "产品描述不能为空");
                        continue;
                    }
                    if (row[11].ToString() == "")
                    {
                        Mess += String.Format(MessModel, "产品名称:" + row[0].ToString(), MessMis, "计量单位不能为空");
                        continue;
                    }
                    if (row[12].ToString() != "")
                    {
                        if (!int.TryParse(row[12].ToString(), out intError))
                        {
                            Mess += String.Format(MessModel, "产品名称:" + row[0].ToString(), MessMis, "供应总量必须是整型数字");
                            continue;
                        }
                    }
                    if (row[13].ToString() != "")
                    {
                        if (!int.TryParse(row[13].ToString(), out intError))
                        {
                            Mess += String.Format(MessModel, "产品名称:" + row[0].ToString(), MessMis, "最小起订量必须是整型数字");
                            continue;
                        }
                    }
                    if (row[14].ToString() != "")
                    {
                        if (!double.TryParse(row[14].ToString(), out doubleError))
                        {
                            Mess += String.Format(MessModel, "产品名称:" + row[0].ToString(), MessMis, "产品单价必须是数字");
                            continue;
                        }
                    }
                    if (row[16].ToString() != "")
                    {
                        if (!double.TryParse(row[16].ToString(), out doubleError))
                        {
                            Mess += String.Format(MessModel, "产品名称:" + row[0].ToString(), MessMis, "产品运费必须是数字");
                            continue;
                        }
                    }
                  
                  
                }
                else
                {
                    /*====这里是商机的======================================*/
                    if (row[0].ToString() == "" && row[1].ToString() == "" && row[3].ToString() == "" && row[7].ToString() == "")
                    {
                        nullCount++;
                        continue;
                    }

                    if (row[0].ToString() == "")
                    {
                        Mess += String.Format(MessModel, "商机类型：空", MessMis, "商机类型不能为空");
                        continue;
                    }
                    else
                    {
                        if (row[0].ToString() != "供应" && row[0].ToString() != "求购")
                        {
                            Mess += String.Format(MessModel, "商机名称：" + row[1].ToString(), MessMis, "商机类型不匹配");
                            continue;
                        }
                    }

                    if (row[1].ToString() == "")
                    {
                        Mess += String.Format(MessModel, "商机名称：空", MessMis, "商机名称不能为空");
                        continue;
                    }
                    else
                    {
                        if (row[1].ToString().Length > 20)
                        {
                            Mess += String.Format(MessModel, "商机名称：" + row[1].ToString(), MessMis, "商机名称长度应该小于20字");
                            continue;
                        }
                    }

                    if (row[3].ToString() == "" && row[4].ToString() == "" && row[5].ToString() == "")
                    {
                        Mess += String.Format(MessModel, "商机名称：" + row[1].ToString(), MessMis, "至少填写一个关键词");
                        continue;
                    }
                    else
                    {
                        if (row[3].ToString().Length > 20)
                        {
                            Mess += String.Format(MessModel, "商机名称：" + row[1].ToString(), MessMis, "关键词1长度应该小于20字");
                            continue;
                        }

                        if (row[4].ToString().Length > 20)
                        {
                            Mess += String.Format(MessModel, "商机名称：" + row[1].ToString(), MessMis, "关键词2长度应该小于20字");
                            continue;
                        }

                        if (row[5].ToString().Length > 20)
                        {
                            Mess += String.Format(MessModel, "商机名称：" + row[1].ToString(), MessMis, "关键词3长度应该小于20字");
                            continue;
                        }
                    }
                    if (row[6].ToString() == "")
                    {
                        Mess += String.Format(MessModel, "商机名称：" + row[1].ToString(), MessMis, "有效期不能为空");
                        continue;
                    }

                    if (row[7].ToString() == "")
                    {
                        Mess += String.Format(MessModel, "商机名称：" + row[1].ToString(), MessMis, "商机描述不能为空");
                        continue;
                    }
               
                }
                if (rowCount == 0)
                {
                    DataColumn MyColumn;
                    for (int i = 0; i < dt.Columns.Count; i++)
                    {
                        MyColumn = dp.Columns.Add(i.ToString(), typeof(string));

                    }
                }
                DataRow dk = dp.NewRow();
                for (int k = 0; k < dt.Columns.Count; k++)
                {
                    dk[k] = row[k];
                }
                dp.Rows.Add(dk);
                rowCount++;   
            }
            if (nullCount == dt.Rows.Count)
            {
                Mess += String.Format(MessModel, "至少填入1行数据", "", "");
            }

            if (dp.Rows.Count > 0 && Mess=="")//当Mess为空,既没有任何错误的时候,执行添加操作
            {
                string strTradeName = "";
                foreach (DataRow dr in dp.Rows)
                {
                    TradeInfo ConInfo = GetTradeInfoByDataRow(dr, intTradeID, intInfoCategory, type);
                    MainOneProduct.Trade.BLL.Trade.Insert(ConInfo);
                    strTradeName = ConInfo.TradeID1Name;
                }
                Mess += String.Format(MessModel, "您上传了" + dp.Rows.Count + "条信息", "<br/>产品分类为:   " + strTradeName, "");
                str[0] = "";
                str[1] = Mess;
               
            }
            else
            {
                str[0] = "Error";
                str[1] = Mess;
            }
            return str;
        }
       /// <summary>
        /// 产品/商机批量新增填充方法
       /// </summary>
       /// <param name="row">要添加的一行数据信息</param>
       /// <param name="intTradeID">行业ID</param>
       /// <param name="intInfoCategory">分类ID</param>
       /// <param name="type">0:产品信息,1:商机信息</param>
       /// <returns></returns>
        private static TradeInfo GetTradeInfoByDataRow(DataRow row, int intTradeID, int intInfoCategory,int type)
        {
           
            TradeInfo info = new TradeInfo();
            /*产品信息*/
            if (type == 0)
            {
                info.UserID = MainOneProduct.Member.BLL.User.CurrentUserID;
                info.IsProduct = true;
                info.IsTrade = false;
                info.Title = row[0].ToString().Trim();//产品名称
                string strSign = "无标志";
                strSign = row[1].ToString().Trim();//产品标志
                if (strSign.Equals("热销产品"))
                    info.HotProduct = 1;
                if (strSign.Equals("新品上架"))
                    info.NewProduct = 1;
                if (strSign.Equals("打折促销"))
                    info.Rebate = 1;
                if (strSign.Equals("加急"))
                    info.Instancy = 1;

                info.keyWord1 = row[2].ToString().Trim();//关键字
                info.keyWord2 = row[3].ToString().Trim();
                info.keyWord3 = row[4].ToString().Trim();
                info.P_Brand = row[5].ToString().Trim();//品牌
                info.P_Texture = row[6].ToString().Trim();//材质
                info.P_Spec = row[7].ToString().Trim();//规格
                info.P_Packing = row[8].ToString().Trim();//包装
                info.Content = row[9].ToString().Trim();
                if (row[10].ToString().Trim().Equals(""))
                {
                    info.T_ProvideType = "其它";
                }
                else
                {
                    info.T_ProvideType = row[10].ToString().Trim();//供应商类型
                }
                info.T_Unit = row[11].ToString().Trim();//计量单位
                info.T_MaxCount = row[12].ToString().Trim();//供应总量
                info.T_MinCount = row[13].ToString().Trim();//最小起订量
                if (row[14].ToString().Trim()!="")
                    info.Price = double.Parse(row[14].ToString().Trim()).ToString("0.00");//产品单价
                info.T_DeliveryExplain = row[15].ToString().Trim();//交货方式
                info.T_TransportationExplain = row[17].ToString().Trim();//货品运输
                if (row[16].ToString().Trim()!="")
                    info.T_Freight = double.Parse(row[16].ToString().Trim()).ToString("0.00");//运费
                string strDeliveryDate = "";
                strDeliveryDate = row[18].ToString().Trim();
                if(strDeliveryDate=="")
                    info.T_DeliveryDate = "0";//发货期限
                if (strDeliveryDate.Equals("1天"))
                    info.T_DeliveryDate = "1";
                if (strDeliveryDate.Equals("3天内"))
                    info.T_DeliveryDate = "3";
                if (strDeliveryDate.Equals("1周内"))
                    info.T_DeliveryDate = "7";
                if (strDeliveryDate.Equals("半月内"))
                    info.T_DeliveryDate = "15";
                if (strDeliveryDate.Equals("1月内"))
                    info.T_DeliveryDate = "30";
                if (strDeliveryDate.Equals("3月内"))
                    info.T_DeliveryDate = "90";
           
                    info.IsBuy = 0;//在线订购默认为不支持
            
                info.TradeID1 = intTradeID;
                info.ProductCategory = intInfoCategory;
            }
            else
            {
                /*====这里是商机的======================================*/
                info.UserID = MainOneProduct.Member.BLL.User.CurrentUserID;
                info.IsProduct = false;
                info.IsTrade = true;
                info.TradeID1 = intTradeID;
                info.InfoCategory = intInfoCategory;

                info.Title = row[1].ToString().Trim();
                if (GetIntTradeFlag(row[2].ToString().Trim())==1)
                    info.Rebate = 1;
                else if (GetIntTradeFlag(row[2].ToString().Trim()) == 2)
                    info.Instancy = 1;
                else if (GetIntTradeFlag(row[2].ToString().Trim()) == 3)
                    info.NewProduct = 1;
                else if (GetIntTradeFlag(row[2].ToString().Trim()) == 4)
                    info.HotProduct = 1;
                info.keyWord1 = row[3].ToString().Trim();
                info.keyWord2 = row[4].ToString().Trim();
                info.keyWord3 = row[5].ToString().Trim();
                info.IntValidityDay = GetIntValidityDay(row[6].ToString().Trim());
                info.OutTime = DateTime.Now.AddDays(GetIntValidityDay(row[6].ToString().Trim()));
                info.Content = row[7].ToString().Trim();

               //产品、加工、批发、库存
                if (intInfoCategory >= 1 && intInfoCategory <= 4)
                {
                    if (row[0].ToString().Trim() == "供应")
                    {
                        info.IsSupplyTrade = true;
                        info.T_ProvideType = row[12].ToString().Trim();
                        info.T_MaxCount = row[14].ToString().Trim();
                        info.T_MinCount = row[15].ToString().Trim();
                        info.T_Freight = row[18].ToString().Trim();
                        info.T_DeliveryDate = GetIntDeliveryDate(row[20].ToString().Trim());
                        info.IsBuy = row[21].ToString().Trim() == "是" ? 1 : 0;
                    }
                    else if (row[0].ToString().Trim() == "求购")
                    {
                        info.IsSupplyTrade = false;
                        info.T_NeedCount = row[14].ToString().Trim();
                    }
                    info.P_Brand = row[8].ToString().Trim();
                    info.P_Texture = row[9].ToString().Trim();
                    info.P_Spec = row[10].ToString().Trim();
                    info.P_Packing = row[11].ToString().Trim();
                    info.T_Unit = row[13].ToString().Trim();
                    info.Price = row[16].ToString().Trim();
                    info.T_DeliveryExplain = row[17].ToString().Trim();
                    info.T_TransportationExplain = row[19].ToString().Trim();
       
                }
                if (intInfoCategory == 5)//二手
                {
                    if (row[0].ToString().Trim() == "供应")
                    {
                        info.IsSupplyTrade = true;
                        info.T_MaxCount = row[14].ToString().Trim();
                        info.T_MinCount = row[15].ToString().Trim();
                        info.T_Freight = row[18].ToString().Trim();
                        info.T_DeliveryDate = GetIntDeliveryDate(row[20].ToString().Trim());
                        info.IsBuy = row[21].ToString().Trim() == "是" ? 1 : 0;
                    }
                    else if (row[0].ToString().Trim() == "求购")
                    {
                        info.IsSupplyTrade = false;
                        info.T_NeedCount = row[14].ToString().Trim();
                     
                    }
                    info.P_Brand = row[8].ToString().Trim();
                    info.P_Texture = row[9].ToString().Trim();
                    info.P_Depreciation = row[10].ToString().Trim();
                    info.P_Spec = row[11].ToString().Trim();
                    info.P_Packing = row[12].ToString().Trim();
                    info.T_Unit = row[13].ToString().Trim();
                    info.Price = row[16].ToString().Trim();
                    info.T_DeliveryExplain = row[17].ToString().Trim();
                    info.T_TransportationExplain = row[19].ToString().Trim();
                }
                if (intInfoCategory == 6)//招商加盟
                {
                    if (row[0].ToString().Trim() == "供应")
                    {
                        info.IsSupplyTrade = true;
                        info.T_MaxCount = row[10].ToString().Trim();
                        info.T_MinCount = row[11].ToString().Trim();
                    
                    }
                    else if (row[0].ToString().Trim() == "求购")
                    {
                        info.IsSupplyTrade = false;
                        info.T_NeedCount = row[10].ToString().Trim();
                    }
                    info.P_Brand = row[8].ToString().Trim();
                    info.T_Unit = row[9].ToString().Trim();
                    info.Price = row[12].ToString().Trim();
                    info.T_JoinFee = row[13].ToString().Trim();
                    info.T_Bail = row[14].ToString().Trim();
                    info.T_Bankroll = row[15].ToString().Trim();
                    info.T_BargainTime = row[16].ToString().Trim();
                    info.T_DeliveryExplain = row[17].ToString().Trim();
                    info.T_TransportationExplain = row[18].ToString().Trim();
                }
                if (intInfoCategory == 7)//项目合作
                {
                    if (row[0].ToString().Trim() == "供应")
                    {
                        info.IsSupplyTrade = true;
                        info.T_MaxCount = row[9].ToString().Trim();
                        info.T_MinCount = row[10].ToString().Trim();
                    }
                    else if (row[0].ToString().Trim() == "求购")
                    {
                        info.IsSupplyTrade = false;
                        info.T_NeedCount = row[9].ToString().Trim();
                    }
                    info.T_Unit = row[8].ToString().Trim();
                    info.Price = row[11].ToString().Trim();
                    info.T_BargainTime = row[12].ToString().Trim();
                    info.T_Locus = row[13].ToString().Trim();
                    info.T_DeliveryExplain = row[14].ToString().Trim();
                    info.T_TransportationExplain = row[15].ToString().Trim();
                }
                if (intInfoCategory == 8)//商业服务
                {
                    if (row[0].ToString().Trim() == "供应")
                    {
                        info.IsSupplyTrade = true;
                        info.T_MaxCount = row[9].ToString().Trim();
                        info.T_MinCount = row[10].ToString().Trim();
                    }
                    else if (row[0].ToString().Trim() == "求购")
                    {
                        info.IsSupplyTrade = false;
                        info.T_NeedCount = row[9].ToString().Trim();
                    }
                    info.T_Unit = row[8].ToString().Trim();
                    info.Price = row[11].ToString().Trim();
                    info.T_BargainTime = row[12].ToString().Trim();
                }
            }

            return info;
        }

        /// <summary>
        /// 得到有效期int值
        /// </summary>
        /// <param name="strValidityDay"></param>
        /// <returns></returns>
        protected static int GetIntValidityDay(string strValidityDay)
        {
            switch (strValidityDay.Trim())
            {
                case "1天":
                    return 1;
                case "2天":
                    return 2;
                case "3天":
                    return 3;
                case "4天":
                    return 4;
                case "5天":
                    return 5;
                case "7天":
                    return 7;
                case "15天":
                    return 15;
                case "1个月":
                    return 30;
                case "3个月":
                    return 90;
                case "6个月":
                    return 180;
                default:
                    return 1;
            }
        }

        /// <summary>
        /// 得到商机标志int值
        /// </summary>
        /// <param name="strFlag"></param>
        /// <returns></returns>
        protected static int GetIntTradeFlag(string strFlag)
        {
            switch (strFlag.Trim())
            {
                case "无标志":
                    return 0;
                case "打折促销":
                    return 1;
                case "加急":
                    return 2;
                case "新品上架":
                    return 3;
                case "热销产品":
                    return 4;
                default:
                    return 0;
            }
        }

        /// <summary>
        /// 得到发货期限int值
        /// </summary>
        /// <param name="strDeliveryDate"></param>
        /// <returns></returns>
        protected static string GetIntDeliveryDate(string strDeliveryDate)
        {
            switch (strDeliveryDate)
            {
                case "":
                    return "0";
                case "1天":
                    return "1";
                case "3天内":
                    return "3";
                case "1周内":
                    return "7";
                case "半月内":
                    return "15";
                case "1月内":
                    return "30";
                case "3月内":
                    return "90";
                default:
                    return "0";
            }
        }
    }
}