public List <ProductionMakeWorkOrderView> GetProductionMakeWorkOrderView(string whereSql) { //创建视图SQL var sqlCmd = MsGenerateSql.SelectFromTable <ProductionMakeWorkOrder>(). LeftJoin <WorkOrder, ProductionMakeWorkOrder>((t1, t2) => t1.WorkOrderId == t2.WorkOrderId). LeftJoin <ProductionVersion, ProductionMakeWorkOrder>((t1, t2) => t1.ProductionVersionId == t2.ProductionVersionId).Distinct(); //.Where<ProductionMakeWorkOrder>((t) => t.ProductionVersionId == ProductionVersionId); //设置视图返回值 string sql = sqlCmd.AutoMapDisplayItem <ProductionMakeWorkOrderView>().GenerateSql(); sql = sql + " " + whereSql; //执行视图SQL return(BaseEntityFac.GetEntityView <ProductionMakeWorkOrderView>(sql)); }