Exemplo n.º 1
0
        /// <summary>
        ///  更改回文本方式
        /// </summary>
        /// <param name="cell"></param>
        /// <returns></returns>
        public void CheckTextBox(DataGridViewCell cell)
        {
            if (cell.Value == null)
            {
                return;
            }
            cell.Style.BackColor = Color.White;
            string context = cell.Value.ToString();

            if (context.Trim() == "")     //空白直接返回
            {
                return;
            }
            //语法错误的
            if (context.Contains(",") || context.Contains("'"))
            {
                cell.Style.BackColor = Color.Green;
                return;
            }
            switch (cell.ColumnIndex)
            {
            case 4:      //箱子重量  重新录入
                if (cell.Value != null)
                {
                    try
                    {
                        double.Parse(cell.Value.ToString());
                        cell.Style.BackColor = Color.White;
                        if (double.Parse(cell.Value.ToString()) <= 0)
                        {
                            cell.Style.BackColor = Color.Brown;
                        }
                    }
                    catch (Exception)
                    {
                        cell.Style.BackColor = Color.Red;
                    }
                }
                else
                {
                    //当为空时候的判断 是否是空箱
                    cell.Value           = "0";
                    cell.Style.BackColor = Color.Red;
                }
                break;

            case 5:        //箱子型
                BoxSize bs = new BaseService <BoxSize>().GetRecord(" name='" + context + "'");
                if (string.IsNullOrEmpty(bs.ID))
                {
                    cell.Style.BackColor = Color.Red;
                }
                break;

            case 7:        //船公司
                Company company = new BaseService <Company>().GetRecord(" name='" + context + "' or code='" + context + "'");
                if (string.IsNullOrEmpty(company.ID))
                {
                    cell.Style.BackColor = Color.Red;
                }
                else
                {
                    cell.Value = company.Name;
                }
                break;

            case 8:      //目的港
                Aim aim = new BaseService <Aim>().GetRecord(" name='" + context + "' or code='" + context + "'");
                if (string.IsNullOrEmpty(aim.ID))
                {
                    cell.Style.BackColor = Color.Red;
                }
                else
                {
                    cell.Value = aim.Name;
                }
                break;

            case 9:       //货种
                GoodsType goodstype = new BaseService <GoodsType>().GetRecord(" name='" + context + "' or code='" + context + "'");
                if (string.IsNullOrEmpty(goodstype.ID))
                {
                    cell.Style.BackColor = Color.Red;
                }
                else
                {
                    cell.Value = goodstype.Name;
                    GoodsTypeUp goodsup = new BaseService <GoodsTypeUp>().GetRecord(" code='" + goodstype.UpID + "'");
                    if (string.IsNullOrEmpty(goodsup.ID))
                    {
                        cell.Style.BackColor = Color.Yellow;
                    }
                }
                break;

            case 10:
                WorkPlace workplace = new BaseService <WorkPlace>().GetRecord(" name='" + context + "' or code='" + context + "'");
                if (string.IsNullOrEmpty(workplace.ID))
                {
                    cell.Style.BackColor = Color.Red;
                }
                else
                {
                    cell.Value = workplace.Name;
                }
                break;

            case 11:
                Proxy proxy = new BaseService <Proxy>().GetRecord(" name='" + context + "' or code='" + context + "'");
                if (string.IsNullOrEmpty(proxy.ID))
                {
                    cell.Style.BackColor = Color.Red;
                }
                else
                {
                    cell.Value = proxy.Name;
                }
                break;

            case 14:
                Source source = new BaseService <Source>().GetRecord(" name='" + context + "' or code='" + context + "'");
                if (string.IsNullOrEmpty(source.ID))
                {
                    cell.Style.BackColor = Color.Red;
                }
                else
                {
                    cell.Value = source.Name;
                }
                break;

            case 15:
                Direction direction = new BaseService <Direction>().GetRecord(" name='" + context + "' or code='" + context + "'");
                if (string.IsNullOrEmpty(direction.ID))
                {
                    cell.Style.BackColor = Color.Red;
                }
                else
                {
                    cell.Value = direction.Name;
                }
                break;

            case 16:
                SendPlace sendplace = new BaseService <SendPlace>().GetRecord(" name='" + context + "' or code='" + context + "'");
                if (string.IsNullOrEmpty(sendplace.ID))
                {
                    cell.Style.BackColor = Color.Red;
                }
                else
                {
                    cell.Value = sendplace.Name;
                }
                break;

            case 6:
                BoxState boxstate = new BaseService <BoxState>().GetRecord(" name='" + context + "'");
                if (string.IsNullOrEmpty(boxstate.ID))
                {
                    cell.Style.BackColor = Color.Red;
                }
                break;
            }
            return;
        }
