| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 岗位技能根据id获取信息 |
| | | /// </summary> |
| | | public static ApiResult<DataSet> GetGy_PostSkillDetail(string HID) |
| | | { |
| | | if (string.IsNullOrEmpty(HID)) |
| | | return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; |
| | | var dataSet = GetGy_PostSkillDb(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 GetGy_PostSkillDb(string HID) |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_PostSkill where HItemID= " + HID + " ", "h_v_Gy_PostSkill"); |
| | | return dataSet; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 岗位根据id获取信息 |
| | | /// </summary> |
| | | public static ApiResult<DataSet> GetGy_PostDetail(string HID) |
| | | { |
| | | if (string.IsNullOrEmpty(HID)) |
| | | return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; |
| | | var dataSet = GetGy_PostDb(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 GetGy_PostDb(string HID) |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_Post where HItemID= " + HID + " ", "h_v_Gy_Post"); |
| | | return dataSet; |
| | | } |
| | | |
| | | /// <summary> |
| | | ///调拨类型根据id获取信息 |
| | | /// </summary> |
| | | public static ApiResult<DataSet> GetGy_StockMoveStyleDetail(string HID) |
| | | { |
| | | if (string.IsNullOrEmpty(HID)) |
| | | return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; |
| | | var dataSet = GetGy_StockMoveStyleDb(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 GetGy_StockMoveStyleDb(string HID) |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_StockMoveStyle where HItemID= " + HID + " ", "h_v_Gy_StockMoveStyle"); |
| | | return dataSet; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | ///入库类型根据id获取信息 |
| | | /// </summary> |
| | | public static ApiResult<DataSet> GetGy_StockInStyleDetail(string HID) |
| | | { |
| | | if (string.IsNullOrEmpty(HID)) |
| | | return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; |
| | | var dataSet = GetGy_StockInStyleDb(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 GetGy_StockInStyleDb(string HID) |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_StockInStyle where HItemID= " + HID + " ", "h_v_Gy_StockInStyle"); |
| | | return dataSet; |
| | | } |
| | | |
| | | /// <summary> |
| | | ///出库类型根据id获取信息 |
| | | /// </summary> |
| | | public static ApiResult<DataSet> GetGy_StockOutStyleDetail(string HID) |
| | | { |
| | | if (string.IsNullOrEmpty(HID)) |
| | | return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; |
| | | var dataSet = GetGy_StockOutStyleDb(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 GetGy_StockOutStyleDb(string HID) |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_StockOutStyle where HItemID= " + HID + " ", "h_v_Gy_StockOutStyle"); |
| | | return dataSet; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 计量单位根据id获取信息 |
| | | /// </summary> |
| | | public static ApiResult<DataSet> GetGy_UnitBillDetail(string HID) |