Admin/jiaoyiAdd.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;

public partial class jiaoyiAdd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.bianhao.Text = "jy"+DateTime.Now.ToString("yyyyMMddhhmmss");
            string Number = this.Number.Text;
            string sql = "select * from Project";
            DataSet result = new DataSet();
            result = new Class1().hsggetdata(sql);
            if (result != null)
            {
                for (int i = 0; i < result.Tables[0].Rows.Count; i++) 
                {
                    this.DropDownList1.Items.Add(result.Tables[0].Rows[i]["Name"].ToString());
                }
            }
        }
    }
    protected void Number_TextChanged(object sender, EventArgs e)
    {
        string Number = this.Number.Text;
        string  sql = "select * from Client where Number='"+Number+"'";
        DataSet result = new DataSet();
        result = new Class1().hsggetdata(sql);
        if (result != null)
        {
            if (result.Tables[0].Rows.Count > 0) 
            {
                this.Name.Text = result.Tables[0].Rows[0]["Name"].ToString();

            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string bianhao = this.bianhao.Text;
        string Number = this.Number.Text;
        string Name = this.Name.Text;
        string qici = this.qici.Text;
        string ProjectName = this.DropDownList1.Text;
        string jiner = this.jiiner.Text;
        string Times1 = this.Times1.Text;
        string Times2 = this.Times2.Text;
        string Times3 = this.Times3.Text;
        string shouyi = this.shouyi.Text;
        string strsql = "Insert into jiaoyi(Number,shenfenzheng,ClientName,ProjectName,qici,jiner,Times1,Times2,Times3,shouyi)values(";
        strsql += " '" + bianhao + "','" + Number + "','" + Name + "','" + ProjectName + "','" + qici + "'," + jiner + ",'" + Times1 + "','" + Times2 + "','" + Times3 + "'," + shouyi + ")";
        int result;
        result = new Class1().hsgexucute(strsql);
        if (result == 1)