| | |
| | | |
| | | |
| | | |
| | | ///// <summary> |
| | | ///// 增加或编辑实体 |
| | | ///// </summary> |
| | | ///// <param name="model"></param> |
| | | ///// <returns></returns> |
| | | //[RequestMethod(RequestMethods.POST)] |
| | | //public ReturnDto<string?> EditModel([FromBody] dynamic model) |
| | | //{ |
| | | // Guid? guid = model.guid; //主键 |
| | | // string sjxt = model.sjxt; //工单号 |
| | | // string bz = model.bz;//仓库 |
| | | // var _outMsg = ""; |
| | | // var _outSum = -1; |
| | | // using (var conn = new SqlConnection(DbHelperSQL.strConn)) |
| | | // { |
| | | // using (var cmd = new SqlCommand("[prc_wom_daa_edt]", conn)) |
| | | // { |
| | | // try |
| | | // { |
| | | // conn.Open(); |
| | | // cmd.CommandType = CommandType.StoredProcedure; |
| | | // SqlParameter[] parameters = |
| | | // { |
| | | // new("@outMsg", SqlDbType.NVarChar, 300), |
| | | // new("@outSum", SqlDbType.Int), |
| | | // new("@inOrderGuid",UtilityHelper.CheckGuid(guid)? guid : DBNull.Value), |
| | | // new("@inSjxt", sjxt), |
| | | // new("@inBz", bz), |
| | | // new("@inEdtUserGuid", _userGuid), |
| | | // }; |
| | | // parameters[0].Direction = ParameterDirection.Output; |
| | | // parameters[1].Direction = ParameterDirection.Output; |
| | | // foreach (var parameter in parameters) |
| | | // cmd.Parameters.Add(parameter); |
| | | // cmd.ExecuteNonQuery(); |
| | | // _outMsg = parameters[0].Value.ToString(); |
| | | // _outSum = int.Parse(parameters[1].Value.ToString()); |
| | | // } |
| | | // catch (Exception ex) |
| | | // { |
| | | // LogHelper.Debug(ToString(), |
| | | // "prc_wom_daa_edt error:" + ex.Message); |
| | | // _outMsg = ex.Message; |
| | | // _outSum = -1; |
| | | // } |
| | | // finally |
| | | // { |
| | | // conn.Close(); |
| | | // } |
| | | // } |
| | | // } |
| | | // if (_outSum <= 0) |
| | | // return ReturnDto<string>.QuickReturn(guid.ToString(), |
| | | // ReturnCode.Exception, _outMsg); |
| | | // return ReturnDto<string>.QuickReturn(guid.ToString(), |
| | | // ReturnCode.Success, _outMsg); |
| | | //} |
| | | /// <summary> |
| | | /// 增加或编辑实体 |
| | | /// </summary> |
| | | /// <param name="model"></param> |
| | | /// <returns></returns> |
| | | [RequestMethod(RequestMethods.POST)] |
| | | public ReturnDto<string?> EditModel([FromBody] dynamic model) |
| | | { |
| | | Guid? guid = model.guid; //主键 |
| | | string sjxt = model.sjxt; //线体 |
| | | string bz = model.bz;//备注 |
| | | var _outMsg = ""; |
| | | var _outSum = -1; |
| | | using (var conn = new SqlConnection(DbHelperSQL.strConn)) |
| | | { |
| | | using (var cmd = new SqlCommand("[prc_wom_daa_edt]", conn)) |
| | | { |
| | | try |
| | | { |
| | | conn.Open(); |
| | | cmd.CommandType = CommandType.StoredProcedure; |
| | | SqlParameter[] parameters = |
| | | { |
| | | new("@outMsg", SqlDbType.NVarChar, 300), |
| | | new("@outSum", SqlDbType.Int), |
| | | new("@inOrderGuid",UtilityHelper.CheckGuid(guid)? guid : DBNull.Value), |
| | | new("@inSjxt", sjxt), |
| | | new("@inBz", bz), |
| | | new("@inEdtUserGuid", _userGuid), |
| | | }; |
| | | parameters[0].Direction = ParameterDirection.Output; |
| | | parameters[1].Direction = ParameterDirection.Output; |
| | | foreach (var parameter in parameters) |
| | | cmd.Parameters.Add(parameter); |
| | | cmd.ExecuteNonQuery(); |
| | | _outMsg = parameters[0].Value.ToString(); |
| | | _outSum = int.Parse(parameters[1].Value.ToString()); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | LogHelper.Debug(ToString(), |
| | | "prc_wom_daa_edt error:" + ex.Message); |
| | | _outMsg = ex.Message; |
| | | _outSum = -1; |
| | | } |
| | | finally |
| | | { |
| | | conn.Close(); |
| | | } |
| | | } |
| | | } |
| | | if (_outSum <= 0) |
| | | return ReturnDto<string>.QuickReturn(guid.ToString(), |
| | | ReturnCode.Exception, _outMsg); |
| | | return ReturnDto<string>.QuickReturn(guid.ToString(), |
| | | ReturnCode.Success, _outMsg); |
| | | } |
| | | |
| | | |
| | | /// <summary> |