public DataTable GetOrderReturnCount(OrderReturnUserQuery store) { try { return _iordertempreturnlistdao.GetOrderReturnCount(store); } catch (Exception ex) { throw new Exception(" ReturnMasterMgr-->GetOrderReturnCount-->" + ex.Message, ex); } }
public List<OrderReturnUserQuery> OrderMasterQuery(OrderReturnUserQuery store) { try { return _iordertempreturnlistdao.OrderMasterQuery(store); } catch (Exception ex) { throw new Exception(" ReturnMasterMgr-->OrderMasterQuery-->" + ex.Message, ex); } }
public int UpdateOrderMaster(OrderReturnUserQuery store) { try { return _iordertempreturnlistdao.UpdateOrderMaster(store); } catch (Exception ex) { throw new Exception(" ReturnMasterMgr-->UpdateOrderMaster-->" + ex.Message, ex); } }
public int InsertOrderReturnDetail(OrderReturnUserQuery store) { try { return _iordertempreturnlistdao.InsertOrderReturnDetail(store); } catch (Exception ex) { throw new Exception(" ReturnMasterMgr-->InsertOrderReturnDetail-->" + ex.Message, ex); } }
public int InsertOrderReturnDetail(OrderReturnUserQuery store) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@" insert into order_return_detail(return_id,detail_id) values('{0}','{1}')", store.return_id, store.detail_id); return _accessMySql.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("ReturnMasterDao-->InsertOrderReturnDetail-->" + ex.Message + "sql:" + sql.ToString(), ex); } }
public List<OrderReturnUserQuery> OrderMasterQuery(OrderReturnUserQuery store) { try { StringBuilder sql = new StringBuilder(); sql.AppendFormat(@"select order_status,invoice_status,order_invoice from order_master where order_id='{0}'", store.order_id); return _accessMySql.getDataTableForObj<OrderReturnUserQuery>(sql.ToString()); } catch (Exception ex) { throw new Exception("ReturnMasterDao.OrderMasterQuery-->" + _accessMySql.ToString() + ex.Message, ex); } }
public DataTable GetOrderReturnCount(OrderReturnUserQuery store) { StringBuilder sqlcount = new StringBuilder(); try{ sqlcount.AppendFormat(@" select count(*) as search_total from order_return_detail where detail_id='{0}' ", store.detail_id); return _accessMySql.getDataTable(sqlcount.ToString()); } catch(Exception ex) { throw new Exception("ReturnMasterDao-->GetOrderReturnCount-->" + ex.Message + "sql:" + sqlcount.ToString() , ex); } }
public int InsertOrderReturnMaster(OrderReturnUserQuery store) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@" INSERT INTO order_return_master (return_id,order_id,vendor_id,return_status,return_note,return_zip,return_address,return_createdate,return_updatedate,return_ipfrom)"); sql.AppendFormat(@" values('{0}','{1}','{2}',", store.return_id, store.order_id, store.item_vendor_id); sql.AppendFormat(@" '{0}','{1}','{2}','{3}',", store.return_status, store.user_note, store.return_zip, store.return_address); sql.AppendFormat(@" '{0}','{1}','{2}')", store.return_createdate, store.return_updatedate, store.return_ipfrom); string s = sql.ToString(); return _accessMySql.execCommand(s); } catch (Exception ex) { throw new Exception("ReturnMasterDao-->InsertOrderReturnMaster-->" + ex.Message + "sql:" + sql.ToString(), ex); } }
public int UpdateOrderDetailStatus(OrderReturnUserQuery store) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(" update order_detail set detail_status='{0}' where detail_id='{1}'", store.detail_status, store.detail_id); return _accessMySql.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("OrderTempReturnListDao.UpdateOrderDetailStatus-->" + sql.ToString() + ex.Message, ex); } }
public DataTable Seltime(OrderReturnUserQuery store) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@" SELECT invoice_status,invoice_date,invoice_attribute from invoice_master_record where order_id='{0}' ", store.order_id); return _accessMySql.getDataTable(sql.ToString()); } catch (Exception ex) { throw new Exception("OrderTempReturnListDao.Seltime-->" + sql.ToString() + ex.Message, ex); } }
public DataTable SelCon(OrderReturnUserQuery store) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@"SELECT count(*) AS search_total from order_detail od LEFT JOIN order_slave os ON os.slave_id=od.slave_id where os.order_id='{0}' and od.detail_status in (0,4)", store.order_id); return _accessMySql.getDataTable(sql.ToString()); } catch (Exception ex) { throw new Exception("OrderTempReturnListDao.SelCon-->" + sql.ToString() + ex.Message, ex); } }
public int Updinvoice(OrderReturnUserQuery store) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@" UPDATE order_master SET order_invoice='',invoice_status=2 where order_id='' ", store.order_id); return _accessMySql.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("OrderTempReturnListDao.Updinvoice-->" + sql.ToString() + ex.Message, ex); } }
public DataTable Seldetail(OrderReturnUserQuery store, string status) { try { return _iordertempreturnlistdao.Seldetail(store, status); } catch (Exception ex) { throw new Exception(" ReturnMasterMgr-->Seldetail-->" + ex.Message, ex); } }
public DataTable SelCon(OrderReturnUserQuery store) { try { return _iordertempreturnlistdao.SelCon(store); } catch (Exception ex) { throw new Exception(" ReturnMasterMgr-->SelCon-->" + ex.Message, ex); } }
public int UpdateOrderMaster(OrderReturnUserQuery store) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(" update order_master set order_status='{0}',order_updatedate='{1}',order_ipfrom='{2}',order_date_close='{3}',order_date_cancel='{4}' where order_id='{5}'", store.order_status, store.order_updatedate, store.order_ipfrom, store.order_date_close, store.order_date_cancel, store.order_id); return _accessMySql.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("OrderTempReturnListDao.UpdateOrderMaster-->" + sql.ToString() + ex.Message, ex); } }
public DataTable SelOrderMaster(OrderReturnUserQuery store) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@"SELECT invoice_status,order_invoice,* from order_master where order_id='{0}';", store.order_id); return _accessMySql.getDataTable(sql.ToString()); } catch (Exception ex) { throw new Exception("OrderTempReturnListDao.SelOrderMaster-->" + sql.ToString() + ex.Message, ex); } }
public DataTable Seldetail(OrderReturnUserQuery store, string status) {//查詢明細 StringBuilder sql = new StringBuilder(); try { sql.AppendFormat(@" SELECT od.product_name,od.product_spec_name,od.single_money,od.item_id,od.deduct_bonus,od.detail_status,od.buy_num,os.order_id from order_detail od LEFT JOIN order_slave os on os.slave_id=od.slave_id where os.order_id='{0}' and od.detail_status in ({1})", store.order_id, status); return _accessMySql.getDataTable(sql.ToString()); } catch (Exception ex) { throw new Exception("OrderTempReturnListDao.Seldetail-->" + sql.ToString() + ex.Message, ex); } }