查询列表子表按subid排序

wtt

2024-11-26 fd8f4776bf512f7e3068a5868c3b5af0bd974647

 WebAPI/Controllers/XSGL/Xs_OutDoorBillController.cs

@@ -1220,7 +1220,7 @@
        #region  出门确认单报表
        [Route("Xs_OutDoorBill/Xs_OutDoorBillReport")]
        [HttpGet]
        public object Xs_OutDoorBillReport(string HBeginDate, string HEndDate, string sWhere, string user)
        public object Xs_OutDoorBillReport(string HBeginDate, string HEndDate, string sWhere, string user,int HOperationType)
        {
            try
            {
@@ -1233,7 +1233,7 @@
                    return objJsonResult;
                }

                string sql = "exec h_p_Xs_OutDoorBillReport '" + HBeginDate + "','" + HEndDate + "','" + sWhere + "'";
                string sql = "exec h_p_Xs_OutDoorBillReport '" + HBeginDate + "','" + HEndDate + "','" + sWhere + "'," + HOperationType;

                ds = oCN.RunProcReturn(sql, "h_p_Xs_OutDoorBillReport");