/// <summary>
/// 通过对象删除记录
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool Del( TbSqlQuery item)
{
bool res = false;
using (var connection = DataBase.GetOpenConnection())
{
res = connection.Delete< TbSqlQuery>(item);
}
return res;
}
/// <summary>
/// 通过ID删除记录
/// </summary>
/// <param name="id">需要删除的对象的ID</param>
/// <returns></returns>
public bool Del(int id)
{
bool res = false;
TbSqlQuery item = new TbSqlQuery();
using (var connection = DataBase.GetOpenConnection())
{
item = GetByID(id);
res = connection.Delete<TbSqlQuery>(item);
}
return res;
}
/// <summary>
/// 插入一个对象
/// </summary>
/// <param name="item">需要插入的对象</param>
/// <returns></returns>
public int Insert(TbSqlQuery item)
{
int id = 0;
using (var connection = DataBase.GetOpenConnection())
{
id = (int)connection.Insert<TbSqlQuery>(item);
}
return id;
}
/// <summary>
/// 获取所有的SQL语句
/// </summary>
/// <returns></returns>
public JsonResult GetSQLName()
{
List<TbSqlQuery> SQLList = new List<TbSqlQuery>();
// TbSqlQuery tempQuery = new TbSqlQuery(); //定义一个表对象
try
{
Database db = DBHelper.CreateDataBase("PlatformData");
DbCommand cmd = db.GetSqlStringCommand("select ID, SSqlName from tb_SqlQuery");
using (DataSet myDs = db.ExecuteDataSet(cmd))
{
DataTable tmpDT = myDs.Tables[0];
for (int i = 0; i < tmpDT.Rows.Count; i++)
{
TbSqlQuery tempQuery = new TbSqlQuery(); //定义一个表对象
string tempID = tmpDT.Rows[i][0].ToString(); //获取SQL语句的id
int id = int.Parse(tempID);
string tempSQLName = tmpDT.Rows[i][1].ToString(); //获取SQL语句的名字
tempQuery.Id = id;
tempQuery.SSqlName = tempSQLName;
SQLList.Add(tempQuery);
}
}
return Json(SQLList, JsonRequestBehavior.AllowGet);
}
catch (Exception e2)
{
return null;
}
}
/// <summary>
/// PUT api/SqlQuery/Put/5,更新数据
/// </summary>
public int Put(int id, TbSqlQuery item)
{
if (id != item.Id)
{
//数据无效
return -1;
}
try
{
item.DCreate = DateTime.Now;//更新时间
item.ICreateID = SysUserInfo.GetUserID();
SqlQueryDAO.Update(item);
}
catch (Exception ex)
{
//更新数据失败
return -2;
}
//更新成功
return 1;
}
/// <summary>
/// POST api/SqlQuery/Post
///新增item数据，
/// </summary>
/// <param name="item">item,新增数据</param>
public int Post(TbSqlQuery item)
{
item.DCreate = DateTime.Now;
item.ICreateID = SysUserInfo.GetUserID();
SqlQueryDAO.Insert(item);
return item.Id;//新增数据成功
}