WebAPI/Controllers/BLL/Xt_UserController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/WebAPIController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/Gy_UserUser.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Service/LuBaoSevice.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/BLL/Xt_UserController.cs
@@ -914,6 +914,45 @@ } #endregion #region 用户关联用户列表查询 [Route("Xt_User/Gy_UserByUserList")] [HttpGet] public object Gy_UserByUserList(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); string sql1 = "select * from h_v_Gy_UserByUserRelationList where 1 = 1"; string sql = sql1 + sWhere + " order by 用户代码 "; ds = oCN.RunProcReturn(sql, "h_v_Gy_UserStockRelation"); //添加列名 foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess!"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception!" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 根据用户编码查找已分配班组列表 [Route("Xt_User/UserGrouplistPlaylist")] [HttpGet] WebAPI/Controllers/WebAPIController.cs
@@ -7872,6 +7872,69 @@ return model; } /// <summary> /// 用户关联用户删除 /// </summary> /// <returns></returns> [Route("Xt_User/Gy_UserByUserListDrop")] [HttpGet] public object DeltetGy_Material(string HItemID, string user) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //删除权限 if (!DBUtility.ClsPub.Security_Log("Gy_UserByUser_Drop", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限"; objJsonResult.data = null; return objJsonResult; } if (string.IsNullOrWhiteSpace(HItemID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HItemID为空!"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran();//开始事务 ds = oCN.RunProcReturn("select * from Gy_UserByUserRelation where HItemID=" + HItemID, "Gy_UserByUserRelation"); if (ds == null || ds.Tables[0].Rows.Count == 0) { oCN.RollBack();//回滚事务 objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有数据,无法删除!"; objJsonResult.data = null; return objJsonResult; ; } oCN.RunProc("delete from Gy_UserByUserRelation where HItemID=" + HItemID); oCN.Commit();//提交事务 objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "* 数据删除成功!"; objJsonResult.data = null; return objJsonResult; ; } catch (Exception e) { oCN.RollBack();//回滚事务 objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除失败!" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// <summary> /// 用关联物料获取信息 @@ -7899,6 +7962,18 @@ } /// <summary> /// 用关联用户获取信息 /// </summary> /// <returns></returns> [Route("Gy_UserByUserEdit")] [HttpGet] public ApiResult<DataSet> Gy_UserByUserEdit(string HID) { var model = LuBaoSevice.Gy_UserByUserEdit(HID); return model; } /// <summary> /// 报废原因 /// </summary> /// <returns></returns> WebAPI/Models/Gy_UserUser.cs
@@ -7,7 +7,7 @@ { public class Gy_UserUser { public int HUserID2 { get; set; } public string HUserID2 { get; set; } public string HUserNumber2 { get; set; } public string HUserName2 { get; set; } } WebAPI/Service/LuBaoSevice.cs
@@ -342,6 +342,9 @@ return new ApiResult<DataSet> { code = -1, msg = "不存在用户关联仓库数据" }; return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet }; } public static DataSet GetGy_UserStockRelationDb(string HID) { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); @@ -350,6 +353,27 @@ } /// <summary> /// 用户关联用户根据id获取信息 /// </summary> public static ApiResult<DataSet> Gy_UserByUserEdit(string HID) { if (string.IsNullOrEmpty(HID)) return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; var dataSet = Gy_UserByUserEdittDb(HID); if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) return new ApiResult<DataSet> { code = -1, msg = "不存在用户关联仓库数据" }; return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet }; } public static DataSet Gy_UserByUserEdittDb(string HID) { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); var dataSet = oCN.RunProcReturn("select * from h_v_Gy_UserByUserRelationList where 用户代码= '" + HID + "' ", "h_v_Gy_UserByUserRelationList"); return dataSet; } /// <summary> /// 用户关联物料根据id获取信息 /// </summary> public static ApiResult<DataSet> GetGy_UserMaterDetail(string HID)