private void FillData(NoticeInfo entity)
{
entity.Title = txtTitle.Value;
entity.Content = GetString("txtContent");
entity.CorporationID = GetInt("corpid");
entity.Realname = Admin.Realname;
}
private void LoadData()
{
int id = GetInt("id");
if (id > 0)
{
CurrentNotice = Notices.Instance.GetModel(id);
if (CurrentNotice == null)
WriteMessage("/message.aspx", "系统提示", "无效公告通知！", "", "/index.aspx");
}
}
private void LoadData()
{
int id = GetInt("id");
if (id > 0)
{
CurrentNotice = Notices.Instance.GetModel(id);
if (CurrentNotice == null)
WriteMessage("/message.aspx", "系统提示", "无效公告通知！", "", "/index.aspx");
else
{
if (!Admin.Administrator && Admin.CorporationID != CurrentNotice.CorporationID)
WriteMessage("/message.aspx", "系统提示", "没有权限！", "", "/index.aspx");
if (!Admin.Administrator && CurrentNotice.DataLevel == 0)
WriteMessage("/message.aspx", "系统提示", "没有权限！", "", "/index.aspx");
txtTitle.Value = CurrentNotice.Title;
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
NoticeInfo entity = new NoticeInfo();
int id = GetInt("id");
if (id > 0)
{
entity = Notices.Instance.GetModel(id, true);
FillData(entity);
Notices.Instance.Update(entity);
}
else
{
FillData(entity);
entity.DataLevel = GetInt("corpid") == 0 ? 0 : 1;
Notices.Instance.Add(entity);
}
Notices.Instance.ReloadNoticeListCache();
Response.Redirect(string.IsNullOrEmpty(FromUrl) ? "noticemg.aspx" : FromUrl);
}
public void Update(NoticeInfo entity)
{
CommonDataProvider.Instance().UpdateNotice(entity);
}
public void Add(NoticeInfo entity)
{
CommonDataProvider.Instance().AddNotice(entity);
}
public abstract void UpdateNotice(NoticeInfo entity);
public abstract void AddNotice(NoticeInfo entity);
public void Update(NoticeInfo entity)
{
CommonDataProvider.Instance().UpdateNotice(entity);
}
public void Add(NoticeInfo entity)
{
CommonDataProvider.Instance().AddNotice(entity);
}
public override void AddNotice(NoticeInfo entity)
{
string sql = @"INSERT INTO ComOpp_Notice(
[Title]
,[Content]
,[DataLevel]
,[Realname]
,[PublicUserID]
,[CorporationID]
)VALUES(
@Title
,@Content
,@DataLevel
,@Realname
,@PublicUserID
,@CorporationID
)";
SqlParameter[] p =
{
new SqlParameter("@Title",entity.Title),
new SqlParameter("@Content",entity.Content),
new SqlParameter("@DataLevel",entity.DataLevel),
new SqlParameter("@Realname",entity.Realname),
new SqlParameter("@PublicUserID",entity.PublicUserID),
new SqlParameter("@CorporationID",entity.CorporationID)
};
SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, p);
}
public override void UpdateNotice(NoticeInfo entity)
{
string sql = @"
UPDATE ComOpp_Notice set
Title = @Title
,Content = @Content
WHERE ID=@ID";
SqlParameter[] parameters =
{
new SqlParameter("@ID", entity.ID),
new SqlParameter("@Title", entity.Title),
new SqlParameter("@Content", entity.Content)
};
SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, parameters);
}
public abstract void UpdateNotice(NoticeInfo entity);
public abstract void AddNotice(NoticeInfo entity);
public static NoticeInfo PopulateNoticeInfo(IDataReader reader)
{
NoticeInfo entity = new NoticeInfo()
{
ID = (int)reader["ID"],
Title = reader["Title"] as string,
Content = reader["Content"] as string,
DataLevel = (int)reader["DataLevel"],
Realname = reader["Realname"] as string,
PublicUserID = (int)reader["PublicUserID"],
AddTime = DataConvert.SafeDate(reader["AddTime"]),
CorporationID = (int)reader["CorporationID"]
};
return entity;
}