using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
public class HR_PostSkillBillController : ApiController
{
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
public const string ModName = "2331"; //单据类型
public const string ModCaption = "岗位技能清单"; //单据名称
public const string ModRightName = "HR_PostSkillBillMain";
public const string ModRightNameQuery = ModRightName + "_Query"; //查询
public const string ModRightNameEdit = ModRightName + "_Edit"; //编辑
public const string ModRightNameCheck = ModRightName + "_Check"; //审核
public const string ModRightNameClose = ModRightName + "_Close"; //关闭
public const string ModRightNameDelete = ModRightName + "_Delete"; //作废
public const string ModRightNameDrop = ModRightName + "_Drop"; //删除
public DataSet ds = new DataSet();
private json objJsonResult = new json();
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
public DAL.ClsHR_PostSkillBill oBill = new DAL.ClsHR_PostSkillBill();
public DAL.ClsHR_PostSkillBill BillNew = new DAL.ClsHR_PostSkillBill(); //对应单据类
public DAL.ClsHR_PostSkillBill BillOld = new DAL.ClsHR_PostSkillBill(); //对应单据类
// HR_PostSkillBill HR_PostSkillBillMain
#region 岗位技能清单列表
///
/// 获取岗位技能清单列表信息
///
///
[Route("HR_PostSkillBill/GetHR_PostSkillBillList")]
[HttpGet]
public object GetHR_PostSkillBillList(string sWhere, string HMaker)
{
try
{
//判断权限
if (!DBUtility.ClsPub.Security_Log(ModRightNameQuery, 3, false, HMaker))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "您没有该模块权限,请与管理员联系!";
objJsonResult.data = null;
return objJsonResult;
}
//返回列表信息
ds = oCn.RunProcReturn("select * from h_v_HR_PostSkillBillMainList where 1=1 " + sWhere + " order by hmainid desc", "h_v_HR_PostSkillBillMainList");
List