AcceptChanges() public method

Commits all the changes made to this table since the last time was called.
public AcceptChanges ( ) : void
return void
Beispiel #1
1
		public void GetReady ()
		{
			dataTable = new DataTable ("itemTable");
			dc1 = new DataColumn ("itemId");
			dc2 = new DataColumn ("itemName");
			dc3 = new DataColumn ("itemPrice");
			dc4 = new DataColumn ("itemCategory");
			
			dataTable.Columns.Add (dc1);
			dataTable.Columns.Add (dc2);
			dataTable.Columns.Add (dc3);
			dataTable.Columns.Add (dc4);
			DataRow dr;
			seed = 123;
			rowCount = 5;
			rndm = new Random (seed);
			for (int i = 1; i <= rowCount; i++) {
				dr = dataTable.NewRow ();
				dr["itemId"] = "item " + i;
				dr["itemName"] = "name " + rndm.Next ();
				dr["itemPrice"] = "Rs. " + (rndm.Next () % 1000);
				dr["itemCategory"] = "Cat " + ((rndm.Next () % 10) + 1);
				dataTable.Rows.Add (dr);
			}
			dataTable.AcceptChanges ();
			dataView = new DataView (dataTable);
			dataView.ListChanged += new ListChangedEventHandler (OnListChanged);
			listChangedArgs = null;
		}
    public void LoadImgs()
    {
        LoadSelect();

        System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(Request.PhysicalApplicationPath + "\\Images\\avatar");
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("ID"));
        dt.Columns.Add(new DataColumn("Name"));
        dt.AcceptChanges();

        foreach (System.IO.FileInfo file in  dir.GetFiles())
        {
            string ID = file.Name.Replace(file.Extension, "");
            try
            {
                int i = int.Parse(ID);
                DataRow dr = dt.NewRow();
                dr["ID"] = file.Name.Replace(file.Extension, "");
                dr["Name"] = "../../Images/avatar/" + file.Name;
                dt.Rows.Add(dr);
            }
            catch
            {
                continue;
            }
        }

        dt.AcceptChanges();
        dlstImg.DataSource = dt;
        dlstImg.DataBind();
    }
        /// <summary>
        /// Processes the result of a data submission to the Server where the result of that operation is
        /// <see cref="TSubmitChangesResult.scrOK" />. (Overload for DataTables.)
        /// </summary>
        /// <param name="ACallingFormOrUserControl"></param>
        /// <param name="ALocalDT"></param>
        /// <param name="ASubmitDT"></param>
        /// <param name="APetraUtilsObject"></param>
        /// <param name="AVerificationResults"></param>
        /// <param name="ASetPrimaryKeyOnlyMethod"></param>
        /// <param name="AMasterDataTableSaveCall"></param>
        /// <param name="ACalledFromUserControl"></param>
        /// <param name="ACallAcceptChangesOnReturnedDataBeforeMerge"></param>
        public static void ProcessSubmitChangesResultOK(IFrmPetra ACallingFormOrUserControl, DataTable ALocalDT,
            DataTable ASubmitDT, TFrmPetraEditUtils APetraUtilsObject, TVerificationResultCollection AVerificationResults,
            Action <bool>ASetPrimaryKeyOnlyMethod, bool AMasterDataTableSaveCall, bool ACalledFromUserControl,
            bool ACallAcceptChangesOnReturnedDataBeforeMerge = false)
        {
            if (AMasterDataTableSaveCall)
            {
                // Call AcceptChanges to get rid now of any deleted columns before we Merge with the result from the Server
                ALocalDT.AcceptChanges();

                // Merge back with data from the Server (eg. for getting Sequence values)
                if (ACallAcceptChangesOnReturnedDataBeforeMerge)
                {
                    ASubmitDT.AcceptChanges();
                }

                ALocalDT.Merge(ASubmitDT, false);

                // Need to accept any new modification ID's
                ALocalDT.AcceptChanges();

                if (ASetPrimaryKeyOnlyMethod != null)
                {
                    // Ensure the Primary-Key(s)-containing Controls are disabled to prevent further modification of Primary Key values
                    ASetPrimaryKeyOnlyMethod(true);
                }
            }

            CommonPostMergeOperations(ACallingFormOrUserControl, APetraUtilsObject,
                AVerificationResults, ACalledFromUserControl);
        }
