| | |
| | | namespace Gs.Warehouse.Services; |
| | | |
| | | [ApiGroup(ApiGroupNames.PerMission)] |
| | | public class MesScrksqDjManager : IRomteService |
| | | public class MesScrksqDjManager :IRomteService |
| | | { |
| | | private readonly IHttpContextAccessor _http; |
| | | |
| | | private readonly string _userCode, _userGuid, _orgFids; |
| | | |
| | | public MesScrksqDjManager(IHttpContextAccessor httpContextAccessor) |
| | | { |
| | | _http = httpContextAccessor; |
| | |
| | | }; |
| | | try |
| | | { |
| | | dset = DbHelperSQL.RunProcedure("prc_scrksqdj_lst", parameters, |
| | | "0"); |
| | | dset = DbHelperSQL.RunProcedure("prc_scrksqdj_lst", parameters, "0"); |
| | | if (dset != null && dset.Tables.Count > 0 && |
| | | dset.Tables[0].Rows.Count > 0) //有数据 |
| | | { |
| | |
| | | { |
| | | LogHelper.Debug(ToString(), ex.Message); |
| | | return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist, |
| | | ReturnCode.Exception, ex.Message); |
| | | ReturnCode.Exception, ex.Message); |
| | | } |
| | | |
| | | return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist, |
| | |
| | | /// <summary> |
| | | /// 提交检验 |
| | | /// </summary> |
| | | /// <param name="mode"></param> |
| | | /// <param name="mode"></param> |
| | | /// <returns></returns> |
| | | [RequestMethod(RequestMethods.POST)] |
| | | public ReturnDto<ExpandoObject> EditModelSubmit([FromBody] dynamic mode) |
| | | { |
| | | string _guid = mode.guid; |
| | | string _inFieldValue = mode.inFieldValue; |
| | | var _proName = "prc_scrksqdj_submit"; |
| | | string _proName = "prc_scrksqdj_submit"; |
| | | dynamic m = new ExpandoObject(); |
| | | m.outSum = -1; |
| | | m.outMsg = ""; |
| | | |
| | | if (!Guid.TryParse(_userGuid, out var userGuid)) |
| | | if (!Guid.TryParse(_userGuid, out Guid userGuid)) |
| | | throw new ArgumentException("无效的 UserGuid"); |
| | | if (!Guid.TryParse(_guid, out var orderGuid)) |
| | | if (!Guid.TryParse(_guid, out Guid orderGuid)) |
| | | throw new ArgumentException("无效的 OrderGuid"); |
| | | |
| | | using (var conn = new SqlConnection(DbHelperSQL.strConn)) |
| | |
| | | new("@outSum", SqlDbType.Int), |
| | | new("@inEdtUserGuid", userGuid), |
| | | new("@inOrderGuid", orderGuid), |
| | | new("@inFieldName", SqlDbType.NVarChar, 20) |
| | | { Value = DBNull.Value }, |
| | | new("@inFieldName", SqlDbType.NVarChar, 20) { Value = DBNull.Value }, |
| | | new("@inFieldValue", _inFieldValue), |
| | | new("@in1", ""), |
| | | new("@in2", "") |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功!"); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 撤回报工 |
| | | /// </summary> |
| | | /// <param name="mode"></param> |
| | | /// <param name="mode"></param> |
| | | /// <returns></returns> |
| | | [RequestMethod(RequestMethods.POST)] |
| | | public ReturnDto<ExpandoObject> EditModelChbg([FromBody] dynamic mode) |
| | |
| | | string _guid = mode.guid; |
| | | string _billNo = mode.billNo; |
| | | string _inFieldValue = mode.inFieldValue; |
| | | var _proName = "prc_pda_scbg_withdraw"; |
| | | string _proName = "prc_pda_scbg_withdraw"; |
| | | dynamic m = new ExpandoObject(); |
| | | m.outSum = -1; |
| | | m.outMsg = ""; |
| | | |
| | | if (!Guid.TryParse(_userGuid, out var userGuid)) |
| | | if (!Guid.TryParse(_userGuid, out Guid userGuid)) |
| | | throw new ArgumentException("无效的 UserGuid"); |
| | | if (!Guid.TryParse(_guid, out var orderGuid)) |
| | | if (!Guid.TryParse(_guid, out Guid orderGuid)) |
| | | throw new ArgumentException("无效的 OrderGuid"); |
| | | |
| | | using (var conn = new SqlConnection(DbHelperSQL.strConn)) |
| | |
| | | cmd.CommandType = CommandType.StoredProcedure; |
| | | SqlParameter[] parameters = |
| | | { |
| | | new("@outMsg", SqlDbType.NVarChar, 2000) |
| | | { Direction = ParameterDirection.Output }, |
| | | new("@outSum", SqlDbType.Int) |
| | | { Direction = ParameterDirection.Output }, |
| | | new("@inEdtUserGuid", SqlDbType.UniqueIdentifier) |
| | | { Value = userGuid }, |
| | | new("@inOrderGuid", SqlDbType.UniqueIdentifier) |
| | | { Value = orderGuid }, |
| | | new("@pi_inventoryAppBillNo", SqlDbType.NVarChar, 100) |
| | | { Value = _billNo ?? (object)DBNull.Value }, |
| | | new("@in1", ""), |
| | | new("@in2", ""), |
| | | new("@in3", "") |
| | | new SqlParameter("@outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output }, |
| | | new SqlParameter("@outSum", SqlDbType.Int) { Direction = ParameterDirection.Output }, |
| | | new SqlParameter("@inEdtUserGuid", SqlDbType.UniqueIdentifier) { Value = userGuid }, |
| | | new SqlParameter("@inOrderGuid", SqlDbType.UniqueIdentifier) { Value = orderGuid }, |
| | | new SqlParameter("@pi_inventoryAppBillNo", SqlDbType.NVarChar, 100) { Value = _billNo ?? (object)DBNull.Value }, |
| | | new SqlParameter("@in1", ""), |
| | | new SqlParameter("@in2", ""), |
| | | new SqlParameter("@in3", "") |
| | | }; |
| | | parameters[0].Direction = ParameterDirection.Output; |
| | | parameters[1].Direction = ParameterDirection.Output; |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功!"); |
| | | } |
| | | |
| | | } |