107 lines
3.6 KiB
C#
107 lines
3.6 KiB
C#
using Dapper;
|
|
using dccdc.Models;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace dccdc.DAL
|
|
{
|
|
public class InfectionOpenCrowdDal
|
|
{
|
|
public List<InfectionOpenCrowdModel> GetAllDataList()
|
|
{
|
|
string sql = "Select * From infection_open_crowd Order By create_time";
|
|
using (IDbConnection conn = CommHelper.GetSqlConnection())
|
|
{
|
|
return conn.Query<InfectionOpenCrowdModel>(sql).ToList();
|
|
}
|
|
}
|
|
|
|
public object saveData(InfectionOpenCrowdModel model)
|
|
{
|
|
string sql = string.Empty;
|
|
if (model.id == 0)
|
|
{
|
|
sql = @"Insert Into infection_open_crowd(sort,name,isQuestion,isOpen,create_by,create_time) Values (@sort,@name,@isQuestion,@isOpen,@create_by,@create_time)";
|
|
}
|
|
else
|
|
{
|
|
sql = @"Update infection_open_crowd Set sort=@sort,name=@name,isQuestion=@isQuestion,isOpen=@isOpen Where id=@id";
|
|
}
|
|
using (IDbConnection conn = CommHelper.GetSqlConnection())
|
|
{
|
|
try
|
|
{
|
|
int c = conn.Execute(sql, model);
|
|
if (c > 0)
|
|
{
|
|
return new { State = 1, Message = "保存成功！" };
|
|
}
|
|
else
|
|
{
|
|
return new { State = 0, Message = "操作失败，请联系管理员！" };
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
return new { State = 0, Message = ex.Message };
|
|
}
|
|
}
|
|
}
|
|
|
|
public object deleteData(string id)
|
|
{
|
|
string sql = string.Format("Delete From infection_open_crowd Where id = {0}", id);
|
|
using (IDbConnection conn = CommHelper.GetSqlConnection())
|
|
{
|
|
try
|
|
{
|
|
int c = conn.Execute(sql);
|
|
if (c > 0)
|
|
{
|
|
return new { State = 1, Message = "删除成功！" };
|
|
}
|
|
else
|
|
{
|
|
return new { State = 0, Message = "操作失败，请联系管理员！" };
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
return new { State = 0, Message = ex.Message };
|
|
}
|
|
}
|
|
}
|
|
|
|
public List<InfectionOpenCrowdModel> GetOpenDataList()
|
|
{
|
|
string sql = "Select * From infection_open_crowd where isOpen=1 Order By sort";
|
|
using (IDbConnection conn = CommHelper.GetSqlConnection())
|
|
{
|
|
return conn.Query<InfectionOpenCrowdModel>(sql).ToList();
|
|
}
|
|
}
|
|
|
|
public List<InfectionOpenCrowdModel> GetAllIDNameIsQuestion()
|
|
{
|
|
string sql = "Select id,name,isQuestion From Infection_open_crowd Where isOpen = 1";
|
|
using (IDbConnection conn = CommHelper.GetSqlConnection())
|
|
{
|
|
return conn.Query<InfectionOpenCrowdModel>(sql).ToList();
|
|
}
|
|
}
|
|
|
|
public InfectionOpenCrowdModel findById(int crowd_id)
|
|
{
|
|
string sql = "Select * From Infection_open_crowd Where id = "+crowd_id;
|
|
using (IDbConnection conn = CommHelper.GetSqlConnection())
|
|
{
|
|
return conn.QueryFirst<InfectionOpenCrowdModel>(sql);
|
|
}
|
|
}
|
|
}
|
|
}
|