62,074
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class manage_daywork_add : System.Web.UI.Page
{
static string st = "";
static string ch = "";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strcon = ConfigurationManager.ConnectionStrings["WHConn"].ConnectionString;
SqlConnection conn = new SqlConnection(strcon);
conn.Open();
string strcom1 = "select name man_name from men";
SqlCommand sqlcom1 = new SqlCommand(strcom1, conn);
SqlDataReader sdr1 = sqlcom1.ExecuteReader();
this.men.DataSource = sdr1;
this.men.DataTextField = "man_name";
this.men.DataValueField = "man_name";
this.men.DataBind();
sdr1.Close();
string strcom2 = "select name che_name from che";
SqlCommand sqlcom2 = new SqlCommand(strcom2, conn);
SqlDataReader sdr2 = sqlcom2.ExecuteReader();
this.che.DataSource = sdr2;
this.che.DataTextField = "che_name";
this.che.DataValueField = "che_name";
this.che.DataBind();
sdr2.Close();
conn.Close();
conn.Dispose();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
string tt = zt.Text.ToString().Trim();
string site = TextBox1.Text.ToString().Trim();
string time = TextBox4.Text.ToString().Trim();
string tool = TextBox5.Text.ToString().Trim();
string content = TextBox6.Text.ToString().Trim();
string strcon = ConfigurationManager.ConnectionStrings["WHConn"].ConnectionString;
SqlConnection sqlcon = new SqlConnection(strcon);
sqlcon.Open();
string strcom = "insert into daywork(title,author,addtime,work_site,work_content,work_time,personel,tool,vehicle) values('"+tt+"','"+Session["user"].ToString()+"','"+dt+"','"+site+"','"+content+"','"+time+"','"+st+"','"+tool+"','"+ch+"')";
SqlCommand sqlcom = new SqlCommand(strcom, sqlcon);
sqlcom.ExecuteNonQuery();
sqlcon.Close();
Response.Redirect("manage_daywork.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("manage_daywork.aspx");
}
protected void men_SelectedIndexChanged(object sender, EventArgs e)
{
string str = "";
foreach(ListItem li in this.men.Items)
{
if(li.Selected==true)
{
str = str + "、" + li.ToString().Trim();
st = str.Substring(1);
}
}
}
protected void che_SelectedIndexChanged(object sender, EventArgs e)
{
string str = "";
foreach (ListItem li in this.che.Items)
{
if (li.Selected == true)
{
str = str + "、" + li.ToString().Trim();
ch = str.Substring(1);
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if(st != ""||ch != ""){
DateTime dt = DateTime.Now;
string tt = zt.Text.ToString().Trim();
string site = TextBox1.Text.ToString().Trim();
string time = TextBox4.Text.ToString().Trim();
string tool = TextBox5.Text.ToString().Trim();
string content = TextBox6.Text.ToString().Trim();
string strcon = ConfigurationManager.ConnectionStrings["WHConn"].ConnectionString;
SqlConnection sqlcon = new SqlConnection(strcon);
sqlcon.Open();
string strcom = "insert into daywork(title,author,addtime,work_site,work_content,work_time,personel,tool,vehicle) values('"+tt+"','"+Session["user"].ToString()+"','"+dt+"','"+site+"','"+content+"','"+time+"','"+st+"','"+tool+"','"+ch+"')";
SqlCommand sqlcom = new SqlCommand(strcom, sqlcon);
sqlcom.ExecuteNonQuery();
sqlcon.Close();
st = "";
ch = "";
Response.Redirect("manage_daywork.aspx");
}
else
{
//弹出框
}
}
protected void Button1_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
string tt = zt.Text.ToString().Trim();
string site = TextBox1.Text.ToString().Trim();
string time = TextBox4.Text.ToString().Trim();
string tool = TextBox5.Text.ToString().Trim();
string content = TextBox6.Text.ToString().Trim();
string strcon = ConfigurationManager.ConnectionStrings["WHConn"].ConnectionString;
SqlConnection sqlcon = new SqlConnection(strcon);
sqlcon.Open();
string strcom = "insert into daywork(title,author,addtime,work_site,work_content,work_time,personel,tool,vehicle) values('"+tt+"','"+Session["user"].ToString()+"','"+dt+"','"+site+"','"+content+"','"+time+"','"+st+"','"+tool+"','"+ch+"')";
SqlCommand sqlcom = new SqlCommand(strcom, sqlcon);
sqlcom.ExecuteNonQuery();
sqlcon.Close();
Response.Redirect("manage_daywork.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
if(st != ""||ch != ""){
DateTime dt = DateTime.Now;
string tt = zt.Text.ToString().Trim();
string site = TextBox1.Text.ToString().Trim();
string time = TextBox4.Text.ToString().Trim();
string tool = TextBox5.Text.ToString().Trim();
string content = TextBox6.Text.ToString().Trim();
string strcon = ConfigurationManager.ConnectionStrings["WHConn"].ConnectionString;
SqlConnection sqlcon = new SqlConnection(strcon);
sqlcon.Open();
string strcom = "insert into daywork(title,author,addtime,work_site,work_content,work_time,personel,tool,vehicle) values('"+tt+"','"+Session["user"].ToString()+"','"+dt+"','"+site+"','"+content+"','"+time+"','"+st+"','"+tool+"','"+ch+"')";
SqlCommand sqlcom = new SqlCommand(strcom, sqlcon);
sqlcom.ExecuteNonQuery();
sqlcon.Close();
st = "";
;
Response.Redirect("manage_daywork.aspx");
}
else
{
//弹出框
}
}