public void FormatDataGridView() { DataTable dt = new DataTable(); dt = NewDataTable(applicationFileName, ",", true); if (applicationFileName.Contains("OPS")) { dataGridView2.DataSource = dt.Copy(); dtAll.Merge(dt); } else if (applicationFileName.Contains("DPM")) { dataGridView1.DataSource = dt.Copy(); dtAll.Merge(dt); } else if (applicationFileName.Contains("BDW")) { dataGridView3.DataSource = dt.Copy(); dtAll.Merge(dt); } else if (applicationFileName.Contains("DEALS")) { dataGridView4.DataSource = dt.Copy(); dtAll.Merge(dt); } }
private void UpDatadataGridView() { if (dataGridView_Checkcontent.Visible && MainForm.m_CheckHander != null) { CheckcontentDataSource = MainForm.m_CheckHander.GetCheckdataGridView_DB(); if (checkBox_ZhengChang.Checked && checkBox_YiChang.Checked) { dataGridView_Checkcontent.DataSource = null; dataGridView_Checkcontent.DataSource = CheckcontentDataSource; } else if (checkBox_ZhengChang.Checked) { CheckcontentDataSource1 = CheckcontentDataSource.Copy(); for (int ii = 0; ii < CheckcontentDataSource1.Rows.Count; ii++) { if ((CheckcontentDataSource1.Rows[ii][(int)EquipmentCheck.CheckdataGridView_titleArr_Index.Content].ToString().Length == 0 || CheckcontentDataSource1.Rows[ii][(int)EquipmentCheck.CheckdataGridView_titleArr_Index.Content].ToString() == "正常") && CheckcontentDataSource1.Rows[ii][(int)EquipmentCheck.CheckdataGridView_titleArr_Index.Status].ToString() != "离线") { } else { CheckcontentDataSource1.Rows[ii].Delete(); ii--; } } dataGridView_Checkcontent.DataSource = null; dataGridView_Checkcontent.DataSource = CheckcontentDataSource1; } else if (checkBox_YiChang.Checked) { CheckcontentDataSource1 = CheckcontentDataSource.Copy(); for (int ii = 0; ii < CheckcontentDataSource1.Rows.Count; ii++) { if ((CheckcontentDataSource1.Rows[ii][(int)EquipmentCheck.CheckdataGridView_titleArr_Index.Status].ToString().Length == 0 || CheckcontentDataSource1.Rows[ii][(int)EquipmentCheck.CheckdataGridView_titleArr_Index.Status].ToString() == "正常") && CheckcontentDataSource1.Rows[ii][(int)EquipmentCheck.CheckdataGridView_titleArr_Index.Status].ToString() != "离线") { CheckcontentDataSource1.Rows[ii].Delete(); ii--; } else { } } dataGridView_Checkcontent.DataSource = null; dataGridView_Checkcontent.DataSource = CheckcontentDataSource1; } else { dataGridView_Checkcontent.DataSource = null; } } }
/// <summary> /// DataTable分页 /// </summary> /// <param name="dt">DataTable</param> /// <param name="PageIndex">页索引,注意:从1开始</param> /// <param name="PageSize">每页大小</param> /// <returns>分好页的DataTable数据</returns> 第1页 每页10条 public static System.Data.DataTable GetPagedTable(System.Data.DataTable dt, int PageIndex, int PageSize) { if (PageIndex == 0) { return(dt); } System.Data.DataTable newdt = dt.Copy(); newdt.Clear(); int rowbegin = (PageIndex - 1) * PageSize; int rowend = PageIndex * PageSize; if (rowbegin >= dt.Rows.Count) { return(newdt); } if (rowend > dt.Rows.Count) { rowend = dt.Rows.Count; } for (int i = rowbegin; i <= rowend - 1; i++) { DataRow newdr = newdt.NewRow(); DataRow dr = dt.Rows[i]; foreach (DataColumn column in dt.Columns) { newdr[column.ColumnName] = dr[column.ColumnName]; } newdt.Rows.Add(newdr); } return(newdt); }
/// <summary> /// Saves a copy of the ProxyTable in the application settings /// </summary> /// <param name="proxyTable">DataTable to save</param> public static void saveConfig(DataTable proxyTable) { DataTable copyTable = proxyTable.Copy(); SwitchProxy.Properties.Settings.Default.ProxyTable = null; SwitchProxy.Properties.Settings.Default.ProxyTable = copyTable; SwitchProxy.Properties.Settings.Default.Save(); }
public DataTable GetPagedTable(DataTable dt, int PageIndex, int PageSize) { if (PageIndex == 0) return dt; DataTable newdt = dt.Copy(); newdt.Clear(); int rowbegin = (PageIndex - 1) * PageSize; int rowend = PageIndex * PageSize; if (rowbegin >= dt.Rows.Count) return newdt; if (rowend > dt.Rows.Count) rowend = dt.Rows.Count; for (int i = rowbegin; i <= rowend - 1; i++) { DataRow newdr = newdt.NewRow(); DataRow dr = dt.Rows[i]; foreach (DataColumn column in dt.Columns) { newdr[column.ColumnName] = dr[column.ColumnName]; } newdt.Rows.Add(newdr); } return newdt; }
/// <summary> /// Export a DataTable to an CSV File /// </summary> /// <param name="dt">The Data Table.</param> /// <param name="response">The HttpResponse that will download the Excel File.</param> /// <param name="fileName">Name of the file.</param> /// <param name="startCol">The first column of the Gridview to export.</param> /// <exception cref="System.ArgumentOutOfRangeException">Starting column must be within the range of the column count</exception> public static void DataTableToCSV(System.Data.DataTable dt, HttpResponse response, string fileName, int startCol) { System.Data.DataTable myTable = dt.Copy(); if (startCol > myTable.Columns.Count || startCol < 0) { throw new ArgumentOutOfRangeException("Starting column must be within the range of the column count"); } for (int i = startCol; i < myTable.Columns.Count; i++) { myTable.Columns.Add(dt.Columns[i].ToString()); } for (int j = 0; j < dt.Rows.Count; j++) { int length = dt.Columns.Count - startCol; string[] colValues = new string[length]; for (int k = 0; k < length; k++) { colValues[k] = dt.Rows[j][k].ToString(); } myTable.Rows.Add(colValues); } myTable.AcceptChanges(); DataTableToCSV(myTable, response, fileName); }
private int GetZeroReactionsCount(System.Data.DataTable _reporttbl) { int intCnt = 0; try { if (_reporttbl != null) { if (_reporttbl.Rows.Count > 0) { System.Data.DataTable dtReport = _reporttbl.Copy(); DataView dvTemp = dtReport.DefaultView; dvTemp.RowFilter = "[No.of Reactions]" + " = 0"; System.Data.DataTable dt = dvTemp.ToTable(); if (dt != null) { intCnt = dt.Rows.Count; } } } } catch (Exception ex) { ErrorHandling.WriteErrorLog(ex.ToString()); } return(intCnt); }
private void InitialOriginTable(DataTable dt) { originalTable = dt.Copy(); originalTable.Columns.Add("PassengerName"); originalTable.Columns["PassengerName"].SetOrdinal(0); originalTable.Columns.Add("FlightInfo"); originalTable.Columns["FlightInfo"].SetOrdinal(1); originalTable.Columns.Add("StaffName"); //originalTable.Columns["StaffName"].SetOrdinal(2); foreach (DataRow row in originalTable.Rows) { Guid passengerID = Guid.Parse(row["PassengerID"].ToString()); Passenger passenger = reservationSystem.GetPassengerByID(passengerID); string passengerName = passenger.firstName + " " + passenger.lastName; row["PassengerName"] = passengerName; Guid staffID = Guid.Parse(row["StaffID"].ToString()); Staff staff = reservationSystem.GetStaffByID(staffID); string staffName = staff.firstName + " " + staff.lastName; row["StaffName"] = staffName; Guid flightID = Guid.Parse(row["FlightID"].ToString()); Flight flight = reservationSystem.GetFlightByID(flightID); string flightInfo = flight.origin.name + " - " + flight.destination.name; row["FlightInfo"] = flightInfo; } }
protected void Page_Load(object sender, EventArgs e) { GridView grid = new GridView(); DataTable dt = new DataTable(); List<Terceiro> lista = new List<Terceiro>(); TerceiroBL tbl = new TerceiroBL(); lista = tbl.buscaTerceiros(Convert.ToInt16(Session["empresa"].ToString())); DataColumn c1 = new DataColumn("Cnpj", Type.GetType("System.String")); DataColumn c2 = new DataColumn("Nome", Type.GetType("System.String")); DataColumn c3 = new DataColumn("Email", Type.GetType("System.String")); DataColumn c4 = new DataColumn("Telefone", Type.GetType("System.String")); DataColumn c5 = new DataColumn("editar", Type.GetType("System.String")); dt.Columns.Add(c1); dt.Columns.Add(c2); dt.Columns.Add(c3); dt.Columns.Add(c4); dt.Columns.Add(c5); foreach (Terceiro t in lista) { DataRow dr = dt.NewRow(); dr["Cnpj"] = t.cpfCnpj.ToString(); dr["Nome"] = t.nome.ToString(); dr["Email"] = t.email.ToString(); dr["Telefone"] = t.telefone.ToString(); dr["editar"] = "~/EditaTerceiro.aspx?id_terceiro=" + t.id.ToString(); dt.Rows.Add(dr); } gridTerceiros.DataSource = dt.Copy(); gridTerceiros.DataBind(); }
/// <summary> /// /// </summary> /// <param name="tbl"></param> public void AddGRAlarm(DataTable tbl) { DataTable s = this.dataGridView1.DataSource as DataTable; if (s == null) { s = tbl.Copy(); this.dataGridView1.DataSource = s; } else { s.Merge(tbl); } if (dataGridView1.Rows.Count > 0) { // remove records // if (dataGridView1.Rows.Count > Config.Default.GRAlarmMaxCount) { int n = dataGridView1.Rows.Count - Config.Default.GRAlarmMaxCount; for (int i = 0; i < n; i++) { dataGridView1.Rows.RemoveAt(0); //s.Rows[0].Delete(); } } // move to last record // DataGridViewCell lastCell = this.dataGridView1[0, this.dataGridView1.Rows.Count - 1]; this.dataGridView1.CurrentCell = lastCell; } }
/// <summary> /// Export to one sheet excel /// Trả về : /// "err": lỗi /// đường dẫn: thành công /// </summary> /// <param name="dt"></param> /// <param name="fileName"></param> /// <returns></returns> public static string ExportDatatableToExcel(System.Data.DataTable dt, string fileName, string sheetName = "SheetBC") { try { string _fileName = "CP_" + fileName + "_" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xlsx"; using (ClosedXML.Excel.XLWorkbook wb = new ClosedXML.Excel.XLWorkbook()) { wb.Worksheets.Add(dt.Copy(), sheetName); wb.Style.Alignment.Horizontal = ClosedXML.Excel.XLAlignmentHorizontalValues.Center; wb.Style.Font.Bold = true; if (!Directory.Exists(System.Web.HttpContext.Current.Server.MapPath("/export/"))) { Directory.CreateDirectory(System.Web.HttpContext.Current.Server.MapPath("/export/")); } string pathStr = System.Web.HttpContext.Current.Server.MapPath("/export/") + _fileName; using (var outStream = new System.IO.MemoryStream()) { using (var fileStream = new System.IO.FileStream(pathStr, System.IO.FileMode.CreateNew, System.IO.FileAccess.ReadWrite)) { wb.SaveAs(fileStream, false); } } return(_fileName); } } catch (Exception) { return("err"); } }
public void alimentagrid() { GridView grid = new GridView(); DataTable dt = new DataTable(); List<Etapa> lista = new List<Etapa>(); EtapaBL ebl = new EtapaBL(); lista = ebl.buscaEtapas(); DataColumn c1 = new DataColumn("id", Type.GetType("System.String")); DataColumn c2 = new DataColumn("nome", Type.GetType("System.String")); DataColumn c3 = new DataColumn("editar", Type.GetType("System.String")); dt.Columns.Add(c1); dt.Columns.Add(c2); dt.Columns.Add(c3); foreach (Etapa e in lista) { DataRow dr = dt.NewRow(); dr["id"] = e.id.ToString(); dr["nome"] = e.tituloEtapa.ToString(); dr["editar"] = "~/EditaEtapa.aspx?id_etapa=" + e.id.ToString(); dt.Rows.Add(dr); } griEtapas.DataSource = dt.Copy(); griEtapas.DataBind(); }
public void carregaTabela() { GridView grid = new GridView(); DataTable dt = new DataTable(); List<ItemTarefa> lista = new List<ItemTarefa>(); TarefaBL tbl = new TarefaBL(); lista = tbl.buscaItensTarefa(idTarefa); DataColumn c1 = new DataColumn("data", Type.GetType("System.String")); DataColumn c2 = new DataColumn("descricao", Type.GetType("System.String")); DataColumn c3 = new DataColumn("excluir", Type.GetType("System.String")); dt.Columns.Add(c1); dt.Columns.Add(c2); dt.Columns.Add(c3); foreach (ItemTarefa t in lista) { EtapaBL ebl = new EtapaBL(); DataRow dr = dt.NewRow(); dr["data"] = t.data.ToString(); dr["descricao"] = t.descricao.ToString(); dr["excluir"] = "ExcluirItemTarefa.aspx?id_item=" + t.id.ToString(); dt.Rows.Add(dr); } gridItens.DataSource = dt.Copy(); gridItens.DataBind(); }
/// <summary> /// Sorts the <see cref="System.Data.DataTable"/>. /// </summary> /// <param name="sourceTable">The source table.</param> /// <param name="sortColumn">The column to sort by.</param> /// <param name="order">The <see cref="Tools.Common.SortOrder"/>.</param> /// <param name="copyIfNoSort">Should only be true when one table owner is assumed /// other time and space.</param> /// <returns></returns> public static DataTable SortDataTable(DataTable sourceTable, string sortColumn, SortOrder order, bool copyIfNoSort) { if (String.IsNullOrEmpty(sortColumn)) { // copyIfNoSort make the semantic more stable, even if there is no sort required // the copy is returned, so the caller may assume same level of independence. if (copyIfNoSort) return sourceTable.Copy(); return sourceTable; } DataTable targetTable = sourceTable.Clone(); DataRow[] sourceRows = sourceTable.Select(null, ("[" + sortColumn + "] " + order.ToString()).TrimEnd(' ')); for (int i = 0; i < sourceRows.Length; i++) { DataRow newRow = targetTable.NewRow(); newRow.ItemArray = sourceRows[i].ItemArray; targetTable.Rows.Add(newRow); } return targetTable; }
public void DarFormatoGrillas() { DataTable oDTIzq = new DataTable("Datos"); oDTIzq.Columns.Add("-250-"); oDTIzq.Columns.Add("-500-"); oDTIzq.Columns.Add("-1K-"); oDTIzq.Columns.Add("-2K-"); oDTIzq.Columns.Add("-4K-"); DataRow oDR = oDTIzq.NewRow(); DataRow oDR2 = oDTIzq.NewRow(); oDTIzq.Rows.Add(oDR); oDTIzq.Rows.Add(oDR2); DataTable oDTDer = oDTIzq.Copy(); dgvTablaReflejosIzq.DataSource = oDTIzq; dgvTablaReflejosDer.DataSource = oDTDer; DeterminarAnchoColumnas(); //String strDT = Mds.Architecture.HelpersFunctions.SerializationFunctions.Serialize(oDT); //DataTable kk = (DataTable)Mds.Architecture.HelpersFunctions.SerializationFunctions.DeserializeFromXml(typeof(DataTable), strDT); }
protected void Page_Load(object sender, EventArgs e) { GridView grid = new GridView(); DataTable dt = new DataTable(); List<Usuario> lista = new List<Usuario>(); UsuarioBL uBL = new UsuarioBL(); lista = uBL.buscaUsuariosEmpresa(Convert.ToInt16(Session["empresa"].ToString())); DataColumn c1 = new DataColumn("Email", Type.GetType("System.String")); DataColumn c2 = new DataColumn("Nome", Type.GetType("System.String")); DataColumn c3 = new DataColumn("Empresa", Type.GetType("System.String")); DataColumn c4 = new DataColumn("Licença", Type.GetType("System.String")); DataColumn c5 = new DataColumn("editar", Type.GetType("System.String")); dt.Columns.Add(c1); dt.Columns.Add(c2); dt.Columns.Add(c3); dt.Columns.Add(c4); dt.Columns.Add(c5); foreach (Usuario u in lista) { DataRow dr = dt.NewRow(); dr["Email"] = u.email.ToString(); dr["Nome"] = u.nome.ToString(); dr["Empresa"] = u.idEmpresa.ToString(); dr["Licença"] = u.dataFimLicenca.ToShortDateString(); dr["editar"] = "~/EditarUsuario.aspx?user_mail=" + u.email.ToString(); dt.Rows.Add(dr); } gridUsuarios.DataSource = dt.Copy(); gridUsuarios.DataBind(); }
public void SerializePart( DataTable data ) { // TODO: ТОЛЬКО ДЛЯ ТЕСТИРОВАНИЯ. УБРАТЬ! // data.TableName += Guid.NewGuid().ToString(); ResultDataSet.Tables.Add( data.Copy() ); }
private DataTable DisposeTask(System.Data.DataTable dtTask) { try { DataTable dtNew = dtTask.Copy(); dtNew.Columns.Add("StatusName"); dtNew.Columns.Add("ImportantName"); dtNew.Columns.Add("Master"); dtNew.Columns.Add("Exceed"); dtNew.Columns.Add("PicName", System.Type.GetType("System.String")); for (int i = 0; i < dtNew.Rows.Count; i++) { dtNew.Rows[i]["StatusName"] = (dtNew.Rows[i]["Status"] == System.DBNull.Value)?"":ComSource.GetTaskStatusName(dtNew.Rows[i]["Status"].ToString()); dtNew.Rows[i]["ImportantName"] = (dtNew.Rows[i]["ImportantLevel"] == System.DBNull.Value)?"":ComSource.GetImportantName(dtNew.Rows[i]["ImportantLevel"].ToString()); dtNew.Rows[i]["Master"] = this.GetMaster(dtNew.Rows[i]["WBSCode"].ToString()); dtNew.Rows[i]["Exceed"] = "0"; if (dtNew.Rows[i]["PlannedStartDate"] != System.DBNull.Value && dtNew.Rows[i]["Status"].ToString() == "0") // 未开始的工作延期 { dtNew.Rows[i]["Exceed"] = (DateTime.Now.Date.Subtract(DateTime.Parse(dtNew.Rows[i]["PlannedStartDate"].ToString())).Days > 0)?"1":"0"; } if (dtNew.Rows[i]["PlannedFinishDate"] != System.DBNull.Value && dtNew.Rows[i]["Status"].ToString() != "4" && dtNew.Rows[i]["Exceed"].ToString() != "1") // 非完成的工作,非延期时再次判断 { dtNew.Rows[i]["Exceed"] = (DateTime.Now.Date.Subtract(DateTime.Parse(dtNew.Rows[i]["PlannedFinishDate"].ToString())).Days > 0)?"1":"0"; } dtNew.Rows[i]["PicName"] = this.GetStatusImg(dtNew.Rows[i]["Status"].ToString()) + " " + dtNew.Rows[i]["SortID"].ToString() + " " + dtNew.Rows[i]["TaskName"].ToString(); } return(dtNew); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); return(null); } }
private void delete_Click(object sender, EventArgs e) { if(meeting_dg.Rows.Count==0) return ; int current_index= meeting_dg.CurrentRow.Index; object obj = meeting_dg.Rows[current_index].Cells[0].Value; string meetingname = Convert.ToString(obj); try { mainform.db.update("delete from dbo.meeting where meetingname='" + meetingname + "'"); DataTable temp = new DataTable(); temp =(DataTable) meeting_dg.DataSource; DataTable temp2 = new DataTable(); temp2 = temp.Copy(); temp2.Clear(); for (int i = 0; i < temp.Rows.Count; i++) { string tempname=Convert.ToString(temp.Rows[i].ItemArray[0]); if(tempname!=meetingname) { temp2.Rows.Add(temp.Rows[i].ItemArray); } } meeting_dg.DataSource =temp2; } catch (Exception ee) { MessageBox.Show(ee.Message); } }
//////////////////////////////////////////MySQL public void NW_Dhcp_Customer_Getlist_MySQL() { string sql = "Select * from NW_Dhcp_Customer"; dt = Class.MySqlConnect.ExecQuery(sql); gridItem.DataSource = dt; dtIpPublic = dt.Copy(); }
/// <summary> /// 取得 VDS_CRM_ORDER_MAIN && VDS_CRM_ORDER_DETL 的 Data /// </summary> /// <param name="ParameterList"></param> /// <returns>回傳查詢結果</returns> public DataSet QUERY_CRM041_MAIN_AND_DETL(ArrayList ParameterList) { try { DataSet ds_Return = new DataSet(); DataTable dt_Return_Main = new DataTable(); DataTable dt_Return_Detl = new DataTable(); DBO.VDS_CRM_ORDER_MAINDBO VCOM = new VDS_CRM_ORDER_MAINDBO(ref USEDB); DBO.VDS_CRM_ORDER_DETLDBO VCOD = new VDS_CRM_ORDER_DETLDBO(ref USEDB); dt_Return_Main = VCOM.QUERY_CRM041_MAIN(ParameterList); dt_Return_Main.TableName = "VDS_CRM_ORDER_MAIN"; dt_Return_Detl = VCOD.QUERY_CRM041_DETL(ParameterList); dt_Return_Detl.TableName = "VDS_CRM_ORDER_DETL"; ds_Return.Tables.Add(dt_Return_Main.Copy()); ds_Return.Tables.Add(dt_Return_Detl.Copy()); dt_Return_Main.Clear(); dt_Return_Detl.Clear(); dt_Return_Main.Dispose(); dt_Return_Detl.Dispose(); return ds_Return; } catch (Exception ex) { throw GetNewException(ex); } }
// Function : ExportDetails // Arguments : DetailsTable, FormatType, FileName // Purpose : To get all the column headers in the datatable and // exorts in CSV / Excel format with all columns public void ExportDetails(DataTable DetailsTable, ExportFormat FormatType, string FileName) { try { if (DetailsTable.Rows.Count == 0) throw new Exception("There are no details to export."); // Create Dataset DataSet dsExport = new DataSet("Export"); DataTable dtExport = DetailsTable.Copy(); dtExport.TableName = "Values"; dsExport.Tables.Add(dtExport); // Getting Field Names string[] sHeaders = new string[dtExport.Columns.Count]; string[] sFileds = new string[dtExport.Columns.Count]; for (int i = 0; i < dtExport.Columns.Count; i++) { //sHeaders[i] = ReplaceSpclChars(dtExport.Columns[i].ColumnName); sHeaders[i] = dtExport.Columns[i].ColumnName; sFileds[i] = ReplaceSpclChars(dtExport.Columns[i].ColumnName); } if (appType == "Web") Export_with_XSLT_Web(dsExport, sHeaders, sFileds, FormatType, FileName); else if (appType == "Win") Export_with_XSLT_Windows(dsExport, sHeaders, sFileds, FormatType, FileName); } catch (Exception Ex) { throw Ex; } }
protected void Page_Load(object sender, EventArgs e) { GridView grid = new GridView(); DataTable dt = new DataTable(); List<Mensagem> lista = new List<Mensagem>(); MensagemBL mbl = new MensagemBL(); UsuarioBL ubl = new UsuarioBL(); lista = mbl.buscaMensagensusuario(Session["email"].ToString()); DataColumn c1 = new DataColumn("data", Type.GetType("System.String")); DataColumn c2 = new DataColumn("remetente", Type.GetType("System.String")); DataColumn c3 = new DataColumn("nome", Type.GetType("System.String")); DataColumn c4 = new DataColumn("abrir", Type.GetType("System.String")); dt.Columns.Add(c1); dt.Columns.Add(c2); dt.Columns.Add(c3); dt.Columns.Add(c4); foreach (Mensagem m in lista) { DataRow dr = dt.NewRow(); dr["data"] = m.data.ToShortDateString(); dr["remetente"] = m.remetente.ToString(); dr["nome"] = ubl.buscaNome(m.remetente.ToString()); dr["abrir"] = "~/LerMensagem.aspx?id_mensagem=" + m.id.ToString(); dt.Rows.Add(dr); } gridMensagens.DataSource = dt.Copy(); gridMensagens.DataBind(); }
DataTable IConsulta.CarregaDadosMae(string idUnit) { DataTable table2; StringBuilder builder = new StringBuilder(); DataTable table = new DataTable(); try { builder.Length = 0; builder.AppendLine("EXECUTE INTOUCH.DBO.[BIINTOUCH.CARREGAINFORMACOES_MAE] "); builder.AppendLine("@ID_UNIT = '" + idUnit + "' "); table = DbIntouch.ExecuteDataTable(builder.ToString()); table2 = table.Copy(); } catch { table2 = null; } finally { if (table != null) { table.Dispose(); } } return table2; }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.Columns[e.ColumnIndex].Name == "exe") {//打开文件 openFileDialog1.ShowDialog(); dataGridView1.CurrentCell.Value = openFileDialog1.FileName; } else if (dataGridView1.Columns[e.ColumnIndex].Name == "ok") {//保存文件 DataTable _dt = new DataTable(); _dt.Columns.Add("exe"); _dt.Columns.Add("message"); _dt.Columns.Add("rule"); foreach (DataGridViewRow var in dataGridView1.Rows) { if (var.Cells[1].Value == null) { continue; } _dt.Rows.Add(var.Cells["exe"].Value.ToString(), var.Cells["message"].Value.ToString() == null ? "*" : var.Cells["message"].Value.ToString(), var.Cells["rule"].Value.ToString() == null ? "1" : var.Cells["rule"].Value.ToString()); } DataSet _ds = new DataSet(); _ds.Tables.Add(_dt.Copy()); SaveData(_ds); } }
public DataTable ConvertEMeterTransaction(DataTable _dt, int adcID) { DataTable dt = _dt.Copy(); // string sID = "device_adc_id"; string sDate = "e_datetime"; // if (!dt.Columns.Contains(sID)) dt.Columns.Add(new DataColumn(sID, typeof(int), "'" + adcID + "'")); // if (!dt.Columns.Contains(sDate)) dt.Columns.Add(new DataColumn(sDate, typeof(DateTime), "Convert(E_Date + ' ' + E_Time, 'System.DateTime')")); // string sConnection = "e_connection"; if (!dt.Columns.Contains(sConnection)) dt.Columns.Add(new DataColumn(sConnection, typeof(int), "Convert(IIF(E_CommStatus like '%complete',1,0), 'System.Int16')")); // foreach (DataRow r in dt.Rows) { foreach(DataColumn c in dt.Columns) if(r[c.ColumnName].ToString().Contains("null")) r[c.ColumnName] = "0"; } dt.AcceptChanges(); // return dt; }
private void btnBUSCAR_Click(object sender, EventArgs e) { if (rdbDETALLE.Checked) { //BUSCAR POR ARTICULO if (cbxSUCURSAL.SelectedIndex >= 0 && cbxCATEGORIA.SelectedIndex >= 0) { INVENTARIO = dbInventario.CUSTODIA_PRENDASAL((string)cbxSUCURSAL.SelectedValue, (string)cbxCATEGORIA.SelectedValue, (string)cbxARTICULO.SelectedValue); tblINVENTARIO.DataSource = INVENTARIO.Copy(); System.Media.SystemSounds.Exclamation.Play(); } } else { //BUSCAR POR CODIGO if (txtCODIGO.Text.Trim() != string.Empty) { INVENTARIO = dbInventario.CUSTODIA_BY_CODIGO_PRENDASAL(txtCODIGO.Text.Trim()); tblINVENTARIO.DataSource = INVENTARIO.Copy(); System.Media.SystemSounds.Exclamation.Play(); } else { MessageBox.Show("INGRESE CODIGO DE ARTICULOS A BUSCAR", "VALIDACION DE DATOS", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private DataTable AddChild(System.Data.DataTable _tb) { DataTable _Tbtmp = _tb.Copy(); foreach (DataRow _RootDr in _Tbtmp.Rows) { string _RootMaSP = _RootDr["MaSP"].ToString(); string _RootCD = _RootDr["MaCongDoan"].ToString(); string _RootCD2 = ""; if (_RootDr["MaCongDoanMe"] != DBNull.Value) { _RootCD2 = _RootDr["MaCongDoanMe"].ToString(); } double _soluong = double.Parse(_RootDr["Soluong"].ToString()); double _thutu = double.Parse(_RootDr["Thutu"].ToString()); string sql = "select b.MaCongdoan, a.MaCongdoan as MaCongdoanMe, b.MaSP, b.MaWC, b.Thutu," + _soluong.ToString() + "*a.Soluong as Soluong,dbo.RoundUp(" + _soluong.ToString() + ",b.Lot) as SLThaotac, dbo.RoundUp(" + _soluong.ToString() + ",b.Lot)*(b.SetupTime + b.MoveTime+b.RunTime*b.Lot) as LenOfRouting, b.ToTalTime, b.Lot,(b.SetupTime + b.MoveTime+b.RunTime*b.Lot) as LotTime,0.0 as Stime,0.0 as Etime,0.0 as OrgETime " + "from dfRouting b LEFT join dfSPTree a ON a.MaVT=b.MaSP WHERE (a.masp='" + _RootMaSP + "' and b.Thutu=0 and a.MaCongdoan='" + _RootCD + "')" + "union all " + "select b.MaCongdoan, '" + _RootCD + "' as MaCongdoanMe, b.MaSP, b.MaWC, b.Thutu," + _soluong.ToString() + " as Soluong,dbo.RoundUp(" + _soluong.ToString() + ",b.Lot) as SLThaotac,dbo.RoundUp(" + _soluong.ToString() + ",b.Lot)*(b.SetupTime + b.MoveTime+b.RunTime*b.Lot) as LenOfRouting, b.ToTalTime, b.Lot,(b.SetupTime + b.MoveTime+b.RunTime*b.Lot) as LotTime,0.0 as Stime,0.0 as Etime,0.0 as OrgETime " + "from dfRouting b LEFT join dfSPTree a ON a.MaVT=b.MaSP WHERE (b.MaSP='" + _RootMaSP + "' and b.Thutu=" + (_thutu + 1).ToString() + " and a.MaCongdoan='" + _RootCD2 + "') "; DataTable _tbBTP = db.GetDataTable(sql); DataTable _ChildTb = _tb.Clone(); _ChildTb = AddChild(_tbBTP); _tb = AddChildTb(_tb, _ChildTb); } return(_tb); }
public static DataTable getTopCategoryTotals(DataTable inputTable, int topRowsCount) { DataTable table = inputTable.Copy(); table.Clear(); double otherTotal = 0; try { for (int i = 0; i < inputTable.Rows.Count; i++) { if (i > topRowsCount - 1) { otherTotal = otherTotal + double.Parse(inputTable.Rows[i]["total"].ToString()); } else { table.Rows.Add(inputTable.Rows[i][0], inputTable.Rows[i][1]); } } if (inputTable.Rows.Count>5) { table.Rows.Add("Other", otherTotal); } } catch (Exception exception) { Logger.LogException(exception); Helper.showMessage("Unable to trim top category totals from database. \n\n " + exception.ToString()); } return table; }
private DataTable FormatDataTable(System.Data.DataTable srcTable) { DataTable tbRet = srcTable.Copy( ); if (srcTable.Rows.Count == 0) { return(tbRet); } DataRow dr = tbRet.NewRow( ); int startCol = 0; if (reportType == HIS.MZ_BLL.ReportType.门诊收入月报表) { startCol = 2; } else { startCol = 3; } //加入合计行 for (int i = startCol - 1; i < tbRet.Columns.Count - 1; i++) { dr[tbRet.Columns[i].ColumnName] = tbRet.Compute("sum(" + tbRet.Columns[i].ColumnName + ")", ""); } dr[0] = "合计"; tbRet.Rows.Add(dr); return(tbRet); }
/// <summary> /// 输出超纲词表 /// </summary> /// <param name="oldDt">原各等级词汇表</param> /// <param name="maxIndex">选择的最高等级</param> /// <returns>超纲词汇表</returns> public static DataTable NewDataTable(DataTable oldDt, int maxIndex) { DataTable newDt = new DataTable(); //DataRow[] dr = oldDT.Select(); foreach (DataRow row in oldDt.Rows) { //string strName = row["词汇"].ToString(); //取对应字段信息 //string str1 = row["基本"].ToString(); //string str2 = row["较高"].ToString(); //string str3 = row["更高"].ToString(); //string wordfreq = row["词频"].ToString(); if (int.Parse(row[1].ToString()) > maxIndex && int.Parse(row[1].ToString()) <= 0) { newDt.Rows.Add(row); } } //string sql = string.Empty; //for (int i = 1; i <=maxIndex; i++) //{ //} DataRow[] rows = oldDt.Select("[level]>0 and [level]<=" + maxIndex); DataTable dt2 = oldDt.Copy(); //我印象中有Clone方法可以直接复制架构和数据结构但不复制数据的,不要用copy方法。 dt2.Rows.Clear(); foreach (DataRow row2 in rows) { object[] row3 = row2.ItemArray; dt2.Rows.Add(row3); } return(newDt); }
private void GetFromDB(object sender, RoutedEventArgs e) { // Create an open a connection. try { using (SqlConnection cn = new SqlConnection()) { cn.ConnectionString = _cnStrBuilder.ConnectionString; cn.Open(); string strSQL = "Select * From Sales.SalesOrderDetail"; if (tb.Text != String.Empty) { strSQL = "Select top " + tb.Text + " * From Sales.SalesOrderDetail"; } _dataSet = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(strSQL, cn); // adapter.FillSchema(_dataSet, SchemaType.Mapped); adapter.Fill(_dataSet); tesTable = _dataSet.Tables[0]; // return _dataSet.Tables[0]; //500000行 翻番 for (int i = 0; i < 2; i++) { tesTable.Merge(tesTable.Copy()); } dg.ItemsSource = tesTable.DefaultView; tb.Text = tesTable.Rows.Count.ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private DataTable DisposeTask(System.Data.DataTable dtTask) { try { DataTable dtNew = dtTask.Copy(); dtNew.Columns.Add("StatusName"); dtNew.Columns.Add("ImportantName"); dtNew.Columns.Add("Master"); dtNew.Columns.Add("PicName", System.Type.GetType("System.String")); for (int i = 0; i < dtNew.Rows.Count; i++) { dtNew.Rows[i]["StatusName"] = (dtNew.Rows[i]["Status"] == System.DBNull.Value)?"":ComSource.GetTaskStatusName(dtNew.Rows[i]["Status"].ToString()); dtNew.Rows[i]["ImportantName"] = (dtNew.Rows[i]["ImportantLevel"] == System.DBNull.Value)?"":ComSource.GetImportantName(dtNew.Rows[i]["ImportantLevel"].ToString()); dtNew.Rows[i]["Master"] = this.GetMaster(dtNew.Rows[i]["WBSCode"].ToString()); //dtNew.Rows[i]["PicName"] = this.GetStatusImg(dtNew.Rows[i]["Status"].ToString())+" "+dtNew.Rows[i]["SortID"].ToString()+" "+BLL.StringRule.TruncText(dtNew.Rows[i]["TaskName"].ToString(),15); dtNew.Rows[i]["PicName"] = this.GetStatusImg(dtNew.Rows[i]["Status"].ToString()) + " " + " " + BLL.StringRule.TruncText(dtNew.Rows[i]["TaskName"].ToString(), 15); } return(dtNew); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); return(null); } }
public ReportForm(DataTable reportData, string crystalReportFilePath) { InitializeComponent(); // Make a copy of the data to be provided to the Crystal Report... _reportSourceTable = reportData.Copy(); _crystalReportFilePath = crystalReportFilePath; }
public ServicosEstadia(DataTable t) { _tabela = new DataTable(); _tabela = t.Copy(); _tabela.PrimaryKey = null; _tabela.Columns.Remove("id"); _tabela.Columns.Remove("data"); }
public Fuzzification(List<Description> descriptions, DataTable data) { m_Descriptions = descriptions; m_Data = data; result = new Dictionary<string, List<ValueItem>>(); m_ResultData = m_Data.Copy(); }
public void AddResults(DataTable dt) { _results = dt.Copy(); //foreach(DataRow dr in dt.Rows) //{ // _results.ImportRow(dr); //} }
public Position(List<string> fullTickerList) { FullTickerList = fullTickerList; PositionWithFilledOrders = new DataTable(); PositionWithFilledOrders.Columns.Add("FullTicker", typeof(string)); PositionWithFilledOrders.Columns.Add("Qty", typeof(double)); for (int i = 0; i < FullTickerList.Count; i++) { PositionWithFilledOrders.Rows.Add(); PositionWithFilledOrders.Rows[i]["FullTicker"] = FullTickerList[i]; PositionWithFilledOrders.Rows[i]["Qty"] = 0; } PositionWithWorkingOrders = PositionWithFilledOrders.Copy(); PositionWithAllOrders = PositionWithFilledOrders.Copy(); }
public frmReport_The_kho(DataTable ct_tk, string ma_vt, string ten_vt, string dvt) { InitializeComponent(); this.ct_thekho = ct_tk.Copy(); this.ma_vt = ma_vt; this.ten_vt = ten_vt; this.dvt = dvt; }
public static DataTable Calculate(DataTable source, DataTable template, string formulaColumn, string[] calculateColumns) { //构造目的表 DataTable result = template.Copy(); foreach (string item in calculateColumns) { DataColumn column = new DataColumn(item, source.Columns[item].DataType); result.Columns.Add(column); } //END foreach (DataRow dr in result.Rows) { //公式 string formula = dr[formulaColumn].ToString().Trim(); //拆分公式 variableList中存储各个因式 IEnumerable<string> factorList = Regex.Split(formula, @"[+\-*/()]+") .Except((IEnumerable<string>)new string[] { "" }) .Select(p => p = Regex.Replace(p, @"^([0-9]+)([\.]([0-9]+))?$", "")) .Except((IEnumerable<string>)new string[] { "" }); //m_dictionary存储各个因式及其对应的行记录 IDictionary<string, DataRow> m_dictionary = new Dictionary<string, DataRow>(); foreach (string item in factorList) { //因式(factor) string factor = item.TrimStart('[').TrimEnd(']'); DataRow[] rows = source.Select("VariableId='" + factor + "'"); if (1 == rows.Count()) { m_dictionary.Add(factor, rows[0]); } else if (0 == rows.Count()) { m_dictionary.Add(factor, source.NewRow());//没有找到则添加一个空行 } else { throw new Exception(item + "对应" + rows.Count() + "条数据!"); } } ///item当前要计算的列名 foreach (string item in calculateColumns) { try { string tempFormulaValue = formula; foreach (string node in m_dictionary.Keys.ToArray()) { tempFormulaValue = tempFormulaValue.Replace("[" + node + "]", m_dictionary[node][item].ToString()); } dr[item] = Convert.ToDecimal(source.Compute(tempFormulaValue, "true")); } catch { dr[item] = 0; }; } } return result; }
public void Combos() { var dt = new DataTable(); cboLunes.DataSource = dt.Copy(); cboLunes.ValueMember = "CODIGO"; cboLunes.DisplayMember = "DESCRIPCION"; cboMartes.DataSource = dt.Copy(); cboMartes.ValueMember = "CODIGO"; cboMartes.DisplayMember = "DESCRIPCION"; cboMiercoles.DataSource = dt.Copy(); cboMiercoles.ValueMember = "CODIGO"; cboMiercoles.DisplayMember = "DESCRIPCION"; cboJueves.DataSource = dt.Copy(); cboJueves.ValueMember = "CODIGO"; cboJueves.DisplayMember = "DESCRIPCION"; cboViernes.DataSource = dt.Copy(); cboViernes.ValueMember = "CODIGO"; cboViernes.DisplayMember = "DESCRIPCION"; cboSabado.DataSource = dt.Copy(); cboSabado.ValueMember = "CODIGO"; cboSabado.DisplayMember = "DESCRIPCION"; cboDomingo.DataSource = dt.Copy(); cboDomingo.ValueMember = "CODIGO"; cboDomingo.DisplayMember = "DESCRIPCION"; }
public static DataTable getDifferentRecords(DataTable FirstDataTable, DataTable SecondDataTable) { FirstDataTable = FirstDataTable.Copy(); FirstDataTable.TableName += " First"; SecondDataTable = SecondDataTable.Copy(); SecondDataTable.TableName += " Second"; //Create Empty Table DataTable ResultDataTable = new DataTable("ResultDataTable"); //use a Dataset to make use of a DataRelation object using (DataSet ds = new DataSet()) { //Add tables ds.Tables.AddRange(new DataTable[] { FirstDataTable, SecondDataTable }); //Get Columns for DataRelation DataColumn[] firstColumns = FirstDataTable.Columns.Cast<DataColumn>().ToArray(); DataColumn[] secondColumns = SecondDataTable.Columns.Cast<DataColumn>().ToArray(); //Create DataRelation DataRelation r1 = new DataRelation(string.Empty, firstColumns, secondColumns, false); ds.Relations.Add(r1); //DataRelation r2 = new DataRelation(string.Empty, secondColumns, firstColumns, false); //ds.Relations.Add(r2); //Create columns for return table List<DataColumn> PK = new List<DataColumn>(); for (int i = 0; i < FirstDataTable.Columns.Count; i++) { DataColumn newdc = ResultDataTable.Columns.Add(FirstDataTable.Columns[i].ColumnName, FirstDataTable.Columns[i].DataType); if (FirstDataTable.PrimaryKey.Contains(FirstDataTable.Columns[i])) PK.Add(newdc); } ResultDataTable.PrimaryKey = PK.ToArray(); //If FirstDataTable Row not in SecondDataTable, Add to ResultDataTable. ResultDataTable.BeginLoadData(); foreach (DataRow parentrow in FirstDataTable.Rows) { DataRow[] childrows = parentrow.GetChildRows(r1); if (childrows == null || childrows.Length == 0) ResultDataTable.LoadDataRow(parentrow.ItemArray, true); } ////If SecondDataTable Row not in FirstDataTable, Add to ResultDataTable. //foreach (DataRow parentrow in SecondDataTable.Rows) //{ // DataRow[] childrows = parentrow.GetChildRows(r2); // if (childrows == null || childrows.Length == 0) // ResultDataTable.LoadDataRow(parentrow.ItemArray, true); //} ResultDataTable.EndLoadData(); } return ResultDataTable; }
/// <summary> /// FastReports /// </summary> /// <param name="isDesign"></param> private void FastReports(bool isDesign) { System.Data.DataSet printDataDs = new System.Data.DataSet(); try { int[] rownumber = this.gridViewMainData.GetSelectedRows(); DataRow row = this.gridViewMainData.GetDataRow(rownumber[0]); System.Data.DataTable mainData = ToDataTable(row); System.Data.DataTable detailsData = ((DataView)this.gridViewDetailsData.DataSource).ToTable(); if (mainData != null && mainData.Rows.Count > 0) { mainData.TableName = "mainData"; printDataDs.Tables.Add(mainData.Copy()); } if (detailsData != null && detailsData.Rows.Count > 0) { detailsData.TableName = "detailsData"; printDataDs.Tables.Add(detailsData.Copy()); } FastReport.Report report = new FastReport.Report(); Res.LocaleFolder = AppDomain.CurrentDomain.BaseDirectory + "FastReports\\Localization"; Res.LoadLocale(Res.LocaleFolder + @"\Chinese (Simplified).frl"); string FDataTables = "FDataTables"; string filename = @"FastReports\Reports\fx_001.frx"; report.Load(filename); using (Designer designer = new Designer()) { designer.SetModified(this, "EditData"); int i = 0; foreach (DataTable dt in printDataDs.Tables) { FDataTables = "FDataTables" + i.ToString(); printDataDs.Tables[i].TableName = FDataTables; report.RegisterData(printDataDs.Tables[i], FDataTables); report.GetDataSource(FDataTables).Enabled = true; i = i + 1; } Res.LocaleFolder = AppDomain.CurrentDomain.BaseDirectory + "FastReports\\Localization"; Res.LoadLocale(Res.LocaleFolder + @"\Chinese (Simplified).frl"); if (isDesign) { report.Design(); } else { report.SetParameterValue("time", DateTime.Now.Date.ToString("yyyy-MM-dd")); report.Prepare(); report.ShowPrepared(); } } } catch (Exception err) { MessageBox.Show(err.Message); } }
private void BuscarInstancias() { // Retrieve the enumerator instance and then the data. SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance; System.Data.DataTable dt1 = instance.GetDataSources(); dtInstancias = dt1.Copy(); }
private void timer1_Tick(object sender, EventArgs e) { if (dataGridViewTask_UpData && dataGridViewTask.Visible && TaskDb != null) { dataGridViewTask.DataSource = null; dataGridViewTask.DataSource = TaskDb.Copy(); dataGridViewTask_UpData = false; } }
/// <summary> /// ╤тйЩ╬щ╠М╫ЬппеепР /// </summary> /// <param name="dtSort">р╙еепР╣д╠М</param> /// <param name="ColName">еепРвж╤нцШ[еепРвж╤нйгвж╥Ш╢╝вж╤нспп╖]</param> /// <param name="Asc">иЩпР</param> public static void Sort(ref System.Data.DataTable dtSort, string ColName, bool Asc) { string IndexColName = "___Index___"; System.Data.DataTable dtTmp = dtSort.Copy(); dtTmp.Columns.Add(IndexColName, typeof(int)); int MaxLen = 1; //х║еепРвж╤нё╛вН╢СйЩ╬щЁ╓╤х╡╒гриХжцппкВрЩ for (int i = 0; i < dtTmp.Rows.Count; i++) { dtTmp.Rows[i][IndexColName] = i; if (dtTmp.Rows[i][ColName].ToString().Length > MaxLen) { MaxLen = dtTmp.Rows[i][ColName].ToString().Length; } } //╫╚еепРвж╤н╟╢ср╤тфКё╛вС╠ъ╡╧0 for (int i = 0; i < dtTmp.Rows.Count; i++) { dtTmp.Rows[i][ColName] = dtTmp.Rows[i][ColName].ToString().PadRight(MaxLen, '0'); } //╡Ия╞ DataRow[] Rows; if (Asc) { Rows = dtTmp.Select("", string.Format("{0} Asc", ColName)); } else { Rows = dtTmp.Select("", string.Format("{0} Desc", ColName)); } System.Data.DataTable dtTmp2 = dtSort.Copy(); dtSort.Rows.Clear(); for (int i = 0; i < Rows.Length; i++) { dtSort.Rows.Add(dtTmp2.Rows[Convert.ToInt32(Rows[i][IndexColName])].ItemArray); } }
public string GetExcelXml(System.Data.DataTable dtInput, string filename) { var excelTemplate = getWorkbookTemplate(); var ds = new DataSet(); ds.Tables.Add(dtInput.Copy()); var worksheets = getWorksheets(ds); var excelXml = string.Format(excelTemplate, worksheets); return(excelXml); }
private void btn_Export_Click(object sender, EventArgs e) { load_Progressbar.Start_progres(); dtcopy_export = dtuser.Copy(); ds.Tables.Add(dtcopy_export); Convert_Dataset_to_Excel(); //Grid_Export_Data(); }
private DataTable DisposeTask(System.Data.DataTable dtTask) { try { DataTable dtNew = dtTask.Copy(); dtNew.Columns.Add("StatusName", System.Type.GetType("System.String")); dtNew.Columns.Add("ImportantName"); dtNew.Columns.Add("Master"); EntityData entityUser = new EntityData("TaskPerson"); for (int i = 0; i < dtNew.Rows.Count; i++) { dtNew.Rows[i]["ImportantName"] = (dtNew.Rows[i]["ImportantLevel"] == System.DBNull.Value)?"":ComSource.GetImportantName(dtNew.Rows[i]["ImportantLevel"].ToString()); entityUser = WBSDAO.GetTaskPersonByWBSCode(dtNew.Rows[i]["WBSCode"].ToString()); string strTUser = ""; // 取得当前任务负责人 for (int j = 0; j < entityUser.CurrentTable.Rows.Count; j++) { if (entityUser.CurrentTable.Rows[j]["Type"].ToString() == "2") // 负责 { strTUser += (strTUser == "")?"":","; strTUser = BLL.SystemRule.GetUserName(entityUser.CurrentTable.Rows[j]["UserCode"].ToString()); } } dtNew.Rows[i]["Master"] = strTUser; string strTxt = this.GetStatusImg(dtNew.Rows[i]["Status"].ToString()) + " " + dtNew.Rows[i]["SortID"].ToString() + " " + dtNew.Rows[i]["TaskName"].ToString(); // 此处只有负责人可以更改状态,所以此处负责人拥有子项的权限,不必再次判断权限 // string strTUsers = ""; // string strTUserNames = ""; // string strTStations = ""; // string strTStationNames = ""; // BLL.ResourceRule.GetAccessRange(dtNew.Rows[i]["WBSCode"].ToString(),"0701","070107",ref strTUsers,ref strTUserNames,ref strTStations,ref strTStationNames); // bool isIN = false; // string strBuildStations = base.user.BuildStationCodes(); // foreach(string str in strBuildStations.Split(',')) // { // if(strTStations.IndexOf(str)>-1) // { // isIN = true;break; // } // } // if(strTUsers.IndexOf(base.user.UserCode)<0&&!isIN) // 无权 // dtNew.Rows[i]["StatusName"] = strTxt; // else dtNew.Rows[i]["StatusName"] = "<a href=\"javascript:OpenTask('" + dtNew.Rows[i]["WBSCode"].ToString() + "');\">" + strTxt + "</a>"; } entityUser.Dispose(); return(dtNew); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); return(null); } }
//******************EndWithHalter********************* //*********************WithOutHalter********************* public System.Data.DataTable GetForceOnPole(System.Data.DataTable dtPoleForce, double SaftyFactor, double SaftyFactorOburi) { System.Data.DataTable dtResult = dtPoleForce.Copy(); System.Data.DataTable dtPower = Atend.Base.Calculating.CPower.AccessSelect(); System.Data.DataColumn dcPowerWithSaftyFactor = new System.Data.DataColumn("PowerWithSaftyFactor"); dtPower.Columns.Add(dcPowerWithSaftyFactor); //foreach (DataRow dr in dtPower.Rows) //{ // dr["PowerWithSaftyFactor"] = Convert.ToDouble(dr["Power"].ToString()) * SaftyFactor; //} System.Data.DataColumn dcPower = new System.Data.DataColumn("DcPower"); System.Data.DataColumn dcCount = new System.Data.DataColumn("DcCount"); dtResult.Columns.Add(dcPower); dtResult.Columns.Add(dcCount); ed.WriteMessage("dtPower.Rows.Count={0}\n", dtPower.Rows.Count); if (dtPower.Rows.Count > 0) { foreach (DataRow drPoleForce in dtResult.Rows) { double MaxForce = GetForceOnPole(drPoleForce); //Convert.ToDouble(drPoleForce["DcNorm"].ToString()); //if (Convert.ToDouble(drPoleForce["DcIceHeavy"].ToString()) > MaxForce) //{ // MaxForce = Convert.ToDouble(drPoleForce["DcIceHeavy"].ToString()); //} //if (Convert.ToDouble(drPoleForce["DcWindSpeed"].ToString()) > MaxForce) //{ // MaxForce = Convert.ToDouble(drPoleForce["DcWindSpeed"].ToString()); //} //if (Convert.ToDouble(drPoleForce["DcMaxTemp"].ToString()) > MaxForce) //{ // MaxForce = Convert.ToDouble(drPoleForce["DcMaxTemp"].ToString()); //} //if (Convert.ToDouble(drPoleForce["DcMinTemp"].ToString()) > MaxForce) //{ // MaxForce = Convert.ToDouble(drPoleForce["DcMinTemp"].ToString()); //} //if (Convert.ToDouble(drPoleForce["DcWindIce"].ToString()) > MaxForce) //{ // MaxForce = Convert.ToDouble(drPoleForce["DcWindIce"].ToString()); //} ed.WriteMessage("****MaxForce={0}\n", MaxForce); DataRow drResult = GetPower(MaxForce, dtPower, drPoleForce, SaftyFactor, SaftyFactorOburi); drPoleForce["DcPower"] = drResult["DcPower"].ToString(); drPoleForce["DcCount"] = drResult["DcCount"].ToString(); } } return(dtResult); }
private void OnSubmit(object sender, EventArgs e)//提交代码处理 { try { System.Data.DataTable temp_dt = dt_fault.Copy(); for (int index = 0; index < dt_fault.Rows.Count; index++) { string str_fault = dt_fault.Rows[index]["故障"] as string; for (int i = 0; i < dt_symptom.Rows.Count; i++) { if (matrix[i, index] == 1)//规则1必要性检测 { if ((bool)dt_symptom.Rows[i]["isChecked"] == false) { DataRow[] rows = temp_dt.Select("故障='" + str_fault + "'"); if (rows.Count() == 1) { temp_dt.Rows.Remove(rows[0]); continue; } else if (rows.Count() > 1) { throw new Exception("故障名称重复"); } } } if (matrix[i, index] == -1)//规则3充分性检测 { if ((bool)dt_symptom.Rows[i]["isChecked"] == true) { DataRow[] rows = temp_dt.Select("故障='" + str_fault + "'"); if (rows.Count() == 1) { temp_dt.Rows.Remove(rows[0]); continue; } else if (rows.Count() > 1) { throw new Exception("故障名称重复"); } } } } } dataResult.DataSource = temp_dt; // temp_dt.Rows. } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public System.Data.DataTable AddTableColumnValue(System.Data.DataTable dt, params string[] cols) { if (dt == null || cols == null || cols.Length == 0) { return(dt); } DataTable tmptable = dt.Copy(); List <string> tags = null; foreach (string tagcol in cols) { tags = new List <string>(); if (tmptable.Columns[tagcol] == null) { continue; } for (int i = 0; i < tmptable.Rows.Count; i++) { if (tmptable.Rows[i][tagcol].ToString() == "") { continue; } tags.Add(tmptable.Rows[i][tagcol].ToString()); } if (tags.Count == 0) { continue; } Dictionary <string, object> values = GetValues(tags.ToArray()); string tmptagname = ""; tmptable.Columns.Add(tagcol + "VALUE"); for (int i = 0; i < tmptable.Rows.Count; i++) { tmptagname = tmptable.Rows[i][tagcol].ToString(); if (values[tmptagname] != null) { tmptable.Rows[i][tagcol + "VALUE"] = values[tmptagname]; } } } return(tmptable); }
/// <summary> /// 导入Bom单主表资料 /// </summary> /// <param name="values"></param> private void ImportBom(System.Array values) { int len1 = values.GetLength(0); int len2 = values.GetLength(1); DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet dsBom = myHelper.GetDs("select * from t_Bom"); System.Data.DataTable dt = dsBom.Tables[0]; System.Data.DataTable dtTmp = dt.Copy(); dt.Columns["F_BillID"].Unique = true; string strID; try { for (int i = 1; i < len1; i++) { strID = values.GetValue(i, 1).ToString(); if (strID.Length == 0) { continue; } if (dt.Select("F_BillID = '" + strID + "'").Length > 0) { MessageBox.Show(this, "数据库已存在编码为'" + strID + "'的BOM单号,请检查待导入Excel文件!", "提示"); break; } DataRow drNew = dsBom.Tables[0].NewRow(); drNew["F_BillID"] = values.GetValue(i, 1).ToString(); if (values.GetValue(i, 2).ToString().Length == 0) { drNew["F_Date"] = "1900-1-1"; } else { drNew["F_Date"] = values.GetValue(i, 2).ToString(); } drNew["F_ItemID"] = values.GetValue(i, 3).ToString(); drNew["F_Remark"] = values.GetValue(i, 4).ToString(); dsBom.Tables[0].Rows.Add(drNew); } myHelper.SaveData(dsBom, "select * from t_Bom"); } catch (Exception E) { MessageBox.Show(this, E.Message, "错误"); } }
private bool DataTablePrinterWithOutModel(System.Data.DataTable dt, System.Collections.Generic.Dictionary <string, string> titles) { bool result; if (dt == null) { result = false; } else { System.Data.DataTable dataTable = dt.Copy(); if (titles != null && titles.Count > 0) { System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>(); for (int i = 0; i < dataTable.Columns.Count; i++) { if (titles.ContainsKey(dataTable.Columns[i].ColumnName.ToUpper())) { dataTable.Columns[i].ColumnName = titles[dataTable.Columns[i].ColumnName].ToString(); } else { list.Add(dataTable.Columns[i].ColumnName); } } foreach (string current in list) { dataTable.Columns.Remove(current); } } Range range = null; Range range2 = this.GetRange(out range); for (int i = 1; i <= dataTable.Columns.Count; i++) { this.sheet.Cells[2, i] = dataTable.Columns[i - 1].Caption; } int num = 3; for (int j = 0; j < dataTable.Rows.Count; j++) { DataRow dataRow = dataTable.Rows[j]; for (int i = 0; i < dataTable.Columns.Count; i++) { this.sheet.Cells[num, i + 1] = dataRow[i].ToString(); } num++; } result = true; } return(result); }
private void LoadExistingPO(string poCode) { DataTable dt = dalData.POSelectWithSizeAndType(); loadLocationData(dt_CustomerList, cmbCustomer, dalData.FullName); foreach (DataRow row in dt.Rows) { if (poCode == row[dalData.POCode].ToString()) { cmbCustomer.Text = row[dalData.FullName].ToString(); dtpPODate.Text = row[dalData.PODate].ToString(); txtPONo.Text = row[dalData.PONo].ToString(); txtAddress1.Text = row[dalData.Address1].ToString(); txtAddress2.Text = row[dalData.Address2].ToString(); txtCity.Text = row[dalData.AddressCity].ToString(); txtState.Text = row[dalData.AddressState].ToString(); txtCountry.Text = row[dalData.AddressCountry].ToString(); txtPostalCode.Text = row[dalData.AddressPostalCode].ToString(); DataRow dt_Row = dt_OrderList.NewRow(); dt_Row[header_TblCode] = row[dalData.TableCode]; dt_Row[header_DataMode] = text_ToEdit; dt_Row[header_Size] = row[dalData.SizeNumerator]; dt_Row[header_Unit] = row[dalData.SizeUnit].ToString().ToUpper(); dt_Row[header_Code] = row[dalData.ItemCode]; dt_Row[header_Type] = row[dalData.TypeName]; dt_Row[header_OrderQty] = row[dalData.POQty]; dt_Row[header_Note] = row[dalData.PONote]; dt_OrderList.Rows.Add(dt_Row); } } dt_OrderList = AddTypeDivideSpace(dt_OrderList); AddIndexToOrderTable(); dgvPOItemList.DataSource = dt_OrderList; if (poEditing) { dt_OriginalToEditList = dt_OrderList.Copy(); } DgvUIEdit(dgvPOItemList); dgvPOItemList.ClearSelection(); }
private async void Form3_LoadAsync(object sender, EventArgs e) { string path = Directory.GetCurrentDirectory() + "\\MASTER-EXPORT.csv"; DataTable dt = new DataTable(); dt = NewDataTable(path, ",", false); dataGridView1.DataSource = dt.Copy(); //await PutTaskDelay(); //await PutTaskDelay(); //button3.PerformClick(); }
public void insertperidword(string bookmark1, System.Data.DataTable dt) //老炼周期表格的插入 { object oStart1 = bookmark1; wordApp.ActiveDocument.Bookmarks.get_Item(ref oStart1).Select(); if (dt.Rows.Count != 0) { wordApp.Selection.InsertRowsBelow(dt.Rows.Count); } wordApp.ActiveDocument.Bookmarks.get_Item(ref oStart1).Select(); int b = (int)(wordApp.Selection.get_Information(WdInformation.wdEndOfRangeRowNumber)); Microsoft.Office.Interop.Word.Table table = wordDoc.Content.Tables[1]; System.Data.DataTable dtcut = dt.Copy(); dtcut.Columns.Remove("剩余时间"); for (int i = 0; i < dtcut.Columns.Count; i++) { for (int j = 0; j < dtcut.Rows.Count; j++) { table.Cell(j + b + 1, i + 1).Range.Text = dtcut.Rows[j][i].ToString(); } } int tempflag = 0; for (int i = 0; i < dtcut.Rows.Count - 1; i++) { string str1 = table.Cell(i + b + 1, 0).Range.Text.ToString(); for (int j = i + 1; j < dtcut.Rows.Count; j++) { string str2 = table.Cell(j + b + 1, 0).Range.Text.ToString(); if (str1 == str2) { tempflag = j; } else { break; } } for (int k = i; k < tempflag; k++) { table.Cell(k + b + 1, 0).Range.Text = ""; } table.Cell(i + b + 1, 0).Merge(table.Cell(tempflag + b + 1, 0)); i = tempflag; } }
private void button9_Click(object sender, EventArgs e) { dataGridView5.DataSource = dtAll.Copy(); for (int x = 0; x < dataGridView5.Rows.Count - 1;) { // MessageBox.Show(dataGridView1.Rows[x].Cells[0].Value.ToString()); if (!dataGridView5.Rows[x].Cells[0].Value.ToString().StartsWith("DE")) { dataGridView5.Rows.RemoveAt(x); } else { x++; } } }
private void InitialFormData() { string sql = null; System.Data.DataTable dt = null; System.Data.DataTable dtcpy = null; DataRow dr = null; sql = "select po_code,po_code + ' ' + po_date as po_desc from purchase_po_master where status > 0 order by po_code"; dt = TJSystem.Public.PublicStatic.db.GetDataTable(sql); dr = dt.NewRow(); dr[0] = ""; dr[1] = ""; dt.Rows.InsertAt(dr, 0); dtcpy = dt.Copy(); this.priComboBox2.DataSource = dtcpy.DefaultView; this.priComboBox2.ValueMember = "po_code"; this.priComboBox2.DisplayMember = "po_desc"; }
public void insertrow(string bookmark1, System.Data.DataTable dt) { object oStart1 = bookmark1; wordApp.ActiveDocument.Bookmarks.get_Item(ref oStart1).Select(); if (dt.Rows.Count != 0) { wordApp.Selection.InsertRowsBelow(dt.Rows.Count); } wordApp.ActiveDocument.Bookmarks.get_Item(ref oStart1).Select(); int b = (int)(wordApp.Selection.get_Information(WdInformation.wdEndOfRangeRowNumber)); Microsoft.Office.Interop.Word.Table table = wordDoc.Content.Tables[1]; System.Data.DataTable dtcut = dt.Copy(); dtcut.Columns.Remove("资源测试通道"); for (int i = 0; i < dtcut.Columns.Count; i++) { for (int j = 0; j < dtcut.Rows.Count; j++) { table.Cell(j + b + 1, 1).Range.Text = (j + 1).ToString(); table.Cell(j + b + 1, i + 2).Range.Text = dtcut.Rows[j][i].ToString(); } } if (bookmark1 == "IOOut" || bookmark1 == "IOIn" || bookmark1 == "DA" || bookmark1 == "AD") { for (int i = 0; i < dtcut.Columns.Count - 1; i++) { for (int j = 0; j < dtcut.Rows.Count; j = j + 2) { string str1 = table.Cell(j + b + 1, i + 2).Range.Text.ToString(); string str2 = table.Cell(j + b + 2, i + 2).Range.Text.ToString(); if (str1 == str2) { table.Cell(j + b + 1, i + 2).Range.Text = ""; table.Cell(j + b + 1, i + 2).Merge(table.Cell(j + b + 2, i + 2)); } } } } }