/// <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"]));
}
/// <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()");
}