Project/SysManage/YeJiOper.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Text;

namespace Project.SysManage
{
    public partial class YeJiOper : ManagerBase
    {
        int id;
        protected void Page_Load(object sender, EventArgs e)
        {
            id = Common.RequestInt("id");
            if (!IsPostBack)
            {
                DB.Bind_Dropdownlist("select * from YuanGong", YuanGong, "id", "xm");
                if (id > 0)
                {
                    Get_Data();
                }
                else
                    sj.Text = DateTime.Now.AddMonths(-1).ToString("yyyy-MM");
            }
        }

        void Get_Data()
        {
            DataTable dt = DB.getDataTable("select * from YeJi where Id=" + id);
            if (dt.Rows.Count == 1)
            {
                sj.Text = dt.Rows[0]["sj"].ToString();
                YuanGong.SelectedValue = dt.Rows[0]["UserId"].ToString();
                zhi1.Text = dt.Rows[0]["zhi1"].ToString();
                zt1.SelectedValue = dt.Rows[0]["zt1"].ToString();
                zt2.SelectedValue = dt.Rows[0]["zt2"].ToString();
                bz.Text = dt.Rows[0]["bz"].ToString();
            }

        }

        /// <summary>
        /// 按钮事件：提交信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnSave_Click(object sender, EventArgs e)
        {
            StringBuilder strSql = new StringBuilder();
            if (id <= 0)//添加
            {
                strSql.Append("insert into YeJi(");
                strSql.Append("UserId,sj,zhi1,zt1,zt2,bz,AddTime");
                strSql.Append(") values (");
                strSql.Append("'" + YuanGong.SelectedValue + "','" + sj.Text + "','" + zhi1.Text + "','" + zt1.SelectedValue + "','" + zt2.SelectedValue + "','" + bz.Text + "',getdate()");
                strSql.Append(") ");    
            }