Пример #1
0
        /// <summary>
        /// 保存数据方法
        /// </summary>
        private void DataSave()
        {
            OrderBase _OrderBase = new OrderBase();

            #region 销售单实体赋值

            _OrderBase.OA01002 = this.txtOA01002.Text.Trim();
            _OrderBase.OA01003 = this.rbtnOA01003Yes.Checked == true ? 3 : 1;
            _OrderBase.OA01004 = 1;                     //下单
            _OrderBase.OA01005 = this.rbtnOA01005Yes.Checked ? 1 : 0;
            _OrderBase.OA01006 = "";                    //系统订单号
            _OrderBase.OA01007 = "";                    //喷嘴订单号
            _OrderBase.OA01008 = this.txtOA01008.Text.Trim();
            if (!string.IsNullOrEmpty(this.txtOA01009.Text.Trim()))
            {
                _OrderBase.OA01009 = Convert.ToDateTime(this.txtOA01009.Text.Trim());
            }
            if (!string.IsNullOrEmpty(this.txtOA01010.Text.Trim()))
            {
                _OrderBase.OA01010 = Convert.ToDateTime(this.txtOA01010.Text.Trim());
            }
            if (!string.IsNullOrEmpty(this.txtOA01011.Text.Trim()))
            {
                _OrderBase.OA01011 = Convert.ToDateTime(this.txtOA01011.Text.Trim());
            }
            _OrderBase.OA01012 = this.txtOA01012.Text.Trim();
            _OrderBase.OA01013 = this.ddlUA01.SelectedValue;
            _OrderBase.OA01014 = this.txtOA01014.Text.Trim();
            _OrderBase.OA01015 = Request.Form["txtOA01015"].Trim();
            if (!string.IsNullOrEmpty(this.ddlOA01016.SelectedValue))
            {
                _OrderBase.OA01016 = Convert.ToDecimal(this.ddlOA01016.SelectedValue);
            }
            else
            {
                _OrderBase.OA01016 = 0;
            }
            _OrderBase.OA01017 = Request.Form["txtOA01017"].Trim();
            if (!string.IsNullOrEmpty(this.ddlOA01018.SelectedValue))
            {
                _OrderBase.OA01018 = Convert.ToDecimal(this.ddlOA01018.SelectedValue);
            }
            else
            {
                _OrderBase.OA01018 = 0;
            }
            if (!string.IsNullOrEmpty(Request.Form["txtOA01019"].Trim()))
            {
                _OrderBase.OA01019 = Convert.ToDecimal(Request.Form["txtOA01019"].Trim());
            }
            if (!string.IsNullOrEmpty(Request.Form["txtOA01020"].Trim()))
            {
                _OrderBase.OA01020 = Convert.ToDecimal(Request.Form["txtOA01020"].Trim());
            }
            if (!string.IsNullOrEmpty(this.txtOA01021.Text.Trim()))
            {
                _OrderBase.OA01021 = Convert.ToDecimal(this.txtOA01021.Text.Trim());
            }
            if (!string.IsNullOrEmpty(Request.Form["txtOA01022"].Trim()))
            {
                _OrderBase.OA01022 = Convert.ToDecimal(Request.Form["txtOA01022"].Trim());
            }
            if (!string.IsNullOrEmpty(Request.Form["txtOA01023"].Trim()))
            {
                _OrderBase.OA01023 = Convert.ToDecimal(Request.Form["txtOA01023"].Trim().Replace('%', '0')) / 100;
            }
            _OrderBase.OA01024 = this.rbtnOA01024Yes.Checked ? this.txtOA01024.Text.Trim() : string.Empty;
            _OrderBase.OA01025 = Convert.ToInt32(this.ddlOA01025.SelectedValue);
            _OrderBase.OA01026 = this.txtOA01026.Text.Trim();
            _OrderBase.OA01027 = this.txtOA01027.Text.Trim();
            _OrderBase.OA01028 = this.txtOA01028.Text.Trim();
            _OrderBase.OA01029 = this.txtOA01029.Text.Trim();
            _OrderBase.OA01030 = this.txtOA01030.Text.Trim();
            _OrderBase.OA01031 = this.txtOA01031.Text.Trim();
            _OrderBase.OA01032 = this.txtOA01032.Text.Trim();
            _OrderBase.OA01033 = this.txtOA01033.Text.Trim();
            _OrderBase.OA01034 = this.txtOA01034.Text.Trim();
            _OrderBase.OA01035 = this.txtOA01035.Text.Trim();
            _OrderBase.OA01055 = this.ddlUA01.SelectedValue;
            _OrderBase.OA01013 = this.ddlUA01.SelectedValue;

            #region 获取客户的信息
            DataTable dt = new CustomerBLL().SelectCustomerBase(string.Format(" AND CA01001 = '{0}'", Request.QueryString["CA01001"]));
            if (dt.Rows.Count < 1)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('数据异常!');</script>");
                return;
            }
            #endregion

            _OrderBase.OA01036 = dt.Rows[0]["CA01002"].ToString();            //客户编码
            _OrderBase.OA01037 = (Session["USER_SESSION"] as UserBase).UA01001;
            _OrderBase.OA01038 = Convert.ToInt32(dt.Rows[0]["CA01001"]);
            _OrderBase.OA01039 = "";                                         //主订单编号
            if (!string.IsNullOrEmpty(dt.Rows[0]["CA01019"].ToString()))
            {
                _OrderBase.OA01040 = Convert.ToInt32(dt.Rows[0]["CA01019"]);
            }
            if (!string.IsNullOrEmpty(dt.Rows[0]["CA01020"].ToString()))
            {
                _OrderBase.OA01041 = Convert.ToInt32(dt.Rows[0]["CA01020"]);
            }
            if (!string.IsNullOrEmpty(dt.Rows[0]["CA01022"].ToString()))
            {
                _OrderBase.OA01042 = Convert.ToInt32(dt.Rows[0]["CA01022"]);
            }
            if (!string.IsNullOrEmpty(dt.Rows[0]["CA01023"].ToString()))
            {
                _OrderBase.OA01043 = Convert.ToInt32(dt.Rows[0]["CA01023"]);
            }
            _OrderBase.OA01044 = this.rbtnOA01044Yes.Checked ? 1 : 0;
            _OrderBase.OA01045 = this.rbtnOA01045Yes.Checked ? 1 : 0;
            _OrderBase.OA01046 = this.txtOA01046.Text.Trim();
            _OrderBase.OA01047 = this.ddlOA01047.SelectedValue;
            _OrderBase.OA01048 = this.txtOA01048.Text.Trim();
            _OrderBase.OA01049 = this.txtOA01049.Text.Trim();
            _OrderBase.OA01050 = this.txtOA01050.Text.Trim();
            _OrderBase.OA01052 = (Session["USER_SESSION"] as UserBase).UA01001;
            _OrderBase.OA01053 = this.txtOA01053.Text.Trim();
            _OrderBase.OA01054 = int.Parse(ddlOA01054.SelectedValue);
            if (!string.IsNullOrEmpty(this.txtOA01051.Text.Trim()))
            {
                _OrderBase.OA01051 = Convert.ToDateTime(this.txtOA01051.Text.Trim());
            }
            _OrderBase.OA01999 = Guid.NewGuid().ToString();
            _OrderBase.OA01055 = this.ddlOA01055.SelectedValue;
            _OrderBase.OA01056 = this.ddlOA01056.SelectedValue;
            _OrderBase.OA01057 = this.ddlOA01055.SelectedItem.Text.Equals("请选择") ? string.Empty : this.ddlOA01055.SelectedItem.Text;
            _OrderBase.OA01058 = this.ddlOA01056.SelectedItem.Text.Equals("请选择") ? string.Empty : this.ddlOA01056.SelectedItem.Text;

            _OrderBase.OA01060 = Convert.ToDecimal(new AreaBLL().GetSettings().Rows[0]["Value"]);
            #endregion

            #region 销售单明细
            List <OrderProduct> listOrderProduct = new List <OrderProduct>();
            if (!string.IsNullOrEmpty(this.txtmingxi.Value)) //判断是否有订单明细数据
            {
                string   strmingxi = this.txtmingxi.Value;   //获取明细数据
                string[] strrow    = strmingxi.Split(new[] { "_&_" }, StringSplitOptions.None);
                if (strrow.Length > 0)
                {
                    foreach (string itemrow in strrow)
                    {
                        string[] strcolumns = itemrow.Split(new[] { "_^_" }, StringSplitOptions.None);
                        if (strcolumns.Length > 0)
                        {
                            if (strcolumns[0].Trim() != "")
                            {
                                OrderProduct _OrderProduct = new OrderProduct();
                                _OrderProduct.OB01002 = _OrderBase.OA01999;                     //订单编号
                                _OrderProduct.OB01003 = 1;
                                _OrderProduct.OB01004 = Convert.ToInt32(strcolumns[10].Trim()); //商品Id
                                _OrderProduct.OB01005 = strcolumns[0].Trim();                   //商品型号
                                _OrderProduct.OB01006 = strcolumns[1].Trim();                   //商品描述
                                if (!string.IsNullOrEmpty(strcolumns[2].Trim()))
                                {
                                    _OrderProduct.OB01007 = Convert.ToInt32(strcolumns[2].Trim());  //商品数量
                                }
                                if (!string.IsNullOrEmpty(strcolumns[3].Trim()))
                                {
                                    _OrderProduct.OB01008 = Convert.ToDecimal(strcolumns[3].Trim());  //含税单价(含税价格)
                                }
                                if (!string.IsNullOrEmpty(strcolumns[4].Trim()))
                                {
                                    _OrderProduct.OB01009 = Convert.ToDecimal(strcolumns[4].Trim());  //含税总价(含税总计)
                                }
                                if (!string.IsNullOrEmpty(strcolumns[5].Trim()))
                                {
                                    _OrderProduct.OB01010 = Convert.ToDecimal(strcolumns[5].Trim());  //不含税单价(不含税价格)
                                }
                                if (!string.IsNullOrEmpty(strcolumns[6].Trim()))
                                {
                                    _OrderProduct.OB01011 = Convert.ToDecimal(strcolumns[6].Trim());  //不含税总价(不含税总计)
                                }
                                if (!string.IsNullOrEmpty(strcolumns[7].Trim()))
                                {
                                    _OrderProduct.OB01012 = Convert.ToDecimal(strcolumns[7].Trim());  //税额
                                }
                                if (!string.IsNullOrEmpty(strcolumns[8].Trim()))
                                {
                                    _OrderProduct.OB01013 = Convert.ToDecimal(strcolumns[8].Trim());  //单位成本
                                }
                                if (!string.IsNullOrEmpty(strcolumns[9].Trim()))
                                {
                                    _OrderProduct.OB01014 = Convert.ToDecimal(strcolumns[9].Trim()); //合计成本
                                }
                                _OrderProduct.OB01999 = Guid.NewGuid().ToString();                   //GUID
                                listOrderProduct.Add(_OrderProduct);
                            }
                        }
                    }
                }
            }

            #endregion

            #region 销售发票
            List <OrderInvoice> listOrderInvoice = new List <OrderInvoice>();
            if (!string.IsNullOrEmpty(this.txtfapiao.Value)) //判断是否有发票数据
            {
                string   strfapiao = this.txtfapiao.Value;   //获取发票数据
                string[] strrow1   = strfapiao.Split('&');
                if (strrow1.Length > 0)
                {
                    int i = 0;
                    foreach (string itemrow in strrow1)
                    {
                        string[] strcolumns = itemrow.Split('^');
                        if (strcolumns.Length > 0)
                        {
                            OrderInvoice _OrderInvoice = new OrderInvoice();

                            _OrderInvoice.OC01002 = Convert.ToInt32(strcolumns[0].Trim());  //序号
                            _OrderInvoice.OC01003 = listOrderProduct[i].OB01999.ToString(); //商品GUID;
                            _OrderInvoice.OC01004 = 1;                                      //销售单
                            _OrderInvoice.OC01005 = strcolumns[1].Trim();                   //型号
                            if (!string.IsNullOrEmpty(strcolumns[2].Trim()))
                            {
                                _OrderInvoice.OC01006 = Convert.ToInt32(strcolumns[2].Trim());  //数量
                            }
                            if (!string.IsNullOrEmpty(strcolumns[3].Trim()))
                            {
                                _OrderInvoice.OC01007 = Convert.ToInt32(strcolumns[3].Trim() == "N" ? "0" : "1");  //是否到货
                            }
                            if (!string.IsNullOrEmpty(strcolumns[4].Trim()))
                            {
                                _OrderInvoice.OC01008 = strcolumns[4];  //到货批次
                            }
                            if (!string.IsNullOrEmpty(strcolumns[5].Trim()))
                            {
                                _OrderInvoice.OC01009 = Convert.ToDateTime(strcolumns[5].Trim()); //到货时间
                            }
                            if (!string.IsNullOrEmpty(strcolumns[6].Trim()))
                            {
                                _OrderInvoice.OC01010 = Convert.ToInt32(strcolumns[6].Trim() == "N" ? "0" : "1");  //是否到货
                            }
                            if (!string.IsNullOrEmpty(strcolumns[7].Trim()))
                            {
                                _OrderInvoice.OC01011 = Convert.ToDateTime(strcolumns[7].Trim()); //发货时间
                            }
                            _OrderInvoice.OC01012 = strcolumns[8].Trim();
                            _OrderInvoice.OC01013 = strcolumns[9].Trim();
                            if (!string.IsNullOrEmpty(strcolumns[11].Trim()))
                            {
                                _OrderInvoice.OC01014 = Convert.ToInt32(strcolumns[11].Trim() == "N" ? "0" : "1");  //是否开发票
                            }
                            if (!string.IsNullOrEmpty(strcolumns[12].Trim()))
                            {
                                _OrderInvoice.OC01015 = Convert.ToDateTime(strcolumns[12].Trim());//开发票时间
                            }
                            _OrderInvoice.OC01017 = strcolumns[14].Trim();
                            _OrderInvoice.OC01018 = strcolumns[13].Trim();

                            _OrderInvoice.OC01019 = strcolumns[10].Trim();
                            _OrderInvoice.OC01020 = strcolumns[15].Trim();

                            listOrderInvoice.Add(_OrderInvoice);
                            i++;
                        }
                    }
                }
            }

            #endregion

            #region 付款信息

            OrderPayment _OrderPayment = new OrderPayment();
            _OrderPayment.OP01002 = this.labOP01002.InnerText.Trim();
            _OrderPayment.OP01003 = _OrderBase.OA01999; //订单GUID
            if (!string.IsNullOrEmpty(this.txtOA01009.Text.Trim()))
            {
                _OrderPayment.OP01004 = Convert.ToDateTime(this.txtOA01009.Text.Trim());
            }
            if (!string.IsNullOrEmpty(Request.Form["txtOA01020"]))
            {
                _OrderPayment.OP01005 = Convert.ToDecimal(Request.Form["txtOA01020"]);
            }
            //if (!string.IsNullOrEmpty(this.ddlOP01006.SelectedValue)) _OrderPayment.OP01006 = Convert.ToInt32(this.ddlOP01006.SelectedValue);
            if (!string.IsNullOrEmpty(this.txtOP01007.Text.Trim()))
            {
                _OrderPayment.OP01007 = Convert.ToDecimal(this.txtOP01007.Text.Trim());
            }

            _OrderPayment.OP01008 = this.txtOP01008.Text.Trim();

            if (!string.IsNullOrEmpty(this.txtOP01009.Text.Trim()))
            {
                _OrderPayment.OP01009 = Convert.ToDecimal(this.txtOP01009.Text.Trim());
            }

            _OrderPayment.OP01010 = this.txtOP01010.Text.Trim();

            if (!string.IsNullOrEmpty(this.txtOP01011.Text.Trim()))
            {
                _OrderPayment.OP01011 = Convert.ToDecimal(this.txtOP01011.Text.Trim());
            }

            _OrderPayment.OP01012 = this.txtOP01012.Text.Trim();

            if (!string.IsNullOrEmpty(this.txtOP01013.Text.Trim()))
            {
                _OrderPayment.OP01013 = Convert.ToDecimal(this.txtOP01013.Text.Trim());
            }
            if (!string.IsNullOrEmpty(this.txtOP01014.Text.Trim()))
            {
                _OrderPayment.OP01014 = this.txtOP01014.Text.Trim();
            }

            if (!string.IsNullOrEmpty(this.txtOP01023.Text.Trim()))
            {
                _OrderPayment.OP01023 = this.txtOP01023.Text.Trim();
            }

            #region 添加5 6 7付款

            if (!string.IsNullOrEmpty(this.txtOP01017.Text.Trim()))
            {
                _OrderPayment.OP01017 = Convert.ToDecimal(this.txtOP01017.Text.Trim());
            }
            if (!string.IsNullOrEmpty(this.txtOP01018.Text.Trim()))
            {
                _OrderPayment.OP01018 = this.txtOP01018.Text.Trim();
            }
            if (!string.IsNullOrEmpty(this.txtOP01019.Text.Trim()))
            {
                _OrderPayment.OP01019 = Convert.ToDecimal(this.txtOP01019.Text.Trim());
            }
            if (!string.IsNullOrEmpty(this.txtOP01020.Text.Trim()))
            {
                _OrderPayment.OP01020 = this.txtOP01020.Text.Trim();
            }

            if (!string.IsNullOrEmpty(this.txtOP01021.Text.Trim()))
            {
                _OrderPayment.OP01021 = Convert.ToDecimal(this.txtOP01021.Text.Trim());
            }
            if (!string.IsNullOrEmpty(this.txtOP01022.Text.Trim()))
            {
                _OrderPayment.OP01022 = this.txtOP01022.Text.Trim();
            }

            #endregion

            if (!string.IsNullOrEmpty(this.txtOP01015.Value.Trim()))
            {
                _OrderPayment.OP01015 = Convert.ToDecimal(this.txtOP01015.Value.Trim());
            }

            if (!string.IsNullOrEmpty(this.txtOP01016.Value.Trim()))
            {
                _OrderPayment.OP01016 = Convert.ToDecimal(this.txtOP01016.Value.Trim());
            }

            #endregion

            int result = Math.Abs(_OrderBLL.AddOrderBase(_OrderBase, listOrderProduct, listOrderInvoice, _OrderPayment));

            new Sinoo.Common.MessageShow().InsertMessage(this, result, string.Format("location.href='OA0101List.aspx?PageIndex={0}'", Request.QueryString["PageIndex"]));
        }
