WebAPI/Controllers/LMESController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj.user | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/LMESController.cs
@@ -128,6 +128,46 @@ } /// <summary> /// 返回工序流转卡(下达)列表 ///参数:string sql。 ///返回值:object。 /// </summary> [Route("LEMS/MES_Sc_ProcessExchangeIssueBillList_Json")] [HttpGet] public object MES_Sc_ProcessExchangeIssueBillList_Json(string sWhere, string user) { DataSet ds; try { //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查询权限!"; objJsonResult.data = null; return objJsonResult; } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeIssueBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeIssueBillQuery"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess!"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "异常!" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// <summary> /// 返回工序出站汇报单列表 ///参数:string sql。 ///返回值:object。 WebAPI/WebAPI.csproj
@@ -581,6 +581,7 @@ <Compile Include="Models\Sc_WorkDemandPlanBillMain.cs" /> <Compile Include="Models\Sc_WorkDemandPlanBillSub.cs" /> <Compile Include="Models\动态列\OptionListModel.cs" /> <Compile Include="Models\基础资料\Gy_ClassTimePrj.cs" /> <Compile Include="Models\工资管理\ClsGy_ClassTimePrj_Model.cs" /> <Compile Include="Models\工资管理\ClsPay_GroupBalBillEmp.cs" /> <Compile Include="Models\工资管理\ClsPay_GroupBalBillMain.cs" /> @@ -743,10 +744,8 @@ <Compile Include="Models\WW_EntrustProcSendWorkViewModel.cs" /> <Compile Include="Models\WW_EntrustWorkOrderViewModel.cs" /> <Compile Include="Models\基础资料\Gy_ClassTimePrjSub.cs" /> <Compile Include="Models\基础资料\Gy_ClassTimePrj.cs" /> <Compile Include="Models\基础资料\Gy_Employee.cs" /> <Compile Include="Models\基础资料\Gy_Process.cs" /> <Compile Include="Models\基础资料\Gy_ClassTimePrj.cs" /> <Compile Include="Models\基础资料\Warehouse.cs" /> <Compile Include="Models\工资管理\ClsPay_WorkTimesBillMain.cs" /> <Compile Include="Models\工资管理\ClsPay_WorkTimesBillSub.cs" /> WebAPI/WebAPI.csproj.user
@@ -18,7 +18,7 @@ <IISExpressWindowsAuthentication /> <IISExpressUseClassicPipelineMode /> <UseGlobalApplicationHostFile /> <ProjectView>ProjectFiles</ProjectView> <ProjectView>ShowAllFiles</ProjectView> <Controller_SelectedScaffolderID>ApiControllerEmptyScaffolder</Controller_SelectedScaffolderID> <Controller_SelectedScaffolderCategoryPath>root/Common/Web API</Controller_SelectedScaffolderCategoryPath> </PropertyGroup>