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();
}
private void SearchCustomers()
{
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 ";
//8:已入庫
sqlstr += "and d.status_id = '8'";
if (!string.IsNullOrEmpty(txtSearch.Text.Trim()))
{
/*全文搜索*/
sqlstr += " and d.Form_No LIKE '%" + txtSearch.Text.Trim();
sqlstr += "%' UNION ";
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 d.status_id = '8'";
sqlstr += " and M.mat_name LIKE '%" + txtSearch.Text.Trim();
sqlstr += "%' UNION ";
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 d.status_id = '8'";
sqlstr += " and d.qty LIKE '%" + txtSearch.Text.Trim();
sqlstr += "%' UNION ";
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 d.status_id = '8'";
sqlstr += " and d.Emp_Id LIKE '%" + txtSearch.Text.Trim();
sqlstr += "%' UNION ";
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 d.status_id = '8'";
sqlstr += " and d.Import_Date LIKE '%" + txtSearch.Text.Trim();
sqlstr += "%' UNION ";
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 d.status_id = '8'";
sqlstr += " and d.comment LIKE '%" + txtSearch.Text.Trim();
sqlstr += "%'";
//Response.Write(sqlstr);
ResGrid.DataSource = mydb.GetDataTable(sqlstr);
ResGrid.DataBind();
}
}
void showGrid()
{
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 ";
/*狀態為已入庫才會顯示*/
//sqlstr += " and d.status_id='8'";
ResGrid.DataSource = mydb.GetDataTable(sqlstr);
ResGrid.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string sqlstr = "select s.comment AS Status, r.Form_No as form_no, r.Emp_Id as Emp_Id, r.import_date as import_date, r.comment as comment";
sqlstr += " from reserve_Import r,Status s ";
sqlstr += " where s.status_id = r.status_id";
ResGrid.DataSource = mydb.GetDataTable(sqlstr);
ResGrid.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
/*顯示在GridView*/
string sqlstr = "Select M.Form_No , mat.mat_name ,M.Emp_Id ,M.Form_Date, M.Import_Date, v.Vendor_Name,p.Pay_Name";
sqlstr += " from Material_Import M , Material mat , Vendor v , Pay p,Status s";
sqlstr += " where M.mat_id = mat.mat_id";
sqlstr += " and M.Vendor_id =v.Vendor_Id";
sqlstr += " and M.Pay_id = p.Pay_Id";
sqlstr += " and M.Status_id= s.Status_Id";
sqlstr += " and s.Class='Material'";
ResGrid.DataSource = mydb.GetDataTable(sqlstr);
ResGrid.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();
}
void showGrid()
{
ResGrid.DataSource = tempItem;
ResGrid.DataBind();
}
