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);
}
}
