RMYY_CallCenter_Api/RMYY_CallCen.../Controllers/EquipmentCon...

using RMYY_CallCenter_Api.DB;
using RMYY_CallCenter_Api.Models;
using RMYY_CallCenter_Api.Models.Enum;
using RMYY_CallCenter_Api.Models.Input;
using RMYY_CallCenter_Api.Utility;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Web;
using System.Web.Mvc;

namespace RMYY_CallCenter_Api.Controllers
{
    public class EquipmentController : BaseController
    {
      private BLL.T_Equipment          equipbll = new BLL.T_Equipment();


        /// <summary>
        /// 获取设备列表
        /// </summary>
        /// <returns></returns>
        public ActionResult GetList(string equipmentname,int PageSize = 10,int PageIndex=1)
        {
            var sql = " ";
            if(!string.IsNullOrEmpty(equipmentname))
            {
                sql += " and F_EquipName='" + equipmentname + "'";
            }           
            var recordCount = 0;
            var dt = RMYY_CallCenter_Api.Bll.PagerBll.GetListPager(
              "T_Equipment",
              "F_EquipID",
              "*,(case F_state when 0 then '无效'    when 1 then '有效' else '' end ) statename",
              sql,
              "ORDER BY F_CreateTime desc ",
               PageSize,
               PageIndex,
              true,
              out recordCount);
             
           
            return Success("设备列表读取成功",dt);
        }



        /// <summary>
        /// 添加字典
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public ActionResult AddEquip(string equipname, string equipnumber, decimal equipprice, int state)
        {
            Model.T_Equipment equipModel = new Model.T_Equipment();

            equipModel.F_EquipName = equipname;
            equipModel.F_EquipNumber = equipnumber;
            equipModel.F_State = state;
            equipModel.F_EquipPrice = equipprice;
            equipModel.F_CreateTime = DateTime.Now;
            equipModel.F_CreateUser =User.F_UserCode;
            if (equipbll.Add(equipModel) > 0)
            {
                Model.T_Sys_DictionaryValue dvmodel = new Model.T_Sys_DictionaryValue();
                dvmodel.F_DictionaryFlag = "SBXX";
                dvmodel.F_Name = equipname;
                dvmodel.F_State = true;
                dvmodel.F_Sort = 0;
                Bll.T_Sys_DictionaryValue dvbll = new Bll.T_Sys_DictionaryValue();
                dvbll.Add(dvmodel);
                return Success("设备添加成功");
            }

            else
                return Error("设备添加失败");
        }



        /// <summary>
        /// 编辑设备
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public ActionResult EditEquip(int equipid,string equipname,string equipnumber,decimal equipprice,int state)
        {
            Model.T_Equipment equipModel = equipbll.GetModel(equipid);
            if (equipModel == null)
                return Error("设备对象不存在");
            equipModel.F_EquipName = equipname;
            equipModel.F_EquipNumber = equipnumber;
            equipModel.F_State = state;
            equipModel.F_EquipPrice = equipprice;
            if (equipbll.Update(equipModel))
                return Success("设备修改成功");
            else
                return Error("设备修改失败");
        }


        //[Authority]
        /// <summary>
        /// 删除字典
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        public ActionResult DelEquips(string[] ids)
        {
            if (ids == null || ids.Length <= 0)
                return Error("获取参数失败");
            StringBuilder sb = new StringBuilder();
            foreach (var item in ids)
            {
                sb.Append("'" + item + "',");
            }
            if (equipbll.DeleteList(sb.ToString().Trim(',')))
                return Success("删除成功");
            else
                return Error("删除失败");
        }


        //获取设备值列表
        public ActionResult GetAllList()
        {
            DataTable dt = new DataTable();
            dt = equipbll.GetList("   F_state=1 ").Tables[0];
            return Success("列表加载成功", dt);

        }

    }
}