protected void AcceptButton1_Click(object sender, EventArgs e)
{
if (UIDTextBox.Text != "" && StepTextBox.Text != "")
{
GridviewIframe.Attributes.Add("src", "History.aspx?passcode=aws");
if (ArticleTextBox.Text != "" && OperatorNameTextBox.Text != "" && MachineTextBox.Text != "")
{
//OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Server.MapPath("~/test/Access//Tablas.mdb"));
con.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandText = "Insert into [Ordenes de fabricación (historia/taller)] (NumOrd,NumFas,HorIni,CodPer,CodMaq) VALUES ('" + UIDTextBox.Text + "','" + StepTextBox.Text + "','" + DateTime.Now + "','" + OperatorNumTextBox.Text + "','" + MachineNumTextBox.Text + "')";
if (cmd.ExecuteNonQuery() == 1)
{
CleartextBoxes(this);
//GridviewIframe.Attributes.Add("src", "History.aspx");
OperatorNumTextBox.Focus();
}
else
{
Response.Write("Input values are incorrect...!");
}
con.Close();
}
}
else
{
Response.Write("We can't do more step on this piece...!");
}
}
protected void AcceptButton2_Click(object sender, EventArgs e)
{
AcceptButton2.Enabled = false;
int count = 0;
if (PcsNumTextBox.Text != "" && count == 0)
{
count++;
//OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Server.MapPath("~/test/Access//Tablas.mdb"));
con.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandText = "Update [Ordenes de fabricación (historia/taller)] SET [HorFin]='" + DateTime.Now + "',[TiePre]='" + 1 + "',[CanPie]='" + PcsNumTextBox.Text + "' WHERE ( CodPer = " + OperatorNumTextBox.Text + " AND CodMaq = " + MachineNumTextBox.Text + ") AND HorFin IS NULL";
if (cmd.ExecuteNonQuery() == 1)
{
GridviewIframe.Attributes.Add("src", "History.aspx?passcode=aws");
//Iframe1.Attributes.Add("src", "Drawing.aspx?UID=" + UIDTextBox.Text + "&Article=" + ArticleTextBox.Text);
}
else
{
Response.Write("Input values are incorrect...!");
}
con.Close();
CleartextBoxes(this);
AcceptButton2.Enabled = true;
OperatorNumTextBox.Focus();
}
else
{
//PreparetimeTextBox.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
OperatorNumTextBox.Focus();
OperatorNumTextBox.Attributes["onfocus"] = "javascript:this.select();";
//if (CheckForInternetConnection() == false)
//{
// Response.Close();
// }
if (!IsPostBack)
{
GridviewIframe.Attributes.Add("src", "History.aspx");
OperatorImage1.ImageUrl = "~/OperatorPhotos/OperatorImage.png";
MachineImage2.ImageUrl = "~/MachinePhotos/MachineImage.jpg";
}
//IframePdf.Attributes.Add("src", "Drawing.aspx?UID=" + 0 + "&Article=" + 0);
}
void OperatorData()
{
if (Convert.ToInt32(OperatorNumTextBox.Text) > 1000)
{
OperatorNumTextBox.Text = rfidOperatorNo.ToString();
}
if (File.Exists(Server.MapPath("~/OperatorPhotos/" + OperatorNumTextBox.Text + ".jpg")))
{
OperatorImage1.ImageUrl = "~/OperatorPhotos/" + OperatorNumTextBox.Text + ".jpg";
}
else
{
OperatorImage1.ImageUrl = "~/OperatorPhotos/OperatorImage.png";
}
MachineImage2.ImageUrl = "~/MachinePhotos/MachineImage.jpg";
if (OperatorNumTextBox.Text != "")
{
//OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Server.MapPath("~/test/Access//Tablas.mdb"));
// OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " +"D:\\test\\Access\\Tablas.mdb");
con.Open();
OleDbDataAdapter adoperator = new OleDbDataAdapter("SELECT NomPer FROM [Personal] WHERE CodPer = " + OperatorNumTextBox.Text + " ", con);
DataTable dtoperator = new DataTable();
adoperator.Fill(dtoperator);
if (dtoperator.Rows.Count > 0)
{
OperatorNameTextBox.Text = dtoperator.Rows[0][0].ToString();
OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT HorIni,NumOrd,NumFas,CodMaq FROM [Ordenes de fabricación (historia/taller)] WHERE CodPer = " + OperatorNumTextBox.Text + " AND (HorFin IS NULL AND HorIni IS NOT NULL) ", con);
DataTable dtable = new DataTable();
adapter.Fill(dtable);
con.Close();
if (dtable.Rows.Count > 0)
{
StartDateTextBox.Text = Convert.ToDateTime(dtable.Rows[0][0]).ToString("dd/MM/yyyy HH:mm:ss");
UIDTextBox.Text = dtable.Rows[0][1].ToString();
StepTextBox.Text = dtable.Rows[0][2].ToString();
MachineNumTextBox.Text = dtable.Rows[0][3].ToString();
UIDEnter_Click(null, null);
StepEnter_Click(null, null);
MachineNumEnter_Click(null, null);
// FinishButton.Focus();
FinishButton_Click(null, null);
}
else
{
StartDateTextBox.Text = "";
UIDTextBox.Text = "";
StepTextBox.Text = "";
MachineNumTextBox.Text = "";
OrderQtyTextbox.Text = "";
//FinishQtyTextBox.Text = "";
//PendingTextBox.Text = "";
MachineTextBox.Text = "";
ArticleTextBox.Text = "";
OperationTextBox.Text = "";
UIDEnter_Click(null, null);
StepEnter_Click(null, null);
MachineNumEnter_Click(null, null);
StartButton.Focus();
}
}
else
{
string script = "alert('Please Enter Valid Operator No....!!!')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(Enter, this.GetType(), "Test", script, true);
OperatorNumTextBox.Text = string.Empty;
OperatorNumTextBox.Focus();
}
}
}
