public JsonResult AddRotation(RotationChartViewModel model) { ResultRetrun rmodel = new ResultRetrun(); if (ModelState.IsValid) { RotationChart downModel = new RotationChart() { ImgSrc = model.HeadImg, Type = model.RotationType, WebLink = model.WebLink, State = PublishState.Upper }; List <RotationChart> rlist = rotationService.GetAll(model.RotationType); if (rlist != null && model.RotationType == RotationType.Banner && rlist.Count >= 5) { rmodel.message = "最多添加Banner轮播不可超过5条"; return(Json(rmodel)); } if (rlist != null && model.RotationType == RotationType.Logo && rlist.Count >= 20) { rmodel.message = "最多添加Logo轮播不可超过20条"; return(Json(rmodel)); } rmodel.isSuccess = rotationService.Add(downModel); } return(Json(rmodel)); }
public bool Update(RotationChart rotationChartInfo) { //参数验证 if (rotationChartInfo == null) { ErrorMsg = ErrorCode.ParameterNull; return(false); } return(_rotationChartProvider.Update(rotationChartInfo)); }
/// <summary> /// 从游标中读取数据 /// </summary> /// <param name="reader"></param> /// <returns></returns> private RotationChart GetRotationChartFromReader(DbDataReader reader) { RotationChart rotationInfo = new RotationChart(); rotationInfo.Id = Convert.ToInt32(reader["Id"]); rotationInfo.WebLink = reader["WebLink"].ToString(); rotationInfo.Type = (RotationType)reader["Type"]; rotationInfo.ImgSrc = reader["ImgSrc"].ToString(); rotationInfo.State = Convert.ToInt32(reader["State"]) < 1 ? PublishState.Lower : PublishState.Upper; rotationInfo.CreateDate = Convert.ToDateTime(reader["CreateDate"]); return(rotationInfo); }
public RotationChart Get(int id) { //参数验证 if (id < 1) { ErrorMsg = ErrorCode.ParameterNull; return(null); } //数据获取 RotationChart rotationChartInfo = _rotationChartProvider.Get(id); return(rotationChartInfo); }
public JsonResult EditRotation(RotationChartViewModel model) { ResultRetrun rmodel = new ResultRetrun(); if (ModelState.IsValid) { RotationChart data = rotationService.Get(model.Id); data.ImgSrc = model.HeadImg; data.Type = model.RotationType; data.WebLink = model.WebLink; rmodel.isSuccess = rotationService.Update(data); } return(Json(rmodel)); }
/// <summary> /// 更新 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult EditRotation(int id) { RotationChart model = rotationService.Get(id); if (model != null) { return(View(new RotationChartViewModel() { Id = model.Id, HeadImg = model.ImgSrc, WebLink = model.WebLink, RotationType = model.Type, SmallHeadImg = GetThumb(model.ImgSrc) })); } return(View()); }
/// <summary> /// 根据ID获取轮播信息 /// </summary> /// <param name="id">轮播ID</param> /// <returns>轮播信息</returns> public RotationChart Get(int id) { RotationChart rotationInfo = null; DBHelper dbHelper = new DBHelper(ConnectionString, DbProviderType.SqlServer); string strSql = @"SELECT Id, ImgSrc, WebLink, State, Type, CreateDate from RotationChart where IsDeleted=0 and id=@Id "; List <DbParameter> parametersList = new List <DbParameter>(); parametersList.Add(new SqlParameter("@Id", id)); using (DbDataReader reader = dbHelper.ExecuteReader(strSql, parametersList)) { while (reader.Read()) { rotationInfo = GetRotationChartFromReader(reader); } } return(rotationInfo); }
/// <summary> /// 修改轮播 /// </summary> /// <param name="rotationInfo">轮播信息</param> /// <returns>修改成功标识</returns> public bool Update(RotationChart rotationInfo) { DBHelper dbHelper = new DBHelper(ConnectionString, DbProviderType.SqlServer); string strSql = @"Update RotationChart Set [ImgSrc]=@ImgSrc ,[WebLink]=@WebLink ,[State]=@State ,[Type]=@Type Where ID=@ID"; List <DbParameter> parametersList = new List <DbParameter>(); parametersList.Add(new SqlParameter("@ID", rotationInfo.Id)); parametersList.Add(new SqlParameter("@ImgSrc", rotationInfo.ImgSrc)); parametersList.Add(new SqlParameter("@WebLink", rotationInfo.WebLink)); parametersList.Add(new SqlParameter("@State", (int)rotationInfo.State)); parametersList.Add(new SqlParameter("@Type", (int)rotationInfo.Type)); return(dbHelper.ExecuteNonQuery(strSql, parametersList) > 0); }
public bool Add(RotationChart rotationChartInfo) { //参数验证 if (rotationChartInfo == null) { ErrorMsg = ErrorCode.ParameterNull; return(false); } bool isSuccess = _rotationChartProvider.Add(rotationChartInfo); if (isSuccess) { try { List <RotationSort> sortList = GetRotationSorts(); if (sortList.Find(g => g.RotationType == rotationChartInfo.Type) != null) { sortList.Find(g => g.RotationType == rotationChartInfo.Type).SortList.Add(rotationChartInfo.Id); } else { sortList.Add(new RotationSort() { RotationType = rotationChartInfo.Type, SortList = new List <int>() { rotationChartInfo.Id } }); } UpdateRotationSort(sortList); } catch { } } return(isSuccess); }
/// <summary> /// 获取所有轮播信息 /// </summary> /// <param name="condition">筛选条件</param> /// <returns>轮播集合</returns> public List <RotationChart> GetAll(FilterEntityModel condition) { string whereSort = string.Empty; if (condition != null) { condition.DefaultSort = SortType.Desc; whereSort = condition.Where + condition.OrderBy; } List <RotationChart> rotationList = null; DBHelper dbHelper = new DBHelper(ConnectionString, DbProviderType.SqlServer); string strSql = @"SELECT Id, ImgSrc, WebLink, State, Type, CreateDate from RotationChart where IsDeleted=0 " + whereSort; IList <DbParameter> parameList = null; if (condition != null && condition.SqlParList.Count > 0) { parameList = new List <DbParameter>(); foreach (var item in condition.SqlParList) { parameList.Add(new SqlParameter(item.Key, item.Value)); } } using (DbDataReader reader = dbHelper.ExecuteReader(strSql, parameList)) { rotationList = new List <RotationChart>(); RotationChart rotationInfo = null; while (reader.Read()) { rotationInfo = GetRotationChartFromReader(reader); rotationList.Add(rotationInfo); } } return(rotationList); }
/// <summary> /// 添加轮播 /// </summary> /// <param name="rotationInfo">轮播信息</param> /// <returns>添加成功标识</returns> public bool Add(RotationChart rotationInfo) { bool isSuccess = false; DBHelper dbHelper = new DBHelper(ConnectionString, DbProviderType.SqlServer); string strSql = @"Insert Into RotationChart (ImgSrc, WebLink, State, Type) Values (@ImgSrc, @WebLink, @State, @Type);select SCOPE_IDENTITY()"; List <DbParameter> parametersList = new List <DbParameter>(); parametersList.Add(new SqlParameter("@ImgSrc", rotationInfo.ImgSrc)); parametersList.Add(new SqlParameter("@WebLink", rotationInfo.WebLink)); parametersList.Add(new SqlParameter("@State", (int)rotationInfo.State)); parametersList.Add(new SqlParameter("@Type", (int)rotationInfo.Type)); int iResultInsert = Convert.ToInt32(dbHelper.ExecuteScalar(strSql, parametersList)); if (iResultInsert > 0) { //若成功,则记录成功信息:患者信息,发卡时间,索引信息 rotationInfo.Id = iResultInsert; isSuccess = true; } return(isSuccess); }
public async Task <IActionResult> Edit(int id) { RotationChart result = await _bll.GetById(id); return(PartialView(result)); }