Exemplo n.º 2
0
        /// <summary>
        /// 校验数据个列合法性
        /// </summary>
        /// <param name="dgv"></param>
        /// <param name="b"></param>
        /// <returns></returns>
        private void CheckItemData(DataGridViewRow dgvRow, Bill b, ref Dictionary <string, int> boxnumber, ref int errorint, ref double weight)
        {
            #region ID号
            dgvRow.Cells["dgvExcelID"].Value = b.ID;
            #endregion

            #region 序号
            if (b.Sequence != null)
            {
                dgvRow.Cells["dgvExcelSequence"].Value = b.Sequence;
                try
                {
                    int.Parse(b.Sequence);
                    dgvRow.Cells["dgvExcelSequence"].Style.BackColor = Color.White;
                }
                catch (Exception)
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelSequence"].Style.BackColor = Color.Red;
                }
                if (b.Sequence.Contains(",") || b.Sequence.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelSequence"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelSequence"].Value = "";
            }
            #endregion

            #region 箱子号
            if (b.BoxNo != null)
            {
                dgvRow.Cells["dgvExcelBoxNo"].Value = b.BoxNo;
                if (b.BoxNo.Contains(",") || b.BoxNo.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelBoxNo"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelBoxNo"].Value = "";
            }
            #endregion

            #region 封号
            if (b.SealNo != null)
            {
                dgvRow.Cells["dgvExcelSealNo"].Value = b.SealNo;
                if (b.SealNo.Contains(",") || b.SealNo.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelSealNo"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelSealNo"].Value = "";
            }
            #endregion

            #region 重量
            if (b.Weight != null)
            {
                dgvRow.Cells["dgvExcelWeight"].Value = b.Weight;
                try
                {
                    double singleweigth = double.Parse(b.Weight);
                    dgvRow.Cells["dgvExcelWeight"].Style.BackColor = Color.White;
                    if (b.BoxState == CommValue.BoxState[0])                   //如果重的 重量大于系数
                    {
                        if (b.BoxSize.Substring(0, 2) == CommValue.BoxSize[0]) //20长的 要大于2.3
                        {
                            if (singleweigth <= CommValue.SingleCoefficient)
                            {
                                dgvRow.Cells["dgvExcelWeight"].Style.BackColor = Color.Brown;
                            }
                        }
                        else
                        {
                            //如果是40长的箱子
                            if (singleweigth <= CommValue.DoubleCoefficient)
                            {
                                dgvRow.Cells["dgvExcelWeight"].Style.BackColor = Color.Brown;
                            }
                        }
                    }
                    else
                    {
                        //如果是空的箱子 则直接可以赋值
                        if (b.BoxSize.Substring(0, 2) == CommValue.BoxSize[0])   //20长的
                        {
                            if (b.Weight != CommValue.SingleCoefficient.ToString())
                            {
                                dgvRow.Cells["dgvExcelWeight"].Style.BackColor = Color.Yellow;
                            }
                        }
                        else
                        {
                            if (b.Weight != CommValue.DoubleCoefficient.ToString())
                            {
                                dgvRow.Cells["dgvExcelWeight"].Style.BackColor = Color.Yellow;
                            }
                        }
                    }

                    weight += double.Parse(b.Weight);
                }
                catch (Exception)
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelWeight"].Style.BackColor = Color.Red;
                }
                if (b.Weight.Contains(",") || b.Weight.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelWeight"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                //当为空时候的判断 是否是空箱
                if (b.BoxState == CommValue.BoxState[1])                   //是否为空箱子
                {
                    if (b.BoxSize.Substring(0, 2) == CommValue.BoxSize[0]) //20长的
                    {
                        dgvRow.Cells["dgvExcelWeight"].Value = CommValue.SingleCoefficient.ToString();
                        b.Weight = CommValue.SingleCoefficient.ToString();
                    }
                    else
                    {
                        dgvRow.Cells["dgvExcelWeight"].Value = (CommValue.DoubleCoefficient).ToString();
                        b.Weight = (CommValue.DoubleCoefficient).ToString();
                    }
                }
                else
                {
                    dgvRow.Cells["dgvExcelWeight"].Value           = "0";
                    dgvRow.Cells["dgvExcelWeight"].Style.BackColor = Color.Red;
                }
            }
            #endregion

            #region 箱子型号
            if (b.BoxSize != null)
            {
                dgvRow.Cells["dgvExcelBoxSize"].Value = b.BoxSize;
                if (!string.IsNullOrEmpty(new BaseService <BoxSize>().GetRecord(" name='" + b.BoxSize + "'").ID))
                {
                    boxnumber[b.BoxSize]++;
                    dgvRow.Cells["dgvExcelBoxSize"].Style.BackColor = Color.White;
                }
                else
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelBoxSize"].Style.BackColor = Color.Red;
                }
                if (b.BoxSize.Contains(",") || b.BoxSize.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelBoxSize"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelBoxSize"].Value = "";
            }
            #endregion

            #region 箱子状态
            if (b.BoxState != null)
            {
                dgvRow.Cells["dgvExcelBoxState"].Value = b.BoxState;
                if (CommValue.BoxState.Contains(b.BoxState))     //利用常量数组来完成比较
                {
                    dgvRow.Cells["dgvExcelBoxState"].Style.BackColor = Color.White;
                }
                else
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelBoxState"].Style.BackColor = Color.Red;
                }
                if (b.BoxState.Contains(",") || b.BoxState.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelBoxState"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelBoxState"].Value = "";
            }
            #endregion

            #region 船公司
            if (b.Company != null)
            {
                dgvRow.Cells["dgvExcelCompany"].Value = b.Company;
                if (!string.IsNullOrEmpty(new BaseService <Company>().GetRecord(" name='" + b.Company + "'").ID))
                {
                    dgvRow.Cells["dgvExcelCompany"].Style.BackColor = Color.White;
                }
                else
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelCompany"].Style.BackColor = Color.Red;
                }
                if (b.Company.Contains(",") || b.Company.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelCompany"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelCompany"].Value = "";
            }
            #endregion

            #region 目的港
            if (b.Aim != null)
            {
                dgvRow.Cells["dgvExcelAim"].Value = b.Aim;
                if (b.BoxState != "空" || (!string.IsNullOrEmpty(b.Aim)))     //空船必须判断
                {
                    if (!string.IsNullOrEmpty(new BaseService <Aim>().GetRecord(" name='" + b.Aim + "' ").ID))
                    {
                        dgvRow.Cells["dgvExcelAim"].Style.BackColor = Color.White;
                    }
                    else
                    {
                        errorint++;
                        dgvRow.Cells["dgvExcelAim"].Style.BackColor = Color.Red;
                    }
                }
                if (b.Aim.Contains(",") || b.Aim.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelAim"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelAim"].Value = "";
            }
            #endregion

            #region 货种
            if (b.GoodsType != null)
            {
                dgvRow.Cells["dgvExcelGoodsType"].Value = b.GoodsType;
                if (b.BoxState != "空" || (!string.IsNullOrEmpty(b.GoodsType)))
                {
                    GoodsType goods = new BaseService <GoodsType>().GetRecord(" name='" + b.GoodsType + "'");
                    if (!string.IsNullOrEmpty(goods.ID))
                    {
                        //如果没有上级的则出现另类颜色
                        if (!string.IsNullOrEmpty(goods.UpID) && goods.UpID != "0")
                        {
                            dgvRow.Cells["dgvExcelGoodsType"].Style.BackColor = Color.White;
                        }
                        else
                        {
                            dgvRow.Cells["dgvExcelGoodsType"].Style.BackColor = Color.Yellow;       //黄色的为没定义上一 级货种
                        }
                    }
                    else
                    {
                        errorint++;
                        dgvRow.Cells["dgvExcelGoodsType"].Style.BackColor = Color.Red;        //红色为错误的格式,无对应记录内容
                    }
                }
                if (b.GoodsType.Contains(",") || b.GoodsType.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelGoodsType"].Style.BackColor = Color.Green;            //非法字符
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelGoodsType"].Value = "";
            }
            #endregion

            #region 工作地点
            if (b.WorkPlace != null)
            {
                dgvRow.Cells["dgvExcelWorkPlace"].Value = b.WorkPlace;
                if (!string.IsNullOrEmpty(new BaseService <WorkPlace>().GetRecord(" name='" + b.WorkPlace + "'").ID))
                {
                    dgvRow.Cells["dgvExcelWorkPlace"].Style.BackColor = Color.White;
                }
                else
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelWorkPlace"].Style.BackColor = Color.Red;
                }
                if (b.WorkPlace.Contains(",") || b.WorkPlace.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelWorkPlace"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelWorkPlace"].Value = "";
            }
            #endregion

            #region 代理
            if (b.Proxy != null)
            {
                dgvRow.Cells["dgvExcelProxy"].Value = b.Proxy;
                if (b.BoxState != "空" || (!string.IsNullOrEmpty(b.Proxy)))
                {
                    if (!string.IsNullOrEmpty(new BaseService <Proxy>().GetRecord(" name='" + b.Proxy + "'").ID))
                    {
                        dgvRow.Cells["dgvExcelProxy"].Style.BackColor = Color.White;
                    }
                    else
                    {
                        errorint++;
                        dgvRow.Cells["dgvExcelProxy"].Style.BackColor = Color.Red;
                    }
                }
                if (b.Proxy.Contains(",") || b.Proxy.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelProxy"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelProxy"].Value = "";
            }
            #endregion

            #region 船舶名称
            if (b.ShipName != null)
            {
                dgvRow.Cells["dgvExcelShipName"].Value = b.ShipName;
                if (b.ShipName.Contains(",") || b.ShipName.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelShipName"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelShipName"].Value = "";
            }
            #endregion

            #region 运单号
            if (b.WayBillNo != null)
            {
                dgvRow.Cells["dgvExcelWayBillNo"].Value = b.WayBillNo;
                if (b.WayBillNo.Contains(",") || b.WayBillNo.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelWayBillNo"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelWayBillNo"].Value = "";
            }
            #endregion

            #region 来源地
            if (b.Source != null)
            {
                dgvRow.Cells["dgvExcelSource"].Value = b.Source;
                if (b.BoxState != "空" || (!string.IsNullOrEmpty(b.Source)))
                {
                    if (!string.IsNullOrEmpty(new BaseService <Source>().GetRecord(" name='" + b.Source + "'").ID))
                    {
                        dgvRow.Cells["dgvExcelSource"].Style.BackColor = Color.White;
                    }
                    else
                    {
                        errorint++;
                        dgvRow.Cells["dgvExcelSource"].Style.BackColor = Color.Red;
                    }
                }
                if (b.Source.Contains(",") || b.Source.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelSource"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelSource"].Value = "";
            }
            #endregion

            #region 流向
            if (b.Direction != null)
            {
                dgvRow.Cells["dgvExcelDirection"].Value = b.Direction;
                if (b.BoxState != "空" || (!string.IsNullOrEmpty(b.Direction)))
                {
                    if (!string.IsNullOrEmpty(new BaseService <Direction>().GetRecord(" name='" + b.Direction + "'").ID))
                    {
                        dgvRow.Cells["dgvExcelDirection"].Style.BackColor = Color.White;
                    }
                    else
                    {
                        errorint++;
                        dgvRow.Cells["dgvExcelDirection"].Style.BackColor = Color.Red;
                    }
                }
                if (b.Direction.Contains(",") || b.Direction.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelDirection"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelDirection"].Value = "";
            }
            #endregion

            #region 发往地
            if (b.SendPlace != null)
            {
                dgvRow.Cells["dgvExcelSendPlace"].Value = b.SendPlace;
                if (b.BoxState != "空" || (!string.IsNullOrEmpty(b.SendPlace)))
                {
                    if (!string.IsNullOrEmpty(new BaseService <SendPlace>().GetRecord(" name='" + b.SendPlace + "'").ID))
                    {
                        dgvRow.Cells["dgvExcelSendPlace"].Style.BackColor = Color.White;
                    }
                    else
                    {
                        errorint++;
                        dgvRow.Cells["dgvExcelSendPlace"].Style.BackColor = Color.Red;
                    }
                }
                if (b.SendPlace.Contains(",") || b.SendPlace.Contains("'"))
                {
                    errorint++;
                    dgvRow.Cells["dgvExcelSendPlace"].Style.BackColor = Color.Green;
                }
            }
            else
            {
                dgvRow.Cells["dgvExcelSendPlace"].Value = "";
            }
            #endregion

            #region 备注标注
            dgvRow.Cells["dgvExcelDemo"].Value = b.Demo;
            if (b.Demo.Contains(",") || b.Demo.Contains("'"))
            {
                errorint++;
                dgvRow.Cells["dgvExcelDemo"].Style.BackColor = Color.Green;
            }
            #endregion
        }
