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