repares/Add.aspx.cs

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

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

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

public partial class repares_Add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
        
        }
    }

    /// <summary>
    /// 添加检修单
    ///</summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (txt_tel.Text.Length != 11)
        {
            MessageBox.Show(this, "请重新输入手机号！");
            return;
        }

        if (!DbHelperSQL.Exists("select count(*) from assets where asname='" + txt_assname.Text + "'"))
        {
            MessageBox.Show(this, "该检修设备名称不存在，请重新输入！");
            return;
        }

        //设置添加sql
        string strSql=String.Format(@"insert into repares(assname,address,rtype,rdate,ques,peo,tel,flag1)
                                values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",
                                txt_assname.Text,txt_address.Text,ddlrtype.SelectedValue,txt_rdate.Text,txt_ques.Text,txt_peo.Text,txt_tel.Text,"等待审核");
        //提交到数据库
        DbHelperSQL.ExecuteSql(strSql.ToString());


        MessageBox.ShowAndRedirect(this, "提交成功，请等待组长的审核!", "Manage.aspx");
    }



    protected void txt_assname_TextChanged(object sender, EventArgs e)
    {
        if (!DbHelperSQL.Exists("select count(*) from assets where asname='" + txt_assname.Text + "'"))
        {
            MessageBox.Show(this, "该检修设备名称不存在，请重新输入！");
            return;
        }