/// <summary> /// Page_Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //判断是否存在该id的公告 int id = int.Parse(Request.QueryString["id"].ToString()); AnnouncementEntity ae = AnnouncementOperation.GetAM(int.Parse(Request.QueryString["id"].ToString())); if (ae == null) { SmallScript.MessageBox(Page, "不存在该公告!点击返回!"); SmallScript.GoBack(Page); return; } else { //在表单中显示数据 DataBase db = new DataBase(); DataSet sql = db.ExCommand(string.Format("SELECT tb_announcement.id, tb_announcement.uid, tb_announcement.amtitle, tb_announcement.essay, tb_announcement.uptime, tb_user.userName FROM tb_announcement INNER JOIN tb_user ON tb_announcement.uid = tb_user.id WHERE (tb_announcement.id ={0} )", id)); string User = sql.Tables[0].Rows[0]["userName"].ToString(); lb_ID.Text = ae.Id.ToString(); tb_amtitle.Text = ae.AmTitle; lb_User.Text = User; lb_essay.Text = ae.Essay; lb_UpTime.Text = ae.Time.ToString(); } } }
public ActionResult Index() { AnnouncementEntity objAnnouncment = AnnouncementServices.GetAnnouncement(); List <HolidayEntity> objHolidayList = HolidayServices.GetAllHoliday(); ViewBag.HolidayList = objHolidayList; string AnnouncmentText = objAnnouncment.AnnouncementText; AnnouncmentText = AnnouncmentText == null ? string.Empty : AnnouncmentText; string AnnouncmentHtml = ""; if (AnnouncmentText.Trim() != "") { try { string[] AnnouncmentList = AnnouncmentText.Split(new string[] { Environment.NewLine }, StringSplitOptions.None); foreach (string item in AnnouncmentList) { AnnouncmentHtml += "<li class=\"news-item\"><small>" + item + "</small></li>"; } } catch { } } else { AnnouncmentHtml = "<li class=\"news-item\"><small>No new Announcments.</small></li>"; } ViewBag.AnnouncementMessage = AnnouncmentHtml; return(View()); }
/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/8/12 16:39:53</remarks> public bool Update(AnnouncementEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_Announcement_Update"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx); database.AddInParameter(commandWrapper, "@Platform", DbType.AnsiString, entity.Platform); database.AddInParameter(commandWrapper, "@IsTop", DbType.Boolean, entity.IsTop); database.AddInParameter(commandWrapper, "@IsRnable", DbType.Boolean, entity.IsRnable); database.AddInParameter(commandWrapper, "@Title", DbType.AnsiString, entity.Title); database.AddInParameter(commandWrapper, "@ContentString", DbType.AnsiString, entity.ContentString); database.AddInParameter(commandWrapper, "@StartTime", DbType.DateTime, entity.StartTime); database.AddInParameter(commandWrapper, "@EndTime", DbType.DateTime, entity.EndTime); database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.Idx = (System.Int32)database.GetParameterValue(commandWrapper, "@Idx"); return(Convert.ToBoolean(results)); }
private void Init() { _announcementDic = new Dictionary <string, AnnouncementEntity>(); _TopAnnouncementDic = null; var allAnnouncement = AnnouncementMgr.SelectAnnouncement(""); foreach (var item in allAnnouncement) { if (item.IsTop) { if (_TopAnnouncementDic == null) { _TopAnnouncementDic = item; } continue; } if (!_announcementDic.ContainsKey(item.Platform)) { _announcementDic.Add(item.Platform, item); } else { if (_announcementDic[item.Platform].Idx < item.Idx) { _announcementDic[item.Platform] = item; } } } }
public ActionResult Index() { AnnouncementModel model = new AnnouncementModel(); AnnouncementEntity ob = AnnouncementServices.GetAnnouncement(); model.AnnouncementText = ob.AnnouncementText; return(View(model)); }
/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, AnnouncementEntity entity) { try { service.SaveForm(keyValue, entity); } catch (Exception) { throw; } }
public ActionResult Create(AnnouncementModel model) { if (ModelState.IsValid) { AnnouncementEntity ob = new AnnouncementEntity(); ob.AnnouncementText = model.AnnouncementText; AnnouncementServices.UpdateAnnouncement(ob); TempData[HRMWeb.Helpers.AlertStyles.Success] = "Announcement Successfully Updated"; } return(RedirectToAction("Index", "Announcement")); }
public object GetAnnouncement([FromBody] JObject json) { try { string res = json.Value <string>("json"); dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res); //获取用户Id string userId = dy.userid; OperatorProvider.AppUserId = userId; //设置当前用户 Operator curUser = OperatorProvider.Provider.Current(); if (null == curUser) { return(new { code = -1, count = 0, info = "请求失败,请登录!" }); } string id = dy.data.AnnouncementId;//通知公告记录ID AnnouncementEntity entity = announcementbll.GetEntity(id); if (entity == null) { throw new ArgumentException("未找到信息"); } //未开放 //else //{ // if (entity.IsSend == "0") // { // //更改状态 // announcementbll.UpdateStatus(id); // } //} string jsondata = JsonConvert.SerializeObject(entity); NoticeData model = JsonConvert.DeserializeObject <NoticeData>(jsondata); List <Photo> pList = new List <Photo>(); //附件 DataTable file = fileInfoBLL.GetFiles(entity.Id); foreach (DataRow dr in file.Rows) { Photo p = new Photo(); p.id = dr["fileid"].ToString(); p.filename = dr["filename"].ToString(); p.fileurl = dataitemdetailbll.GetItemValue("imgUrl") + dr["filepath"].ToString().Substring(1); pList.Add(p); } model.file = pList; JsonSerializerSettings settings = new JsonSerializerSettings { DateFormatString = "yyyy-MM-dd HH:mm", //格式化日期 }; return(new { code = 0, info = "获取数据成功", data = JObject.Parse(JsonConvert.SerializeObject(model, Formatting.None, settings)) }); } catch (Exception ex) { return(new { Code = -1, Count = 0, Info = ex.Message }); } }
/// <summary> /// 添加公告 /// </summary> /// <param name="ae">公告的实例</param> /// <returns>添加成功返回true,添加失败返回 false</returns> public static bool AddAnnouncement(AnnouncementEntity ae) { DataBase db = new DataBase(); try { string sql = string.Format("INSERT INTO tb_announcement (amtitle,essay,uid) VALUES ( '{0}', '{1}','{2}')", ae.AmTitle, ae.Essay,ae.Uid); db.ExCommandNoBack(sql); return true; } catch { return false; } }
public static async Task <HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequestMessage req, TraceWriter log) { log.Info("C# HTTP trigger function processed a request."); // parse query parameter string name = req.GetQueryNameValuePairs() .FirstOrDefault(q => string.Compare(q.Key, "name", true) == 0) .Value; if (name == null) { // Get request body dynamic data = await req.Content.ReadAsAsync <object>(); name = data?.name; } string storageAccountSetting = @"DefaultEndpointsProtocol=https;AccountName=mmebstorage;AccountKey=OVUxaTWk9L0gW2/7fjhX6gJZOAjH2me9zn6g1oQKxxQVU8TOadUaNp6JLMhGJdSi3E1MMk9ezQeo9SxXQOyzYA==;EndpointSuffix=core.windows.net"; CloudStorageAccount storageAccount = CloudStorageAccount.Parse(storageAccountSetting); // Create the table client. CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); // Retrieve a reference to the table. CloudTable table = tableClient.GetTableReference("Announcements"); // Create a new customer entity. AnnouncementEntity announcement = new AnnouncementEntity(); // Construct the query operation for all customer entities where PartitionKey="Active". TableQuery <AnnouncementEntity> query = new TableQuery <AnnouncementEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Active")); //List<string> announcements = new List<string>(); List <AnnouncementModel> announcements = new List <AnnouncementModel>(); // Print the fields for each announcement. foreach (AnnouncementEntity entity in table.ExecuteQuery(query)) { if (!string.IsNullOrEmpty(entity.Announcement)) { AnnouncementModel announcementModel = new AnnouncementModel(); announcementModel.Announcement = entity.Announcement ?? string.Empty; announcementModel.StartDate = entity.StartDate; announcements.Add(announcementModel); } } return(req.CreateResponse(HttpStatusCode.OK, announcements)); }
public static void UpdateAnnouncement(AnnouncementEntity ob) { try { Announcement temp = repository.FindBy(x => x.AnnouncementId == 1).FirstOrDefault(); temp.AnnouncementId = 1; temp.AnnouncementText = ob.AnnouncementText; repository.Edit(temp); repository.Save(); } catch { throw; } }
/// <summary> /// 添加公告 /// </summary> /// <param name="ae">公告的实例</param> /// <returns>添加成功返回true,添加失败返回 false</returns> public static bool AddAnnouncement(AnnouncementEntity ae) { DataBase db = new DataBase(); try { string sql = string.Format("INSERT INTO tb_announcement (amtitle,essay,uid) VALUES ( '{0}', '{1}','{2}')", ae.AmTitle, ae.Essay, ae.Uid); db.ExCommandNoBack(sql); return(true); } catch { return(false); } }
/// <summary> /// 将IDataReader的当前记录读取到AnnouncementEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public AnnouncementEntity LoadSingleRow(IDataReader reader) { var obj = new AnnouncementEntity(); obj.Idx = (System.Int32)reader["Idx"]; obj.Platform = (System.String)reader["Platform"]; obj.IsTop = (System.Boolean)reader["IsTop"]; obj.IsRnable = (System.Boolean)reader["IsRnable"]; obj.Title = (System.String)reader["Title"]; obj.ContentString = (System.String)reader["ContentString"]; obj.StartTime = (System.DateTime)reader["StartTime"]; obj.EndTime = (System.DateTime)reader["EndTime"]; obj.RowTime = (System.DateTime)reader["RowTime"]; return(obj); }
public static AnnouncementEntity GetAM(int id) { DataBase db = new DataBase(); DataSet rs = db.RunProcReturn("select * from tb_announcement where id=" + id, "tb_announcement"); if (rs.Tables[0].Rows.Count > 0) { AnnouncementEntity ae = new AnnouncementEntity(); ae.Id=int.Parse(rs.Tables[0].Rows[0]["id"].ToString()); ae.Uid = int.Parse(rs.Tables[0].Rows[0]["uid"].ToString()); ae.AmTitle = rs.Tables[0].Rows[0]["amtitle"].ToString(); ae.Essay = rs.Tables[0].Rows[0]["essay"].ToString(); ae.Time = DateTime.Parse(rs.Tables[0].Rows[0]["uptime"].ToString()); return ae; } return null; }
public ActionResult SaveForm(string keyValue, AnnouncementEntity entity) { try { if (entity.IsSend == "0")//发布时间已发送时间为准 { entity.ReleaseTime = DateTime.Now; } announcementbll.SaveForm(keyValue, entity); return(Success("操作成功。")); } catch (Exception ex) { return(Error(ex.Message)); } }
public static async Task <HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequestMessage req, TraceWriter log) { log.Info("C# HTTP trigger function processed a request."); // parse query parameter string name = req.GetQueryNameValuePairs() .FirstOrDefault(q => string.Compare(q.Key, "name", true) == 0) .Value; if (name == null) { // Get request body dynamic data = await req.Content.ReadAsAsync <object>(); name = data?.name; } string storageAccountSetting = @"DefaultEndpointsProtocol=https;AccountName=mmebstorage;AccountKey=OVUxaTWk9L0gW2/7fjhX6gJZOAjH2me9zn6g1oQKxxQVU8TOadUaNp6JLMhGJdSi3E1MMk9ezQeo9SxXQOyzYA==;EndpointSuffix=core.windows.net"; CloudStorageAccount storageAccount = CloudStorageAccount.Parse(storageAccountSetting); // Create the table client. CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); // Retrieve a reference to the table. CloudTable table = tableClient.GetTableReference("Announcements"); // Create the table if it doesn't exist. table.CreateIfNotExists(); // Create a new customer entity. AnnouncementEntity announcement = new AnnouncementEntity(name, "Active"); announcement.StartDate = DateTime.Now.ToShortDateString(); // Create the TableOperation object that inserts the customer entity. TableOperation insertOperation = TableOperation.Insert(announcement); // Execute the insert operation. table.Execute(insertOperation); return(name == null ? req.CreateResponse(HttpStatusCode.BadRequest, "Please pass a name on the query string or in the request body") : req.CreateResponse(HttpStatusCode.OK, "Hello " + name)); }
/// <summary> /// 获取公告信息 /// </summary> /// <param name="id">公告ID</param> /// <returns>返回公告实例</returns> public static AnnouncementEntity GetAM(int id) { DataBase db = new DataBase(); DataSet rs = db.RunProcReturn("select * from tb_announcement where id=" + id, "tb_announcement"); if (rs.Tables[0].Rows.Count > 0) { AnnouncementEntity ae = new AnnouncementEntity(); ae.Id = int.Parse(rs.Tables[0].Rows[0]["id"].ToString()); ae.Uid = int.Parse(rs.Tables[0].Rows[0]["uid"].ToString()); ae.AmTitle = rs.Tables[0].Rows[0]["amtitle"].ToString(); ae.Essay = rs.Tables[0].Rows[0]["essay"].ToString(); ae.Time = DateTime.Parse(rs.Tables[0].Rows[0]["uptime"].ToString()); return(ae); } return(null); }
protected void tb_submit_Click(object sender, EventArgs e) { /*初始化工程,并设置属性*/ AnnouncementEntity ae = new AnnouncementEntity(); ae.AmTitle = tb_amtitle.Text; ae.Essay = tb_essay.Text; ae.Uid = UserOperation.GetCurrentUid(Session); /*添加工程,并返回是否成功*/ if (AnnouncementOperation.AddAnnouncement(ae) == true) { SmallScript.goRedirect(Response, Session, "公告已成功添加!", "/admin/Announcement.aspx"); } else { SmallScript.MessageBox(Page, "添加公告失败!"); }; }
public static AnnouncementEntity GetAnnouncement() { AnnouncementEntity rType = new AnnouncementEntity(); try { rType = repository.FindBy(x => x.AnnouncementId == 1).Select(x => new AnnouncementEntity { AnnouncementId = x.AnnouncementId, AnnouncementText = x.AnnouncementText }).FirstOrDefault(); } catch { throw; } return(rType); }
/// <summary> /// GetById /// </summary> /// <param name="idx">idx</param> /// <returns>AnnouncementEntity</returns> /// <remarks>2016/8/12 16:39:53</remarks> public AnnouncementEntity GetById(System.Int32 idx) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_Announcement_GetById"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx); AnnouncementEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
/// <summary> /// Page_Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = int.Parse(Request.QueryString["id"].ToString()); AnnouncementEntity ae = AnnouncementOperation.GetAM(int.Parse(Request.QueryString["id"].ToString())); if (ae != null) { DataBase db = new DataBase(); DataSet sql = db.ExCommand(string.Format("SELECT tb_announcement.id, tb_announcement.uid, tb_announcement.amtitle, tb_announcement.essay, tb_announcement.uptime, tb_user.userName FROM tb_announcement INNER JOIN tb_user ON tb_announcement.uid = tb_user.id WHERE (tb_announcement.id ={0} ) ", id)); string User = sql.Tables[0].Rows[0]["userName"].ToString(); //在表单中显示数据 lb_Id.Text = ae.Id.ToString(); lb_amtitle.Text = ae.AmTitle; lb_User.Text = User; lb_UpTime.Text = ae.Time.ToString(); lb_essay.Text = ae.Essay; } } }
/// <summary> /// 添加按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void tb_submit_Click(object sender, EventArgs e) { /*初始化工程,并设置属性*/ AnnouncementEntity ae = new AnnouncementEntity(); ae.AmTitle = tb_amtitle.Text; ae.Essay = tb_essay.Text; ae.Uid = UserOperation.GetCurrentUid(Session); /*添加工程,并返回是否成功*/ if (ae.Essay == "" || ae.AmTitle == "") { SmallScript.MessageBox(Page, "请输入完整公告信息!"); return; } if (AnnouncementOperation.AddAnnouncement(ae) == true) { SmallScript.goRedirect(Response, Session, "公告已成功添加!", "/admin/Announcement.aspx"); } else { SmallScript.MessageBox(Page, "添加公告失败!"); }; }
public static void UpdateAnnouncement(AnnouncementEntity ob) { AnnouncementProvider.UpdateAnnouncement(ob); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/8/12 16:39:53</remarks> public bool Insert(AnnouncementEntity entity) { return(Insert(entity, null)); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2016/8/12 16:39:53</remarks> public bool Update(AnnouncementEntity entity) { return(Update(entity, null)); }
public static bool Insert(AnnouncementEntity announcementEntity, DbTransaction trans = null, string zoneId = "") { var provider = new AnnouncementProvider(zoneId); return(provider.Insert(announcementEntity, trans)); }