/// <summary>
/// 修改發票信息
/// </summary>
/// <param name="imr"></param>
/// <returns></returns>
public int Update(InvoiceMasterRecord imr)
{
try
{
return _imrDao.Update(imr);
}
catch (Exception ex)
{
throw new Exception("InvoiceMasterRecordMgr-->Update" + ex.Message, ex);
}
}
public int Insertdb(InvoiceMasterRecord Imr, InvoiceSliveInfo Isi)
{
try
{
return _iordertempreturnlistdao.Insertdb(Imr, Isi);
}
catch (Exception ex)
{
throw new Exception(" ReturnMasterMgr-->Insertdb-->" + ex.Message, ex);
}
}
public int Update(InvoiceMasterRecord imr)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat(@"update invoice_master_record set company_title='{0}',company_invoice='{1}' ", imr.company_title, imr.company_invoice);
sql.AppendFormat(@" ,order_zip='{0}',order_address='{1}' ", imr.order_zip, imr.order_address);
sql.AppendFormat(@" where invoice_id={0} ;", imr.invoice_id);
try
{
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("InvoiceMasterRecordDao-->Update" + ex.Message + sql.ToString(), ex);
}
}
public int Insertdb(InvoiceMasterRecord Imr,InvoiceSliveInfo Isi)
{//修改數據
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(@" UPDATE invoice_master_record SET invoice_status='{0}',free_tax='{1}',sales_amount='{2}',tax_amount='{3}',total_amount='{4}',deduct_bonus='{5}',order_freight_normal='{6}',order_freight_normal_notax='{7}',order_freight_low='{8}',order_freight_low_notax='{9}',status_createdate='{10}' where invoice_id='{11}';", Imr.invoice_status, Imr.free_tax, Imr.sales_amount, Imr.tax_amount, Imr.total_amount, Imr.deduct_bonus, Imr.order_freight_normal, Imr.order_freight_normal_notax, Imr.order_freight_low, Imr.order_freight_low_notax, Imr.status_createdate, Imr.invoice_id);
sql.AppendFormat(@" INSERT INTO invoice_slive_info (invoice_slive_info,invoice_id,order_id,item_id,product_name,product_spec_name,sort,single_money,sub_deduct_bonus,buy_num,subtotal,slive_note,slive_createdate) VALUES ();", Isi.buy_num);
return _accessMySql.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("OrderTempReturnListDao.Insertdb-->" + sql.ToString() + ex.Message, ex);
}
}