| | |
| | | }, |
| | | "AllowedHosts": "*", |
| | | /*"ConnectionStrings": "Data Source=192.168.1.146;Initial Catalog=TEST_MES;User ID=testUser;Password =qixi1qaz@WSXtest",*/ |
| | | "ConnectionStrings": "Data Source=192.168.8.8;Initial Catalog=YS_MES;User ID=sa;Password =JianHui@2025", |
| | | "ConnectionStrings": "Data Source=192.168.8.8;Initial Catalog=GS_MES;User ID=sa;Password =JianHui@2025", |
| | | "TestErpUrl": "http://60.204.140.168:8080//kingdee/billWriteIn", |
| | | "TestErpUrl2": "http://192.168.1.149:8066/WebService1.asmx/MesToErpUpdateFlag", |
| | | "ProductionErpUrl": "http://192.168.1.149:8066/WebService1.asmx/mesToErpinfoFormal", |
| | |
| | | m.outMsg = parameters[0].Value.ToString(); |
| | | m.outSum = int.Parse(parameters[1].Value.ToString()); |
| | | } |
| | | catch (Exception ex) |
| | | catch (Exception ex) |
| | | { |
| | | LogHelper.Debug(ToString(), |
| | | "prc_cgrk_submit error:" + ex.Message); |
| | |
| | | return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, |
| | | "操作成功!"); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// |
| | | /// </summary> |
| | | /// <param name="model"></param> |
| | | /// <returns></returns> |
| | | [RequestMethod(RequestMethods.POST)] |
| | | public ReturnDto<ExpandoObject> GetModelByOrg([FromBody] dynamic model) |
| | | { |
| | | string workNo = model.workNo; |
| | | string lineno = model.line_no; |
| | | string orgId = model.orgId; |
| | | |
| | | dynamic m = new ExpandoObject(); |
| | | SqlParameter[] parameters = |
| | | { |
| | | new("@inWorkNo", workNo), |
| | | new("@inLineName", lineno), |
| | | new("@inOrgId", orgId), |
| | | }; |
| | | var dset = new DataSet(); |
| | | try |
| | | { |
| | | dset = DbHelperSQL.RunProcedure("[prc_womcaa_detailByOrg]", parameters, "0"); |
| | | if (dset != null && dset.Tables.Count > 0 && |
| | | dset.Tables[0].Rows.Count > 0) |
| | | { |
| | | var dr = dset.Tables[0].Rows[0]; |
| | | m = dr.RowToDynamic(); |
| | | return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "读取成功!"); |
| | | } |
| | | return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "读取失败,找不到!"); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | LogHelper.Debug(ToString(), ex.Message); |
| | | return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "读取失败," + ex.Message.ToString()); |
| | | } |
| | | } |
| | | } |