Beispiel #4
0
        private void button4_Click(object sender, EventArgs e)
        {
            //Satır Sil butonu


            try
            {
                //Liste güncellenir
                TeklifList = Teklif.teklif_listesi_olustur(dt);

                if (dataGridView1.SelectedRows.Count != 0)
                {
                    foreach (DataGridViewRow row in dataGridView1.SelectedRows)
                    {
                        dataGridView1.Rows.Remove(row);
                    }

                    //Datatable güncellenir
                    dt.AcceptChanges();
                }
                else
                {
                    MessageBox.Show("Lütfen silinecek satırı seçiniz.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (NullReferenceException exception) {
                MessageBox.Show("Satır seçilmedi");
            }
            catch (System.Exception exception)
            {
                MessageBox.Show("Bir hata meydana geldi.ERROR=" + exception.Message);
            }
        }
Beispiel #5
0
        public static DataTable ParseToDataTable(IList<Data.PemeriksaanDetail> srs)
        {
            DataTable deta = new DataTable();

            foreach (PropertyInfo info in typeof(Data.PemeriksaanDetail).GetProperties())
            {
                deta.Columns.Add(info.Name, info.PropertyType);
            }
            deta.AcceptChanges();

            foreach (var i in srs)
            {
                Data.PemeriksaanDetail sr = new Data.PemeriksaanDetail();
                sr = i;
                DataRow row = deta.NewRow();

                foreach (var property in sr.GetType().GetProperties())
                {
                    row[property.Name] = property.GetValue(sr, null);
                }
                deta.Rows.Add(row);
            }

            deta.AcceptChanges();
            return deta;
        }
Beispiel #6
0
        public void Execute(string query, out Object data)
        {
            //execute the query and return data from it
            //i.e. like a select query

            MySqlCommand    cmd = new MySqlCommand(query, _conn);
            MySqlDataReader rdr = cmd.ExecuteReader();

            //tbd....check that rows aren't empty first

            //get the column list
            DataColumnCollection cols = rdr.GetSchemaTable().Columns;
            DataTable            dt   = new System.Data.DataTable();

            for (int i = 0; i < cols.Count; i++)
            {
                dt.Columns.Add(cols[i]);
            }

            dt.AcceptChanges();
            //read the data
            while (rdr.Read())
            {
                //who knows if this works i'm experimenting for now...
                object[] values = null;
                rdr.GetValues(values);
                dt.Rows.Add(values);
                dt.AcceptChanges();
            }
            rdr.Close();
            data = dt;
        }
Beispiel #7
0
        public static System.Data.DataTable AutoFind組込(System.Data.DataTable _dtbSeihin, System.Data.DataTable _dtbBuhin)
        {
            #region 20161223 - BotFjP - 日付と図面番号で 順番
            // DataView _dvSeihin = new DataView(_dtbSeihin);
            _dtbSeihin.DefaultView.Sort = "納期,図面番号";
            _dtbSeihin = _dtbSeihin.DefaultView.ToTable();

            //DataView _dvBuhin = new DataView(_dtbBuhin);
            _dtbBuhin.DefaultView.Sort = "納期,図面番号";
            _dtbBuhin = _dtbBuhin.DefaultView.ToTable();

            for (int i = 0; i < _dtbBuhin.Rows.Count; i++)
            {
                _dtbSeihin.Rows[i]["組込番号"] = _dtbBuhin.Rows[i]["組込番号"].ToString();
            }
            _dtbSeihin.AcceptChanges();
            #endregion

            #region 20161223 - BotFjP - add column 棚番号 注文番号
            _dtbSeihin.Columns.Add("注文番号", typeof(string));
            _dtbSeihin.Columns.Add("棚番号", typeof(string));
            #endregion

            _dtbSeihin.AcceptChanges();
            return(_dtbSeihin);
        }
Beispiel #8
0
        private void btnImport_Click(object sender, EventArgs e)
        {
            System.Data.DataTable dt = new System.Data.DataTable("datable");
            DataSet dsSource         = new DataSet("dataSet");

            dt.Reset();

            Microsoft.Office.Interop.Excel.Workbook    ExWorkbook;
            Microsoft.Office.Interop.Excel.Worksheet   ExWorksheet;
            Microsoft.Office.Interop.Excel.Range       ExRange;
            Microsoft.Office.Interop.Excel.Application Exobj = new Microsoft.Office.Interop.Excel.Application();

            openFileDialog1.Filter = "Excel Files |*.xls;*.xlsx;*.xlsm";
            DialogResult result = openFileDialog1.ShowDialog();

            if (result == DialogResult.OK)//test result
            {
                ExWorkbook  = Exobj.Workbooks.Open(openFileDialog1.FileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                ExWorksheet = (Microsoft.Office.Interop.Excel.Worksheet)ExWorkbook.Sheets.get_Item(1);
                ExRange     = ExWorksheet.UsedRange;

                for (int Cnum = 1; Cnum <= ExRange.Columns.Count; Cnum++)
                {
                    dt.Columns.Add(new DataColumn((ExRange.Cells[1, Cnum] as Microsoft.Office.Interop.Excel.Range).Value2.ToString()));
                }
                dt.AcceptChanges();

                string[] columnNames = new string[dt.Columns.Count];
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    columnNames[0] = dt.Columns[i].ColumnName;
                }
                for (int Rnum = 2; Rnum <= ExRange.Rows.Count; Rnum++)
                {
                    DataRow dr = dt.NewRow();
                    for (int Cnum = 1; Cnum <= ExRange.Columns.Count; Cnum++)
                    {
                        if ((ExRange.Cells[Rnum, Cnum] as Microsoft.Office.Interop.Excel.Range).Value2 != null)
                        {
                            dr[Cnum - 1] = (ExRange.Cells[Rnum, Cnum] as Microsoft.Office.Interop.Excel.Range).Value2.ToString();
                        }
                        dt.Rows.Add(dr);
                        dt.AcceptChanges();
                    }
                }

                ExWorkbook.Close(true, Missing.Value, Missing.Value);
                Exobj.Quit();
                dataGridView1.DataSource = dt;
            }
        }
        private System.Data.DataTable GetDataTable(IEnumerable list)
        {
            System.Data.DataTable dt = new System.Data.DataTable();
            bool schemaIsBuild       = false;

            PropertyInfo[] props = null;

            foreach (object item in list)
            {
                if (!schemaIsBuild)
                {
                    props = item.GetType().GetProperties();
                    foreach (var pi in props)
                    {
                        dt.Columns.Add(new DataColumn(pi.Name, pi.PropertyType));
                    }
                }

                schemaIsBuild = true;

                var row = dt.NewRow();
                foreach (var pi in props)
                {
                    row[pi.Name] = pi.GetValue(item, null);
                }
                dt.Rows.Add(row);
                dt.AcceptChanges();
            }
            return(dt);
        }
Beispiel #10
0
        public static void Load_ListDS()
        {
            if (File.Exists(m_MySensors_FilePath))
              {
            SensorDS = new DataSet("SensorDS");
            SensorDS.ReadXml(m_MySensors_FilePath, XmlReadMode.ReadSchema);
              }
              else
              {
            if (SensorDS != null)
            {
              SensorDS.Dispose();
              GC.Collect();
            }
            DataTable dt0 = new DataTable("SensorTBL");
            dt0.Columns.Add(new DataColumn(Cfg.C_IS_PICK, Type.GetType(Cfg.SYS_INT32)));
            dt0.Columns[Cfg.C_IS_PICK].DefaultValue = 1;

            dt0.Columns.Add(new DataColumn(Sensor.C_SENSOR_ID, Type.GetType(Cfg.SYS_INT64)));
            dt0.Columns[Sensor.C_SENSOR_ID].DefaultValue = Sensor.Sensor_ID;

            dt0.Columns.Add(new DataColumn(Sensor.C_LOCATION_NAME, Type.GetType(Cfg.SYS_STRING)));
            dt0.Columns[Sensor.C_LOCATION_NAME].DefaultValue = Sensor.Location_Name;

            dt0.Rows.Add(dt0.NewRow());
            dt0.AcceptChanges();
            SensorDS = new DataSet("SensorDS");
            SensorDS.Tables.Add(dt0);
            SensorDS.AcceptChanges();
              }
              SensorDS.Tables[0].DefaultView.Sort = Sensor.C_SENSOR_ID;
        }
Beispiel #11
0
 private DataSet GetLookupValuesFromDatabase()
 {
     DataSet ds = new DataSet();
     DataTable dt = new DataTable();
     DataColumn idCol = new DataColumn("ID", typeof(int));
     DataColumn nameCol = new DataColumn("Name", typeof(string));
     dt.Columns.Add(idCol);
     dt.Columns.Add(nameCol);
     dt.AcceptChanges();
     DataRow newRow = null;
     newRow = dt.NewRow();
     newRow[idCol] = 1;
     newRow[nameCol] = "Joe Bloggs ID#1";
     dt.Rows.Add(newRow);
     newRow = dt.NewRow();
     newRow[idCol] = 2;
     newRow[nameCol] = "Mr A. Nonymous ID#2";
     dt.Rows.Add(newRow);
     newRow = dt.NewRow();
     newRow[idCol] = 3;
     newRow[nameCol] = "Mrs N. Extdoorneighbour ID#3";
     dt.Rows.Add(newRow);
     newRow = dt.NewRow();
     newRow[idCol] = 4;
     newRow[nameCol] = "Mr. Pea Body ID#4";
     dt.Rows.Add(newRow);
     ds.Tables.Add(dt);
     ds.AcceptChanges();
     return ds;
 }
Beispiel #12
0
        public static DataTable GetTableFromCSVTextFile (String TextFileName, String TableName, char Delimitter)
            {
            DataTable CSVTable = new DataTable (TableName);

            StreamReader CSVReader = new StreamReader (TextFileName, Encoding.UTF7);
            String OriginalHeadLine = CSVReader.ReadLine ();
            String HeadLine = OriginalHeadLine.Replace ("  ", "");
            String [] CSVCols = HeadLine.Split (Delimitter);

            int ActuallIndex = 0;
            foreach (String ColumnName in CSVCols)
                {
                CSVTable.Columns.Add (ColumnName, typeof (System.String));
                }
            while (CSVReader.Peek () != null)
                {
                String ContentLine = CSVReader.ReadLine ();
                if (ContentLine == null)
                    break;
                String [] CSVContent = ContentLine.Split (Delimitter);
                DataRow NewRow = CSVTable.NewRow ();
                int ColIndex = 0;
                foreach (String Content in CSVContent)
                    {
                    NewRow [ColIndex++] = Content;
                    }
                CSVTable.Rows.Add (NewRow);
                }
            CSVReader.Close ();
            CSVTable.AcceptChanges ();
            return CSVTable;
            }
Beispiel #13
0
 public static void AddRowTableDetail(ref DataTable dtResultDetail, string TestData_ID, int Patient_ID, int Test_ID)
 {
     try
     {
         DataRow dr = dtResultDetail.NewRow();
         DataRow drStandardTest = Utility.GetDataRow(PreloadedLists.StandardTest, LStandardTest.Columns.TestDataId,
                                                     TestData_ID);
         dr[TResultDetail.Columns.TestDetailId] = -1;
         dr[TResultDetail.Columns.ParaName] = drStandardTest[LStandardTest.Columns.DataName];
         dr[TResultDetail.Columns.NormalLevel] = drStandardTest[LStandardTest.Columns.NormalLevel];
         dr[TResultDetail.Columns.NormalLevelW] = drStandardTest[LStandardTest.Columns.NormalLevelW];
         dr[TResultDetail.Columns.DataSequence] = drStandardTest[LStandardTest.Columns.DataSequence];
         dr[TResultDetail.Columns.PrintData] = drStandardTest[LStandardTest.Columns.DataPrint];
         dr[TResultDetail.Columns.MeasureUnit] = drStandardTest[LStandardTest.Columns.MeasureUnit];
         dr[TResultDetail.Columns.TestDataId] = drStandardTest[LStandardTest.Columns.TestDataId];
         dr[TResultDetail.Columns.PatientId] = Patient_ID;
         dr[TResultDetail.Columns.TestTypeId] = drStandardTest[LStandardTest.Columns.TestTypeId]; ;
         dr[TResultDetail.Columns.TestId] = Test_ID;
         dtResultDetail.Rows.Add(dr);
         dtResultDetail.AcceptChanges();
     }
     catch (Exception ex)
     {
         Utility.ShowMsg(ex.Message);
     }
 }
Beispiel #14
0
        protected System.Data.DataTable GetDataFromGrid2()
        {
            System.Data.DataTable dt = new System.Data.DataTable();
            #region
            dt.Columns.Add("GOODNAME");
            dt.Columns.Add("GOODGUIGE");
            dt.Columns.Add("GOODNUM");
            dt.Columns.Add("GOODDANWEI");
            dt.Columns.Add("GOODPRICE");
            dt.Columns.Add("GOODMONEY");
            #endregion
            for (int i = 0; i < Repeater2.Items.Count; i++)
            {
                RepeaterItem rItem  = Repeater2.Items[i];
                DataRow      newRow = dt.NewRow();
                newRow[0] = ((HtmlInputText)rItem.FindControl("goodsname2")).Value.Trim();
                newRow[1] = ((HtmlInputText)rItem.FindControl("goodsguige2")).Value.Trim();
                newRow[2] = ((HtmlInputText)rItem.FindControl("goodsnum2")).Value.Trim();
                newRow[3] = ((HtmlInputText)rItem.FindControl("goodsdanwei2")).Value.Trim();
                newRow[4] = ((HtmlInputText)rItem.FindControl("goodsprice2")).Value.Trim();
                newRow[5] = ((HtmlInputText)rItem.FindControl("moneyone2")).Value.Trim();
                dt.Rows.Add(newRow);
            }
            for (int i = Repeater2.Items.Count; i < 3; i++)
            {
                DataRow newRow = dt.NewRow();

                dt.Rows.Add(newRow);
            }
            dt.AcceptChanges();
            return(dt);
        }
Beispiel #15
0
 protected void btnSaveChanges_Click(object sender, EventArgs e)
 {
     using (System.Data.DataTable xmlData = Lib.Blok.GetXmlData())
     {
         foreach (GridViewRow item in dataGrid1.Rows)
         {
             switch (((CheckBox)item.Cells[0].FindControl("chkSelected")).Checked)
             {
             case true:
                 xmlData.DefaultView.RowFilter      = "";
                 xmlData.DefaultView.RowFilter      = "ID=" + BAYMYO.UI.Converts.NullToInt32(dataGrid1.DataKeys[item.RowIndex]["ID"]);
                 xmlData.DefaultView[0]["Sira"]     = BAYMYO.UI.Converts.NullToInt16(((DropDownList)item.FindControl("ddlSira")).SelectedValue);
                 xmlData.DefaultView[0]["Yer"]      = ((DropDownList)item.FindControl("ddlYer")).SelectedValue;
                 xmlData.DefaultView[0]["Dil"]      = ((DropDownList)item.FindControl("ddlDil")).SelectedValue;
                 xmlData.DefaultView[0]["TumDil"]   = ((CheckBox)item.FindControl("chkTumDil")).Checked;
                 xmlData.DefaultView[0]["TumSayfa"] = ((CheckBox)item.FindControl("chkTumSayfa")).Checked;
                 xmlData.DefaultView[0]["Aktif"]    = ((CheckBox)item.FindControl("chkAktif")).Checked;
                 break;
             }
         }
         xmlData.AcceptChanges();
         xmlData.WriteXml(Server.MapPath(Lib.Blok.XmlPath));
         infoLiteral.Text = "Tablo üzerindeki değişiklikler başarılı bir şekilde kaydedildi!";
     }
 }
Beispiel #16
0
 void CustomizeControl1_RemoveClick(SortedDictionary <string, Control> controls)
 {
     try
     {
         if (!string.IsNullOrEmpty(Request.QueryString["bid"]))
         {
             using (System.Data.DataTable xmlData = Lib.Blok.GetXmlData())
             {
                 xmlData.DefaultView.RowFilter = "";
                 xmlData.DefaultView.RowFilter = "ID=" + Request.QueryString["bid"];
                 if (xmlData.DefaultView.Count > 0)
                 {
                     switch (Request.QueryString["type"])
                     {
                     case "html":
                         FileIO.Remove(Server.MapPath(Lib.Blok.HtmlPath) + xmlData.DefaultView[0]["Adi"]);
                         break;
                     }
                     xmlData.DefaultView[0].Delete();
                     xmlData.AcceptChanges();
                     xmlData.WriteXml(Server.MapPath(Lib.Blok.XmlPath));
                     ScriptManager.RegisterStartupScript(Page, typeof(Page), "x", "alert('Silme işleminiz başarılı bir şekilde tamamlandı!');", true);
                     Response.Redirect(Settings.PanelPath + "?go=blok&type=" + Request.QueryString["type"], false);
                 }
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 void FormDetailTVP(ref DataTable Dt)
 {
     DataColumn CHKD_ProcessId = Dt.Columns.Add("CHKD_ProcessId", typeof(String));
     DataColumn CHKD_RowId = Dt.Columns.Add("CHKD_RowId", typeof(Int32));
     DataColumn CHKD_Checked = Dt.Columns.Add("CHKD_Checked", typeof(Boolean));
     Dt.AcceptChanges();
 }
Beispiel #18
0
 private void FillTable()
 {
     dataTable1.Rows.Add(new object[] { "Ann", "Washington", 30 });
     dataTable1.Rows.Add(new object[] { "Bill", "New York", 40 });
     dataTable1.Rows.Add(new object[] { "Clive", "New York", 50 });
     dataTable1.AcceptChanges();
 }
        /// <summary>
        /// Transtorms list into JSON string accepted by http://d3js.org/ charts
        /// </summary>
        /// <param name="chartData"></param>
        /// <returns></returns>
        public static string ToChartJson(this List<StatsdChartData> chartData)
        {
            var table = new DataTable("Nodes");
            table.Columns.Add("date");
            var rows = new Dictionary<DateTime, DataRow>();

            foreach (var chart in chartData)
            {
                table.Columns.Add(string.Format("chart{0}", chartData.IndexOf(chart)+1));
            }

            foreach (var chart in chartData)
            {
                foreach (var dataPoint in chart.DataPoints)
                {
                    if (!rows.ContainsKey(dataPoint.UtcTime)) {
                        var row = table.NewRow();
                        row["date"] = dataPoint.UtcTime;
                        rows.Add(dataPoint.UtcTime, row);
                    }
                    rows[dataPoint.UtcTime][string.Format("chart{0}", chartData.IndexOf(chart) + 1)] = dataPoint.Value;
                }
            }

            foreach (var row in rows) {
                table.Rows.Add(row.Value);
            }
            table.AcceptChanges();

            DataSet ds = new DataSet();
            ds.Tables.Add(table);

            return JsonConvert.SerializeObject(ds, Formatting.None);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sql">构建表结构的sql</param>
        /// <param name="dt">数据集</param>
        /// <param name="sqlconnnection">数据库连接字符串</param>
        /// <returns></returns>
        public static bool ExecuteSave(string sqlconnnection, string sql, DataTable dt)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandTimeout = 300;
            SqlConnection conn = new SqlConnection(sqlconnnection);
            ConnOpen(conn);
            try
            {
                SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                adapter.SelectCommand = new SqlCommand(sql, conn);
                SqlCommandBuilder cmdbuilder = new SqlCommandBuilder(adapter);
                adapter.Update(dt);
                dt.AcceptChanges();
                cmd.Parameters.Clear();
                return true;
            }
            catch
            {
                return false;
            }
            finally
            {
                ConnClose(conn);//关闭数据库并释放内存

            }
        }
Beispiel #21
0
        public static DataTable ListToTable(this List<Dictionary<string, string>> dic)
        {
            var dt = new DataTable("Results");

            dic.ForEach(props =>
            {
                props.ToList().ForEach(i =>
                {
                    if (!dt.Columns.Contains(i.Key))
                    {
                        dt.Columns.Add(new DataColumn(i.Key));
                    }
                });

                var dr = dt.NewRow();

                props.ToList().ForEach(i => dr[i.Key] = i.Value);

                dt.Rows.Add(dr);
            });

            dt.AcceptChanges();

            return dt;
        }
Beispiel #22
0
 private void openFileSourceToolStripMenuItem_Click(object sender, EventArgs e)
 {
     try
     {
         OpenFileDialog _of = new OpenFileDialog();
         _of.Filter      = "All Files (*.*)|*.*";
         _of.FilterIndex = 1;
         _of.Multiselect = false;
         if (_of.ShowDialog() == DialogResult.OK)
         {
             _dtbSource = Common.GetDataTable(_of.FileName);
             for (int i = _dtbSource.Columns.Count - 1; i >= 0; i--)
             {
                 if (!string.IsNullOrEmpty(_dtbSource.Rows[0][i].ToString()))
                 {
                     _dtbSource.Columns[i].ColumnName = _dtbSource.Rows[0][i].ToString();
                 }
                 else
                 {
                     //delete null columns
                     _dtbSource.Columns.RemoveAt(i);
                 }
             }
             _dtbSource.Rows[0].Delete();
             _dtbSource.AcceptChanges();
             //  MessageBox.Show("col5:" + _dtbSource.Columns[5].ColumnName.ToString()+ "col6" + _dtbSource.Columns[6].ColumnName.ToString());
             MessageBox.Show("Import Excel 出来ました。", "お知らせ", MessageBoxButtons.OK, MessageBoxIcon.Information);
             txtChumon.Focus();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
 }
Beispiel #23
0
        public static void Baocaohuychot(DataTable m_dtReport, string kieuthuoc_vt, string sTitleReport,  string dieukienbaocao, bool theonhom)
        {
            string tieude = "", reportname = "", reportcode = "thuoc_baocao_huychot_theonhom";
              ReportDocument crpt = null;
              if (kieuthuoc_vt .Contains("THUOC"))
              {
              if (theonhom)
              {
                  reportcode = "thuoc_baocao_huychot_theonhom";
              }
              else
              {
                  reportcode = "thuoc_baocao_huychot";
              }
              }
              else//VTTH
              {
              if (theonhom)
              {
                  reportcode = "vt_baocao_huychot_theonhom";
              }
              else
              {
                  reportcode = "vt_baocao_huychot";
              }
              }
              crpt = Utility.GetReport(reportcode, ref tieude, ref reportname);
              if (crpt == null) return;

              MoneyByLetter _moneyByLetter = new MoneyByLetter();
              var objForm = new frmPrintPreview(sTitleReport, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true);
              objForm.mv_sReportFileName = Path.GetFileName(reportname);
              objForm.mv_sReportCode = reportcode;
              Utility.UpdateLogotoDatatable(ref m_dtReport);
              try
              {
              if (theonhom)
                  m_dtReport.DefaultView.Sort = "stt_hthi_nhom,tenbietduoc";
              else
                  m_dtReport.DefaultView.Sort = "tenbietduoc";
              m_dtReport.AcceptChanges();
              crpt.SetDataSource(m_dtReport.DefaultView);

              Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
              Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
              Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
              Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
              Utility.SetParameterValue(crpt, "dieukienbaocao", dieukienbaocao);
              Utility.SetParameterValue(crpt, "sTitleReport", tieude);
              Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
              Utility.SetParameterValue(crpt, "txttrinhky","");
              objForm.crptViewer.ReportSource = crpt;
              objForm.ShowDialog();
              // Utility.DefaultNow(this);
              }
              catch (Exception ex)
              {
              Utility.CatchException(ex);
              }
        }
Beispiel #24
0
        protected override IEnumerable ExecuteSelect(DataSourceSelectArguments selectArgs)
        {
            // only continue if a membership provider has been configured
            if (!Utils.IsProviderConfigured())
                return null;

            // get roles and build data table
            DataTable dataTable = new DataTable();
            String[] roles = Utils.BaseRoleProvider().GetAllRoles();
            dataTable.Columns.Add("Role");
            dataTable.Columns.Add("UsersInRole");

            // add users in role counts
            for (int i = 0; i < roles.Length; i++)
            {
                DataRow row = dataTable.NewRow();
                row["Role"] = roles[i];
                row["UsersInRole"] = Utils.BaseRoleProvider().GetUsersInRole(roles[i].ToString()).Length;
                dataTable.Rows.Add(row);
            }
            dataTable.AcceptChanges();
            DataView dataView = new DataView(dataTable);

            // sort if a sort expression available
            if (selectArgs.SortExpression != String.Empty)
            {
                dataView.Sort = selectArgs.SortExpression;
            }

            // return as a DataList
            return (IEnumerable) dataView;
        }
Beispiel #25
0
        public void DSMauC79_80a_HD()//cấu trúc chung mẫu c80a-HD; c79a-HD
        {
            dtChungC79_80_a_HD = new System.Data.DataTable();
            dtChungC79_80_a_HD.Columns.Add("stt", typeof(string));
            // dtChungC79_80_a_HD.Columns.Add("tennhom", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dt_stt", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dt_bv", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dt_ngayqd", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dt_ngayhl", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dt_nhom", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("masobyt", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("tenhc", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("tenvp", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("tentm", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("quicach", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("donvitinh", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("tennuoc", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("tenhang", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dvktcao", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dvktthuong", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("codantem", typeof(string));

            dtChungC79_80_a_HD.Columns.Add("giamua", typeof(decimal)).DefaultValue = 0;
            dtChungC79_80_a_HD.Columns.Add("dinhmucts", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("giattbh", typeof(decimal)).DefaultValue    = 0;
            dtChungC79_80_a_HD.Columns.Add("slngoaitru", typeof(decimal)).DefaultValue = 0;
            dtChungC79_80_a_HD.Columns.Add("slnoitru", typeof(decimal)).DefaultValue   = 0;
            dtChungC79_80_a_HD.Columns.Add("thanhtien", typeof(decimal)).DefaultValue  = 0;
            dtChungC79_80_a_HD.Columns.Add("ghichu", typeof(string));

            dtChungC79_80_a_HD.AcceptChanges();
        }
Beispiel #26
0
        public static DataTable ExpandoToDataTable(List<dynamic> data)
        {
            int counter = 0;
            DataTable dt = new DataTable("data");
            //generate columns
            foreach (dynamic item in data)
            {
                if (item is ExpandoObject)
                {
                    if (counter <= 0)
                    {
                        foreach (var dataitem in (IDictionary<string, object>)item)
                        {
                            dt.Columns.Add(dataitem.Key);
                        }
                    }

                    {
                        var NewItem = dt.NewRow();
                        foreach (var dataitem in (IDictionary<string, object>)item)
                        {
                            NewItem[dataitem.Key] = dataitem.Value;
                        }
                        dt.Rows.Add(NewItem);
                    }
                    counter++;
                }

            }
            dt.AcceptChanges();
            return dt;
        }
Beispiel #27
0
        //protected string[][] ArmadoParametros()
        //{
        //    string[][] Params = new string[grdParams.Rows.Count][];
        //    HiddenField hddTipoDato = new HiddenField();
        //    HiddenField hddValor = new HiddenField();
        //    HiddenField hddNombre = new HiddenField();
        //    HiddenField hddLongitud = new HiddenField();
        //    int Longitud = 0; //Para forzar la salida de un número

        //    for (int w = 0; w < grdParams.Rows.Count; w++)
        //    {
        //        hddTipoDato = (HiddenField)grdParams.Rows[w].FindControl("hddTipoDato");
        //        hddValor = (HiddenField)grdParams.Rows[w].FindControl("hddValor");
        //        hddNombre = (HiddenField)grdParams.Rows[w].FindControl("hddNombre");
        //        hddLongitud = (HiddenField)grdParams.Rows[w].FindControl("hddLongitud");
        //        int.TryParse(hddLongitud.Value, out Longitud);


        //        Params[w] = new string[] { hddNombre.Value, hddValor.Value, hddTipoDato.Value.ToLowerInvariant(), Longitud.ToString() };
        //    }

        //    return Params;
        //}

        protected System.Data.DataTable ArmadoParametros()
        {
            System.Data.DataTable Params = new System.Data.DataTable("Parametros");
            System.Data.DataRow   dr;
            HiddenField           hddTipoDato = new HiddenField();
            HiddenField           hddValor    = new HiddenField();
            HiddenField           hddNombre   = new HiddenField();
            HiddenField           hddLongitud = new HiddenField();
            int Longitud = 0; //Para forzar la salida de un número

            Params.Columns.Add("Nombre");
            Params.Columns.Add("Valor");
            Params.Columns.Add("Tipo");
            Params.Columns.Add("Longitud");

            for (int w = 0; w < grdParams.Rows.Count; w++)
            {
                hddTipoDato = (HiddenField)grdParams.Rows[w].FindControl("hddTipoDato");
                hddValor    = (HiddenField)grdParams.Rows[w].FindControl("hddValor");
                hddNombre   = (HiddenField)grdParams.Rows[w].FindControl("hddNombre");
                hddLongitud = (HiddenField)grdParams.Rows[w].FindControl("hddLongitud");
                int.TryParse(hddLongitud.Value, out Longitud);

                dr             = Params.NewRow();
                dr["Nombre"]   = hddNombre.Value;
                dr["Valor"]    = hddValor.Value;
                dr["Tipo"]     = hddTipoDato.Value.ToLowerInvariant();
                dr["Longitud"] = Longitud.ToString();
                Params.Rows.Add(dr);
            }

            Params.AcceptChanges();

            return(Params);
        }
Beispiel #28
0
        public System.Data.DataTable SeihinAutoFixExcelFileCSVConvertXLS(System.Data.DataTable _dtbExec)
        {
            #region 20161214 - BotFJP - Delete columns not use
            for (int i = _dtbExec.Columns.Count - 1; i >= 0; i--)
            {
                if (new[] { 29, 31, 34 }.Contains(i))
                {
                    continue;
                }
                else
                {
                    _dtbExec.Columns.RemoveAt(i);
                }
            }

            _dtbExec.Columns[0].ColumnName = "納期";
            _dtbExec.Columns[1].ColumnName = "図面番号";
            //部品=>組込番号          製品=>受注番号
            _dtbExec.Columns[2].ColumnName = "受注番号";
            _dtbExec.Columns.Add("組込番号", typeof(string));
            _dtbExec.AcceptChanges();

            #endregion

            #region 20161214 - BotFJP - Fix data 納期                 Meo dc
            //foreach (DataRow _row in _dtbSource.Rows)
            //{
            //    _row["納期"] = DateTime.Parse(_row["納期"].ToString()).ToString("MM/dd");
            //}
            //_dtbSource.AcceptChanges();
            #endregion
            return(_dtbExec);
        }
        /// <summary>
        /// 获取带DataGrid的仪表盘
        /// </summary>
        /// <param name="title">表盘标题</param>
        /// <param name="unit">表盘单位</param>
        /// <param name="actualValue">实际值</param>
        /// <param name="alarmValue">报警设定值</param>
        /// <param name="maximunValue">表盘上限(可选)</param>
        /// <param name="minimumValue">表盘下限(可选)</param>
        /// <returns></returns>
        public static string GetGridMeterGaugeJsonString(string title, string unit, decimal actualValue, decimal alarmValue, decimal maximunValue = 0, decimal minimumValue = 0)
        {
            string[] myColumnsName = new string[] { "项目", "值" };
            string[] myRowsName = new string[] { "表盘实际值", "报警设定值", "表盘的上限值", "表盘下限值" };
            decimal[] myRowsValue = new decimal[] { actualValue, alarmValue, maximunValue, minimumValue };
            string myUnitX = unit;
            string myUnitY = "";
            int myFrozenColumns = 0;

            DataTable dt = new DataTable();
            dt.Columns.Add("RowName", typeof(string));
            dt.Columns.Add("Value", typeof(decimal));

            for (int i = 0; i < myRowsName.Length; i++)
            {
                DataRow dr = dt.NewRow();
                dr["RowName"] = myRowsName[i];
                dr["Value"] = myRowsValue[i];
                dt.Rows.Add(dr);
            }

            dt.AcceptChanges();

            return GetGridChartJsonString(dt, myColumnsName, myRowsName, myUnitX, myUnitY, myFrozenColumns);
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        DataTable myTable = new DataTable("myTable");
            DataColumn colItem = new DataColumn("item", Type.GetType("System.String"));
            DataColumn colItem1 = new DataColumn("item1", Type.GetType("System.Int32"));

            myTable.Columns.Add(colItem);
            myTable.Columns.Add(colItem1);

            // Add five items.
            DataRow NewRow;
            for (int i = 0; i < 2; i++)
            {
                NewRow = myTable.NewRow();
                NewRow["item"] = i;
                myTable.Rows.Add(NewRow);
            }

            myTable.Rows[0]["item"] = "Juan";
            myTable.Rows[0]["item1"] = "60";

            myTable.Rows[1]["item"] = "Diego";
            myTable.Rows[1]["item1"] = "40";

            myTable.AcceptChanges();

            //DataView custDV = new DataView(custDS.Tables["Customers"], "Country = 'USA'", "ContactName", DataViewRowState.CurrentRows);
            DataView custDV = new DataView(myTable);

            //Display(custDV);
    }
Beispiel #31
0
            /// <summary>
            /// converts a excel byte array (fileuploader creates this for you) to data table.
            /// needs the NuGet package excelDatareader (npm: Install-Package ExcelDataReader), using Excel.
            /// Use if you cant/dont want to save documents to your directories
            /// </summary>
            /// <param name="excelArray">The excel array.</param>
            /// <returns></returns>

            /*public static System.Data.DataTable XLSXByteArraytoDataTable(byte[] excelArray)
             * {
             *  IExcelDataReader excelReader;
             *  System.Data.DataTable dt = new System.Data.DataTable();
             *  MemoryStream excelStream = new MemoryStream(excelArray);
             *  excelReader = ExcelReaderFactory.CreateOpenXmlReader(excelStream);
             *  excelReader.IsFirstRowAsColumnNames = true;
             *  DataSet ds = excelReader.AsDataSet();
             *  dt = ds.Tables[0];
             *  return dt;
             * }*/

            /// <summary>
            /// Converts a CSV file's data to a Data Table
            /// </summary>
            /// <param name="inputFile">The input file.</param>
            /// <returns></returns>
            public static System.Data.DataTable CSVToDataTable(string inputFile)
            {
                System.Data.DataTable dt = new System.Data.DataTable();
                FileStream            fs = File.OpenRead(inputFile);
                StreamReader          sr = new StreamReader(fs);
                string totalContent      = sr.ReadToEnd();

                string[] lines = totalContent.Split("\r\n"[0]);

                for (int i = 0; i < lines.Length; i++)
                {
                    dt.Rows.Add();
                    string[] lineContent = lines[i].Split(","[0]); //should be the same length as the colLength
                    for (int j = 0; j < lineContent.Length; j++)
                    {
                        if (dt.Columns.Count < j + 1)
                        {
                            dt.Columns.Add();
                        }
                        dt.Rows[i][j] = lineContent[j];
                    }
                }

                dt.AcceptChanges();
                return(dt);
            }
Beispiel #32
0
        private DataTable RemoveNonOutToCustomerData(DataTable dt)
        {
            if (dt.Rows.Count > 0)
            {
                string trfFrom, trfTo;
                for (int i = dt.Rows.Count - 1; i >= 0; i--)
                {
                    trfFrom = dt.Rows[i][dalTrfHist.TrfFrom].ToString();
                    trfTo   = dt.Rows[i][dalTrfHist.TrfTo].ToString();

                    if (dt.Rows[i][dalTrfHist.TrfResult].ToString().Equals("Passed"))
                    {
                        if (tool.getFactoryID(trfFrom) == -1 || tool.getCustID(trfTo) == -1)
                        {
                            dt.Rows[i].Delete();
                        }
                    }
                    else
                    {
                        dt.Rows[i].Delete();
                    }
                }
                dt.AcceptChanges();
            }
            return(dt);
        }
Beispiel #33
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);
            }
        void MedStoreLoad()
        {
            try
            {
                conn.Open();
                string sqlquery = "SELECT * FROM MED_STORE";
                //string sqlquery = "SELECT * FROM MED_INFO";
                OracleCommand cmd = new OracleCommand(sqlquery, conn);
                OracleDataAdapter oda = new OracleDataAdapter();
                oda.SelectCommand = cmd;
                dt = new DataTable();
                //     dt.Columns["MED_NAME"].ColumnName = "Name";

                oda.Fill(dt);
                BindingSource bsource = new BindingSource();
                bsource.DataSource = dt;
                dataGridView1.DataSource = bsource;
                oda.Update(dt);
                dt.Columns[0].ColumnName = "ID";
                dt.Columns[1].ColumnName = "Name";
                dt.Columns[2].ColumnName = "Quantity";
                dt.Columns[3].ColumnName = "Damage Qty";
                dt.Columns[4].ColumnName = "Reorder Level";

                dt.AcceptChanges();

                conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Beispiel #35
0
        public static System.Data.DataTable CreateChildDataTable()
        {
            System.Data.DataTable dtChild = new System.Data.DataTable("Child");
            dtChild.Columns.Add("ParentId", typeof(int));
            dtChild.Columns.Add("ChildId", typeof(int));
            dtChild.Columns.Add("String1", typeof(string));
            dtChild.Columns.Add("String2", typeof(string));
            dtChild.Columns.Add("ChildDateTime", typeof(DateTime));
            dtChild.Columns.Add("ChildDouble", typeof(double));

            dtChild.Rows.Add(new object[] { 1, 1, "1-String1", "1-String2", new DateTime(2000, 1, 1, 0, 0, 0, 0), 1.534 });
            dtChild.Rows.Add(new object[] { 1, 2, "2-String1", "2-String2", DateTime.MaxValue, -1.534 });
            dtChild.Rows.Add(new object[] { 1, 3, "3-String1", "3-String2", DateTime.MinValue, double.MaxValue / 10000 });
            dtChild.Rows.Add(new object[] { 2, 1, "1-String1", "1-String2", new DateTime(1973, 6, 20, 0, 0, 0, 0), double.MinValue * 10000 });
            dtChild.Rows.Add(new object[] { 2, 2, "2-String1", "2-String2", new DateTime(2008, 12, 1, 13, 59, 59, 59), 0.45 });
            dtChild.Rows.Add(new object[] { 2, 3, "3-String1", "3-String2", new DateTime(2003, 1, 1, 1, 1, 1, 1), 0.55 });
            dtChild.Rows.Add(new object[] { 5, 1, "1-String1", "1-String2", new DateTime(2002, 1, 1, 1, 1, 1, 1), 0 });
            dtChild.Rows.Add(new object[] { 5, 2, "2-String1", "2-String2", new DateTime(2001, 1, 1, 1, 1, 1, 1), 10 });
            dtChild.Rows.Add(new object[] { 5, 3, "3-String1", "3-String2", new DateTime(2000, 1, 1, 1, 1, 1, 1), 20 });
            dtChild.Rows.Add(new object[] { 6, 1, "1-String1", "1-String2", new DateTime(2000, 1, 1, 1, 1, 1, 0), 25 });
            dtChild.Rows.Add(new object[] { 6, 2, "2-String1", "2-String2", new DateTime(2000, 1, 1, 1, 1, 0, 0), 30 });
            dtChild.Rows.Add(new object[] { 6, 3, "3-String1", "3-String2", new DateTime(2000, 1, 1, 0, 0, 0, 0), 35 });
            dtChild.AcceptChanges();
            return(dtChild);
        }
        /// <summary>コンストラクタ</summary>
        public TextBoxDataGridValidationBindingGroupWindow2()
        {
            InitializeComponent();

            DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("count", typeof(Int32)));
            dt.Columns.Add(new DataColumn("name", typeof(System.String)));
            DataRow dr=null;

            dr = dt.NewRow();
            dr["count"] = 100;
            dr["name"] = "あああ";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["count"] = 200;
            dr["name"] = "いいい";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["count"] = 300;
            dr["name"] = "ううう";
            dt.Rows.Add(dr);

            // ここまでの変更をコミット
            dt.AcceptChanges();

            this.dataGrid1.DataContext = dt;

            // ソースクラスをバインド
            this.DataContext = new SourceClass();
        }
Beispiel #37
0
        protected void btndelete2_Click(object sender, EventArgs e)
        {
            System.Data.DataTable dt = this.GetDataFromGrid2();
            for (int i = 0; i < Repeater2.Items.Count; i++)
            {
                RepeaterItem rItem = Repeater2.Items[i];
                System.Web.UI.WebControls.CheckBox chk = (System.Web.UI.WebControls.CheckBox)rItem.FindControl("cbchecked");
                if (chk.Checked)
                {
                    dt.Rows.RemoveAt(i - count);
                    count++;
                }
            }
            for (int i = dt.Rows.Count; i < 6; i++)
            {
                DataRow newRow = dt.NewRow();

                dt.Rows.Add(newRow);
            }
            dt.AcceptChanges();
            this.Repeater2.DataSource = dt;
            this.Repeater2.DataBind();
            //if (Request.QueryString["action"] == "addjl")
            //{
            //    bind_info();
            //}
            //if (Request.QueryString["action"] == "modjl")
            //{
            //    bind_info2();
            //}
        }
 void FormTVP(ref DataTable Dt)
 {
     DataColumn Floor_Id = Dt.Columns.Add("Floor_Id", typeof(Int32));
     DataColumn Floor_Name = Dt.Columns.Add("Floor_Name", typeof(String));
     DataColumn Floor_Code = Dt.Columns.Add("Floor_Code", typeof(String));
     Dt.AcceptChanges();
 }
Beispiel #39
0
 public static DataTable CreateTicketDt()
 {
     DataTable dt = new DataTable();
     dt.Columns.Add("TrainCode");
     dt.Columns.Add("TrainCodeKey");
     dt.Columns.Add("StartStation");
     dt.Columns.Add("AimStation");
     dt.Columns.Add("TakeTime");
     dt.Columns.Add("ShangWu");
     dt.Columns.Add("TeDeng");
     dt.Columns.Add("YiDeng");
     dt.Columns.Add("ErDeng");
     dt.Columns.Add("GaoJiRuanWo");
     dt.Columns.Add("RuanWo");
     dt.Columns.Add("YingWo");
     dt.Columns.Add("RuanZuo");
     dt.Columns.Add("YingZuo");
     dt.Columns.Add("WuZuo");
     dt.Columns.Add("QiTa");
     dt.Columns.Add("OrderKey");
     dt.Columns.Add("CanOrder");
     dt.Columns.Add("Order", typeof(Image));
     dt.Columns.Add("First");
     dt.Columns.Add("Last");
     dt.AcceptChanges();
     return dt;
 }
        void MgfLoad()
        {
            try
            {
                conn.Open();
              //  string sqlquery = "SELECT MED_ID,MED_NAME,MED_STG,MED_MGF,MED_BATCH,MED_GROUP,MED_TYPE,COST_PRICE,SELL_PRICE,NOTES FROM MED_INFO";
                string sqlquery = "SELECT * FROM MFG_INFO";
                OracleCommand cmd = new OracleCommand(sqlquery, conn);
                OracleDataAdapter oda = new OracleDataAdapter();
                oda.SelectCommand = cmd;
                dt = new DataTable();
                //     dt.Columns["MED_NAME"].ColumnName = "Name";

                oda.Fill(dt);
                BindingSource bsource = new BindingSource();
                bsource.DataSource = dt;
                dataGridView1.DataSource = bsource;
                oda.Update(dt);
                dt.Columns[0].ColumnName = "ID";
                dt.Columns[1].ColumnName = "Name";
                dt.Columns[2].ColumnName = "Address";
                dt.Columns[3].ColumnName = "Mobile";
                dt.AcceptChanges();

                conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// Calculates and sorts the places/probs of the AE vs. VQ data
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="sortName"></param>
        /// <param name="fieldName"></param>
        /// <param name="bRecalc"></param>
        private static void CalculatePlacementForDiffReport
        (
            System.Data.DataTable dt,
            string sortName,
            string fieldName,
            bool bRecalc = false
        )
        {
            dt.AcceptChanges();
            DataView dv = new DataView(dt, null, sortName, DataViewRowState.CurrentRows);

            for (int row = 0; row < dv.Count; row++)
            {
                dv[row][fieldName] = row + 1;
                if (bRecalc)
                {
                    double diff = (double)(dv[row]["prbVQ"]) - (double)(dv[row]["prbAE"]);
                    dv[row]["prbDiA"] = Math.Abs(diff);
                    dv[row]["prbDiD"] = diff;

                    int pdiff = (int)(dv[row]["plVQ"]) - (int)(dv[row]["plAE"]);
                    dv[row]["plDiA"] = (int)(Math.Abs(pdiff));
                    dv[row]["plDiI"] = pdiff;
                }
            }
        }
Beispiel #42
0
		protected override DataTable ProcessResult(DataTable schema)
		{
			schema.BeginLoadData();

			foreach (DataRow row in schema.Rows)
			{
				// ToBoolean
				foreach (DataColumn col in schema.Columns)
					if (col.Caption.StartsWith("IS_"))
						row[col.Caption] =
							row[col.Caption] != DBNull.Value &&
								Convert.ToInt32(row[col.Caption], CultureInfo.InvariantCulture) != 0;

				if (Convert.ToInt32(row["HELPER_CID"], CultureInfo.InvariantCulture) != 0)
					row["SOURCE"] =
						HelperGetObjectDefinition(Convert.ToInt32(row["HELPER_CID"], CultureInfo.InvariantCulture));
			}

			schema.EndLoadData();
			schema.AcceptChanges();

			schema.Columns.Remove("HELPER_CID");

			return schema;
		}
Beispiel #43
0
        public void DSMauC79_80a_HD()//cấu trúc chung mẫu c80a-HD; c79a-HD
        {
            dtChungC79_80_a_HD = new System.Data.DataTable();
            dtChungC79_80_a_HD.Columns.Add("stt", typeof(string));
            // dtChungC79_80_a_HD.Columns.Add("tennhom", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dt_stt", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dt_bv", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dt_ngay", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dt_nhom", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("masobyt", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("tenhc", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("tenvp", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("duongdung", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dangbaoche", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("hamluong", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("dangtrinhbay", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("tenhang", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("tennuoc", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("sogiayphep", typeof(string));
            dtChungC79_80_a_HD.Columns.Add("donvi", typeof(string));

            dtChungC79_80_a_HD.Columns.Add("giamua", typeof(decimal)).DefaultValue     = 0;
            dtChungC79_80_a_HD.Columns.Add("giattbh", typeof(decimal)).DefaultValue    = 0;
            dtChungC79_80_a_HD.Columns.Add("slngoaitru", typeof(decimal)).DefaultValue = 0;
            dtChungC79_80_a_HD.Columns.Add("slnoitru", typeof(decimal)).DefaultValue   = 0;
            dtChungC79_80_a_HD.Columns.Add("thanhtien", typeof(decimal)).DefaultValue  = 0;

            dtChungC79_80_a_HD.Columns.Add("ghichu", typeof(string));

            dtChungC79_80_a_HD.AcceptChanges();
        }
Beispiel #44
0
		public static DataTable CreateChildDataTable()
		{
			DataTable dtChild = new DataTable("Child");
			dtChild.Columns.Add("ParentId",typeof(int));
			dtChild.Columns.Add("ChildId",typeof(int));
			dtChild.Columns.Add("String1",typeof(string));
			dtChild.Columns.Add("String2",typeof(string));
			dtChild.Columns.Add("ChildDateTime",typeof(DateTime));
			dtChild.Columns.Add("ChildDouble",typeof(double));

			dtChild.Rows.Add(new object[] {1,1,"1-String1","1-String2",new DateTime(2000,1,1,0,0,0,0),1.534});
			dtChild.Rows.Add(new object[] {1,2,"2-String1","2-String2",DateTime.MaxValue ,-1.534});
			dtChild.Rows.Add(new object[] {1,3,"3-String1","3-String2",DateTime.MinValue,double.MaxValue/10000});
			dtChild.Rows.Add(new object[] {2,1,"1-String1","1-String2",new DateTime(1973,6,20,0,0,0,0),double.MinValue*10000});
			dtChild.Rows.Add(new object[] {2,2,"2-String1","2-String2",new DateTime(2008,12,1,13,59,59,59),0.45});
			dtChild.Rows.Add(new object[] {2,3,"3-String1","3-String2",new DateTime(2003,1,1,1,1,1,1),0.55});
			dtChild.Rows.Add(new object[] {5,1,"1-String1","1-String2",new DateTime(2002,1,1,1,1,1,1),0});
			dtChild.Rows.Add(new object[] {5,2,"2-String1","2-String2",new DateTime(2001,1,1,1,1,1,1),10});
			dtChild.Rows.Add(new object[] {5,3,"3-String1","3-String2",new DateTime(2000,1,1,1,1,1,1),20});
			dtChild.Rows.Add(new object[] {6,1,"1-String1","1-String2",new DateTime(2000,1,1,1,1,1,0),25});
			dtChild.Rows.Add(new object[] {6,2,"2-String1","2-String2",new DateTime(2000,1,1,1,1,0,0),30});
			dtChild.Rows.Add(new object[] {6,3,"3-String1","3-String2",new DateTime(2000,1,1,0,0,0,0),35});
			dtChild.AcceptChanges();
			return dtChild;
		}
		public DataSet SensitiveData()
		{
			DataSet data = new DataSet();
			
			//Do our authentication
			//this can be via a database or whatever
			if(Authentication.Username == "test" && Authentication.Password == "test")
			{
				//they are allowed access to our sensitive data
				
				//just create some dummy data
				DataTable dtTable1 = new DataTable();
				DataColumn drCol1 = new DataColumn("Data", System.Type.GetType("System.String"));
				dtTable1.Columns.Add(drCol1);

				DataRow drRow = dtTable1.NewRow();
				drRow["Data"] = "Sensitive Data";
				dtTable1.Rows.Add(drRow);
				dtTable1.AcceptChanges();

				data.Tables.Add(dtTable1);


				
			}
			else
			{
				data = null;
			}			

			return data;
		}
Beispiel #46
0
	//Activate This Construntor to log All To Standard output
	//public TestClass():base(true){}

	//Activate this constructor to log Failures to a log file
	//public TestClass(System.IO.TextWriter tw):base(tw, false){}


	//Activate this constructor to log All to a log file
	//public TestClass(System.IO.TextWriter tw):base(tw, true){}

	//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES

	public void run()
	{
		Exception exp = null;
		DataTable myTable = new DataTable("myTable"); 
		DataColumn dc = new DataColumn("Id",typeof(int));
		dc.Unique=true;
		myTable.Columns.Add(dc);
		myTable.Rows.Add(new object[] {1});
		myTable.Rows.Add(new object[] {2});
		myTable.Rows.Add(new object[] {3});
		myTable.AcceptChanges();
					
		DataRow myRow = myTable.Rows[0];
		myRow.Delete();
		
        
		try
		{
			BeginCase("Delete1");
			Compare( myRow.RowState , DataRowState.Deleted  );
		}
		catch(Exception ex)	{exp = ex;}
		finally	{EndCase(exp); exp = null;}

		try
		{
			BeginCase("Delete2");
			myTable.AcceptChanges();
			Compare( myRow.RowState , DataRowState.Detached  );
		}
		catch(Exception ex)	{exp = ex;}
		finally	{EndCase(exp); exp = null;}
			
		
	}
        private DataTable BuildDataTableDefinition(TableDescriptor table)
        {
            var dataTable = new DataTable();
            foreach (var col in table.Columns)
            {
                dataTable.Columns.Add(new DataColumn(col.Name.GetName()));
            }

            dataTable.AcceptChanges();

            dataTable.RowChanged += (sender, args) =>
            {
                dataTable.ExtendedProperties["Changed"] = true;
            };

            dataTable.TableNewRow += (sender, args) =>
            {
                dataTable.ExtendedProperties["Changed"] = true;
            };

            dataTable.RowDeleting += (sender, args) =>
            {
                dataTable.ExtendedProperties["Changed"] = true;
            };

            return dataTable;
        }
Beispiel #48
0
        private void AutoFixBCOrder_Load(object sender, EventArgs e)
        {
            try
            {
                #region 20161129 - BotJava - Auto Import SourceTana


                _dtbSourceTana = Common.GetDataTable("C:\\Users\\HonC\\Desktop\\FixBCOrder\\SourceTana.xls");
                for (int i = _dtbSourceTana.Columns.Count - 1; i >= 0; i--)
                {
                    if (!string.IsNullOrEmpty(_dtbSourceTana.Rows[0][i].ToString()))
                    {
                        _dtbSourceTana.Columns[i].ColumnName = _dtbSourceTana.Rows[0][i].ToString();
                    }
                }
                _dtbSourceTana.Rows[0].Delete();
                _dtbSourceTana.AcceptChanges();
                // dtgSourceTana.DataSource = _dtbSourceTana;

                #endregion
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
Beispiel #49
0
 public static System.Data.DataTable RecordListToDataTable(List <Record> list)
 {
     try
     {
         System.Data.DataTable MethodResult = null;
         System.Data.DataTable dt           = new System.Data.DataTable();
         dt.Columns.Add("ID");
         //Add your additional column fields here
         foreach (Record sr in list)
         {
             DataRow dr = dt.NewRow();
             dr[0] = sr.ID;
             //Add the extra rows to the table here
             dt.Rows.Add(dr);
         }
         dt.AcceptChanges();
         MethodResult = dt;
         return(MethodResult);
     }
     catch (Exception ex)
     {
         Console.WriteLine(ex);
         throw;
     }
 }
Beispiel #50
0
        private void btnImportShukko_Click(object sender, EventArgs e)
        {
            try
            {
                OpenFileDialog _of = new OpenFileDialog();
                _of.Filter      = "All Files (*.*)|*.*";
                _of.FilterIndex = 1;
                _of.Multiselect = false;
                if (_of.ShowDialog() == DialogResult.OK)
                {
                    _dtbShukko = Common.GetDataTable(_of.FileName);


                    #region 20161201 - BotJava - Fix Format Excel -> change column name
                    for (int i = 0; i < _dtbShukko.Columns.Count; i++)
                    {
                        _dtbShukko.Columns[i].ColumnName = _dtbShukko.Rows[0][i].ToString();
                    }
                    _dtbShukko.Rows[0].Delete();
                    _dtbShukko.AcceptChanges();
                    #endregion

                    dtgShukko.DataSource = _dtbShukko;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
Beispiel #51
0
        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog _of = new OpenFileDialog();

            System.Data.DataTable _dtbTanaSource = new System.Data.DataTable();
            _of.Filter      = "All Files (*.*)|*.*";
            _of.FilterIndex = 1;
            _of.Multiselect = false;
            if (_of.ShowDialog() == DialogResult.OK)
            {
                _dtbTanaSource = Common.GetDataTable(_of.FileName);


                #region 20161201 - BotJava - Fix Format Excel -> change column name
                for (int i = 0; i < _dtbTanaSource.Columns.Count - 1; i++)
                {
                    _dtbTanaSource.Columns[i].ColumnName = _dtbTanaSource.Rows[0][i].ToString();
                }
                _dtbTanaSource.Rows[0].Delete();
                _dtbTanaSource.AcceptChanges();
                #endregion

                dtgShukko.DataSource = _dtbTanaSource;
            }
        }
Beispiel #52
0
    public MainWindow() : base(Gtk.WindowType.Toplevel)
    {
        Build();

        System.Console.WriteLine(DatabaseProvider.IsValidType(typeof(DbObservableList)));
        ob_list.ElementAdded   += HandleElementAdded;
        ob_list.ElementChanged += HandleElementChanged;
        ob_list.ElementRemoved += HandleElementRemoved;
        ob_list.ElementsSorted += HandleElementsSorted;         //should come to this

        table.Columns.Add("ID", typeof(int));
        table.Columns.Add("Title", typeof(string));

        table.Rows.Add(new object[] { 1, "Title 1" });
        table.Rows.Add(new object[] { 2, "Title 2" });

        table.Rows[0][0] = 66;

        table.AcceptChanges();

//		table.Rows[0].Delete();
//		System.Console.WriteLine(table.Rows.Count);
//		table.Rows.RemoveAt(1); //you'll notice that Removed event
        //for this one gets fired before the Removed event
        //of element 0 (because it auto-commits it)
//		table.AcceptChanges();
        datatreeview1.ItemsDataSource = table;
//		datatreeview1.ItemsDataSource = ob_list;
        datacombobox1.ItemsDataSource      = ob_list;
        datacomboboxentry1.ItemsDataSource = ob_list;
    }
Beispiel #53
0
        private void DemonstrateDtaView() 
        {
            DataTable table = new DataTable("table");
            DataColumn colItem = new DataColumn("item", Type.GetType("System.String"));
            table.Columns.Add(colItem);

            DataRow NewRow;
            for (int i = 0; i < 5; ++i) 
            {
                NewRow = table.NewRow();
                NewRow["item"] = "Item" + i;
                table.Rows.Add(NewRow);
            }

            table.Rows[0]["item"] = "cat";
            table.Rows[1][0] = "dog";
            // Commits all the changes made to this table since the last time AcceptChanges was called.
            // The DataRowState also changes: all Added and Modified rows become Unchanged, 
            // and Deleted rows are removed.
            table.AcceptChanges();

            DataView firstView = new DataView(table);
            DataView secondView = new DataView(table);
            PrintTableOrView(table, "Current Value in Table");

            firstView.RowStateFilter = DataViewRowState.ModifiedOriginal;
            PrintTableOrView(firstView, "First DataView: Modifiedoriginal");
            DataRowView rowView;
            rowView = secondView.AddNew();
            rowView["item"] = "fish";

            secondView.RowStateFilter = DataViewRowState.ModifiedCurrent
                | DataViewRowState.Added;
            PrintTableOrView(secondView, "Second DataVies: ModifiedCurent | Added");
        }
Beispiel #54
0
        DataSet create_dataset()
        {
            string d_tu = "", d_den = "";

            d_tu  = tu.Value.ToString().PadLeft(2, '0') + yy.Value.ToString().PadLeft(4, '0').Substring(2);
            d_den = den.Value.ToString().PadLeft(2, '0') + yyyy.Value.ToString().PadLeft(4, '0').Substring(2);
            DataSet tmp = new DataSet();

            System.Data.DataTable dttmp = new System.Data.DataTable();
            dttmp.Columns.Add("stt", typeof(int));
            dttmp.Columns.Add("mabd", typeof(decimal));
            dttmp.Columns.Add("ma", typeof(string));
            dttmp.Columns.Add("ten", typeof(string));
            dttmp.Columns.Add("dang", typeof(string));
            dttmp.Columns.Add(d_tu, typeof(string));
            if (d_den != d_tu)
            {
                dttmp.Columns.Add(d_den, typeof(string));
                dttmp.Columns.Add("chenhlech", typeof(string));
            }
            dttmp.AcceptChanges();
            tmp.Tables.Add(dttmp);
            tmp.AcceptChanges();
            return(tmp);
        }
        public DataTable ToDataTable(INetwork network)
        {
            if (network == null)
                throw new ArgumentNullException("network", "The input network must not be null.");
            if (!(network is IEdgeAttributes))
                throw new ArgumentException(string.Format("The input network must implement {0}.", typeof(IEdgeAttributes).Name), "network");
            IEdgeAttributes src = network as IEdgeAttributes;
            DataTable table = new DataTable("Edge data");
            AttributeListMgr mgr = src.EdgeAttributeMgr as AttributeListMgr;
            if (mgr == null)
                throw new ArgumentException("The EdgeAttributeMgr of the input network must not be null.", "network");

            string[] colNames = EnsureUniqueColNames(mgr);
            int ctr = 0;
            foreach (IAttributeList list in mgr.Lists)
            {
                table.Columns.Add(new DataColumn(colNames[ctr++], list.DataType));
            }

            if (table.Columns.Count>0)
                for (int i = 0; i < mgr.Depth; i++)
                {
                    table.Rows.Add(mgr.GetRow(i));
                }

            table.AcceptChanges();
            return table;
        }
Beispiel #56
0
        /// <summary>
        /// 保存后重新加载页面
        /// </summary>
        /// <returns></returns>
        protected System.Data.DataTable AfterSavedReload()
        {
            System.Data.DataTable dt = new System.Data.DataTable();
            #region
            dt.Columns.Add("BM_TUHAO");       //图号0
            dt.Columns.Add("BM_MARID");       //物料编码1
            dt.Columns.Add("BM_ZONGXU");      //总序2
            dt.Columns.Add("BM_CHANAME");     //中文名称3
            dt.Columns.Add("BM_NOTE");        //备注4
            dt.Columns.Add("BM_MALENGTH");    //材料长度5
            dt.Columns.Add("BM_MAWIDTH");     //材料宽度6
            dt.Columns.Add("BM_NUMBER");      //数量7
            dt.Columns.Add("BM_UNITWGHT");    //单重8
            dt.Columns.Add("BM_MAUNITWGHT");  //材料单重9
            dt.Columns.Add("BM_MATOTALWGHT"); //材料总重10
            dt.Columns.Add("BM_MABGZMY");     //面域(m2)11
            dt.Columns.Add("BM_BEIZHUATR");
            dt.Columns.Add("BM_TUUNITWGHT");  //图纸上单重12
            dt.Columns.Add("BM_TUMAQLTY");    //图纸上材质13
            dt.Columns.Add("BM_TUSTAD");      //图纸上标准13
            dt.Columns.Add("BM_TUPROBLEM");   //图纸上问题15
            dt.Columns.Add("BM_MAQUALITY");   //材质16
            dt.Columns.Add("BM_GUIGE");       //规格17
            dt.Columns.Add("BM_MANAME");      //材料名称18
            dt.Columns.Add("BM_MAGUIGE");     //材料规格19
            dt.Columns.Add("BM_THRYWGHT");    //理论重量20
            dt.Columns.Add("BM_TOTALWGHT");   //总重21
            dt.Columns.Add("BM_MATOTALLGTH"); //材料总长22
            dt.Columns.Add("BM_MAUNIT");      //单位23
            dt.Columns.Add("BM_STANDARD");    //国标24
            dt.Columns.Add("BM_MASHAPE");     //毛坯25
            dt.Columns.Add("BM_MASTATE");     //状态26
            dt.Columns.Add("BM_PROCESS");     //工艺流程27
            dt.Columns.Add("BM_ENGSHNAME");   //英文名称28
            dt.Columns.Add("BM_KEYCOMS");     //关键部件29
            dt.Columns.Add("BM_FIXEDSIZE");   //是否定尺30
            dt.Columns.Add("BM_WMARPLAN");    //是否提材料计划
            dt.Columns.Add("BM_KU");          //库
            dt.Columns.Add("BM_TOTALNUMBER"); //34
            dt.Columns.Add("BM_PNUMBER");     //计划数量
            dt.Columns.Add("BM_MPMY");        //计划面域
            dt.Columns.Add("BM_MSXUHAO");     //明细序号
            dt.Columns.Add("BM_XUHAO");       //序号
            dt.Columns.Add("BM_ISMANU");
            dt.Columns.Add("BM_PARTOWNWGHT");
            #endregion
            for (int i = 0; i < 15; i++)
            {
                DataRow newRow = dt.NewRow();
                newRow[30] = "N";
                newRow[31] = "N";
                newRow[32] = "Y";
                newRow[39] = "Y";
                dt.Rows.Add(newRow);
            }

            dt.AcceptChanges();
            return(dt);
        }
Beispiel #57
0
        private void DataGridViewShow()
        {
            string sqltxt = "select * from sys_meta_info where tablename = '" + tablename_comboBox.Text + "'";

            m_adp = new SqlDataAdapter(sqltxt, m_conn);

            System.Data.DataSet DS = new System.Data.DataSet();

            m_adp.Fill(DS);

            m_dic_meta_info_Table = DS.Tables[0];
            if (m_dic_meta_info_Table.Rows.Count == 0)
            {
                if (DialogResult.Yes == MessageBox.Show("没有任何关于" + tablename_comboBox.Text + "表的相关数据!是否要自动添加所有记录", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1))
                {
                    for (int index = 0; index < fieldname_comboBox.Items.Count; index++)
                    {
                        System.Data.DataRow dataRow;
                        dataRow = m_dic_meta_info_Table.NewRow();
                        dataRow.BeginEdit();
                        dataRow["tablename"]     = (tablename_comboBox.Text.Trim() == "" ? null : tablename_comboBox.Text.Trim());
                        dataRow["fieldname"]     = fieldname_comboBox.Items[index].ToString().Trim();
                        dataRow["fieldcnname"]   = null;
                        dataRow["editortype"]    = "text";
                        dataRow["catname"]       = null;
                        dataRow["orderno"]       = "0";
                        dataRow["description"]   = null;
                        dataRow["listtable"]     = null;
                        dataRow["listcondition"] = null;
                        dataRow["keyfield"]      = null;
                        dataRow["listfield"]     = null;
                        dataRow["listvalues"]    = null;
                        dataRow["visible"]       = 1;
                        dataRow["readonly"]      = 0;
                        m_dic_meta_info_Table.Rows.Add(dataRow);
                        dataRow.EndEdit();
                    }
                    try
                    {
                        //使用SqlCommandBuilder  对像填充SqlDataAdapter 的InsertCommand、DeleteCommand、UpdateCommand对像
                        SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(m_adp);
                        m_adp.UpdateCommand = cmdBuilder.GetUpdateCommand();

                        int val = m_adp.Update(m_dic_meta_info_Table);
                        m_dic_meta_info_Table.AcceptChanges();
                    }
                    catch (Exception ex)
                    {
                        //  m_dic_meta_info_Table.Rows[m_dic_meta_info_Table.Rows.Count - 1].Delete();
                        MessageBox.Show(ex.Message);
                    }
                }
            }
            //DataColumn[] primarKey = new DataColumn[1];
            //primarKey[0] = m_dic_meta_info_Table.Columns["fieldname"];
            //m_dic_meta_info_Table.PrimaryKey = primarKey;
            dataGridView1.DataSource = m_dic_meta_info_Table;
        }
Beispiel #58
0
        private void add_button_Click(object sender, EventArgs e)
        {
            // int editortypeID = editortype_comboBox.SelectedIndex;
            System.Data.DataRow dataRow;
            dataRow = m_dic_meta_info_Table.NewRow();
            dataRow.BeginEdit();
            dataRow["tablename"]     = (tablename_comboBox.Text.Trim() == "" ? null : tablename_comboBox.Text.Trim());
            dataRow["fieldname"]     = fieldname_comboBox.Text.Trim();
            dataRow["fieldcnname"]   = fieldcnnametxt.Text.Trim() == "" ? null : fieldcnnametxt.Text.Trim();
            dataRow["editortype"]    = EditorTypeEn[editortype_comboBox.SelectedIndex];
            dataRow["catname"]       = catname_comboBox.Text.Trim() == "" ? null : catname_comboBox.Text.Trim();
            dataRow["orderno"]       = "0";
            dataRow["description"]   = descriptiontxt.Text.Trim() == "" ? null : descriptiontxt.Text.Trim();
            dataRow["listtable"]     = listtable_comboBox.Text.Trim() == "" ? null : listtable_comboBox.Text.Trim();
            dataRow["listcondition"] = listconditiontxt.Text.Trim() == "" ? null : listconditiontxt.Text.Trim();
            dataRow["keyfield"]      = keyfield_comboBox.Text.Trim() == "" ? null : keyfield_comboBox.Text.Trim();
            dataRow["listfield"]     = listfield_comboBox.Text.Trim() == "" ? null : listfield_comboBox.Text.Trim();
            dataRow["listvalues"]    = txtBoxListValues.Text.Trim();
            dataRow["relativepath"]  = txtBoxRelativePath.Text.Trim();
            dataRow["visible"]       = visible_checkBox.Checked ? 1 : 0;
            dataRow["readonly"]      = readonly_checkBox.Checked ? 1 : 0;
            m_dic_meta_info_Table.Rows.Add(dataRow);
            dataRow.EndEdit();

            try
            {
                SqlDataAdapter adapter = m_adp;

                ////使用SqlCommandBuilder  对像填充SqlDataAdapter 的InsertCommand、DeleteCommand、UpdateCommand对像
                SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapter);
                adapter.InsertCommand = cmdBuilder.GetInsertCommand();

                int val = adapter.Update(m_dic_meta_info_Table);
                m_dic_meta_info_Table.AcceptChanges();
                this.dataGridView1.CurrentCell = this.dataGridView1.Rows[0].Cells[0];

                // 更新类别名下拉框
                FillCatNames(this.tablename_comboBox.Text);
            }
            catch (Exception ex)
            {
                m_dic_meta_info_Table.Rows[m_dic_meta_info_Table.Rows.Count - 1].Delete();
                MessageBox.Show(ex.Message);
            }
        }
Beispiel #59
0
        public System.Data.DataTable BuhinAutoFixExcelFileCSVConvertXLS(System.Data.DataTable _dtbSource)
        {
            #region 20161214 - BotFJP - Delete columns not use
            for (int i = _dtbSource.Columns.Count - 1; i >= 0; i--)
            {
                if (new[] { 29, 31, 33 }.Contains(i))
                {
                    continue;
                }
                else
                {
                    _dtbSource.Columns.RemoveAt(i);
                }
            }

            _dtbSource.Columns[0].ColumnName = "納期";
            _dtbSource.Columns[2].ColumnName = "図面番号";
            //部品=>組込番号          製品=>受注番号
            _dtbSource.Columns[1].ColumnName = "組込番号";

            _dtbSource.AcceptChanges();

            #endregion

            #region 20161214 - BotFJP - Fix data 納期
            //IF 納期 月 1,2 => Replace 年 = 年 + 1
            foreach (DataRow _row in _dtbSource.Rows)
            {
                if (new string[] { "1", "2" }.Contains(_row["納期"].ToString().Split('/')[0]))
                {
                    _row["納期"] = _row["納期"].ToString().Replace("2016", "2017");
                }
            }
            _dtbSource.AcceptChanges();
            #endregion

            #region 20161214 - BotFJP - Add column Status and 注文番号
            DataColumn _newcol = new DataColumn("Status", typeof(string));
            _newcol.DefaultValue = "True";
            _dtbSource.Columns.Add(_newcol);
            _dtbSource.AcceptChanges();

            #endregion
            return(_dtbSource);
        }