/// <summary> /// 添加客户 /// </summary> /// <param name="customer"></param> /// <param name="error"></param> /// <returns></returns> public static bool AddInvoice(InvoiceAccountInfo invoiceaccount, ref string error) { string sql = string.Empty; try { invoiceaccount.InvoiceDate = Convert.ToDateTime(invoiceaccount.InvoiceDate).ToString("yyyy-MM-dd"); } catch (Exception ex) { error = string.Format("开票日期{0},不是正规的日期格式yyyy-MM-dd", invoiceaccount.InvoiceDate); return(false); } if (string.IsNullOrEmpty(invoiceaccount.InvoiceNumber) || string.IsNullOrEmpty(invoiceaccount.InvoiceCode)) { error = "发信息不完整!"; return(false); } sql = string.Format(@"select count(*) from Customer where CustomerName='{0}'", invoiceaccount.CustomerId); if (SqlHelper.GetScalar(sql).Equals("0")) { error = string.Format("不存在客户名称{0}", invoiceaccount.CustomerId); return(false); } sql = string.Format(@" insert into InvoiceAccountInfo (SN,InvoiceNumber,InvoiceDate, InvoiceCode,InvoiceMoney,CustomerId,Money,Money_C, IsPay,InvoiceType) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}') ", invoiceaccount.SN, invoiceaccount.InvoiceNumber, invoiceaccount.InvoiceDate, invoiceaccount.InvoiceCode, invoiceaccount.InvoiceMoney, invoiceaccount.CustomerId, invoiceaccount.Money, invoiceaccount.Money_C, invoiceaccount.IsPay, invoiceaccount.InvoiceType); return(SqlHelper.ExecuteSql(sql, ref error)); }
protected void btnUpload_Click(object sender, EventArgs e) { string error = string.Empty; DataSet ds = ToolManager.ImpExcel(this.FU_Excel, Server); if (ds == null) { lbMsg.Text = "选择的文件为空或不是标准的Excel文件!"; return; } List <InvoiceAccountInfo> invoiceaccountss = new List <InvoiceAccountInfo>(); foreach (DataRow dr in ds.Tables[0].Rows) { InvoiceAccountInfo invoiceaccount = new InvoiceAccountInfo(); invoiceaccount.SN = dr["序号"] == null ? "" : dr["序号"].ToString(); invoiceaccount.InvoiceCode = dr["发票代码"] == null ? "" : dr["发票代码"].ToString(); invoiceaccount.CustomerId = dr["客户名称"] == null ? "" : dr["客户名称"].ToString(); invoiceaccount.InvoiceNumber = dr["发票号码"] == null ? "" : dr["发票号码"].ToString(); invoiceaccount.InvoiceDate = dr["开票日期"] == null ? "" : dr["开票日期"].ToString(); invoiceaccount.Money = dr["不含税金额"] == null ? "" : dr["不含税金额"].ToString(); invoiceaccount.Money_C = dr["税额"] == null ? "" : dr["税额"].ToString(); invoiceaccount.InvoiceMoney = dr["发票金额"] == null ? "" : dr["发票金额"].ToString(); invoiceaccount.IsPay = dr["是否已收款"] == null ? "" : dr["是否已收款"].ToString(); invoiceaccount.InvoiceType = dr["发票类型"] == null ? "" : dr["发票类型"].ToString(); invoiceaccountss.Add(invoiceaccount); } bool restult = BatchAddData(invoiceaccountss, ref error); lbMsg.Text = restult == true ? "导入成功!" : error; if (restult) { Tool.WriteLog(Tool.LogType.Operating, "导入发票信息", "导入成功!"); return; } else { Tool.WriteLog(Tool.LogType.Operating, "导入发票信息", "导入失败!原因" + error); return; } }