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