using DBUtility;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Data;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers
{
public class Sb_EquipDotCheckPlanBillController : ApiController
{
private json objJsonResult = new json();
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
public DataSet ds = new DataSet();
public DAL.ClsSb_EquipDotCheckPlanBill BillOld = new DAL.ClsSb_EquipDotCheckPlanBill();
#region 设备点检计划表
///
/// 设备点检计划表列表 list列表数据加载
///
///
[Route("Sb_EquipDotCheckPlanBill/GetEquipDotCheckPlanBillList")]
[HttpGet]
public object GetEquipDotCheckPlanBillList(string sWhere,string user)
{
try
{
if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckPlanBillList", 1, false, user))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "无查看权限！";
objJsonResult.data = null;
return objJsonResult;
}
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("select * from h_v_Sb_EquipDotCheckPlanBillList " + sWhere + " order by hmainid desc", "h_v_Sb_EquipDotCheckPlanBillList");
}
else
{
string sql1 = "select * from h_v_Sb_EquipDotCheckPlanBillList where 1 = 1";
string sql = sql1 + sWhere + " order by hmainid desc";
ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckPlanBillList");
}
//if (ds.Tables[0].Rows.Count != 0 || ds != null)
//{
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "Sucess！";
objJsonResult.data = ds.Tables[0];
return objJsonResult;
//}
//else
//{
//objJsonResult.code = "0";
//objJsonResult.count = 0;
//objJsonResult.Message = "无数据";
//objJsonResult.data = null;
//return objJsonResult;
//}
}
catch (Exception ex)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
objJsonResult.data = null;
return objJsonResult;
}
}
#region 设备点检记录统计分析
///
/// 返回设备点检记录统计分析 列表
///参数：string sql。
///返回值：object。
///
[Route("Sb_EquipDotCheckReport/Statistics")]
[HttpGet]
public object Statistics(string DateYear, string HType, string user)
{
try
{
List