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 string GetFestivalListByGroup(HttpContext context)
{
BCtrl_Festival bll = new BCtrl_Festival();
string qvalue = context.Request.QueryString["query"];
List <FestivalEntity> list = bll.GetFestivalList(qvalue, 3);
if (list != null)
{
dynamic result = new { query = "Unit", suggestions = list.Select(o => new { value = o.FestivalName, data = new { category = o.StartTime.ToString("yyyy年"), text = o.FestivalID } }) };
string temp = StringUti.ToUnicode(JsonObj <object> .ToJsonString(result));
return(temp);
}
return(string.Empty);
}
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 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);
}
private DataTable GetQueryData(bool isDownload)
{
int totalcnt = 0;
BCtrl_Festival bll = new BCtrl_Festival();
searchFestivalEntity entity = new searchFestivalEntity();
if (!string.IsNullOrEmpty(txtStartTime))
{
entity.StartTime = txtStartTime;
}
if (!string.IsNullOrEmpty(txtEndTime))
{
entity.EndTime = txtEndTime;
}
entity.PageSize = base.PageSize;
entity.PageIndex = base.PageIndex;
entity.UseDBPagination = !isDownload;
entity.OrderfieldType = OrderFieldType.Desc;
DataTable db = bll.GetFestivalList(entity, out totalcnt);
base.TotalRecords = totalcnt;
return(db);
}