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_EmployeeSkillBillController : ApiController
{
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
public const string ModName = "2331"; //单据类型
public const string ModCaption = "员工技能清单"; //单据名称
public const string ModRightName = "HR_EmployeeSkillBill";
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_EmployeeSkillBill oBill = new DAL.ClsHR_EmployeeSkillBill();
public DAL.ClsHR_EmployeeSkillBill BillNew = new DAL.ClsHR_EmployeeSkillBill(); //对应单据类
public DAL.ClsHR_EmployeeSkillBill BillOld = new DAL.ClsHR_EmployeeSkillBill(); //对应单据类
// HR_EmployeeSkillBill HR_EmployeeSkillBillMain
#region 员工技能清单列表
///
/// 获取员工技能清单列表信息
///
///
[Route("HR_EmployeeSkillBill/GetHR_EmployeeSkillBillList")]
[HttpGet]
public object GetHR_EmployeeSkillBillList(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_EmployeeSkillBillMainList where 1=1 " + sWhere + " order by hmainid desc", "h_v_HR_EmployeeSkillBillMainList");
List