 |
|
มือใหม่ หัดเขียนค่ะ
Code (C#)
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;
using System.IO;
public partial class a_Reseve : System.Web.UI.Page
{
SYSTEM_CONN conn = new SYSTEM_CONN("Connection");
protected void Page_Load(object sender, EventArgs e)
{
string ktr, mtr;
for (int k = 6; k < 24; k++)
{
for (int m = 0; m < 60; m++)
{
if (k < 10)
{
ktr = "0" + k.ToString();
}
else
{
ktr = k.ToString();
}
if (m < 10)
{
mtr = "0" + m.ToString();
}
else
{
mtr = m.ToString();
}
ddlStarttime.Items.Add(new ListItem(ktr + ":" + mtr));
ddlEndtime.Items.Add(new ListItem(ktr + ":" + mtr));
}
}
if (!Page.IsPostBack)
{
DropDownListDataTable();
string theDate = DateTime.Now.ToString("dd/MM/yyyy ");
txtBK_id.Text = conn.autoIDTypeDate("Booking", "BK_id", theDate, "00");
txtBK_id.Enabled = false;
}
else
{
//((ASP.master_admin_meeting_master)Page.Master).RegisterPostbackTrigger(btnSave);
}
}
void DropDownListDataTable()
{
SqlConnection conn = new SqlConnection();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
String strConnString;
strConnString = "Data Source=admin;Initial Catalog=meeting;User ID=sa;Password=1234";
conn = new SqlConnection(strConnString);
conn.Open();
String strSQL;
strSQL = "SELECT * FROM Room";
da = new SqlDataAdapter(strSQL, conn);
da.Fill(dt);
da = null;
conn.Close();
conn = null;
//*** DropDownList ***//
this.ddlRoom.DataSource = dt;
this.ddlRoom.DataTextField = "R_name";
this.ddlRoom.DataValueField = "R_id";
this.ddlRoom.DataBind();
ddlRoom.Items.Insert(0, "***เลือกห้องประชุม***");
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtBK_id.Text != "" && txtHead.Text != "" && ddlRoom.SelectedItem.Value != "***เลือกห้องประชุม***" &&
txtcldStart.Text != "" && txtcldEnd.Text != "" && ddlStarttime.SelectedItem.Value != "" &&
ddlEndtime.SelectedItem.Value != "" && txtNum.Text != "" && txtTel.Text != "")
{
String strCheck;
strCheck = "select R_id,Startdate,Enddate,Starttime,Endtime from Booking where R_id ='" + ddlRoom.SelectedItem.Value + "'AND Startdate ='" + conn.changeToDate(txtcldStart.Text) +
"'AND Enddate ='" + conn.changeToDate(txtcldEnd.Text) + "'AND Starttime ='" + ddlStarttime.SelectedItem.Value + "'AND Endtime ='" + ddlEndtime.SelectedItem.Value + "'";
DataTable dt = new DataTable();
dt = conn.getDatatable(strCheck);
if (dt.Rows.Count == 0)
{
String strcb = "N";
if (cbProjector.Checked)
{
strcb = "Y";
}
String Status = "รอการอนุมัติ";
String Startdate = txtcldStart.Text;
String Enddate = txtcldEnd.Text;
String strEnddate = conn.changeToDate(Enddate);
String strStartdate = conn.changeToDate(Startdate);
String dateNow = DateTime.Now.ToString("yyyy/MM/dd");
String strBooking;
strBooking = "insert into Booking(BK_id,BK_name,R_id,Startdate,Enddate,Starttime,Endtime,Capacity,Projector,Note,Contact_tel,Status,Create_date)" +
"values" + "('" + this.txtBK_id.Text + "','" + this.txtHead.Text + "','" + this.ddlRoom.SelectedItem.Value + "','" + strStartdate + "','" +
strEnddate + "','" + ddlStarttime.SelectedItem.Value + "','" + ddlEndtime.SelectedItem.Value + "','" + this.txtNum.Text + "','" +
strcb + "','" + this.txtNote.Text + "','" + this.txtTel.Text + "','" + Status + "','" + dateNow + "')";
try
{
conn.ExeTransDB(strBooking);
//lblAlertAdd.Text = "เพิ่มข้อมูลเรียบร้อยแล้ว";
//RegisterClientScriptBlock("OnLoad", "<script>alert('เพิ่มข้อมูลเรียบร้อยแล้ว " + this.lblAlertAdd.Text + "')</script>");
jsAlert("เพิ่มข้อมูลเรียบร้อยแล้ว");
txtHead.Text = "";
ddlRoom.SelectedIndex = 0;
txtcldStart.Text = "";
txtcldEnd.Text = "";
ddlStarttime.SelectedIndex = 0;
ddlEndtime.SelectedIndex = 0;
txtNum.Text = "";
cbProjector.Checked = false;
txtNote.Text = "";
txtTel.Text = "";
lblAlertAdd.Text = "";
string theDate = DateTime.Now.ToString("dd/MM/yyyy ");
txtBK_id.Text = conn.autoIDTypeDate("Booking", "BK_id", theDate, "00");
}
catch (Exception ex)
{
lblAlertAdd.Text = "เพิ่มข้อมูลไม่ได้";
string ee = ex.ToString();
}
}
else
{
jsAlert("วันเวลาไม่ว่าง กรุณาเลือก วันเวลาอื่น ");
}
}
else
{
lblAlertAdd.Text = "กรอกข้อมูลให้ครบ";
}
}
protected void jsAlert(string alertText)
{
string scriptText = @"alert('" + alertText + "');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "script_ref_name", scriptText, true);
}
protected void btnRoom_Click(object sender, EventArgs e)
{
if (ddlRoom.SelectedItem.Value != "***เลือกห้องประชุม***")
{
String strddl;
strddl = "select * from Room r left join Building b on r.BD_id=b.BD_id where r.R_id = '" + ddlRoom.SelectedItem.Value + "'";
DataTable dt = new DataTable();
dt = conn.getDatatable(strddl);
lblR_id.Text = dt.Rows[0]["R_id"].ToString();
lblR_name.Text = dt.Rows[0]["R_name"].ToString();
lblBuilding.Text = dt.Rows[0]["BD_name"].ToString();
lblFloor.Text = dt.Rows[0]["R_floor"].ToString();
lblNum.Text = dt.Rows[0]["R_capacity"].ToString();
lblfImage.Text = dt.Rows[0]["R_image"].ToString();
if (lblfImage.Text.ToString().Trim() != "")
{
lblfImage.Text = "<a href='Images/board/" + lblfImage.Text.ToString().Trim() + "' target='_blank'>" + lblfImage.Text.ToString().Trim() + "</a>";
}
mpeRoom.Show();
}
}
protected void btnCheck_Click(object sender, EventArgs e)
{
if (ddlRoom.SelectedItem.Value != "***เลือกห้องประชุม***" && txtcldStart.Text != "" && txtcldEnd.Text != "" && ddlStarttime.SelectedItem.Value != "" && ddlEndtime.SelectedItem.Value != "")
{
String strCheck;
strCheck = "select R_id,Startdate,Enddate,Starttime,Endtime from Booking where R_id ='" + ddlRoom.SelectedItem.Value + "'AND Startdate ='" + conn.changeToDate(txtcldStart.Text) +
"'AND Enddate ='" + conn.changeToDate(txtcldEnd.Text) + "'AND Starttime ='" + ddlStarttime.SelectedItem.Value + "'AND Endtime ='" + ddlEndtime.SelectedItem.Value + "'";
DataTable dt = new DataTable();
dt = conn.getDatatable(strCheck);
if (dt.Rows.Count==0)
{
lblAlertCheck.Text = "***วันและเวลาว่าง***";
}
else
{
lblAlertCheck.Text = "***วันและเวลาไม่ว่าง***";
}
}
else
{
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
txtHead.Text = "";
ddlRoom.SelectedIndex = 0;
txtcldStart.Text = "";
txtcldEnd.Text = "";
ddlStarttime.SelectedIndex = 0;
ddlEndtime.SelectedIndex = 0;
txtNum.Text = "";
txtNote.Text = "";
txtTel.Text = "";
}
}
|
ประวัติการแก้ไข
2013-01-09 17:21:18
 |
 |
 |
 |
| Date :
2013-01-09 17:16:31 |
By :
5205100068 |
|
 |
 |
 |
 |
|
|
 |
Quote:
