/// <summary>
/// 根据主表的id修改分配的分拣线编号
/// </summary>
/// <param name="sortingCode"></param>
/// <param name="orderId"></param>
public string UpdateOrderDeatil(string sortingCode, string orderId)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SortingOrderDetailBllDao dao = new SortingOrderDetailBllDao();
return(dao.UpdateOrderDeatil(sortingCode, orderId));
}
}
/// <summary>
/// 根据主表id删除明细表数据
/// </summary>
/// <param name="orderid"></param>
public void DeleteOrderId(string orderid)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SortingOrderDetailBllDao dao = new SortingOrderDetailBllDao();
dao.DeleteOrderId(orderid);
}
}
/// <summary>
/// 根据订单号、页数、总条数查询数据
/// </summary>
/// <param name="BillNo"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public DataSet QueryByOrderId(string orderid, int pageIndex, int pageSize)
{
string[] aryBillNo = orderid.Split(',');
string BillNoList = "''";
for (int i = 0; i < aryBillNo.Length; i++)
{
BillNoList += ",'" + aryBillNo[i] + "'";
}
string sql = string.Format("SELECT {0} FROM {1} WHERE ORDER_ID IN ({2}) ORDER BY ORDER_ID DESC", strQueryFields, strTableView, BillNoList);
using (PersistentManager persistentManager = new PersistentManager())
{
SortingOrderDetailBllDao dao = new SortingOrderDetailBllDao();
return(dao.Query(sql, strTableView, pageIndex, pageSize));
}
}