Пример #2
0
        /// <summary>
        /// 保存数据
        /// </summary>
        private void DataSave()
        {
            #region 退货订单

            DataTable dt = _OrderBLL.SelectOrderBaseByCustomerId(this.txtOA01039.Text.Trim()); //根据订单查询客户编码

            OrderBase _OrderBase = new OrderBase();
            _OrderBase.OA01002 = this.txtOA01002.Text.Trim();
            _OrderBase.OA01003 = 2;  //退货单
            _OrderBase.OA01004 = 1;  //下单
            _OrderBase.OA01008 = this.txtOA01008.Text.Trim();
            _OrderBase.OA01009 = Convert.ToDateTime(this.txtOA01009.Text.Trim());
            _OrderBase.OA01015 = Request.Form["txtOA01015"];
            _OrderBase.OA01016 = 0;
            _OrderBase.OA01017 = Request.Form["txtOA01017"];
            _OrderBase.OA01018 = 0;
            _OrderBase.OA01020 = string.IsNullOrEmpty(this.txtOA01020.Value.Trim()) || this.txtOA01020.Value.Trim() == ""
                ? 0
                : Convert.ToDecimal("-" + this.txtOA01020.Value.Trim());
            _OrderBase.OA01021 = string.IsNullOrEmpty(this.txtOA01021.Value.Trim()) || this.txtOA01021.Value.Trim() == ""
                ? 0
                : Convert.ToDecimal(this.txtOA01021.Value.Trim());
            _OrderBase.OA01022 = string.IsNullOrEmpty(this.txtOA01022.Value.Trim()) || this.txtOA01022.Value.Trim() == ""
                ? 0
                : Convert.ToDecimal("-" + this.txtOA01022.Value.Trim());
            _OrderBase.OA01027 = this.txtOA01027.Text.Trim();
            _OrderBase.OA01036 = dt.Rows[0]["OA01036"].ToString();       //客户编码
            _OrderBase.OA01038 = Convert.ToInt32(dt.Rows[0]["OA01038"]); //客户Id
            _OrderBase.OA01039 = dt.Rows[0]["OA01039"].ToString();       //注订单编号
            if (!(dt.Rows[0]["OA01040"] is DBNull))
            {
                _OrderBase.OA01040 = Convert.ToInt32(dt.Rows[0]["OA01040"]); //行业分类
            }
            if (!(dt.Rows[0]["OA01041"] is DBNull))
            {
                _OrderBase.OA01041 = Convert.ToInt32(dt.Rows[0]["OA01041"]); //行业代码
            }
            if (!(dt.Rows[0]["OA01042"] is DBNull))
            {
                _OrderBase.OA01042 = Convert.ToInt32(dt.Rows[0]["OA01042"]);  //204电子分类
            }
            if (!(dt.Rows[0]["OA01043"] is DBNull))
            {
                _OrderBase.OA01043 = Convert.ToInt32(dt.Rows[0]["OA01043"]);  //220汽车分类
            }
            if (!(dt.Rows[0]["OA01044"] is DBNull))
            {
                _OrderBase.OA01044 = Convert.ToInt32(dt.Rows[0]["OA01044"]);  //是否为新客户
            }
            _OrderBase.OA01039 = this.txtOA01039.Text.Trim();
            _OrderBase.OA01049 = this.txtOA01049.Text.Trim();
            _OrderBase.OA01050 = this.txtOA01050.Text.Trim();
            _OrderBase.OA01013 = this.txtOA01013.Value;
            if (ddlOA01016.SelectedValue != "")
            {
                _OrderBase.OA01016 = Convert.ToDecimal(ddlOA01016.SelectedValue);
            }
            if (ddlOA01018.SelectedValue != "")
            {
                _OrderBase.OA01018 = Convert.ToDecimal(ddlOA01018.SelectedValue);
            }
            _OrderBase.OA01025 = Convert.ToInt32(ddlOA01025.SelectedValue);

            _OrderBase.OA01052 = (Session["USER_SESSION"] as UserBase).UA01001;
            _OrderBase.OA01060 = Convert.ToDecimal(new AreaBLL().GetSettings().Rows[0]["Value"]);
            _OrderBase.OA01999 = Guid.NewGuid().ToString();
            if (rbtnOA01005No.Checked)
            {
                _OrderBase.OA01005 = 0;
            }
            if (rbtnOA01005Yew.Checked)
            {
                _OrderBase.OA01005 = 1;
            }

            #endregion

            #region 退货订单明细
            List <OrderProduct> listOrderProduct = new List <OrderProduct>();
            if (!string.IsNullOrEmpty(this.txtmingxi.Value)) //判断是否有订单明细数据
            {
                string   strmingxi = this.txtmingxi.Value;   //获取明细数据
                string[] strrow    = strmingxi.Split(new[] { "_&_" }, StringSplitOptions.None);

                if (strrow.Length > 0)
                {
                    foreach (string itemrow in strrow)
                    {
                        string[] strcolumns = itemrow.Split(new[] { "_^_" }, StringSplitOptions.None);
                        if (strcolumns.Length > 0)
                        {
                            if (strcolumns[0].Trim() != "")
                            {
                                OrderProduct _OrderProduct = new OrderProduct();
                                _OrderProduct.OB01002 = _OrderBase.OA01999;                     //订单GUID
                                _OrderProduct.OB01003 = 2;
                                _OrderProduct.OB01004 = Convert.ToInt32(strcolumns[10].Trim()); //商品Id
                                _OrderProduct.OB01005 = strcolumns[0].ToString().Trim();        //商品型号
                                _OrderProduct.OB01006 = strcolumns[1].ToString().Trim();        //商品描述
                                if (strcolumns[2].Trim() != "")
                                {
                                    _OrderProduct.OB01007 = Convert.ToInt32(strcolumns[2].Trim());  //商品数量
                                }
                                if (strcolumns[3].Trim() != "")
                                {
                                    _OrderProduct.OB01008 = Convert.ToDecimal(strcolumns[3].Trim());  //含税单价(含税价格)
                                }
                                if (strcolumns[4].Trim() != "")
                                {
                                    _OrderProduct.OB01009 = Convert.ToDecimal(strcolumns[4].Trim());  //含税总价(含税总计)
                                }
                                if (strcolumns[5].Trim() != "")
                                {
                                    _OrderProduct.OB01010 = Convert.ToDecimal(strcolumns[5].Trim());  //不含税单价(不含税价格
                                }
                                if (strcolumns[6].Trim() != "")
                                {
                                    _OrderProduct.OB01011 = Convert.ToDecimal(strcolumns[6].Trim());  //不含税总价(不含税总计)
                                }
                                if (strcolumns[7].Trim() != "")
                                {
                                    _OrderProduct.OB01012 = Convert.ToDecimal(strcolumns[7].Trim());  //税额
                                }
                                if (strcolumns[8].Trim() != "")
                                {
                                    _OrderProduct.OB01013 = Convert.ToDecimal(strcolumns[8].Trim());  //单位成本
                                }
                                if (strcolumns[9].Trim() != "")
                                {
                                    _OrderProduct.OB01014 = Convert.ToDecimal(strcolumns[9].Trim()); //合计成本
                                }
                                _OrderProduct.OB01999 = Guid.NewGuid().ToString();                   //GUID
                                listOrderProduct.Add(_OrderProduct);
                            }
                        }
                    }
                }
            }

            #endregion

            #region 退货发票
            List <OrderInvoice> listOrderInvoice = new List <OrderInvoice>();
            if (!string.IsNullOrEmpty(this.txtfapiao.Value)) //判断是否有发票数据
            {
                string   strfapiao = this.txtfapiao.Value;   //获取发票数据
                string[] strrow1   = strfapiao.Split('&');
                if (strrow1.Length > 0)
                {
                    int i = 0;
                    foreach (string itemrow in strrow1)
                    {
                        string[] strcolumns = itemrow.Split('^');
                        if (strcolumns.Length > 0)
                        {
                            OrderInvoice _OrderInvoice = new OrderInvoice();

                            _OrderInvoice.OC01002 = Convert.ToInt32(strcolumns[0].Trim());  //序号
                            _OrderInvoice.OC01003 = listOrderProduct[i].OB01999.ToString(); //商品GUID;
                            _OrderInvoice.OC01004 = 2;                                      //退货单
                            if (strcolumns[1].Trim() != "")
                            {
                                _OrderInvoice.OC01005 = strcolumns[1].ToString().Trim();  //型号
                            }
                            if (strcolumns[2].Trim() != "")
                            {
                                _OrderInvoice.OC01006 = Convert.ToInt32(strcolumns[2].Trim());  //数量
                            }
                            if (strcolumns[3] == "N")
                            {
                                strcolumns[3] = "0";
                            }
                            else
                            {
                                strcolumns[3] = "1";
                            }
                            _OrderInvoice.OC01007 = Convert.ToInt32(strcolumns[3].Trim());  //是否收货
                            if (strcolumns[4].Trim() != "")
                            {
                                _OrderInvoice.OC01009 = Convert.ToDateTime(strcolumns[4].Trim()); //收获时间
                            }
                            if (strcolumns[5] == "N")
                            {
                                strcolumns[5] = "0";
                            }
                            else
                            {
                                strcolumns[5] = "1";
                            }
                            _OrderInvoice.OC01014 = Convert.ToInt32(strcolumns[5].Trim());  //是否开发票
                            if (strcolumns[6].Trim() != "")
                            {
                                _OrderInvoice.OC01016 = Convert.ToDateTime(strcolumns[6].Trim()); //退发票时间
                            }
                            listOrderInvoice.Add(_OrderInvoice);
                            i++;
                        }
                    }
                }
            }

            #endregion

            int num = Math.Abs(_OrderBLL.AddOrderBase(_OrderBase, listOrderProduct, listOrderInvoice));
            new Sinoo.Common.MessageShow().InsertMessage(this, num, "DataClear()");
        }