void showDetail() { //庫存驗貨單 string sqlstr = "select * from Reserve_Import where form_no = " + Form_No.Text; DataTable myTable = mydb.GetDataTable(sqlstr); Emp_Id.Text = myTable.Rows[0]["Emp_Id"].ToString(); Status_Id.Text = myTable.Rows[0]["Status_Id"].ToString(); sqlstr = "select comment from status "; sqlstr += " where class='Reserve' "; sqlstr += " and Status_Id = " + mydb.qo(Status_Id.Text); Status_Comment.Text = mydb.getSingleData(0, sqlstr); Import_Date.Text = myTable.Rows[0]["import_date"].ToString(); Vendor_Id.Text = myTable.Rows[0]["Vendor_Id"].ToString().Trim(); sqlstr = " select vendor_name from vendor where Vendor_Id=" + mydb.qo(Vendor_Id.Text); Vendor_Name.Text = mydb.getSingleData(0, sqlstr); Comment.Text = myTable.Rows[0]["Comment"].ToString().Trim(); //進貨明細 sqlstr = "select d.Form_No as Form_No, d.mat_id as mat_id, m.mat_name as mat_name, d.qty as qty, d.price as price, d.comment as comment "; sqlstr += " from Material_Import_Detail d, Material M "; sqlstr += " where d.form_no = " + Form_No.Text; sqlstr += " and d.mat_id = m.mat_id "; ResGrid.DataSource = mydb.GetDataTable(sqlstr); ResGrid.DataBind(); //驗貨 sqlstr = "select * from Verify "; sqlstr += " where form_no = " + Form_No.Text; //sqlstr += " and class='IMPORT'"; ProcessGrid.DataSource = mydb.GetDataTable(sqlstr); ProcessGrid.DataBind(); }
void showDetail() { //Material_Import string sqlstr = "Select M.Form_No , mat.mat_name ,M.Emp_Id ,M.Form_Date, M.Import_Date, M.Vendor_Id, p.Pay_Name"; sqlstr += " from Material_Import M , Material mat , Pay p, Status s"; sqlstr += " where M.form_no = " + Form_No.Text; sqlstr += " and M.mat_id = mat.mat_id"; sqlstr += " and M.Pay_id = p.Pay_Id"; sqlstr += " and M.Status_id= s.Status_Id"; sqlstr += " and s.Class='Material'"; DataTable myTable = mydb.GetDataTable(sqlstr); /*讀取登入者名稱*/ Emp_Id.Text = Session["Emp_Name"].ToString().Trim(); //日期:讀取資料 Import_Date.Text = ((DateTime)myTable.Rows[0]["import_date"]).ToString("yyyy-MM-dd"); //廠商 Vendor_Id.Text = myTable.Rows[0]["Vendor_Id"].ToString().Trim(); /*用廠商ID抓名稱*/ sqlstr = " select vendor_name from vendor where vendor_id=" + mydb.qo(Vendor_Id.Text); Vendor_Name.Text = mydb.getSingleData(0, sqlstr); //備註 sqlstr = " select comment from Material_Import_Detail where Form_no =" + Form_No.Text; Comment.Text = mydb.getSingleData(0, sqlstr); //------------------------- //Material_Import_Detail sqlstr = "select d.Form_No as Form_No, d.mat_id as mat_id, m.mat_name as mat_name, d.qty as qty, d.price as price, d.comment as comment "; sqlstr += " from Material_Import_Detail d, Material M "; sqlstr += " where d.form_no = " + Form_No.Text; sqlstr += " and d.mat_id = m.mat_id "; ResGrid.DataSource = mydb.GetDataTable(sqlstr); ResGrid.DataBind(); //Verify sqlstr = "select s.Status,v.Form_No,v.Emp_Id,v.Verify_Date,v.Comment from Verify v,Status s "; sqlstr += " where v.Form_No = " + Form_No.Text; sqlstr += " and v.Status_id = s.Status_Id"; sqlstr += " and s.Class ='Material'"; ProcessGrid.DataSource = mydb.GetDataTable(sqlstr); ProcessGrid.DataBind(); }
void showDetail() { //Reserve_Import string sqlstr = "select * from Reserve_Import where form_no = " + Form_No.Text; DataTable myTable = mydb.GetDataTable(sqlstr); /*讀取登入者名稱*/ Emp_Id.Text = mydb.qo(Session["Emp_Name"].ToString()); // string status = myTable.Rows[0]["Status_Id"].ToString().Trim(); for (int idx = 0; idx < StatusList.Items.Count; idx++) { if (status == StatusList.Items[idx].Value.Trim()) { StatusList.SelectedIndex = idx; } } // Import_Date.Text = myTable.Rows[0]["Import_Date"].ToString(); //Import_Date_Est.Text = myTable.Rows[0]["import_date_est"].ToString(); Import_Date.Text = ((DateTime)myTable.Rows[0]["import_date"]).ToString("yyyy-MM-dd");// DateTime.Now.ToString("yyyy-MM-dd");//myTable.Rows[0]["import_date"].ToString(); // Vendor_Id.Text = myTable.Rows[0]["Vendor_Id"].ToString().Trim(); sqlstr = " select vendor_name from vendor where vendor_id=" + mydb.qo(Vendor_Id.Text); Vendor_Name.Text = mydb.getSingleData(0, sqlstr); // Comment.Text = myTable.Rows[0]["Comment"].ToString().Trim(); //------------------------- //Material_Import_Detail sqlstr = "select d.Form_No as Form_No, d.mat_id as mat_id, m.mat_name as mat_name, d.qty as qty, d.price as price, d.comment as comment "; sqlstr += " from Material_Import_Detail d, Material M "; sqlstr += " where d.form_no = " + Form_No.Text; sqlstr += " and d.mat_id = m.mat_id "; ResGrid.DataSource = mydb.GetDataTable(sqlstr); ResGrid.DataBind(); //Verify sqlstr = "select * from Verify "; sqlstr += " where form_no = " + Form_No.Text; ProcessGrid.DataSource = mydb.GetDataTable(sqlstr); ProcessGrid.DataBind(); }