using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DBAccessLib;
using System.Data.Odbc;
using System.Text.RegularExpressions;
public partial class WebPart_wkh_TopsTicket_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
const int offset = -3;
Label1.Text = "";
if (!Page.IsPostBack)
{
//抓入當日日期的方法, 但注意要放在if (!Page.IsPostBack)中,以免新設定的值被洗掉。
tbFromYear.Text = DateTime.Today.AddDays(offset).Year.ToString();
tbFromMonth.Text = DateTime.Today.AddDays(offset).Month.ToString();
tbFromDay.Text = DateTime.Today.AddDays(offset).Day.ToString();
tbToYear.Text = DateTime.Today.Year.ToString();
tbToMonth.Text = DateTime.Today.Month.ToString();
tbToDay.Text = DateTime.Today.Day.ToString();
}
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
tbFromYear.Text = Calendar1.SelectedDate.Year.ToString();
tbFromMonth.Text = Calendar1.SelectedDate.Month.ToString();
tbFromDay.Text = Calendar1.SelectedDate.Day.ToString();
Calendar1.Visible = false;
Button2.Enabled = true;
}
protected void Button1_Click(object sender, EventArgs e)
{
//以button呼叫日曆控制項的方法, 看起來真的很笨, 只是把隱藏設成非隱藏
Calendar1.Visible = true;
Button2.Enabled = false;
Calendar1.Focus();
}
protected void Calendar2_SelectionChanged(object sender, EventArgs e)
{
tbToYear.Text = Calendar2.SelectedDate.Year.ToString();
tbToMonth.Text = Calendar2.SelectedDate.Month.ToString();
tbToDay.Text = Calendar2.SelectedDate.Day.ToString();
Calendar2.Visible = false;
Button1.Enabled = true;
}
protected void Button2_Click(object sender, EventArgs e)
{
Calendar2.Visible = true;
Button1.Enabled = false;
Calendar2.Focus();
}
protected void btSubmit_Click(object sender, EventArgs e)
{
string DSN_RCA = Common.ToGetDsnByNCSR("R");
String SQLStr = "";
if(tbValue.Text.Length == 0) {
}
if (rblFeature.SelectedValue == "dispatch")
{
SQLStr = "select orderid as 聯單號碼, exgname as 交換機, dispatchuserid as 操作員代碼,";
SQLStr += " dispatchtime as 時間 from tkdispatch where dispatchtime >= \'";
SQLStr += tbFromYear.Text + "-" + tbFromMonth.Text + "-" + tbFromDay.Text + " 00:00:00\' ";
SQLStr += " and dispatchtime <= \'" + tbToYear.Text + "-" + tbToMonth.Text + "-" + tbToDay.Text;
SQLStr += " 23:59:59.99999\'";
if (rblCondition.SelectedValue == "tel")
{
SQLStr += "";
}
if (rblCondition.SelectedValue == "number")
{
if (Regex.IsMatch(tbValue.Text, @"^[1-9][0-9]*"))
{
SQLStr += " and orderid =" + tbValue.Text;
}
else
{
Label1.Text = "聯單號碼格非數字，改為搜尋全部條件。";
}
}
if (rblCondition.SelectedValue == "op")
{
SQLStr += " and dispatchuserid like \'%" + tbValue.Text + "%\'";
}
}
if (rblFeature.SelectedValue == "reply")
{
SQLStr = "select orderid as 聯單號碼, replyvalue as 回報代碼, replyuserid as 操作員代碼,";
SQLStr += " replytime as 時間 from tkreply where replytime >= \'";
SQLStr += tbFromYear.Text + "-" + tbFromMonth.Text + "-" + tbFromDay.Text + " 00:00:00\' ";
SQLStr += " and replytime <= \'" + tbToYear.Text + "-" + tbToMonth.Text + "-" + tbToDay.Text;
SQLStr += " 23:59:59.99999\'";
if (rblCondition.SelectedValue == "tel")
{
SQLStr += "";
}
if (rblCondition.SelectedValue == "number")
{
if (Regex.IsMatch(tbValue.Text, @"^[1-9][0-9]*"))
{
SQLStr += " and orderid =" + tbValue.Text;
}
else
{
Label1.Text = "聯單號碼格非數字，改為搜尋全部條件。";
}
}
if (rblCondition.SelectedValue == "op")
{
SQLStr += " and replyuserid like \'%" + tbValue.Text + "%\'";
}
}
//Label1.Text = SQLStr;
//好用的GridView設定方法, 要把DataReader餵過去就ok了
DBAccess db1 = new DBAccess();
OdbcDataReader dr = db1.DataReader(….);
GridView1.DataSource = dr;
GridView1.DataBind();
GridView1.Visible=true;
dr.Close();
}
}
