Copy() public method

public Copy ( ) : DataTable
return DataTable
Beispiel #1
0
        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;
         }
     }
 }
Beispiel #3
0
        /// <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);
        }
Beispiel #4
0
 /// <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;
        }
Beispiel #6
0
            /// <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();
        }
Beispiel #10
0
        /// <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;
            }
        }
Beispiel #11
0
        /// <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();
        }
Beispiel #17
0
        public void SerializePart( DataTable data )
        {
            // TODO: ТОЛЬКО ДЛЯ ТЕСТИРОВАНИЯ. УБРАТЬ!
            // data.TableName += Guid.NewGuid().ToString();

            ResultDataSet.Tables.Add( data.Copy() );
        }
Beispiel #18
0
 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()) + "&nbsp;&nbsp;" + dtNew.Rows[i]["SortID"].ToString() + "&nbsp;&nbsp;" + dtNew.Rows[i]["TaskName"].ToString();
         }
         return(dtNew);
     }
     catch (Exception ex)
     {
         ApplicationLog.WriteLog(this.ToString(), ex, "");
         return(null);
     }
 }
Beispiel #19
0
 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);
     }
 }
Beispiel #20
0
 //////////////////////////////////////////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();
 }
Beispiel #21
0
        /// <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); }
        }
Beispiel #22
0
        // 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();
        }
Beispiel #24
0
 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;
 }
Beispiel #25
0
 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);
         }
     }
 }
Beispiel #28
0
        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;
 }
Beispiel #30
0
        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);
        }
Beispiel #31
0
        /// <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);
        }
Beispiel #32
0
        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);
            }
        }
Beispiel #33
0
 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())+"&nbsp;&nbsp;"+dtNew.Rows[i]["SortID"].ToString()+"&nbsp;&nbsp;"+BLL.StringRule.TruncText(dtNew.Rows[i]["TaskName"].ToString(),15);
             dtNew.Rows[i]["PicName"] = this.GetStatusImg(dtNew.Rows[i]["Status"].ToString()) + "&nbsp;&nbsp;" + "&nbsp;&nbsp;" + BLL.StringRule.TruncText(dtNew.Rows[i]["TaskName"].ToString(), 15);
         }
         return(dtNew);
     }
     catch (Exception ex)
     {
         ApplicationLog.WriteLog(this.ToString(), ex, "");
         return(null);
     }
 }
Beispiel #34
0
        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;
        }
Beispiel #35
0
 public ServicosEstadia(DataTable t)
 {
     _tabela = new DataTable();
     _tabela = t.Copy();
     _tabela.PrimaryKey = null;
     _tabela.Columns.Remove("id");
     _tabela.Columns.Remove("data");
 }
Beispiel #36
0
        public Fuzzification(List<Description> descriptions, DataTable data)
        {
            m_Descriptions = descriptions;
            m_Data = data;
            result = new Dictionary<string, List<ValueItem>>();

            m_ResultData = m_Data.Copy();
        }
Beispiel #37
0
 public void AddResults(DataTable dt)
 {
     _results = dt.Copy();
     //foreach(DataRow dr in dt.Rows)
     //{
     //    _results.ImportRow(dr);
     //}
 }
Beispiel #38
0
        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);
            }
        }
Beispiel #44
0
        private void BuscarInstancias()
        {
            // Retrieve the enumerator instance and then the data.
            SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;

            System.Data.DataTable dt1 = instance.GetDataSources();

            dtInstancias = dt1.Copy();
        }
Beispiel #45
0
 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);
            }
        }
Beispiel #47
0
        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);
        }
Beispiel #48
0
        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();
        }
Beispiel #49
0
        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()) + "&nbsp;&nbsp;" + dtNew.Rows[i]["SortID"].ToString() + "&nbsp;&nbsp;" + 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);
            }
        }
Beispiel #50
0
        //******************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);
        }
Beispiel #51
0
 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);
     }
 }
Beispiel #52
0
        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);
        }
Beispiel #53
0
        /// <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, "错误");
            }
        }
Beispiel #54
0
        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);
        }
Beispiel #55
0
        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();
        }
Beispiel #56
0
        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();
        }
Beispiel #57
0
        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;
            }
        }
Beispiel #58
0
 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++;
         }
     }
 }
Beispiel #59
0
        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";
        }
Beispiel #60
0
        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));
                        }
                    }
                }
            }
        }