private void btnAction_Click(object sender, EventArgs e) { UnBindFormData(); if (_ds == null) { _ds = new DataSet1(); AddNewOrder(); } Button b = sender as Button; switch (b.Name) { case "btnAddProduct": AddNewProduct(); break; case "btnSave": SaveOrder(); BindFormData(); break; case "btnFind": LoadOrder(); BindFormData(); break; case "btnNew": NewOrder(); break; default: break; } }
public void actualizarTabla() { var adaptador = new productoTableAdapter(); DataSet1 datos = new DataSet1(); /* el metodo fillByProducto es un join creado en el data set entre las tablas producto y categoria */ adaptador.FillByProducto(datos.producto); dataGridView1.DataSource = datos.producto; }
private void crystalReportViewer1_Load(object sender, EventArgs e) { if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); DataSet1 ds = new DataSet1(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from orderUser where id = " + j + ""; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds.DataTable1); SqlCommand cmd2 = con.CreateCommand(); cmd2.CommandType = CommandType.Text; cmd2.CommandText = "select * from items where order_id = " + j + ""; cmd2.ExecuteNonQuery(); DataTable dt2 = new DataTable(); SqlDataAdapter da2 = new SqlDataAdapter(cmd2); da2.Fill(ds.DataTable2); da2.Fill(dt2); tot = 0; foreach (DataRow dr2 in dt2.Rows) { tot = tot + Convert.ToInt32(dr2["total"].ToString()); } CrystalReport1 myreport = new CrystalReport1(); myreport.SetDataSource(ds); myreport.SetParameterValue("total", tot.ToString()); crystalReportViewer1.ReportSource = myreport; }
private void button1_Click(object sender, EventArgs e) { try { DataSet1 ds = new DataSet1(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from issue_books where books_return_date=''"; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds.DataTable1); CrystalReport1 myreport = new CrystalReport1(); myreport.SetDataSource(ds); crystalReportViewer1.ReportSource = myreport; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void loadPrint() { if (salescommit == "1") { string q1 = "select itemCode,itemName,quantity,unitPrice,Amount,sReturn from Sales where salesNo='" + sl + "'"; string q2 = "select salesNo,sDate,total,salesType,creditCardPer,discountPer,vatAmount,grandTotal,receive,change from SalesSummary where salesNo='" + sl + "'"; try { aa.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(q1, aa); DataSet1 mydataset = new DataSet1(); da.Fill(mydataset, "Sales"); da.Dispose(); SqlDataAdapter da2 = new SqlDataAdapter(); da2.SelectCommand = new SqlCommand(q2, aa); da2.Fill(mydataset, "SalesSummary"); CrystalReport1 myreport = new CrystalReport1(); myreport.SetDataSource(mydataset); PrintMemo pm = new PrintMemo(); pm.crystalReportViewer1.ReportSource = myreport; pm.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { aa.Close(); } } else { MessageBox.Show("First commit sales by Clicking Save Button!", "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void buscarProducto(int id, Producto p) { DataSet1 datos = new DataSet1(); adaProducto.Fill(datos.producto); if (datos.producto.FindByid_producto(id) != null) { p.IdProducto = datos.producto.FindByid_producto(id).id_producto; p.Nombre = datos.producto.FindByid_producto(id).nombre; //MessageBox.Show("nombre de producto = " + p.Nombre); p.Precio = datos.producto.FindByid_producto(id).precio; p.Stock = datos.producto.FindByid_producto(id).stock; p.IdCategoria = datos.producto.FindByid_producto(id).id_categoria; } else { p.IdProducto = 0; p.Nombre = ""; p.Precio = 0; p.Stock = 0; p.IdCategoria = 0; MessageBox.Show("NO EXISTE EL PRODUCTO CON ID = " + id); } }
private void button1_Click(object sender, EventArgs e) { string sPath, sFile; string sText, sLineText, sTemp; int iPos, iLen, iElement; int iStartPos; string sIDCode, exp; bool bOut; List <string> logLines = new List <string>(); List <string> shooterGroups = new List <string>(); //textBox1.Text = "c:\\dummy.txt"; sPath = tbLogFilePath.Text; StreamReader streamReader = new StreamReader(sPath); sText = streamReader.ReadToEnd(); streamReader.Close(); //string[] sIDCodes = new string[]; //string[] sIDCodes = new string[]; List <string> sIDCodes = new List <string>(); iElement = -1; //used for the array DataSet1 ds = new DataSet1(); DataTable dt1 = ds.ID; DataTable dt2 = ds.HIT; DataTable dt3 = ds.TASKSTART; DataTable dt4 = ds.TASKEND; DataTable dt5 = ds.TARGET; DataTable dt6 = ds.SPOTTER; DataTable dt7 = ds.MALFUNCTION; DataTable dt8 = ds.SCENARIOSTART; DataTable dt9 = ds.TARGETEXPOSED; DataTable dt10 = ds.TARGETCONCEALED; DataTable dt11 = ds.GROUP; //DataTable dt12 = ds.TABLE; //DataTable dt13 = ds.TASK; DataRow shooter_row; DataRow hit_row; DataRow task_start_row; DataRow task_end_row; DataRow target_row; DataRow spotter_row; DataRow malfunction_row; DataRow scenario_start_row; DataRow target_exposed_row; DataRow target_concealed_row; DataRow group_row; //DataRow table_row; //DataRow task_row; DataRow[] foundRows; // Initialize new rows bOut = false; while (bOut == false) //bOut is set to true when the log file parse is complete { iStartPos = sText.Length; // Find the next line header iStartPos = GetStartPos(sText, "SCENARIOSTART:", iStartPos); iStartPos = GetStartPos(sText, "SHOOTER:", iStartPos); iStartPos = GetStartPos(sText, "SPOTTER:", iStartPos); iStartPos = GetStartPos(sText, "TASKSTART:", iStartPos); iStartPos = GetStartPos(sText, "TASKEND:", iStartPos); iStartPos = GetStartPos(sText, "HIT:", iStartPos); iStartPos = GetStartPos(sText, "TARGET:", iStartPos); iStartPos = GetStartPos(sText, "TARGETEXPOSED:", iStartPos); iStartPos = GetStartPos(sText, "TARGETCONCEALED:", iStartPos); iStartPos = GetStartPos(sText, "TASKABORT:", iStartPos); iStartPos = GetStartPos(sText, "SCENARIOEND:", iStartPos); iStartPos = GetStartPos(sText, "MALFUNCTION:", iStartPos); iStartPos = GetStartPos(sText, "TABLE:", iStartPos); iStartPos = GetStartPos(sText, "TASK:", iStartPos); // Take off all characters before the header iLen = sText.Length - iStartPos; if (iLen > 0) { sText = Mid(sText, iStartPos, iLen); } // Find the end of the line (signified by ';') iPos = sText.IndexOf(";", 0); // At the end of the file so return a blank string if (iPos < 0) { iPos = 0; } sLineText = sText.Substring(0, iPos); iPos += 1; iLen = sText.Length - iPos; if (iLen > 0) { sText = Mid(sText, iPos, iLen); } else { bOut = true; // This means that we are at the end, so exit the while loop } //Get the header from the line (sLineText) iPos = sLineText.IndexOf(":", 0); if (iPos < 0) { bOut = true; sTemp = "temp"; } else { sTemp = sLineText.Substring(0, iPos); sTemp = sTemp.ToUpper(); logLines.Add(sLineText); } } //Pull out relevant lines of the log file to add to the database // Add SCENARIOSTART foreach (var line in logLines) { if (line.Contains("SCENARIOSTART:")) { scenario_start_row = dt8.NewRow(); String[] scenStartSplit = splitLine(line); foreach (var item in scenStartSplit) { if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0) { scenario_start_row["TIMESTAMP"] = addTag(item); } else if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0) { scenario_start_row["NAME"] = addTag(item); } } dt8.Rows.Add(scenario_start_row); } } // Add SHOOTER foreach (var line in logLines) { if (line.Contains("SHOOTER:")) { shooter_row = dt1.NewRow(); spotter_row = dt6.NewRow(); String[] shooterSplit = splitLine(line); String shooterType = ""; //If the shooterType is shooter add additional shooter attributes if (line.IndexOf("TYPE(Shooter)", StringComparison.OrdinalIgnoreCase) >= 0) { shooterType = "shooter"; } else if ((line.IndexOf("TYPE(Spotter)", StringComparison.OrdinalIgnoreCase) >= 0)) { shooterType = "spotter"; } foreach (var item in shooterSplit) { if (shooterType == "shooter" || shooterType == "") { // Look for indexes while ignoring case and add them to the data tables if (item.IndexOf("FIRSTNAME(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["FIRSTNAME"] = addTag(item); } else if (item.IndexOf("LASTNAME(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["LASTNAME"] = addTag(item); } else if (item.IndexOf("GROUP(", StringComparison.OrdinalIgnoreCase) >= 0) { shooterGroups.Add(addTag(item)); shooter_row["GROUP"] = addTag(item); } else if (item.IndexOf("UNIT(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["UNIT"] = addTag(item); } else if (item.IndexOf("GROUP(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["GROUP"] = addTag(item); } else if (item.IndexOf("IDCODE(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["IDCode"] = addTag(item); sIDCodes.Add(addTag(item)); // store this for opening multiple reports } else if (item.IndexOf("MIDDLE(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["MIDDLE"] = addTag(item); } else if (item.IndexOf("RANK(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["RANK"] = addTag(item); } else if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["DATE"] = addTag(item); } else if (item.IndexOf("SSN(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["SSN"] = addTag(item); } else if (item.IndexOf("ORDER(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["ORDER"] = addTag(item); } else if (item.IndexOf("LANE(", StringComparison.OrdinalIgnoreCase) >= 0) { shooter_row["LANE"] = addTag(item); } /*else if (item.IndexOf("EVID(", StringComparison.OrdinalIgnoreCase) >= 0) * { * shooter_row["EVID"] = addTag(item); * } * else if (item.IndexOf("GRADER(", StringComparison.OrdinalIgnoreCase) >= 0) * { * shooter_row["GRADER"] = addTag(item); * } * else if (item.IndexOf("EXERCISE(", StringComparison.OrdinalIgnoreCase) >= 0) * { * shooter_row["EXERCISE"] = addTag(item); * } * else if (item.IndexOf("RANGE_NAME(", StringComparison.OrdinalIgnoreCase) >= 0) * { * shooter_row["RANGE_NAME"] = addTag(item); * }*/ // Need to add to database under the Shooter table } else if (shooterType == "spotter") { // Look for indexes while ignoring case and add them to the data tables if (item.IndexOf("FIRSTNAME(", StringComparison.OrdinalIgnoreCase) >= 0) { spotter_row["FIRSTNAME"] = addTag(item); } else if (item.IndexOf("LASTNAME(", StringComparison.OrdinalIgnoreCase) >= 0) { spotter_row["LASTNAME"] = addTag(item); } else if (item.IndexOf("GROUP(", StringComparison.OrdinalIgnoreCase) >= 0) { spotter_row["GROUP"] = addTag(item); } } } // Add to the appropriate table if if (shooterType == "spotter") { dt6.Rows.Add(spotter_row); } else if (shooterType == "shooter" || shooterType == "") { dt1.Rows.Add(shooter_row); } } } // Add TARGET foreach (var line in logLines) { if (line.Contains("TARGET:")) { target_row = dt5.NewRow(); String[] targetSplit = splitLine(line); String thisTargetName = ""; String[] groups = { "", "" }; String sGroup = ""; foreach (var item in targetSplit) { if (item.IndexOf("RANGE(", StringComparison.OrdinalIgnoreCase) >= 0) { target_row["RANGE"] = addTag(item); } else if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0) { thisTargetName = addTag(item); target_row["NAME"] = thisTargetName; } else if (item.IndexOf("GROUP(", StringComparison.OrdinalIgnoreCase) >= 0) { groups = addTag(item).Split(' '); foreach (var piece in groups) { if (shooterGroups.Contains(piece)) { sGroup = piece; } } } } // Only add a new row if this target hasn't been added yet if (!dt5.Rows.Contains(thisTargetName)) { dt5.Rows.Add(target_row); } // add multiple groups for (int i = 0; i < groups.Length; i++) { if (sGroup != groups[i]) { group_row = dt11.NewRow(); group_row["TARGET_NAME"] = thisTargetName; group_row["SHOOTER_GROUP"] = sGroup; group_row["OTHER_GROUP"] = groups[i]; dt11.Rows.Add(group_row); } } } } // Add TargetConcealed foreach (var line in logLines) { if (line.Contains("TARGETCONCEALED:")) { target_concealed_row = dt10.NewRow(); String[] tarConSplit = splitLine(line); foreach (var item in tarConSplit) { if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0) { target_concealed_row["NAME"] = addTag(item); } if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0) { target_concealed_row["TIMESTAMP"] = addTag(item); } if (item.IndexOf("KILL(", StringComparison.OrdinalIgnoreCase) >= 0) { target_concealed_row["KILL"] = addTag(item); } } dt10.Rows.Add(target_concealed_row); } } // Add TASKSTART for (int i = 0; i < logLines.Count; i++) { String hitLine = ""; if (logLines.ElementAt(i).Contains("TASKSTART:")) { task_start_row = dt3.NewRow(); //table_row = dt12.NewRow(); //task_row = dt13.NewRow(); String[] taskStartSplit = splitLine(logLines.ElementAt(i)); String sTable = ""; String sRow = ""; String sRound = ""; String sTask = ""; foreach (var item in taskStartSplit) { if (item.IndexOf("TABLE(", StringComparison.OrdinalIgnoreCase) >= 0) { sTable = addTag(item); //table_row["TABLE_ID"] = sTable; task_start_row["TABLE"] = sTable; //task_row["TABLE_ID"] = sTable; } if (item.IndexOf("TASK(", StringComparison.OrdinalIgnoreCase) >= 0) { sTask = addTag(item); task_start_row["TASK"] = sTask; //task_row["TASK_ID"] = sTask; } if (item.IndexOf("ROW(", StringComparison.OrdinalIgnoreCase) >= 0) // Range needs to be changed to Row { sRow = addTag(item); task_start_row["ROW"] = sRow; //task_row["ROW"] = sRow; } if (item.IndexOf("ROUND(", StringComparison.OrdinalIgnoreCase) >= 0) { sRound = addTag(item); task_start_row["ROUND"] = sRound; //task_row["ROUND"] = sRound; } if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0) { task_start_row["TIMESTAMP"] = addTag(item); //task_row["TIMESTAMP"] = addTag(item); } } //Make sure that there are no duplicate rows already in the datatable // If there are, then they must be deleted from the table. exp = "TABLE = '" + sTable + "' AND TASK = '" + sTask + "' AND ROW = '" + sRow + "' AND ROUND = '" + sRound + "'"; foundRows = dt3.Select(exp); //int i = foundRows[0].ToString; if (foundRows.Length > 0) { foundRows[0].Delete(); } dt3.Rows.Add(task_start_row); //dt13.Rows.Add(task_row); /*int j = 0; * while (!logLines.ElementAt(i + j).Contains("TASKEND:")) * { * if (logLines.ElementAt(i + j).Contains("HIT:")) * { * hit_row = dt2.NewRow(); * hitLine = logLines.ElementAt(i + j); * // add hit count here * String[] hitTaskSplit = splitLine(hitLine); * foreach (var item in hitTaskSplit) * { * if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0) * { * hit_row["NAME"] = addTag(item); * } * else if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0) * { * hit_row["TIMESTAMP"] = addTag(item); * } * // Increase hit count of this table/task * * } * hit_row["TASK_ID"] = sTask; * hit_row["TABLE_ID"] = sTable; * hit_row["ROW"] = sRow; * // Increase hit counter of this table/task/row * string expression = "TASK_ID = " + sTable + " and TABLE_ID = " + sTask; * DataRow[] selectedRows = dt13.Select(expression); * if (selectedRows.Count() > 0) * { * int counter = (int)selectedRows[0]["HIT_COUNT"]; * counter++; * selectedRows[0]["HIT_COUNT"] = counter; * } * dt2.Rows.Add(hit_row); * } * j++; * }*/ } } // Add TargetExposed foreach (var line in logLines) { if (line.Contains("TARGETEXPOSED:")) { target_exposed_row = dt9.NewRow(); String[] tarExpSplit = splitLine(line); foreach (var item in tarExpSplit) { if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0) { target_exposed_row["NAME"] = addTag(item); } if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0) { target_exposed_row["TIMESTAMP"] = addTag(item); } if (item.IndexOf("ATTRITION(", StringComparison.OrdinalIgnoreCase) >= 0) { target_exposed_row["ATTRITION"] = addTag(item); } } dt9.Rows.Add(target_exposed_row); } } // Add TASKEND /*for (int i = 0; i < logLines.Count; i++) * { * String hitLine = ""; * if (logLines.ElementAt(i).Contains("TASKEND:")) * { * task_end_row = dt4.NewRow(); * int j = 0; * while (!logLines.ElementAt(i - j).Contains("TASKSTART:")) * { * if (logLines.ElementAt(i - j).Contains("HIT:")) * { * hitLine = logLines.ElementAt(i - j); * // add hit count here * String[] hitTaskSplit = splitLine(hitLine); * foreach (var item in hitTaskSplit) * { * if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0) * { * task_end_row["HIT_NAME"] = addTag(item); * } * } * } * j++; * } * String[] taskEndSplit = splitLine(logLines.ElementAt(i)); * String tTable = ""; * String tRange = ""; * String tRound = ""; * String tTask = ""; * foreach (var item in taskEndSplit) * { * if (item.IndexOf("TABLE(", StringComparison.OrdinalIgnoreCase) >= 0) * { * tTable = addTag(item); * task_end_row["TABLE"] = tTable; * } * if (item.IndexOf("TASK(", StringComparison.OrdinalIgnoreCase) >= 0) * { * tTask = addTag(item); * task_end_row["TASK"] = tTask; * } * if (item.IndexOf("ROW(", StringComparison.OrdinalIgnoreCase) >= 0) * { * tRange = addTag(item); * task_end_row["ROW"] = tRange; * } * if (item.IndexOf("ROUND(", StringComparison.OrdinalIgnoreCase) >= 0) * { * tRound = addTag(item); * task_end_row["ROUND"] = tRound; * } * if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0) * { * task_end_row["TIMESTAMP"] = addTag(item); * } * } * * //Make sure that there are no duplicate rows already in the datatable * // If there are, then they must be deleted from the table. * exp = "TABLE = '" + tTable + "' AND TASK = '" + tTask + "' AND ROW = '" + tRange + "' AND ROUND = '" + tRound + "'"; * foundRows = dt4.Select(exp); * //int i = foundRows[0].ToString; * if (foundRows.Length > 0) * foundRows[0].Delete(); * * dt4.Rows.Add(task_end_row); * } * * }*/ foreach (var line in logLines) { if (line.Contains("TASKEND:")) { task_end_row = dt4.NewRow(); String[] taskEndSplit = splitLine(line); String tTable = ""; String tRange = ""; String tRound = ""; String tTask = ""; foreach (var item in taskEndSplit) { if (item.IndexOf("TABLE(", StringComparison.OrdinalIgnoreCase) >= 0) { tTable = addTag(item); task_end_row["TABLE"] = tTable; } if (item.IndexOf("TASK(", StringComparison.OrdinalIgnoreCase) >= 0) { tTask = addTag(item); task_end_row["TASK"] = tTask; } if (item.IndexOf("ROW(", StringComparison.OrdinalIgnoreCase) >= 0) { tRange = addTag(item); task_end_row["ROW"] = tRange; } if (item.IndexOf("ROUND(", StringComparison.OrdinalIgnoreCase) >= 0) { tRound = addTag(item); task_end_row["ROUND"] = tRound; } if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0) { task_end_row["TIMESTAMP"] = addTag(item); } } //Make sure that there are no duplicate rows already in the datatable // If there are, then they must be deleted from the table. exp = "TABLE = '" + tTable + "' AND TASK = '" + tTask + "' AND ROW = '" + tRange + "' AND ROUND = '" + tRound + "'"; foundRows = dt4.Select(exp); //int i = foundRows[0].ToString; if (foundRows.Length > 0) { foundRows[0].Delete(); } dt4.Rows.Add(task_end_row); } } // Add HIT foreach (var line in logLines) { if (line.Contains("HIT:")) { hit_row = dt2.NewRow(); String[] hitSplit = splitLine(line); foreach (var item in hitSplit) { if (item.IndexOf("NAME(", StringComparison.OrdinalIgnoreCase) >= 0) { hit_row["NAME"] = addTag(item); } if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0) { // Find table and task according to the timestamp. DateTime hitTime = ConvertDateTime(addTag(item)); //string expression = "1=1"; //DataRow[] selectedRows = dt3.Select(expression); //dt3 - taskstart, dt4 - taskend foreach (var row in dt3.Rows) { DateTime taskStartTime = ConvertDateTime(((WindowsFormsApplication1.DataSet1.TASKSTARTRow)(row)).TIMESTAMP); String taskStartTable = ((WindowsFormsApplication1.DataSet1.TASKSTARTRow)(row)).TABLE; String taskStartTask = ((WindowsFormsApplication1.DataSet1.TASKSTARTRow)(row)).TASK; String taskExpression = "TABLE = '" + taskStartTable + "' AND TASK = '" + taskStartTask + "'"; DataRow[] taskEndRows = dt4.Select(taskExpression); DateTime taskEndTime = ConvertDateTime(((WindowsFormsApplication1.DataSet1.TASKENDRow)(taskEndRows[0])).TIMESTAMP); // Find the taskstart and taskend objects that the hit timestamp falls between if (hitTime > taskStartTime && hitTime < taskEndTime) { hit_row["TABLE_ID"] = taskStartTable; hit_row["TASK_ID"] = taskStartTask; } } hit_row["TIMESTAMP"] = hitTime; } /*if (item.IndexOf("TABLE(", StringComparison.OrdinalIgnoreCase) >= 0) * { * hit_row["TABLE_ID"] = addTag(item); * } * if (item.IndexOf("TASK(", StringComparison.OrdinalIgnoreCase) >= 0) * { * hit_row["TASK_ID"] = addTag(item); * }*/ } dt2.Rows.Add(hit_row); } } // Add MALFUNCTION foreach (var line in logLines) { if (line.Contains("MALFUNCTION:")) { malfunction_row = dt7.NewRow(); String[] malSplit = splitLine(line); foreach (var item in malSplit) { if (item.IndexOf("ADDRESS(", StringComparison.OrdinalIgnoreCase) >= 0) { malfunction_row["ADDRESS"] = addTag(item); } if (item.IndexOf("TIMESTAMP(", StringComparison.OrdinalIgnoreCase) >= 0) { malfunction_row["TIMESTAMP"] = addTag(item); } if (item.IndexOf("DEFINITION(", StringComparison.OrdinalIgnoreCase) >= 0) { malfunction_row["DEFINITION"] = addTag(item); } } dt7.Rows.Add(malfunction_row); } } //Test data /*for (int i = 1; i < 6; i++) * { * table_row = dt12.NewRow(); * table_row["TABLE"] = 1; * table_row["TASK"] = i.ToString(); * table_row["ROW"] = "Row" + i; * if (i % 2 == 0) * { * table_row["HITS"] = "X"; * } * table_row["ROUND"] = "None"; * dt12.Rows.Add(table_row); * } * * for (int i = 1; i < 6; i++) * { * table_row = dt12.NewRow(); * table_row["TABLE"] = 2; * table_row["TASK"] = i.ToString(); * table_row["ROW"] = "Row" + i; * if (i % 3 == 0) * { * table_row["HITS"] = "X"; * } * table_row["ROUND"] = "None"; * dt12.Rows.Add(table_row); * }*/ AddTaskTimes(dt3, dt4); //dt3 = TASKSTART, dt4 = TASKEND //AddHitInfo(dt3, dt2, dt11, dt1, dt5); //dt3 = TASKSTART, dt2 = HIT, dt11 = GROUP, dt1 = ID, dt5 = TARGET ReportDocument cryRpt = new ReportDocument(); sFile = tbFileName.Text; Console.WriteLine("sFile loaded here " + sFile); cryRpt.Load(sFile); crystalReportViewer1.ReportSource = cryRpt; cryRpt.SetDataSource(ds); /*ParameterFields paramFields = new ParameterFields(); * ParameterField paramField = new ParameterField(); * ParameterDiscreteValue discreteVal = new ParameterDiscreteValue(); * * paramField.ParameterFieldName = "IDCode_param"; * * // Run multiple reports * for (int i = 0; i < sIDCodes.Count; i++) * { * sIDCode = sIDCodes.ElementAt(i); * //sIDCode = sIDCodes[i]; * discreteVal.Value = sIDCode; * paramField.CurrentValues.Add(discreteVal); * * crystalReportViewer1.ParameterFieldInfo.Clear(); * crystalReportViewer1.ParameterFieldInfo.Add(paramField); * * paramField.HasCurrentValue = true;*/ crystalReportViewer1.Refresh(); //} //cryRpt.PrintToPrinter(1, false, 0, 0); //MessageBox.Show("Pause", "Go"); //} }
private void loadPrint() { if(commit == "1") { string q1 = "select itemCode,itemName,quantity,unitPrice,Amount,sReturn from Sales where salesNo='" + sl + "'"; string q2 = "select salesNo,sDate,total,salesType,creditCardPer,discountPer,vatAmount,grandTotal,receive,change from SalesSummary where salesNo='" + sl + "'"; try { aa.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(q1, aa); DataSet1 mydataset = new DataSet1(); da.Fill(mydataset, "Sales"); da.Dispose(); SqlDataAdapter da2 = new SqlDataAdapter(); da2.SelectCommand = new SqlCommand(q2, aa); da2.Fill(mydataset, "SalesSummary"); CrystalReport1 myreport = new CrystalReport1(); myreport.SetDataSource(mydataset); PrintMemo pm = new PrintMemo(); pm.crystalReportViewer1.ReportSource = myreport; pm.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { aa.Close(); } } else { MessageBox.Show("First commit sales by Clicking Save Button!", "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click_1(object sender, EventArgs e) { //dsRpt ds = new dsRpt(); //rpt cry = new rpt(); //SQLCON.openConn(); //SQLCON.sql = "Select * from tblcate"; //SQLCON.cmd = new MySqlCommand(SQLCON.sql, SQLCON.cnn); //SQLCON.da = new MySqlDataAdapter(SQLCON.cmd); ////SQLCON.cmd.Parameters.AddWithValue(txtInvoiceNo.Text, "@invoiceNo"); //DataTable dt = new DataTable(); //SQLCON.da.Fill(ds.Tables[0]); //dt = ds.Tables[0]; //cry.SetDataSource(ds.Tables[0]); //crystalReportViewer1.ReportSource = cry; //crystalReportViewer1.Refresh(); //this.reportViewer1.RefreshReport(); DataSet1 dsa = new DataSet1(); //SQLCON.openConn(); //SQLCON.sql = "Select * from tblcate"; // SQLCON.cmd = new MySqlCommand("Select * from tblcate", SQLCON.cnn); SQLCON.da = new MySqlDataAdapter("Select * from tblcate", SQLCON.cnn); DataTable dt = new DataTable(); SQLCON.da.Fill(dsa, "DataTable1"); //dataGridView1.DataSource = dt; ReportDataSource rds = new ReportDataSource("DataSet1", dsa.Tables[0]); // this.reportViewer2.ProcessingMode = ProcessingMode.Local; this.reportViewer2.LocalReport.DataSources.Clear(); this.reportViewer2.LocalReport.DataSources.Add(rds); this.reportViewer2.SetDisplayMode(DisplayMode.PrintLayout); this.reportViewer2.RefreshReport(); ///////////// crystal //crystal cry = new crystal(); //cry.SetDataSource(dsa.Tables[0]); //crystalReportViewer1.ReportSource = cry; //this.crystalReportViewer1.RefreshReport(); // Try // Dim DS As New DataSet_cate // Dim cnn As New MySqlConnection("Server=192.168.0.8;Database=pos;Uid=root;Pwd=12345678;") // cnn.Open() // Dim da As New MySqlDataAdapter("Select * From tbl_cate", cnn) // da.Fill(DS.Tables(0)) // ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local // 'ReportViewer1.LocalReport.ReportPath = System.Environment.CurrentDirectory & "\ReportName.rdp" // ReportViewer1.LocalReport.ReportPath = "D:\My Document\Project\POS 03012017\POS\main\Form\_01_System\Report\rptCate.rdlc" // ReportViewer1.LocalReport.DataSources.Clear() // ReportViewer1.LocalReport.DataSources.Add(New Microsoft.Reporting.WinForms.ReportDataSource("DataSet_cate", DS.Tables(0))) // ReportViewer1.DocumentMapCollapsed = True // 'parameter // Dim printBy As New ReportParameter("printBy", fMain.stUser.Text) // ReportViewer1.LocalReport.SetParameters(printBy) // ReportViewer1.SetDisplayMode(DisplayMode.PrintLayout) // Me.ReportViewer1.RefreshReport() //Catch ex As Exception // cnn.Close() // MsgBox(ex.Message) //End Try }
private void NewOrder() { _ds = null; lblId.Text = string.Empty; tbName.Text = string.Empty; dataGridView1.DataSource = null; }
private void LoadOrder() { //Todo: Remove. For testing purposes int orderId = 0; int.TryParse(tbFind.Text, out orderId); _orderId = orderId; _ds = new DataSet1(); _ds.Rewards.Merge(_dm.RewardsTableAdapter.GetDataById(orderId)); _ds.RewardRequirements.Merge(_dm.RewardRequirementsTableAdapter.GetDataByRewardId(orderId)); dataGridView1.DataSource = _ds.RewardRequirements; }