Esempio n. 1
0
 public M_Notice Show(int NoticeId)
 {
     SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@NoticeId", SqlDbType.Int, 4), new SqlParameter("@TypeId", SqlDbType.Int, 4) };
     commandParameters[0].Value = NoticeId;
     commandParameters[1].Value = 4;
     M_Notice notice = new M_Notice();
     DataTable table = SqlHelper.ExecuteTable(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "UP_Notice", commandParameters);
     notice.NoticeId = NoticeId;
     if (table.Rows.Count > 0)
     {
         notice.Title = table.Rows[0]["Title"].ToString();
         notice.Content = table.Rows[0]["Content"].ToString();
         if (table.Rows[0]["UserId"].ToString() != "")
         {
             notice.UserId = int.Parse(table.Rows[0]["UserId"].ToString());
         }
         notice.UserName = table.Rows[0]["UserName"].ToString();
         if (table.Rows[0]["OverdueDate"].ToString() != "")
         {
             notice.OverdueDate = DateTime.Parse(table.Rows[0]["OverdueDate"].ToString());
         }
         if (table.Rows[0]["IsPriority"].ToString() != "")
         {
             notice.IsPriority = int.Parse(table.Rows[0]["IsPriority"].ToString());
         }
         notice.IsState = table.Rows[0]["IsState"].ToString();
         if (table.Rows[0]["AddDate"].ToString() != "")
         {
             notice.AddDate = DateTime.Parse(table.Rows[0]["AddDate"].ToString());
         }
         return notice;
     }
     return null;
 }
Esempio n. 2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            string NoticeId = Request.QueryString["NoticeId"];

            if (NoticeId == null)
            {
                NoticeId = "";
            }

            if (NoticeId != "")
            {
                model = BNotice.Show(int.Parse(NoticeId));

                Label1.Text = model.Title;
                Label2.Text = model.Content;
                Label5.Text = model.OverdueDate.ToShortDateString();
                Label4.Text = model.AddDate.ToShortDateString();
                Label3.Text = model.UserName;
            }
            else
            {
                Response.Redirect("NoticeList.aspx");
                Response.End();
            }
        }
    }
Esempio n. 3
0
 public void Insert(M_Notice model)
 {
     SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@Title", SqlDbType.NVarChar), new SqlParameter("@Content", SqlDbType.NText), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@OverdueDate", SqlDbType.DateTime), new SqlParameter("@IsPriority", SqlDbType.Int, 4), new SqlParameter("@IsState", SqlDbType.NVarChar), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@TypeId", SqlDbType.Int, 4) };
     commandParameters[0].Value = model.Title;
     commandParameters[1].Value = model.Content;
     commandParameters[2].Value = model.UserId;
     commandParameters[3].Value = model.UserName;
     commandParameters[4].Value = model.OverdueDate;
     commandParameters[5].Value = model.IsPriority;
     commandParameters[6].Value = model.IsState;
     commandParameters[7].Value = model.AddDate;
     commandParameters[8].Value = model.TypeId;
     SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "UP_Notice", commandParameters);
 }
Esempio n. 4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        AdminGroupBll.Power_Judge(46);
        if (!Page.IsPostBack)
        {
            //权限判断

            string NoticeId = Request.QueryString["NoticeId"];

            if (NoticeId == null)
            {
                NoticeId = "";
            }

            if (NoticeId != "")
            {
                model = BNotice.Show(int.Parse(NoticeId));

                Title.Text = model.Title;
                Content.Text = model.Content;
                OverdueDate.Text = model.OverdueDate.ToShortDateString();
                IsPriority.Text = model.IsPriority.ToString();
                IsState.SelectedValue = model.IsState;
                UserName.Text = model.UserName;
            }
            else
            {
                M_LoginAdmin model = AdminBll.GetLoginModel();
                UserName.Text = model.AdminName.ToString();
                OverdueDate.Text = DateTime.Now.AddMonths(1).ToShortDateString();
            }
            OverdueDate.Attributes["Readonly"] = "true";
            AddDate.Text = DateTime.Now.ToShortDateString();
        }
    }
Esempio n. 5
0
 public void Update(M_Notice model)
 {
     this.inotice.Update(model);
 }
Esempio n. 6
0
 public void Insert(M_Notice model)
 {
     this.inotice.Insert(model);
 }
Esempio n. 7
0
 public void UpdateIsState(int NoticeId)
 {
     SqlParameter[] parameterArray;
     M_Notice notice = new M_Notice();
     if (this.Show(NoticeId).IsState == "草稿")
     {
         parameterArray = new SqlParameter[] { new SqlParameter("@NoticeId", SqlDbType.Int, 4), new SqlParameter("@IsState", SqlDbType.NVarChar), new SqlParameter("@TypeId", SqlDbType.Int, 4) };
         parameterArray[0].Value = NoticeId;
         parameterArray[1].Value = "审核通过";
         parameterArray[2].Value = 5;
         SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "UP_Notice", parameterArray);
     }
     else
     {
         parameterArray = new SqlParameter[] { new SqlParameter("@NoticeId", SqlDbType.Int, 4), new SqlParameter("@IsState", SqlDbType.NVarChar), new SqlParameter("@TypeId", SqlDbType.Int, 4) };
         parameterArray[0].Value = NoticeId;
         parameterArray[1].Value = "草稿";
         parameterArray[2].Value = 5;
         SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "UP_Notice", parameterArray);
     }
 }