/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="newInfo"></param>
/// <returns></returns>
public bool AddInfo(EmployeeNewInfo newInfo)
{
try
{
//获取数据库操作接口
IDBOper dbOper = DBOper.DBOperSingle;
//打开数据库连接
using (IDbConnection conn = dbOper.OpenConn())
{
string sql = "insert into T_News(Author,Title,Msg,ImagePath,SubDateTime) values(@Author,@Title,@Msg,@ImagePath,@SubDateTime)";
IDataParameter[] paras = new IDataParameter[]
{
dbOper.GetDataParameter("@Author", newInfo.Author),
dbOper.GetDataParameter("@Title", newInfo.Title),
dbOper.GetDataParameter("@Msg", newInfo.Msg),
dbOper.GetDataParameter("@ImagePath", newInfo.ImagePath),
dbOper.GetDataParameter("@SubDateTime", newInfo.SubDateTime)
};
return(dbOper.Exce(sql, paras, conn));
}
}
catch (System.Exception ex)
{
throw new Exception.DalException(ex.Message);
}
}
/// <summary>
/// 获取一条记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public EmployeeNewInfo GetModel(int id)
{
try
{
//获取数据库操作接口
IDBOper dbOper = DBOper.DBOperSingle;
//打开数据库连接
using (IDbConnection conn = dbOper.OpenConn())
{
string sql = "select * from T_News where id=@id";
IDataParameter[] paras = new IDataParameter[]
{
dbOper.GetDataParameter("@id", id),
};
DataTable dt = dbOper.Query(sql, paras, conn);
EmployeeNewInfo newInfo = null;
if (dt.Rows.Count > 0)
{
newInfo = new EmployeeNewInfo();
LoadEntity(dt.Rows[0], newInfo);
}
return(newInfo);
}
}
catch (System.Exception ex)
{
throw new Exception.DalException(ex.Message);
}
}
public ActionResult GetNewInfoModel()
{
EmployeeNewInfoService NewInfoService = new EmployeeNewInfoService();
int id = int.Parse(Request["id"]);
EmployeeNewInfo newInfo = NewInfoService.GetModel(id); //获取详细信息.
return(Json(newInfo, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 详细信息
/// </summary>
/// <returns></returns>
public ActionResult ShowDetail()
{
EmployeeNewInfoService NewInfoService = new EmployeeNewInfoService();
int id = int.Parse(Request["id"]);
EmployeeNewInfo newInfo = NewInfoService.GetModel(id);
ViewData.Model = newInfo;
return(View());
}
private void LoadEntity(DataRow row, EmployeeNewInfo newInfo)
{
newInfo.Id = Convert.ToInt32(row["ID"]);
newInfo.Author = row["Author"] != DBNull.Value ? row["Author"].ToString() : string.Empty;
newInfo.Title = row["Title"] != DBNull.Value ? row["Title"].ToString() : string.Empty;
newInfo.Msg = row["Msg"] != DBNull.Value ? row["Msg"].ToString() : string.Empty;
newInfo.ImagePath = row["ImagePath"] != DBNull.Value ? row["ImagePath"].ToString() : string.Empty;
newInfo.SubDateTime = Convert.ToDateTime(row["SubDateTime"]);
}
public ActionResult AddNewInfo(EmployeeNewInfo newInfo)
{
EmployeeNewInfoService NewInfoService = new EmployeeNewInfoService();
newInfo.SubDateTime = DateTime.Now;
if (NewInfoService.AddInfo(newInfo))
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
public bool AddInfo(EmployeeNewInfo newInfo)
{
try
{
EmployeeNewInfoDal EmpNewInfoDal = new EmployeeNewInfoDal();
if (newInfo.ImagePath == null)
{
newInfo.ImagePath = "";
}
return(EmpNewInfoDal.AddInfo(newInfo));
}
catch (System.Exception ex)
{
throw new Exception.BllException(ex.Message);
}
}
public List <EmployeeNewInfo> GetPageList(int start, int end)
{
try
{
//获取数据库操作接口
IDBOper dbOper = DBOper.DBOperSingle;
//打开数据库连接
using (IDbConnection conn = dbOper.OpenConn())
{
string sql = "select * from (select row_number() over(order by id) as num,* from T_News) as t where t.num>=@start and t.num<=@end";
IDataParameter[] paras = new IDataParameter[]
{
dbOper.GetDataParameter("@start", start),
dbOper.GetDataParameter("@end", end)
};
DataTable dt = dbOper.Query(sql, paras, conn);
List <EmployeeNewInfo> list = null;
if (dt.Rows.Count > 0)
{
list = new List <EmployeeNewInfo>();
EmployeeNewInfo newInfo = null;
foreach (DataRow row in dt.Rows)
{
newInfo = new EmployeeNewInfo();
LoadEntity(row, newInfo);
list.Add(newInfo);
}
}
return(list);
}
}
catch (System.Exception ex)
{
throw new Exception.DalException(ex.Message);
}
}