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);
}
