protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{ //沒登入就導到 default
if (Session["Emp_Name"] == null)
{
Response.Redirect("~/Login.aspx");
}
if (Request.QueryString["Form_No"] != null)
{
Form_No.Text = Request.QueryString["Form_No"].ToString().Trim();
}
else
{
Response.Redirect("~/Reserve");
}
/*抓取使用者帳號*/
prepareStaff(); Emp_Id_List.DataSource = Emp_Id_Set; Emp_Id_List.DataBind();
getDetail();
}
/*抓取使用者帳號*/
void prepareStaff()
{
string sqlstr = "select Emp_id, Emp_name from Staff order by Emp_id";
Emp_Id_Set = mydb.GetDataTable(sqlstr);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{ //沒登入就導到 default
if (Session["Emp_Name"] == null)
{
Response.Redirect("~/Login.aspx");
}
if (Request.QueryString["Form_No"] != null)
{
Form_No.Text = Request.QueryString["Form_No"].ToString().Trim();
}
else
{
Response.Redirect("~/Reserve");
}
/*抓取使用者帳號*/
prepareStaff(); Emp_Id_List.DataSource = Emp_Id_Set; Emp_Id_List.DataBind();
getDetail();
}
/*抓取使用者帳號*/
void prepareStaff()
{
string sqlstr = "select Emp_id, Emp_name from Staff order by Emp_id";
Emp_Id_Set = mydb.GetDataTable(sqlstr);
}
void getDetail()
{
string sqlstr = "select d.Form_No, M.mat_name,d.qty, d.Emp_Id, d.Import_Date, d.comment from Material M, Reserve_Import_Detail d where m.Mat_Id = d.mat_id and Form_No =" + mydb.qo(Form_No.Text);
DataTable myTable = mydb.GetDataTable(sqlstr);
mat_name.Text = myTable.Rows[0][0].ToString();
//Department
int selected = 0;
string Qdep_Id = myTable.Rows[0][2].ToString().Trim(); //Response.Write("Qdep_Id=" + Qdep_Id);
foreach (DataRow row in depSet.Rows)
{
if (row["dep_id"].ToString().Trim() == Qdep_Id)
{
DepList.SelectedIndex = selected; //Response.Write("Selected=" + selected.ToString());
break;
}
selected++;
}
//Club
selected = 0;
string Qclub_Id = myTable.Rows[0][3].ToString().Trim();
foreach (DataRow row in clubSet.Rows)
{
if (row["club_id"].ToString().Trim() == Qclub_Id)
{
ClubList.SelectedIndex = selected;
break;
}
selected++;
}
//Religion
selected = 0;
string Qreligion = myTable.Rows[0][4].ToString().Trim();
foreach (DataRow row in ReligionSet.Rows)
{
if (row["rel_id"].ToString().Trim() == Qreligion)
{
ReligionList.SelectedIndex = selected;
break;
}
selected++;
}
}
}