📄 addfiles.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.IO;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using RWSB.inputcon;
namespace RWSB
{
/// <summary>
/// AddFiles 的摘要说明。
/// </summary>
public partial class AddFiles : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox Tb_BiaoTi;
private static DateTime oDateTime;
protected void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
//如果用户已登录，则显示本页面，否则转向登录
if((Session["UserGrade"].ToString().Trim() != "车间技术员")&&(Session["UserGrade"].ToString().Trim() != "管理员"))
{
Response.Write("<script>alert('对不起，您不具有权限');</script>");
Response.End();
}
if (Session["UserGrade"] == null)
Session["UserGrade"] = DBOperateSite.GetUserGrade(User.Identity.Name);
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
}
#endregion
private bool CheckInput()
{
if (zyzTB.Text.Trim() == "")
{
Response.Write("<script>alert('作业组人数不能为空！');Form1.zyzTB.focus();</script>");
return false;
}
if (edrsTB.Text.Trim() == "")
{
Response.Write("<script>alert('上网作业人数不能为空！');Form1.edrsTB.focus();</script>");
return false;
}
if (zcTB.Text.Trim() == "")
{
Response.Write("<script>alert('站场、区间不能为空！');Form1.zcTB.focus();</script>");
return false;
}
if (zzhTB.Text.Trim() == "")
{
Response.Write("<script>alert('支柱号不能为空！');Form1.zzhTB.focus();</script>");
return false;
}
if (sbrTB.Text.Trim() == "")
{
Response.Write("<script>alert('上报人不能为空！');Form1.sbrTB.focus();</script>");
return false;
}
return true;
}
protected void Button1_Click(object sender, System.EventArgs e)
{
//提交信息
/*if (!CheckInput())
{
return;
}
*/
string wcslstr, str1, str2, str3, str4, str5, str6, str7, str8, str9, str10, str11, str12, str13,str14;
if (qmjcTB.Text.Trim() != "0")
{
str1 = " 全面检查 " + qmjcTB.Text.Trim() + " km ";
}
else
{
str1 = "";
}
if (mdgjTB.Text.Trim() != "0")
{
str2 = " 锚段关节 " + mdgjTB.Text.Trim() + " 组 ";
}
else
{
str2 = "";
}
if (xcTB.Text.Trim() != "0")
{
str3 = " 线岔 " + xcTB.Text.Trim() + " 组 ";
}
else
{
str3 = "";
}
if (fdTB.Text.Trim() != "0")
{
str4 = " 分段 " + fdTB.Text.Trim() + " 组 ";
}
else
{
str4 = "";
}
if (fxTB.Text.Trim() != "0")
{
str5 = " 分相 " + fxTB.Text.Trim() + " 组 ";
}
else
{
str5 = "";
}
if (gdxTB.Text.Trim() != "0")
{
str6 = " 供电线 " + gdxTB.Text.Trim() + " 米 ";
}
else
{
str6 = "";
}
if (jyppTB.Text.Trim() != "0")
{
str12 = " 绝缘瓶 " + jyppTB.Text.Trim() + " 片 ";
}
else
{
str12 = "";
}
if (jypbTB.Text.Trim() != "0")
{
str13 = " 绝缘瓶 " + jypbTB.Text.Trim() + " 棒 ";
}
else
{
str13 = "";
}
if (qtTB.Text.Trim() != "")
{
str7 = " 其他： " + qtTB.Text.Trim() + " " + dmsgTB.Text.Trim() + " ";
}
else
{
str7 = "";
}
if (dmsgTB.Text.Trim() != "")
{
str14 = " " + dmsgTB.Text.Trim() + " ";
}
else
{
str14 = "";
}
if (phrsTB.Text.Trim() != "")
{
str8 = " 施工配合人数 " + phrsTB.Text.Trim() + " 人 ";
}
else
{
str8 = "";
}
if (phxmDDL.SelectedItem.Text.Trim() != "")
{
str9 = " 配合项目： " + phxmDDL.SelectedItem.Text.Trim() + " ";
}
else
{
str9 = "";
}
if (clqxTB.Text.Trim() != "")
{
str10 = " 处理缺陷： " + clqxTB.Text.Trim() + " ";
}
else
{
str10 = "";
}
if (phgzlTB.Text.Trim() != "")
{
str11 = " 配合工作量： " + phgzlTB.Text.Trim() + " ";
}
else
{
str11 = "";
}
wcslstr = str1 + str2 + str3 + str4 + str5 + str6 + str7 + str8 + str9 + str10 + str11 + str12 + str13 + str14 ;
oDateTime = DateTime.Now;
SqlConnection sqlConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
try
{
string s = "INSERT INTO rwxx (sbsj, xb, tdtc, zysjs, zysje, zyzrs, edrs,zcqj, zzh, zyxm,wcsl,rwxz,sbqx,sbr,zycj,zycjorder,rwsn,qmjc,mdgj,xc,fd,fx,gdx,qt,phrs,phxm,phgzl,jypp,jypb)" +
"VALUES ( @sbsj,@xb,@tdtc,@zysjs,@zysje,@zyzrs,@edrs,@zcqj,@zzh,@zyxm,@wcsl,@rwxz,@sbqx,@sbr,@zycj,@zycjorder,@rwsn,@qmjc,@mdgj,@xc,@fd,@fx,@gdx,@qt,@phrs,@phxm,@phgzl,@jypp,@jypb)";
SqlCommand sqlCmd = new SqlCommand(s, sqlConnection);
sqlCmd.Parameters.Add(new SqlParameter("@zyxm", SqlDbType.Text));
sqlCmd.Parameters["@zyxm"].Value = zynrDDL.SelectedItem.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@wcsl", SqlDbType.Text));
sqlCmd.Parameters["@wcsl"].Value = wcslstr;
sqlCmd.Parameters.Add(new SqlParameter("@sbqx", SqlDbType.Text));
sqlCmd.Parameters["@sbqx"].Value = sbqxTB.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@sbsj", SqlDbType.DateTime));
sqlCmd.Parameters["@sbsj"].Value = ActDate.DATE;
sqlCmd.Parameters.Add(new SqlParameter("@xb", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@xb"].Value = xbDDL.SelectedItem.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@tdtc", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@tdtc"].Value = tdtcTB.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@zysjs", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@zysjs"].Value = zystart.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@zysje", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@zysje"].Value = zyend.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@zyzrs", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@zyzrs"].Value = zyzTB.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@edrs", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@edrs"].Value = edrsTB.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@zcqj", SqlDbType.VarChar, 300));
sqlCmd.Parameters["@zcqj"].Value = zcTB.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@zzh", SqlDbType.VarChar, 300));
sqlCmd.Parameters["@zzh"].Value = zzhTB.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@rwxz", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@rwxz"].Value = rwxzDDL.SelectedItem.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@sbr", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@sbr"].Value = sbrTB.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@zycj", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@zycj"].Value = Session["userbmmc"];
sqlCmd.Parameters.Add(new SqlParameter("@zycjorder", SqlDbType.Int));
sqlCmd.Parameters["@zycjorder"].Value = Convert.ToInt32(Session["userbmorder"]);
sqlCmd.Parameters.Add(new SqlParameter("@rwsn", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@rwsn"].Value = oDateTime.ToString("yyyyMMddhhmmss");
sqlCmd.Parameters.Add(new SqlParameter("@qmjc", SqlDbType.Float));
sqlCmd.Parameters["@qmjc"].Value = Convert.ToDouble(qmjcTB.Text.Trim());
sqlCmd.Parameters.Add(new SqlParameter("@mdgj", SqlDbType.Float));
sqlCmd.Parameters["@mdgj"].Value = Convert.ToDouble(mdgjTB.Text.Trim());
sqlCmd.Parameters.Add(new SqlParameter("@xc", SqlDbType.Float));
sqlCmd.Parameters["@xc"].Value = Convert.ToDouble(xcTB.Text.Trim());
sqlCmd.Parameters.Add(new SqlParameter("@fd", SqlDbType.Float));
sqlCmd.Parameters["@fd"].Value = Convert.ToDouble(fdTB.Text.Trim());
sqlCmd.Parameters.Add(new SqlParameter("@fx", SqlDbType.Float));
sqlCmd.Parameters["@fx"].Value = Convert.ToDouble(fxTB.Text.Trim());
sqlCmd.Parameters.Add(new SqlParameter("@gdx", SqlDbType.Float));
sqlCmd.Parameters["@gdx"].Value = Convert.ToDouble(gdxTB.Text.Trim());
sqlCmd.Parameters.Add(new SqlParameter("@qt", SqlDbType.Text));
sqlCmd.Parameters["@qt"].Value = qtTB.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@phrs", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@phrs"].Value = phrsTB.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@phxm", SqlDbType.VarChar, 50));
sqlCmd.Parameters["@phxm"].Value = phxmDDL.SelectedItem.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@phgzl", SqlDbType.Text));
sqlCmd.Parameters["@phgzl"].Value = phgzlTB.Text.Trim();
sqlCmd.Parameters.Add(new SqlParameter("@jypp", SqlDbType.Float));
sqlCmd.Parameters["@jypp"].Value = Convert.ToDouble(jyppTB.Text.Trim());
sqlCmd.Parameters.Add(new SqlParameter("@jypb", SqlDbType.Float));
sqlCmd.Parameters["@jypb"].Value = Convert.ToDouble(jypbTB.Text.Trim());
sqlConnection.Open();
sqlCmd.ExecuteNonQuery();
Response.Write("<script>alert('任务上报成功！');location.href='default2.aspx';</script>");
sqlConnection.Close();
}
catch (Exception exception)
{
//Response.Write("<script>alert('保存文件时出错！');</script>");
Response.Write(exception.Message);
Response.End();
//sqlConnection.Close();
return;
}
}
protected void Button2_Click(object sender, System.EventArgs e)
{
//清除内容
zyzTB.Text = "";
edrsTB.Text = "";
zcTB.Text = "";
zzhTB.Text = "";
qmjcTB.Text = "";
mdgjTB.Text = "";
sbqxTB.Text = "";
sbrTB.Text = "";
jyppTB.Text = "";
jypbTB.Text = "";
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -