public string GetFestivalList(HttpContext context) { BCtrl_Festival bll = new BCtrl_Festival(); List <FestivalEntity> list = bll.GetFestivalList("", 3); if (list == null) { return(string.Empty); } var groupYear = list.OrderByDescending(o => o.StartTime).GroupBy(o => o.StartTime.ToString("yyyy年")); List <FestivalEntity> resultlist = new List <FestivalEntity>(); foreach (var year in groupYear) { FestivalEntity entity = new FestivalEntity { FestivalName = year.Key, FestivalList = year.Select(o => o).ToList() }; resultlist.Add(entity); } string result = StringUti.ToUnicode(JsonObj <object> .ToJsonString(resultlist)); return(result); }
public async Task <FestivalDTO> CreateFestivalAsync(CreateFestivalDTO createFestivalDTO) { var festival = new FestivalEntity { Year = createFestivalDTO.Year, Location = createFestivalDTO.Location }; if (createFestivalDTO.PartnerIds != null) { var partners = await _DBContext.Partners.Where(p => createFestivalDTO.PartnerIds.Contains(p.Id)).ToListAsync(); if (partners.Count > 0) { festival.PartnerFestivals = partners.Select(partner => new PartnerFestivalEntity { PartnerId = partner.Id }).ToList(); } } await _DBContext.Festivals.AddAsync(festival); await _DBContext.SaveChangesAsync(); var festivalDTO = _mapper.Map <FestivalDTO>(festival); return(festivalDTO); }
/// <summary> /// 添加日历信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public string InsertFestival(FestivalEntity entity) { string flg = "0"; string sql = "select * from M_Festival where FestivalName=@FestivalName and StartTime=@StartTime and EndTime=@EndTime and FestivalType=@FestivalType"; string sql1 = "insert into M_Festival(FestivalName,FestivalShortName,StartTime,EndTime,FestivalType,FestivalWeight) values (@FestivalName,@FestivalShortName,@StartTime,@EndTime,@FestivalType,@FestivalWeight)"; SqlParameter[] pars = { new SqlParameter("FestivalName", SqlDbType.NVarChar, 50), new SqlParameter("FestivalShortName", SqlDbType.NVarChar, 50), new SqlParameter("StartTime", SqlDbType.DateTime), new SqlParameter("EndTime", SqlDbType.DateTime), new SqlParameter("FestivalType", SqlDbType.Int), new SqlParameter("FestivalWeight", SqlDbType.Int) }; pars[0].Value = entity.FestivalName; pars[1].Value = entity.FestivalShortName; pars[2].Value = entity.StartTime; pars[3].Value = entity.EndTime; pars[4].Value = entity.FestivalType; pars[5].Value = entity.FestivalWeight; SqlTransaction trans = null; using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr)) { try { conn.Open(); trans = conn.BeginTransaction(); DataTable db = SQlHelper.ExecuteDataset(trans, CommandType.Text, sql, pars).Tables[0]; if (db.Rows.Count == 0) { SQlHelper.ExecuteNonQuery(trans, CommandType.Text, sql1, pars); flg = "1"; trans.Commit(); } else { flg = "2"; } } catch (Exception e) { LogUtil.WriteLog(e); if (trans != null) { flg = "0"; //数据传输错误! trans.Rollback(); } } } return(flg); }
/// <summary> /// 删除日历信息 /// </summary> /// <param name="FestivalID"></param> /// <returns></returns> public string deleteFestival(FestivalEntity entity) { SqlTransaction trans = null; string flg = "0"; string sql = "delete from M_Festival where FestivalID=@FestivalID"; string sql1 = "update M_EventItem set FestivalID=@Festivalnullid,Title2=@Title2,StartTime2=@StartTime2,EndTime2=@EndTime2,EventItemFlag=@EventItemFlag where FestivalID=@FestivalID"; string sql2 = "select EventItemID from M_EventItem where FestivalID=@FestivalID"; SqlParameter[] pars = { new SqlParameter("FestivalID", SqlDbType.UniqueIdentifier) }; pars[0].Value = entity.FestivalID; SqlParameter[] pars1 = { new SqlParameter("FestivalID", SqlDbType.UniqueIdentifier), new SqlParameter("Festivalnullid", SqlDbType.UniqueIdentifier), new SqlParameter("Title2", SqlDbType.NVarChar,100), new SqlParameter("StartTime2", SqlDbType.DateTime), new SqlParameter("EndTime2", SqlDbType.DateTime), new SqlParameter("EventItemFlag", SqlDbType.Int) }; pars1[0].Value = entity.FestivalID; try { using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr)) { conn.Open(); trans = conn.BeginTransaction(); DataTable db = SQlHelper.ExecuteDataset(trans, CommandType.Text, sql2, pars).Tables[0]; if (db.Rows.Count > 0) { SQlHelper.ExecuteNonQuery(trans, CommandType.Text, sql1, pars1); } SQlHelper.ExecuteNonQuery(trans, CommandType.Text, sql, pars); trans.Commit(); flg = "1"; } } catch (Exception e) { flg = "0"; if (trans != null) { trans.Rollback(); } LogUtil.WriteLog(e); } return(flg); }
private void InitData() { if (!string.IsNullOrEmpty(id)) { FestivalEntity entity = new FestivalEntity(); entity.FestivalID = new Guid(id); BCtrl_Festival bll = new BCtrl_Festival(); DataTable db = bll.GetFestival(entity); if (db.Rows.Count > 0) { this.FestivalName.Value = db.Rows[0]["FestivalName"].ToString(); this.FestivalShortName.Value = db.Rows[0]["FestivalShortName"].ToString(); starttime = Convert.ToDateTime(db.Rows[0]["StartTime"].ToString()).ToString("yyyy-MM-dd"); Endtime = Convert.ToDateTime(db.Rows[0]["EndTime"].ToString()).ToString("yyyy-MM-dd"); this.FestivalType.Value = db.Rows[0]["FestivalType"].ToString(); this.FestivalWeight.Value = db.Rows[0]["FestivalWeight"].ToString(); this.txtid.Value = db.Rows[0]["FestivalID"].ToString(); } } }
public string delFestival(HttpContext context) { string stat = "{\"status\":0}"; string id = context.Request.Form["Festivalid"]; FestivalEntity entity = new FestivalEntity(); entity.FestivalID = new Guid(id); BCtrl_Festival bll = new BCtrl_Festival(); string flg = bll.deleteFestival(entity); if (flg == "1") { stat = "{\"status\":1}"; } else { stat = "{\"status\":0}"; } return(stat); }
public DataTable GetFestival(FestivalEntity entity) { DataTable db = new DataTable(); string sql = "select * from M_Festival where FestivalID=@FestivalID"; SqlParameter[] pars = { new SqlParameter("FestivalID", SqlDbType.UniqueIdentifier) }; pars[0].Value = entity.FestivalID; try { using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr)) { db = SQlHelper.ExecuteDataset(conn, CommandType.Text, sql, pars).Tables[0]; } } catch (Exception e) { LogUtil.WriteLog(e); } return(db); }
public string UpdateFestival(HttpContext context) { string str = "{\"status\":0}"; FestivalEntity entity = new FestivalEntity(); if (!string.IsNullOrEmpty(context.Request.Form["id"])) { entity.FestivalID = new Guid(context.Request.Form["id"]); entity.FestivalName = context.Request.Form["name"]; entity.FestivalShortName = context.Request.Form["shortname"]; int type = 0; int Weight = 0; int.TryParse(context.Request.Form["type"], out type); int.TryParse(context.Request.Form["Weight"], out Weight); entity.FestivalType = type; entity.FestivalWeight = Weight; if (!string.IsNullOrEmpty(context.Request.Form["txtStartTime"])) { entity.StartTime = DateTime.Parse(context.Request.Form["txtStartTime"]).Date; } if (!string.IsNullOrEmpty(context.Request.Form["txtEndTime"])) { entity.EndTime = DateTime.Parse(context.Request.Form["txtEndTime"]).Date.AddDays(1).AddSeconds(-1); } BCtrl_Festival bll = new BCtrl_Festival(); string flg = bll.UpdateFestival(entity); if (flg == "0") { str = "{\"status\":0}"; } else if (flg == "1") { str = "{\"status\":1}"; } else if (flg == "2") { str = "{\"status\":2}"; } } return(str); }
public string UpdateFestival(FestivalEntity entity) { return(fesobj.UpdateFestival(entity)); }
public DataTable GetFestival(FestivalEntity entity) { return(fesobj.GetFestival(entity)); }
public string deleteFestival(FestivalEntity entity) { return(fesobj.deleteFestival(entity)); }
public string InsertFestival(FestivalEntity entity) { return(fesobj.InsertFestival(entity)); }
public string UpdateFestival(FestivalEntity entity) { string flg = "0"; string sql = "select * from M_Festival where FestivalName=@FestivalName and StartTime=@StartTime and EndTime=@EndTime and FestivalType=@FestivalType and FestivalID <> @FestivalID"; string sql3 = "select FestivalName,Convert(varchar(20),StartTime,120) as StartTime,Convert(varchar(20),EndTime,120) as EndTime,FestivalType from M_Festival where FestivalID=@FestivalID"; string sql1 = "update M_Festival set FestivalName=@FestivalName,FestivalShortName=@FestivalShortName,FestivalType=@FestivalType,StartTime=@StartTime,EndTime=@EndTime,FestivalWeight=@FestivalWeight where FestivalID=@FestivalID"; string sql2 = "update M_EventItem set Title2=@FestivalName,StartTime2=@StartTime,EndTime2=@EndTime where FestivalID=@FestivalID"; string sql4 = "update M_EventItem set FestivalID=@Festivalnullid,Title2=@Title2,StartTime2=@StartTime2,EndTime2=@EndTime2,EventItemFlag=@EventItemFlag where FestivalID=@FestivalID"; SqlParameter[] pars1 = { new SqlParameter("FestivalID", SqlDbType.UniqueIdentifier), new SqlParameter("Festivalnullid", SqlDbType.UniqueIdentifier), new SqlParameter("Title2", SqlDbType.NVarChar,100), new SqlParameter("StartTime2", SqlDbType.DateTime), new SqlParameter("EndTime2", SqlDbType.DateTime), new SqlParameter("EventItemFlag", SqlDbType.Int) }; pars1[0].Value = entity.FestivalID; SqlTransaction trans = null; SqlParameter[] pars = { new SqlParameter("FestivalName", SqlDbType.NVarChar, 50), new SqlParameter("FestivalShortName", SqlDbType.NVarChar, 50), new SqlParameter("StartTime", SqlDbType.DateTime), new SqlParameter("EndTime", SqlDbType.DateTime), new SqlParameter("FestivalType", SqlDbType.Int), new SqlParameter("FestivalWeight", SqlDbType.Int), new SqlParameter("@FestivalID", SqlDbType.UniqueIdentifier) }; pars[0].Value = entity.FestivalName; pars[1].Value = entity.FestivalShortName; pars[2].Value = entity.StartTime; pars[3].Value = entity.EndTime; pars[4].Value = entity.FestivalType; pars[5].Value = entity.FestivalWeight; pars[6].Value = entity.FestivalID; using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr)) { try { conn.Open(); trans = conn.BeginTransaction(); DataTable db = SQlHelper.ExecuteDataset(trans, CommandType.Text, sql, pars).Tables[0]; if (db.Rows.Count == 0) //无重复性 可以修改 { DataTable db1 = SQlHelper.ExecuteDataset(trans, CommandType.Text, sql3, pars).Tables[0]; if (db1.Rows.Count > 0) { for (int i = 0; i < db1.Rows.Count; i++) //修改前为日期,改后不为日期,M_EventItem表清空 { if (db1.Rows[i]["FestivalType"].ToString().Trim().Equals("3")) { if (db1.Rows[i]["FestivalType"].ToString().Trim().Equals("3") && entity.FestivalType != 3) { SQlHelper.ExecuteNonQuery(trans, CommandType.Text, sql4, pars1); } else if (!db1.Rows[i]["FestivalName"].ToString().Trim().Equals(entity.FestivalName) || !db1.Rows[i]["StartTime"].ToString().Trim().Equals(entity.StartTime) || !db1.Rows[i]["EndTime"].ToString().Trim().Equals(entity.EndTime)) { SQlHelper.ExecuteNonQuery(trans, CommandType.Text, sql2, pars); } } } } SQlHelper.ExecuteNonQuery(trans, CommandType.Text, sql1, pars); flg = "1"; trans.Commit(); } else { flg = "2"; } } catch (Exception e) { LogUtil.WriteLog(e); if (trans != null) { flg = "0"; //数据传输错误! trans.Rollback(); } } } return(flg); }