protected void Page_Load(object sender, EventArgs e) { SpeechTitle condition = new SpeechTitle(); string title = GetstringKey("name"); condition.ExhibitionID = AdminMethod.ExhibitionID; if (title != "") { condition.Key_Word = "%" + title + "%"; condition.AddAttach("Key_Word", "like"); } m_tableManageList = TableOperate <SpeechTitle> .SelectByPage(condition, PageSize, PageIndex, ref Count); DataBind(); name.Value = title; }
protected void AddLog(string ids) { SpeechTitle condition = new SpeechTitle(); SpeechTitle value = new SpeechTitle(); condition.AddConditon(" and id in(" + ids + ")"); List <SpeechTitle> list = TableOperate <SpeechTitle> .Select(value, condition); if (list.Count > 0) { string deltitle = ""; for (int i = 0; i < list.Count; i++) { deltitle += list[i].Title + ","; } deltitle = deltitle.TrimEnd(','); if (deltitle != "") { string logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "删除了【" + deltitle + "】的语音触发"; Lognet.AddLogin(logbrief); } } }
protected void Page_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.Request["seviceID"])) { return; } if (string.IsNullOrEmpty(this.Request["sn"])) { return; } int SeviceID = Convert.ToInt32(this.Request["seviceID"]); string sn = RequestString.NoHTML(Convert.ToString(this.Request["sn"])); if (!SysConfig.IsTrueSn(SeviceID, sn)) { string error = "加密不正确"; Response.Write(error); return; } string json = ""; SpeechTitle condition = new SpeechTitle(); SpeechTitle value = new SpeechTitle(); condition.ExhibitionID = SeviceID; List <SpeechTitle> list = TableOperate <SpeechTitle> .Select(value, condition); if (list.Count > 0) { json = "{\"list\":["; for (int i = 0; i < list.Count; i++) { json += "{\"ID\":" + list[i].ID + ", \"Title\":\"" + list[i].Title + "\", \"KeyWord\":\"" + list[i].Key_Word + "\",\"CmdList\":" + GetList(list[i].ID) + "},"; } json = json.Trim(','); json += "]}"; Response.Write(json); } }
protected void Page_Load(object sender, EventArgs e) { string action = GetstringKey("action"); if (action != "save") { if (!string.IsNullOrEmpty(this.Request["iD"])) { int _iD = Convert.ToInt32(this.Request["iD"]); SpeechTitle condition = new SpeechTitle(); condition.ID = _iD; news = TableOperate <SpeechTitle> .GetRowData(condition); iD.Value = Convert.ToString(news.ID); } DataBind(); } else { Result result = new Result(); string logbrief = ""; SpeechTitle newChannelNews = new SpeechTitle(); newChannelNews.ID = 0; newChannelNews.AutoForm(this.Page); string Title = newChannelNews.Title; int _iD; if (!string.IsNullOrEmpty(this.Request["iD"])) { _iD = Convert.ToInt32(this.Request["iD"]); TableOperate <SpeechTitle> .Update(newChannelNews); result.msg = "编辑成功,等待返回列表"; logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "编辑了为【" + Title + "】的语音触发"; } else { newChannelNews.ExhibitionID = AdminMethod.ExhibitionID; newChannelNews.AddTime = DateTime.Now; newChannelNews.AddID = AdminMethod.AdminID; _iD = TableOperate <SpeechTitle> .InsertReturnID(newChannelNews); result.msg = "添加成功,等待返回列表"; logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "添加了为【" + Title + "】的语音触发"; } if (_iD > 0) { result.isOk = true; Lognet.AddLogin(logbrief); } else { result.msg = "操作失败"; } Response.ContentType = "text/json"; Response.Write(new JavaScriptSerializer().Serialize(result)); Response.End(); } DataBind(); }