jiyu.aspx.cs

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

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

using System;
using System.Collections.Generic;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
namespace khglcrm
{
    public partial class jiyu : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["admin"] == null)
            {
                Response.Write("<script language='javascript'>alert('登录超时');top.location.href='login.aspx';<" + "/script>");
            }
            else
            {
                if (!Page.IsPostBack)
                {
                    this.drop("预约类型", DropDownList1);
                    this.Label17.Text = "1";
                    this.show();
                    if (Label16.Text == "0")
                    {
                        this.RangeValidator2.MaximumValue = "1";
                    }
                    else
                    {
                        this.RangeValidator2.MaximumValue = Label16.Text;
                    }
                }
            }
        }
        private void drop(string nlei, DropDownList dl)
        {
            DB mydb = new DB();
            OleDbDataReader dr = mydb.GetdataReader("select * from qita where namelei='" + nlei + "'");
            while (dr.Read())
            {
                dl.Items.Add(dr["name"].ToString());
            }
            dr.Close();
            mydb.close();

        }
        private void show()
        {
            string strsql = "SELECT a.id as id, a.yulei, a.yusj, a.txri, a.yyren,a.content, a.gongsi,a.biaoshi,a.sj, b.id AS bid, b.customName AS bname FROM yuyue AS a, customer AS b WHERE int(a.gongsi)=b.id and a.biaoshi='gs' and yyren='" + Session["admin"].ToString() + "' and Format(yusj,'yyyy-mm-dd')>='" + DateTime.Now.ToShortDateString() + "' ORDER BY yusj,a.id DESC";
            DB mydb = new DB();
            mydb.showfypage(strsql, Label16, Label17, Label15, LinkButton1, LinkButton2, LinkButton3, LinkButton4, GridView1, 12);
            mydb.close();
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            TimeSpan ts = Convert.ToDateTime(TextBox2.Text).Subtract(Convert.ToDateTime(DateTime.Now.ToShortDateString()));
            if (ts.Days > int.Parse(this.TextBox3.Text))
            {