Project/addProject.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;
using ExtAspNet;

public partial class Project_addProject : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ExecuteSql exe = new ExecuteSql();

        string strProjectID = exe.getProjectMaxIdentID(1);

        projectID.Text = strProjectID;
    }
    // 下载于www.51aspx.com
    protected void butSubmit_Click(object sender, EventArgs e)
    {
        string projectPrincipal=Request.Form["projectPrincipal"]!=null?Request.Form["projectPrincipal"].ToString():"";

        string projectParticipant=Request.Form["projectParticipant"]!=null?Request.Form["projectParticipant"].ToString():"";

        string strSql = "INSERT INTO [project]([projectID],[projectName],[projectSource],[projectLeve],[projectType],[projectClassName],[projectState],[projectStart],[projectStop],[projectPrincipal],[projectParticipant],[projectTotalMoney],[projectReceiveMoney])";

        
        string strValue = string.Format(" VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}',{11},{12})",
            projectID.Text.Trim(),
            projectName.Text.Trim(),
            projectSource.Text.Trim(),
            projectLeve.SelectedItem.Text,
            projectType.SelectedItem.Text,
            projectClassName.SelectedItem.Text,
            projectState.SelectedItem.Text,
            projectStart.Text.Trim(),
            projectStop.Text.Trim(),
            projectPrincipal,
            projectParticipant,
            projectTotalMoney.Text.Trim(),
            projectReceiveMoney.Text.Trim() 
            );

        strSql = strSql + strValue;

        ExecuteSql exe = new ExecuteSql();

        if (exe.exeSQL(strSql) == 1)
            Alert.ShowInTop("提交成功！", "提示:", "window.location='Project/addProject.aspx';");
        else
            Alert.ShowInTop("提交失败！");

    }
}