 |
|
Code (C#)
Code C#
Code (C#)
[cs]using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Text;
using System.Globalization;
using System.Threading;
namespace Test
{
public partial class _Default : Page
{
SqlConnection conn = new SqlConnection("Data Source=ARTEMIS\\SQL2014;Initial Catalog=SvlITDB;User ID=it;Password=Tigers1234");
protected void Page_Load(object sender, EventArgs e)
{
DateTime d = DateTime.Now.Date;
TextBox3.Text = d.ToString("yyyy-MM-dd");
//DateTime daValues1 = DateTime.Now;
//string MyDt = daValues1.ToString("'HH:mm:ss'");
//TextBox3.Text = MyDt;
DateTime daValues = DateTime.Now;
Random r = new Random();
int num = r.Next();
string MyDt2 = daValues.ToString("yyMM-mmss");
this.TextBox6.Text = num.ToString("'IT','" + MyDt2 + "'");
if (Session["DeptName"] != null && Session["Tel"] != null) {
Label12.Text = Session["DeptName"].ToString();
Label13.Text = Session["Tel"].ToString();
}
}
#region Button1_Click
protected void Button1_Click(object sender, EventArgs e)
{
if (DropDownList3.Text == "0")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Myscript", "alert(' . . . . . . . . . <กรุณาเลือก >> ประเภทของปัญหา << ด้วยค่ะ !!! > . . . . . . . . . ')", true);
}
else if (TextBox1.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Myscript", "alert(' . . . . . . . . . <กรุณากรอก >> หัวข้อ << ด้วยค่ะ !!! > . . . . . . . . . ')", true);
}
else if (Request.Form["Message"] == "" )
{
string scriptText = "alert(' . . . . . . . . . <กรุณากรอก >> รายละเอียด << ด้วยค่ะ !!! > . . . . . . . . . ');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (TextBox3.Text == "")
{
string scriptText = "alert(' . . . . . . . . . <กรุณาใส่ >> วันที่ << ด้วยค่ะ !!! > . . . . . . . . . ');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (TextBox5.Text == "")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Myscript", "alert(' . . . . . . . . . <กรุณากรอก >> ชื่อผู้แจ้งปัญหา << ด้วยค่ะ !! > . . . . . . . . . ')", true);
}
else {
if (Session["DeptName"].ToString() == "Human Resources")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',5,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Accounting")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',2,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Purchase")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',9,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Store")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',11,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Quarrying")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',13,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Ministry")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',14,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Rubber")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',15,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Construction")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',16,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Concrete")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',17,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Maintenance")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',19,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Sale")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',20,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Marketing")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',22,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "Finance")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',23,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
else if (Session["DeptName"].ToString() == "PouringRubber")
{
conn.Open();
SqlCommand sqlcom = conn.CreateCommand();
sqlcom.CommandText = "INSERT INTO [dbo].[Case] ( [CaseName], [CaseDetail], [CaseDT], [CaseStatusKey], [Requester], [UsrKey], [CaseTypeKey],[CaseCode]) VALUES ( '" + TextBox1.Text + "','" + Request.Form["Message"] + "','" + TextBox3.Text + "',1,'" + TextBox5.Text + "',25,'" + DropDownList3.Text + "','" + TextBox6.Text + "')";
sqlcom.CommandType = CommandType.Text;
sqlcom.ExecuteNonQuery();
conn.Close();
string scriptText = "alert(' . . . . . . . . . <บันทึกการแจ้งปัญหาสำเร็จ > . . . . . . . . . '); window.location='" + Request.ApplicationPath + "RequestionShow.aspx'";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMessage", scriptText, true);
}
}
}
#endregion
#region Button2_Click
protected void Button2_Click(object sender, EventArgs e)
{
TextBox1.Text = "";
TextBox5.Text = "";
DropDownList3.Text = "0";
}
protected void Button2_Click1(object sender, EventArgs e)
{
}
protected void Button3_Click(object sender, EventArgs e)
{
}
protected void TextBox6_TextChanged(object sender, EventArgs e)
{
}
protected void TextBox7_TextChanged(object sender, EventArgs e)
{
}
}
}
#endregion
####################################################################################################
Code ASP
Code (ASP)
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Test._Default" %>
<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
<meta charset="utf-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=edge"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<!-- Bootstrap -->
<link href="css/bootstrap.min.css" rel="stylesheet"/>
<link rel="stylesheet" href="css/animate.css"/>
<link rel="stylesheet" href="css/font-awesome.min.css"/>
<link rel="stylesheet" href="css/jquery.bxslider.css"/>
<link rel="stylesheet" type="text/css" href="css/normalize.css" />
<link rel="stylesheet" type="text/css" href="css/demo.css" />
<link rel="stylesheet" type="text/css" href="css/set1.css" />
<link href="css/overwrite.css" rel="stylesheet"/>
<link href="css/style2.css" rel="stylesheet"/>
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
<nav class="navbar navbar-default navbar-fixed-top" role="navigation">
<div class="container">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target=".navbar-collapse.collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="Default.aspx"><span>
<img src="http://localhost:51924/img/IT1.gif" style="height: 65px; width: 70px; margin-top:-18px" /> Suvalee Company</span></a>
</div>
<div class="navbar-collapse collapse">
<div class="menu">
<ul class="nav nav-tabs" role="tablist">
<li role="presentation" class="active"><a href="Default.aspx">แจ้งปัญหา</a></li>
<li role="presentation"><a href="RequestionShow.aspx">แสดงปัญหาที่แจ้ง</a></li>
<li role="presentation"><a href="Login.aspx">ออกจากระบบ</a></li>
</ul>
</div>
</div>
</div>
</nav>
<br />
<br />
<p style="text-align:center; font-size:25px; color:black;">ระบบแจ้งปัญหาสารสนเทศ</p>
<p style="margin-left:390px ; font-size:25px">
<strong>
<asp:Label ID="Label11" runat="server" Text="แผนก : " Font-Size="18px" style="font-size: medium"></asp:Label>
</strong><span style="font-size: medium"><strong>
</strong></span><strong>
<asp:Label ID="Label12" runat="server" Font-Size="18px" Text="Label" style="font-size: medium"></asp:Label>
</strong><span style="font-size: medium"><strong> </strong></span><strong> <asp:Label ID="Label10" runat="server" Text="เบอร์โทรศัพท์ : " Font-Size="18px" style="font-size: medium"></asp:Label>
</strong> <strong><asp:Label ID="Label13" runat="server" Font-Size="18px" Text="Label" style="font-size: medium"></asp:Label>
</strong>
</p>
<div class="errorContainer" align="Center" >
<table align="Center" style="width: 34%; height: 230px;"> <tr>
<td style="height: 40px; width: 176px; text-align: right; font-size: medium;" class="text-justify" >
CODE </td>
<td style="height: 40px">
<asp:TextBox ID="TextBox6" runat="server" OnTextChanged="TextBox6_TextChanged" Width="200px" ReadOnly="true" Enabled="false" Font-Size="14px"></asp:TextBox>
</td>
</tr>
<tr>
<td style="height: 17px; width: 176px; text-align: right; font-size: medium;">
ประเภทปัญหา </td>
<td style="height: 40px">
<asp:DropDownList ID="DropDownList3" runat="server" Font-Size="14px">
<asp:ListItem Value="0">===กรุณาเลือก===</asp:ListItem>
<asp:ListItem Value="1">Computer</asp:ListItem>
<asp:ListItem Value="2">Printer</asp:ListItem>
<asp:ListItem Value="3">Wireless</asp:ListItem>
<asp:ListItem Value="6">ระบบ Syteline</asp:ListItem>
<asp:ListItem Value="4">อื่นๆ</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td style="width: 176px; height: 28px; text-align: right; font-size: medium;">
หัวข้อ </td>
<td style="height: 40px">
<asp:TextBox ID="TextBox1" runat="server" Font-Size="14px"></asp:TextBox>
</td>
</tr>
<tr>
<td style="width: 176px; height: 71px; text-align: right; font-size: medium;">
รายละเอียด </td>
<td style="height: 105px">
<textarea id="TextArea1" cols="35" name="Message" rows="4" ></textarea></td>
</tr>
<tr>
<td style="width: 176px; height: 27px; text-align: right; font-size: medium;">
วันที่แจ้งปัญหา </td>
<td style="height: 40px">
<asp:TextBox ID="TextBox3" runat="server" Font-Size="14px" type="date" name="party-time" Height="22px" ></asp:TextBox>
</td>
</tr>
<tr>
<td style="width: 176px; height: 34px; text-align: right; font-size: medium;">
ชื่อผู้แจ้งปัญหา </td>
<td style="height: 40px">
<asp:TextBox ID="TextBox5" runat="server" Font-Size="14px"></asp:TextBox>
</td>
</tr>
</table>
<br />
<asp:Button ID="Button1" runat="server" Text="บันทึก" OnClick="Button1_Click" align="center" />
<asp:Button ID="Button2" runat="server" Text="ยกเลิก" align="center" OnClick="Button2_Click1" />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
</div>
<footer>
</footer>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="js/jquery-2.1.1.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="js/bootstrap.min.js"></script>
<script src="js/wow.min.js"></script>
<script src="js/jquery.easing.1.3.js"></script>
<script src="js/jquery.isotope.min.js"></script>
<script src="js/jquery.bxslider.min.js"></script>
<script type="text/javascript" src="js/fliplightbox.min.js"></script>
<script src="js/functions.js"></script>
<script type="text/javascript">$('.portfolio').flipLightBox()</script>
</asp:Content>
[/vb]
|
ประวัติการแก้ไข 2019-01-09 07:54:14 2019-01-09 08:41:00
 |
 |
 |
 |
Date :
2019-01-09 07:52:47 |
By :
HI |
|
 |
 |
 |
 |
|
|
 |