Exemplo n.º 3
0
        /// <summary>
        /// 更改成选择方式
        /// </summary>
        /// <param name="cell"></param>
        /// <returns></returns>
        public DataGridViewCell CellToComboBox(DataGridViewCell cell)
        {
            DataGridViewComboBoxCell combox = new DataGridViewComboBoxCell();

            switch (cell.ColumnIndex)
            {
            case 4:      //箱子重量  重新录入
                if (cell.Value != null)
                {
                    try
                    {
                        double.Parse(cell.Value.ToString());
                        cell.Style.BackColor = Color.White;
                    }
                    catch (Exception)
                    {
                        cell.Style.BackColor = Color.Red;
                    }
                }
                else
                {
                    //当为空时候的判断 是否是空箱
                    cell.Value           = "0";
                    cell.Style.BackColor = Color.Red;
                }
                break;

            case 5:        //箱子型
                List <BoxSize> bs = new BaseService <BoxSize>().GetRecords(" 1=1");
                combox.DataSource    = bs;
                combox.ValueMember   = "Name";
                combox.DisplayMember = "Name";
                combox.Value         = cell.Value.ToString();
                cell = combox;
                break;

            case 7:        //船公司
                List <Company> cp = new BaseService <Company>().GetRecords(" 1=1");
                cp.Insert(0, new Company()
                {
                    ID = "0", Name = ""
                });
                combox.DataSource    = cp;
                combox.ValueMember   = "Name";
                combox.DisplayMember = "Name";
                combox.Value         = cell.Value.ToString();
                cell = combox;
                break;

            case 8:      //目的港
                List <Aim> ai = new BaseService <Aim>().GetRecords(" 1=1");
                ai.Insert(0, new Aim()
                {
                    ID = "0", Name = ""
                });
                combox.DataSource    = ai;
                combox.ValueMember   = "Name";
                combox.DisplayMember = "Name";
                combox.Value         = cell.Value.ToString();
                cell = combox;
                break;

            case 9:       //货种
                List <GoodsType> good = new BaseService <GoodsType>().GetRecords(" 1=1");
                good.Insert(0, new GoodsType()
                {
                    ID = "0", Name = ""
                });
                combox.DataSource    = good;
                combox.ValueMember   = "Name";
                combox.DisplayMember = "Name";
                combox.Value         = cell.Value.ToString();
                cell = combox;
                break;

            case 10:
                List <WorkPlace> work = new BaseService <WorkPlace>().GetRecords(" 1=1");
                work.Insert(0, new WorkPlace()
                {
                    ID = "0", Name = ""
                });
                combox.DataSource    = work;
                combox.ValueMember   = "Name";
                combox.DisplayMember = "Name";
                combox.Value         = cell.Value.ToString();
                cell = combox;
                break;

            case 11:
                List <Proxy> proxy = new BaseService <Proxy>().GetRecords(" 1=1");
                proxy.Insert(0, new Proxy()
                {
                    ID = "0", Name = ""
                });
                combox.DataSource    = proxy;
                combox.ValueMember   = "Name";
                combox.DisplayMember = "Name";
                combox.Value         = cell.Value.ToString();
                cell = combox;
                break;

            case 14:
                List <Source> source = new BaseService <Source>().GetRecords(" 1=1");
                source.Insert(0, new Source()
                {
                    ID = "0", Name = ""
                });
                combox.DataSource    = source;
                combox.ValueMember   = "Name";
                combox.DisplayMember = "Name";
                combox.Value         = cell.Value.ToString();
                cell = combox;
                break;

            case 15:
                List <Direction> dt = new BaseService <Direction>().GetRecords(" 1=1");
                dt.Insert(0, new Direction()
                {
                    ID = "0", Name = ""
                });
                combox.DataSource    = dt;
                combox.ValueMember   = "Name";
                combox.DisplayMember = "Name";
                combox.Value         = cell.Value.ToString();
                cell = combox;
                break;

            case 16:
                List <SendPlace> send = new BaseService <SendPlace>().GetRecords(" 1=1");
                send.Insert(0, new SendPlace()
                {
                    ID = "0", Name = ""
                });
                combox.DataSource    = send;
                combox.ValueMember   = "Name";
                combox.DisplayMember = "Name";
                combox.Value         = cell.Value.ToString();
                cell = combox;
                break;

            case 17:
                foreach (string item in CommValue.BoxVirtual)
                {
                    combox.Items.Add(item);
                }
                combox.Value = cell.Value.ToString();
                cell         = combox;
                break;

            case 6:
                List <BoxState> state = new BaseService <BoxState>().GetRecords(" 1=1");
                combox.DataSource    = state;
                combox.ValueMember   = "Name";
                combox.DisplayMember = "Name";
                combox.Value         = cell.Value.ToString();
                cell = combox;
                break;
            }

            return(cell);
        }
        /// <summary>
        /// 获取一级货种ID
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public string GetGoodsTypeUpID(string name)
        {
            string id = new BaseService <GoodsTypeUp>().GetRecord(" name='" + name + "' or code='" + name + "'").Code;

            return(string.IsNullOrEmpty(id) ? "0" : id);
        }