using LeaRun.Application.Entity.NBManage;
using LeaRun.Data;
using LeaRun.Util;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace LeaRun.Application.Service.NBManage
{
public class NBDevTypeService
{
SqlHelper sqlHelper = new SqlHelper("NBDB");
///
/// 保存NBDevType
///
///
///
public bool SaveNBDevType(NBDevTypeEntity entity)
{
try
{
string insertSql = DataHelper.ModelToInsertSql(entity, "RMRS_NBDevType");
return sqlHelper.ExecuteNoParams(insertSql, CommandType.Text) > 0 ;
}
catch (Exception)
{
throw;
}
}
///
/// 更新NBDevType
///
///
///
public bool UpdateNBDevType(NBDevTypeEntity entity)
{
try
{
string updateSql = DataHelper.ModelToUpdateSql(entity, "RMRS_NBDevType");
return sqlHelper.ExecuteNoParams(updateSql, CommandType.Text) > 0 ;
}
catch (Exception)
{
throw;
}
}
///
/// 删除NBDevType
///
///
/// 3 不可删除 1 删除成功 0删除失败
public int DeleteNBDevType(string NBDevTypeID)
{
try
{
//判断次类型下有无表
string sqlMeter = "SELECT * FROM RMRS_MeterInfo WHERE NBDevType = " + NBDevTypeID;
DataTable dtMeter = sqlHelper.ExecuteDataTable(sqlMeter, CommandType.Text, null);
if (dtMeter.Rows.Count > 0)
{
return 3;
}
string delSql = "DELETE FROM RMRS_NBDevType WHERE NBDevTypeID = " + NBDevTypeID;
return sqlHelper.ExecuteNoParams(delSql, CommandType.Text) > 0 ? 1 : 0;
}
catch (Exception)
{
throw;
}
}
///
/// 获取NBDevType
///
///
///
public NBDevTypeEntity GetEntityById(string NBDevTypeID)
{
try
{
string sqlNBDevType = "SELECT * FROM RMRS_NBDevType WHERE NBDevTypeID = " + NBDevTypeID;
DataTable dtResult = sqlHelper.ExecuteDataTable(sqlNBDevType, CommandType.Text, null);
List lists = DataHelper.DataTableToT(dtResult);
if (lists != null)
{
return lists[0];
}
return new NBDevTypeEntity();
}
catch (Exception)
{
throw;
}
}
}
}