protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; var datos = new DataTable(); datos.Columns.Add("Nombre"); datos.Columns.Add("Activo"); var row = datos.NewRow(); row["Nombre"] = "Palma"; row["Activo"] = "Si"; datos.Rows.Add(row); row = datos.NewRow(); row["Nombre"] = "Caucho"; row["Activo"] = "Si"; datos.Rows.Add(row); row = datos.NewRow(); row["Nombre"] = "Café"; row["Activo"] = "Si"; datos.Rows.Add(row); ViewState["Datos"] = datos; ViewState["ckbActivarFiltro"] = ""; }
public override DataTable ReturnDataTable(string param) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("ID")); dt.Columns.Add(new DataColumn("State")); dt.Columns.Add(new DataColumn("Population")); DataRow r = dt.NewRow(); r[0] = "1"; r[1] = "NY"; r[2] = "8002"; dt.Rows.Add(r); DataRow r2 = dt.NewRow(); r2[0] = "2"; r2[1] = "CO"; r2[2] = "6003"; dt.Rows.Add(r2); DataRow r3 = dt.NewRow(); r3[0] = "3"; r3[1] = "CA"; r3[2] = "7200"; dt.Rows.Add(r3); return dt; }
protected void BuildGrade() { DataTable dtNew = new DataTable(); dtNew.Columns.Add("DropdownText"); dtNew.Columns.Add("Grade"); dtNew.Columns.Add("CmbText"); DataRow newRow = dtNew.NewRow(); newRow["DropdownText"] = "All"; newRow["Grade"] = "All"; newRow["CmbText"] = "Grade"; dtNew.Rows.Add(newRow); foreach (var sub in _alllcos.Select(lco => lco.Grade).Distinct().ToList()) { newRow = dtNew.NewRow(); newRow["DropdownText"] = sub; newRow["Grade"] = sub; newRow["CmbText"] = sub; dtNew.Rows.Add(newRow); } cmbGrade.DataTextField = "CmbText"; cmbGrade.DataValueField = "Grade"; cmbGrade.DataSource = dtNew; cmbGrade.DataBind(); RadComboBoxItem item = this.cmbGrade.Items.FindItemByValue((String)this.ViewState[_gradeFilterKey], true) ?? this.cmbGrade.Items[0]; ViewState[_gradeFilterKey] = item.Value; Int32 selIdx = cmbGrade.Items.IndexOf(item); cmbGrade.SelectedIndex = selIdx; }
public static DataTable DT_Quy_QuyetToan(Boolean All = true) { DataTable vR = new DataTable(); vR.Columns.Add("MaQuy", typeof(String)); vR.Columns.Add("TenQuy", typeof(String)); DataRow R = vR.NewRow(); R["MaQuy"] = "1"; R["TenQuy"] = "Quý I"; vR.Rows.InsertAt(R, 1); DataRow R1 = vR.NewRow(); R1["MaQuy"] = "2"; R1["TenQuy"] = "Quý II"; vR.Rows.InsertAt(R1, 2); DataRow R2 = vR.NewRow(); R2["MaQuy"] = "3"; R2["TenQuy"] = "Quý III"; vR.Rows.InsertAt(R2, 3); DataRow R4 = vR.NewRow(); R4["MaQuy"] = "4"; R4["TenQuy"] = "Quý IV"; vR.Rows.InsertAt(R4, 4); if (All) { vR.Rows.InsertAt(vR.NewRow(), 0); vR.Rows[0]["MaQuy"] = "-1"; vR.Rows[0]["TenQuy"] = "-- Quý --"; } return vR; }
public static DataTable tipoDePagamento() { try { DataTable tabela = new DataTable("Tipo"); ; DataColumn Coluna; Coluna = new DataColumn(); Coluna.DataType = typeof(string); Coluna.ColumnName = "Codigo"; tabela.Columns.Add(Coluna); DataRow linha = null; linha = tabela.NewRow(); linha["Codigo"] = "ID"; tabela.Rows.Add(linha); linha = tabela.NewRow(); linha["Codigo"] = "Código"; tabela.Rows.Add(linha); linha = tabela.NewRow(); linha["Codigo"] = "Nome"; tabela.Rows.Add(linha); linha = tabela.NewRow(); linha["Codigo"] = "Categoria"; tabela.Rows.Add(linha); linha = tabela.NewRow(); return tabela; } catch (Exception Erro) { throw new Exception(Erro.Message); } }
public ColumnInformationSave() { DataContext = this; InitializeComponent(); SourceTable = new DataTable(); SourceTable.Columns.Add(new DataColumn("GameName", typeof (string))); SourceTable.Columns.Add(new DataColumn("Creator", typeof (string))); SourceTable.Columns.Add(new DataColumn("Publisher", typeof (string))); SourceTable.Columns.Add(new DataColumn("Owner", typeof (string))); var row = SourceTable.NewRow(); SourceTable.Rows.Add(row); row["GameName"] = "World Of Warcraft"; row["Creator"] = "Blizzard"; row["Publisher"] = "Blizzard"; row["Owner"] = "Mark"; row = SourceTable.NewRow(); SourceTable.Rows.Add(row); row["GameName"] = "Halo"; row["Creator"] = "Bungie"; row["Publisher"] = "Microsoft"; row["Owner"] = "Bill"; row = SourceTable.NewRow(); SourceTable.Rows.Add(row); row["GameName"] = "Gears Of War"; row["Creator"] = "Epic"; row["Publisher"] = "Microsoft"; row["Owner"] = "Steve"; codeViewer.LoadData("ColumnInformationSave"); }
public void Display_HighScores() { DataTable myTable = new DataTable(); DataRow myNewRow = myTable.NewRow(); int count = 1; myTable.Columns.Add("Rank", typeof(int)); myTable.Columns.Add("Name", typeof(string)); myTable.Columns.Add("Score", typeof(string)); SqlConnection con = new SqlConnection("Data Source=KARL-PC;Initial Catalog=TestDB2;Integrated Security=True"); con.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM highscores_default ORDER BY score DESC", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow dr in dt.Rows) { if (count <= 10) { myNewRow = myTable.NewRow(); myNewRow["Rank"] = count++; myNewRow["Name"] = dr["name"].ToString(); myNewRow["Score"] = dr["score"].ToString(); myTable.Rows.Add(myNewRow); } } dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = new BindingSource(myTable, null); con.Close(); }
private void AddShiRows(DataTable table, String group, string sheng) { foreach (string shi in SHI_JSON[sheng]) { DataRow row = table.NewRow(); row[0] = GenerateNextID(); row[1] = shi; row[2] = group; row[3] = 1; table.Rows.Add(row); JArray xianArray = (JArray)XIAN_JSON[shi]; if (xianArray != null) { foreach (string xian in xianArray) { row = table.NewRow(); row[0] = GenerateNextID(); row[1] = xian; row[2] = group; row[3] = 2; table.Rows.Add(row); } } } }
private void MontarDadosFake() { var tabela1 = new DataTable("Talela1"); tabela1.Columns.Add("col_a"); tabela1.Columns.Add("col_b"); tabela1.Columns.Add("col_c"); this.ds.Tables.Add(tabela1); var tabela2 = new DataTable("Talela2"); tabela2.Columns.Add("col_1"); tabela2.Columns.Add("col_2"); tabela2.Columns.Add("col_3"); this.ds.Tables.Add(tabela2); var linha1 = tabela1.NewRow(); tabela1.Rows.Add(linha1); linha1["col_a"] = "Edson"; linha1["col_b"] = "Parizoti"; linha1["col_c"] = "Junior"; var linha1T2 = tabela2.NewRow(); tabela2.Rows.Add(linha1T2); linha1T2["col_1"] = "C#"; linha1T2["col_2"] = 50M; linha1T2["col_3"] = DateTime.Today; var linha2T2 = tabela2.NewRow(); tabela2.Rows.Add(linha2T2); linha2T2["col_1"] = "Java"; linha2T2["col_2"] = 50M; linha2T2["col_3"] = DateTime.Today.AddDays(5); }
protected void radGridReview_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("ReperenceNo"); dt.Columns.Add("CustomerAccount"); dt.Columns.Add("AmtLCY"); dt.Columns.Add("AmtFCY"); dt.Columns.Add("Status"); dt.Columns.Add("LCCode"); DataRow dr = dt.NewRow(); dr["ReperenceNo"] = "TT/09161/078911"; dr["CustomerAccount"] = "BANK OF SHANGHAI"; dr["AmtLCY"] = "2,000,0000"; dr["AmtFCY"] = "100.00"; dr["Status"] = "UNA"; dr["LCCode"] = "1"; dt.Rows.Add(dr); DataRow dr1 = dt.NewRow(); dr1["ReperenceNo"] = "TT/09161/078912"; dr1["CustomerAccount"] = "CITI BANK NEWYORK"; dr1["AmtLCY"] = "4,000,0000"; dr1["AmtFCY"] = "200.00"; dr1["Status"] = "UNA"; dr1["LCCode"] = "2"; dt.Rows.Add(dr1); radGridReview.DataSource = dt; }
public void SetTable1() { dt1 = new DataTable(); DataRow dr; dt1.Columns.Add(new DataColumn("1")); dt1.Columns.Add(new DataColumn("2")); dt1.Columns.Add(new DataColumn("3")); dt1.Columns.Add(new DataColumn("4")); dr = dt1.NewRow(); dr[0] = ""; dr[1] = "Name 姓名"; dr[2] = "Company 公司"; dr[3] = "Department 部门"; dt1.Rows.Add(dr); dr = dt1.NewRow(); dr[0] = "Chinese 中文"; dr[1] = ((TextBox)DataForm1.FindControl("txtUserName")).Text; dr[2] = "西雅衣家(中国)商业有限公司"; dr[3] = ((TextBox)DataForm1.FindControl("txtDeptName")).Text; dt1.Rows.Add(dr); dr = dt1.NewRow(); dr[0] = "English 英文"; dr[1] = ((TextBox)DataForm1.FindControl("txtEnglishName")).Text; dr[2] = "C&A (China) Co., Ltd."; dr[3] = ((TextBox)DataForm1.FindControl("txtEnglishDept")).Text; dt1.Rows.Add(dr); }
public void GetDelimitedStringTest() { DataTable table = new DataTable(); table.Columns.Add(new DataColumn("Column1", typeof(string))); table.Columns.Add(new DataColumn("Column2", typeof(int))); table.Columns.Add(new DataColumn("Column3", typeof(DateTime))); DataRow row = table.NewRow(); table.Rows.Add(row); row["Column1"] = "Cell1"; row["Column2"] = 1; row["Column3"] = DateTime.MinValue; row = table.NewRow(); table.Rows.Add(row); row["Column1"] = "Cell2"; row["Column2"] = 2; row["Column3"] = DateTime.MaxValue; DataView source = table.DefaultView; // TODO: Initialize to an appropriate value string rowDelimiter = "\r\n"; // TODO: Initialize to an appropriate value string columnDelimiter = ","; // TODO: Initialize to an appropriate value bool includeHeaders = true; // TODO: Initialize to an appropriate value string expected = "Column1,Column2,Column3\r\nCell1,1,1/1/0001 12:00:00 AM\r\nCell2,2,12/31/9999 11:59:59 PM"; // TODO: Initialize to an appropriate value string actual; actual = Extensions.GetDelimitedString(source, rowDelimiter, columnDelimiter, includeHeaders); Assert.AreEqual(expected, actual); }
public void SetCombo(System.Windows.Forms.ComboBox Acombo) { string sql; DataTable workDT = new DataTable(); DataRow row; workDT.Columns.Add("id", typeof(int)); workDT.Columns.Add("desc"); StatusVsel workDS = new StatusVsel(); sql = String.Format("Select * from tdbadmin.tdbv_stasel where s_id = {0} and typ = {1} order by bez", tdb.User.Ulangid, status_typ); FillDS(workDS, sql, new string[] { "tdbv_stasel" }); foreach (StatusVsel.tdbv_staselRow Rwork in workDS.tdbv_stasel) { row = workDT.NewRow(); row["id"] = Rwork.STA_ID; row["desc"] = Rwork.BEZ; workDT.Rows.Add(row); } if (optional == true) { row = workDT.NewRow(); row["id"] = (int)-1; row["desc"] = ""; workDT.Rows.Add(row); } Acombo.DataSource = workDT; Acombo.DisplayMember = "desc"; Acombo.ValueMember = "id"; }
private void axMapControl1_OnDoubleClick(object sender, IMapControlEvents2_OnDoubleClickEvent e) { DataTable dt = new DataTable(); dt.Columns.Add("name", typeof(string)); dt.Columns.Add("value", typeof(string)); DataRow dr = dt.NewRow(); dr["name"] = "行政区"; dr["value"] = "沈阳"; dt.Rows.Add(dr); DataRow dr2 = dt.NewRow(); dr2["name"] = "面积"; dr2["value"] = "1234.345"; dt.Rows.Add(dr2); DataRow dr3 = dt.NewRow(); dr3["name"] = "交通轨道长度"; dr3["value"] = "1235.223"; dt.Rows.Add(dr3); DataRow dr4 = dt.NewRow(); dr4["name"] = "GDP总量"; dr4["value"] = "234345"; dt.Rows.Add(dr4); Control control = (Control)sender; System.Drawing.Point pt = control.PointToScreen(new System.Drawing.Point(e.x, e.y)); frmMapFeatureAttr pFrmMapFeatureAttr = new frmMapFeatureAttr(); pFrmMapFeatureAttr.AttrDataTable = dt; pFrmMapFeatureAttr.Location = pt; pFrmMapFeatureAttr.Show(); }
public void SetCombo(System.Windows.Forms.ComboBox Acombo) { DataTable workDT = new DataTable(); DataRow row; ServVsel workDS = new ServVsel(); workDT.Columns.Add("id", typeof(int)); workDT.Columns.Add("desc"); FillDS(workDS, selectionsql, new string[] { "tdbv_servsel" }); foreach (ServVsel.tdbv_servselRow Rwork in workDS.tdbv_servsel) { row = workDT.NewRow(); row["id"] = Rwork.SERV_ID; row["desc"] = Rwork.BEZ; workDT.Rows.Add(row); } if (optional == true) { row = workDT.NewRow(); row["id"] = (int)-1; row["desc"] = ""; workDT.Rows.Add(row); } Acombo.DataSource = workDT; Acombo.DisplayMember = "desc"; Acombo.ValueMember = "id"; }
void MainForm_Load (object sender, EventArgs e) { DataTable dataTable = new DataTable (); dataTable.Columns.Add ("displaymember"); dataTable.Columns.Add ("valuemember"); DataRow row = dataTable.NewRow (); row [0] = "lower"; row [1] = "a"; dataTable.Rows.Add (row); row = dataTable.NewRow (); row [0] = "upper"; row [1] = "A"; dataTable.Rows.Add (row); row = dataTable.NewRow (); row [0] = "else"; row [1] = "e"; dataTable.Rows.Add (row); row = dataTable.NewRow (); row [0] = "inter"; row [1] = "i"; dataTable.Rows.Add (row); row = dataTable.NewRow (); row [0] = "net"; row [1] = "I"; dataTable.Rows.Add (row); _comboBox.DataSource = dataTable; _comboBox.DataBindings.Add ("SelectedValue", new Controller (_selectedValueText), "controlsrc"); InstructionsForm instructionsForm = new InstructionsForm (); instructionsForm.Show (); }
protected DataTable GetClassDataTable() { DataTable table = new DataTable(); table.Columns.Add(new DataColumn("Id", typeof(int))); table.Columns.Add(new DataColumn("Name", typeof(String))); table.Columns.Add(new DataColumn("EntranceYear", typeof(String))); table.Columns.Add(new DataColumn("LogTime", typeof(DateTime))); table.Columns.Add(new DataColumn("Desc", typeof(string))); DataRow row = table.NewRow(); row[0] = 101; row[1] = "班级一"; row[2] = "2000"; row[3] = DateTime.Parse("2000-09-01"); row[4] = "班级一创建于2000年9月1号,班长胡飞,连续三年获得全校优秀班级称号。"; table.Rows.Add(row); row = table.NewRow(); row[0] = 102; row[1] = "班级二"; row[2] = "2005"; row[3] = DateTime.Parse("2005-09-01"); row[4] = "班级一创建于2005年9月1号,班长董婷婷,连续两年获得全校优秀班级称号。"; table.Rows.Add(row); return table; }
public static System.Data.DataTable ReklamTipleri() { System.Data.DataTable dt = new System.Data.DataTable("ReklamTipleri"); dt.Columns.Add("Key", typeof(string)); dt.Columns.Add("Value", typeof(string)); System.Data.DataRow dr = dt.NewRow(); dr[0] = "728x90"; dr[1] = "728x90 Orta Blok"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "650x80"; dr[1] = "650x80 Orta Blok"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "468x60"; dr[1] = "468x60 Orta Blok"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "300x250"; dr[1] = "300x250 İçerik Arası"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "250x250"; dr[1] = "250x250 Sol Blok"; dt.Rows.Add(dr); return(dt); }
private DataTable Table_Define() { DataTable _Dt = new DataTable(); DataColumn DC = new DataColumn(); DC.ColumnName = "SiNo"; _Dt.Columns.Add(DC); DC = new DataColumn(); DC.ColumnName = "Name"; _Dt.Columns.Add(DC); DC = new DataColumn(); DC.ColumnName = "Status"; _Dt.Columns.Add(DC); DataRow dr = _Dt.NewRow(); dr[0] = "1"; dr[1] = "New Application"; dr[2] = "Passed"; _Dt.Rows.Add(dr); dr = _Dt.NewRow(); dr[0] = "2"; dr[1] = "Eclipse Application"; dr[2] = "Applied"; _Dt.Rows.Add(dr); dr = _Dt.NewRow(); dr[0] = "3"; dr[1] = "Sigma Application"; dr[2] = "Applied"; _Dt.Rows.Add(dr); return _Dt; }
public static System.Data.DataTable SayfaTipleri() { System.Data.DataTable dt = new System.Data.DataTable("SayfaTipleri"); dt.Columns.Add("Key", typeof(byte)); dt.Columns.Add("Value", typeof(string)); System.Data.DataRow dr = dt.NewRow(); dr[0] = 0; dr[1] = "<Seçiniz>"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 1; dr[1] = "Üst Menü"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 2; dr[1] = "Alt Menü"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 3; dr[1] = "Sol Menü"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 4; dr[1] = "Sağ Menü"; dt.Rows.Add(dr); return(dt); }
public void Map() { DataTable dt = new DataTable(); DataRow row = null; IDataReader dataReader = null; dt.Columns.Add(new DataColumn("id", typeof(int))); dt.Columns.Add(new DataColumn("name", typeof(string))); dt.Columns.Add(new DataColumn("prop01", typeof(int))); dt.Columns.Add(new DataColumn("unset")); row = dt.NewRow(); row["id"] = 5; row["name"] = "idIs5"; row["prop01"] = DBNull.Value; dt.Rows.Add(row); row = dt.NewRow(); row["id"] = DBNull.Value; row["name"] = "idWithDBNull"; row["prop01"] = 2; dt.Rows.Add(row); dataReader = dt.CreateDataReader(); var entities = FieldMapper.Map<MyEntity01>(new FieldAdoDataReader(dataReader)).ToList(); Assert.IsTrue(entities.Count == 2, "All entities are created"); Assert.IsTrue(entities[0].Id == 5, "Field mapping of int is correct"); Assert.IsTrue(entities[0].Name == "idIs5", "Field mapping of string is correct"); Assert.IsTrue(entities[0].Prop01 == 99, "Field custom default value is set"); Assert.IsTrue(entities[0].Unset == default(string), "Field decorated but not returned by the data source is mapped with type's default value"); Assert.IsTrue(entities[0].UnsetWithDefaultValue == "unset", "Field decorated but not returned by the data source is mapped with field's default value"); Assert.IsTrue(entities[0].IgnoreDecorated == default(string), "Field decorated with [Ignore] is ignored"); Assert.IsTrue(entities[0].IgnoreNotDecorated == default(string), "Field not decorated with [Ignore] but not returned by the data source is ignored"); Assert.IsTrue(entities[1].Id == default(int), "Field mapping of int with DBNull value is correct"); Assert.IsTrue(entities[1].Prop01 == 2, "Field with default value is mapped with its' correct value if provided by the data source"); }
public static System.Data.DataTable HesapTipleri() { System.Data.DataTable dt = new System.Data.DataTable("HesapTipleri"); dt.Columns.Add("Key", typeof(byte)); dt.Columns.Add("Value", typeof(string)); System.Data.DataRow dr = dt.NewRow(); dr[0] = 0; dr[1] = "<Seçiniz>"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 1; dr[1] = "Admin"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 2; dr[1] = "Moderator"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 3; dr[1] = "Editor"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 4; dr[1] = "Standart"; dt.Rows.Add(dr); return(dt); }
public UcQuarantineRecord(IDBOperation dbOperation) { InitializeComponent(); this.dbOperation = dbOperation; //检疫员所属部门货主信息flag,屠宰场名称,检疫分站名称 DataTable table = dbOperation.GetDbHelper().GetDataSet("select ifnull(a.shipperflag,'') as shipperflag, " + " tzcname,INFO_NAME" + " from sys_client_sysdept a " + " where INFO_CODE = " + deptId).Tables[0]; if (table.Rows.Count != 0) { shipperflag = table.Rows[0][0].ToString(); _detect_site.Text = table.Rows[0][2].ToString(); _slaughter_site.Text = table.Rows[0][1].ToString(); } //申报人姓名 ComboboxTool.InitComboboxSource(_shipper_name, string.Format("SELECT sbrid,sbrname FROM t_record_sbr WHERE openflag = '1' and createdeptid = '{0}'", deptId), "lr"); //产地 ComboboxTool.InitComboboxSource(_address, string.Format("SELECT areaid,areaname FROM t_record_area WHERE openflag = '1' and createdeptid = '{0}'", deptId), "lr"); //协检员 ComboboxTool.InitComboboxSource(_help_user, string.Format("call p_user_helpuser({0})", userId), "lr"); //官方兽医姓名 _user_name.Text = username; //录入时间 _entering_datetime.Text = string.Format("{0:g}", System.DateTime.Now); //屠宰动物种类 ComboboxTool.InitComboboxSource(_animal, "SELECT animalid,animalname FROM t_animal_new WHERE openflag = '1' and deptflag = '" + shipperflag + "'", "lr"); _animal.SelectionChanged += new SelectionChangedEventHandler(_animal_SelectionChanged); _animal.SelectedIndex = 1; //临床情况 DataTable dt_quater = new DataTable(); dt_quater.Columns.Add(new DataColumn("quaterid")); dt_quater.Columns.Add(new DataColumn("quatername")); var row = dt_quater.NewRow(); row["quaterid"] = "0"; row["quatername"] = "良好"; dt_quater.Rows.Add(row); var row2 = dt_quater.NewRow(); row2["quaterid"] = "1"; row2["quatername"] = "异常"; dt_quater.Rows.Add(row2); ComboboxTool.InitComboboxSource(_quater, dt_quater, "lr"); //是否佩戴规定的畜禽标识 DataTable dt_object_flag = new DataTable(); dt_object_flag.Columns.Add(new DataColumn("flagid")); dt_object_flag.Columns.Add(new DataColumn("flagname")); var row3 = dt_object_flag.NewRow(); row3["flagid"] = "1"; row3["flagname"] = "是"; dt_object_flag.Rows.Add(row3); var row4 = dt_object_flag.NewRow(); row4["flagid"] = "0"; row4["flagname"] = "否"; dt_object_flag.Rows.Add(row4); ComboboxTool.InitComboboxSource(_object_flag, dt_object_flag, "lr"); }
/// <summary> /// Constructor fills static values. /// </summary> static UserRights() { m_dataTable = new DataTable(); m_dataTable.Columns.Add("Id"); m_dataTable.Columns.Add("Name"); DataRow dr = m_dataTable.NewRow(); dr["Id"] = "N"; dr["Name"] = "Nem tartozik szervezethez"; m_dataTable.Rows.Add(dr); dr = m_dataTable.NewRow(); dr["Id"] = "R"; dr["Name"] = "Olvasási jog"; m_dataTable.Rows.Add(dr); dr = m_dataTable.NewRow(); dr["Id"] = "W"; dr["Name"] = "Írási jog"; m_dataTable.Rows.Add(dr); dr = m_dataTable.NewRow(); dr["Id"] = "A"; dr["Name"] = "Adminisztrátor"; m_dataTable.Rows.Add(dr); m_hashTable = new Hashtable(); foreach (DataRow r in m_dataTable.Rows) { m_hashTable.Add(r["Id"], r["Name"]); } }
public void SetCombo(System.Windows.Forms.ComboBox Acombo) { DataTable workDT = new DataTable(); DataRow row; string arrbez; ArrVsel workDS = new ArrVsel(); workDT.Columns.Add("id", typeof(int)); workDT.Columns.Add("desc"); FillDS(workDS, selectionsql, new string[] { "tdbv_arrsel" }); foreach (ArrVsel.tdbv_arrselRow Rwork in workDS.tdbv_arrsel) { arrbez = String.Format("{0} {1}", Rwork.BEZ, Rwork.ADAT.ToString()); row = workDT.NewRow(); row["id"] = Rwork.ARR_ID; row["desc"] = arrbez; workDT.Rows.Add(row); } if (optional == true) { row = workDT.NewRow(); row["id"] = (int)-1; row["desc"] = ""; workDT.Rows.Add(row); } Acombo.DataSource = workDT; Acombo.DisplayMember = "desc"; Acombo.ValueMember = "id"; }
private DataSet GetSubTotal() { var list = this.Horas; var dataSet = new DataSet(); var table = new DataTable("table"); System.Data.DataRow row; table.Columns.Add("nmFuncionario", Type.GetType("System.String")); table.Columns.Add("salario", Type.GetType("System.Decimal")); table.Columns.Add("porcentagem", Type.GetType("System.Decimal")); table.Columns.Add("flTipo", Type.GetType("System.String")); table.Columns.Add("hora", Type.GetType("System.TimeSpan")); table.Columns.Add("valor", Type.GetType("System.Decimal")); decimal? total = 0; foreach (var item in list.OrderByDescending(u => u.nmFuncionario)) { row = table.NewRow(); row["nmFuncionario"] = item.nmFuncionario; row["flTipo"] = item.flTipo; row["valor"] = item.valor; table.Rows.Add(row); row = table.NewRow(); row["nmFuncionario"] = item.nmFuncionario; row["flTipo"] = "Valor do Descanso Semanal"; row["valor"] = item.valor/26 * 5; table.Rows.Add(row); } dataSet.Tables.Add(table); return dataSet; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = new DataTable(); dt.Columns.Add("Product_Id", typeof(Int32)); dt.Columns.Add("Product_Name", typeof(string)); var dr = dt.NewRow(); dr[0] = 1; dr[1] = "Monitors"; dt.Rows.Add(dr); var dr2 = dt.NewRow(); dr2[0] = 2; dr2[1] = "Laptops"; dt.Rows.Add(dr2); var dr3 = dt.NewRow(); dr3[0] = 3; dr3[1] = "Bikes"; dt.Rows.Add(dr3); //DataTabe should be filled from database.... ddlProducts.DataValueField = "Product_Id"; ddlProducts.DataTextField = "Product_Name"; ddlProducts.DataSource = dt; ddlProducts.DataBind(); } }
public void LoadContactDetail(int?ParentId, int eParentType) { bool IsDefault = true; var dtContacts = new System.Data.DataTable(); dtContacts.Columns.Add("PK"); dtContacts.Columns.Add(CS.ContactId); dtContacts.Columns.Add(CS.ContactName); dtContacts.Columns.Add(CS.ContactText); if (ParentId.HasValue) { var DBdtContacts = new Query() { ParentId = ParentId, eParentType = eParentType, }.Select(eSP.qry_Contacts); if (DBdtContacts.Rows.Count > 0) { IsDefault = false; int i = 0; foreach (System.Data.DataRow DBdrContacts in DBdtContacts.Rows) { i++; var drContacts = dtContacts.NewRow(); drContacts["PK"] = i; drContacts[CS.ContactId] = DBdrContacts[CS.ContactId]; drContacts[CS.ContactName] = DBdrContacts[CS.ContactName]; drContacts[CS.ContactText] = DBdrContacts[CS.ContactText]; dtContacts.Rows.Add(drContacts); } } } if (IsDefault) { var drContacts = dtContacts.NewRow(); drContacts["PK"] = 1; drContacts[CS.ContactId] = string.Empty; drContacts[CS.ContactName] = string.Empty; drContacts[CS.ContactText] = string.Empty; dtContacts.Rows.Add(drContacts); } rptContacts.DataSource = dtContacts; rptContacts.DataBind(); ViewState["dtContacts"] = dtContacts; }
public static System.Data.DataTable SiraNumaralari() { System.Data.DataTable dt = new System.Data.DataTable("SiraNumaralari"); dt.Columns.Add("Key", typeof(byte)); dt.Columns.Add("Value", typeof(string)); System.Data.DataRow dr = dt.NewRow(); for (int i = 0; i < 25; i++) { dr = dt.NewRow(); dr[0] = i.ToString(); dr[1] = (i + 1) + ". Sıra"; dt.Rows.Add(dr); } return(dt); }
public static System.Data.DataTable MesajDurumlari() { System.Data.DataTable dt = new System.Data.DataTable("MesajDurumlari"); dt.Columns.Add("Key", typeof(byte)); dt.Columns.Add("Value", typeof(string)); System.Data.DataRow dr = dt.NewRow(); dr[0] = 1; dr[1] = "Okunmadı olarak işaretlendi!"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 2; dr[1] = "Okundu olarak işaretlendi."; dt.Rows.Add(dr); return(dt); }
public static double Evaluate(string expression) { System.Data.DataTable table = new System.Data.DataTable(); table.Columns.Add("expression", string.Empty.GetType(), expression); System.Data.DataRow row = table.NewRow(); table.Rows.Add(row); return(double.Parse((string)row["expression"])); }
public static System.Data.DataTable YayimlamaDurumlari() { System.Data.DataTable dt = new System.Data.DataTable("YayimlamaDurumlari"); dt.Columns.Add("Key", typeof(bool)); dt.Columns.Add("Value", typeof(string)); System.Data.DataRow dr = dt.NewRow(); dr[0] = 0; dr[1] = "Sadece Ben ve Hasta"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 1; dr[1] = "Herkese Açık!"; dt.Rows.Add(dr); return(dt); }
protected void btnExport_Click(object sender, EventArgs e) { System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add(new System.Data.DataColumn(SupplierProfileStrings.GetText(@"OrderId"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SupplierProfileStrings.GetText(@"OrderDate"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SupplierProfileStrings.GetText(@"BidId"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SupplierProfileStrings.GetText(@"TotalPrice"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SupplierProfileStrings.GetText(@"ApprovedDeal"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SupplierProfileStrings.GetText(@"DealDetails"), typeof(string))); int year = Convert.ToInt32(ddlyear.SelectedValue); int month = Convert.ToInt32(ddlMonth.SelectedValue); int from = Convert.ToInt32(ddlDayFrom.SelectedValue); int to = Convert.ToInt32(ddlDayTo.SelectedValue); DateTime?start = null; DateTime?end = null; if (year != 0 && month != 0 && from != 0) { start = new DateTime(year, month, from); end = (to != 0 ? new DateTime(year, month, to) : end = new DateTime(year, month, DateTime.DaysInMonth(year, month))); } else if (year != 0 && month != 0) { start = new DateTime(year, month, 1); end = new DateTime(year, month, DateTime.DaysInMonth(year, month)); } else if (year != 0) { start = new DateTime(year, 1, 1); end = new DateTime(year, 12, 31); } List <OrderUI> orders = OrderController.GetOrderSupplierHistoryExcel(SuppliersSessionHelper.SupplierId(), start, end); foreach (OrderUI order in orders) { int i = 0; System.Data.DataRow row = dt.NewRow(); row[i++] = order.OrderId; row[i++] = order.OrderDate; row[i++] = order.BidId; row[i++] = order.Price; row[i++] = GlobalStrings.GetYesNo(order.IsPayed); row[i++] = ListTostring(order.LstProduct); dt.Rows.Add(row); } SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, true, true); Response.Clear(); Response.AddHeader(@"content-disposition", @"attachment;filename=Deals_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension); Response.Charset = @"UTF-8"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = ex.FileContentType; Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble()); Response.Write(ex.ToString()); Response.End(); }
protected void btnExport_Click(object sender, EventArgs e) { System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"ProductName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"ProductCode"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"Amount"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"RecomendedPrice"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"Description"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"AnimalType"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"ProductPrice"), typeof(string))); //dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"Category"), typeof(string))); // dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"SubCategory"), typeof(string))); // dt.Columns.Add(new System.Data.DataColumn(ProductsStrings.GetText(@"ProductRate"), typeof(string))); string searchCode = "%" + txtSearch.Text.Trim() + "%"; List <ProductUI> products = ProductController.GetAllProductUI(searchCode, Int64.Parse(ddlCategory.SelectedValue), Int64.Parse(ddlSubCategory.SelectedValue)); foreach (ProductUI product in products) { int i = 0; System.Data.DataRow row = dt.NewRow(); row[i++] = product.ProductName; row[i++] = product.ProductCode; row[i++] = product.Amount; row[i++] = product.RecomendedPrice; row[i++] = product.Description; row[i++] = ProductController.ConvertListToString(product.AnimalLst); SupplierProduct sup_prd = SupplierProduct.FetchByID(SuppliersSessionHelper.SupplierId(), product.ProductId); if (sup_prd != null) { row[i++] = sup_prd.Price; } //row[i++] = product.CategoryName; // row[i++] = product.SubCategoryName; // row[i++] = product.ProductRate; dt.Rows.Add(row); } SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true); Response.Clear(); Response.AddHeader(@"content-disposition", @"attachment;filename=ProductsExport_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension); Response.Charset = @"UTF-8"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = ex.FileContentType; Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble()); Response.Write(ex.ToString()); Response.End(); }
public static System.Data.DataTable getTable(string 参数_数据库路径, string 参数_SQL语句) { //初始化 System.Data.DataTable dt = new System.Data.DataTable(); try { //1、建立连接 C#操作Access之读取mdb string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + 参数_数据库路径 + ";"; System.Data.OleDb.OleDbConnection odcConnection = new System.Data.OleDb.OleDbConnection(strConn); //2、打开连接 C#操作Access之读取mdb odcConnection.Open(); //建立SQL查询 System.Data.OleDb.OleDbCommand odCommand = odcConnection.CreateCommand(); //3、输入查询语句 C#操作Access之读取mdb odCommand.CommandText = 参数_SQL语句; //建立读取 System.Data.OleDb.OleDbDataReader odrReader = odCommand.ExecuteReader(); //查询并显示数据 int size = odrReader.FieldCount; for (int i = 0; i < size; i++) { //Console.WriteLine("{0} {1}", "列", odrReader.GetName(i).ToString()); dt.Columns.Add(odrReader.GetName(i).ToString(), typeof(string)); } while (odrReader.Read()) { System.Data.DataRow dr = dt.NewRow(); for (int i = 0; i < size; i++) { //Console.WriteLine("{0} {1}", odrReader.GetName(i).ToString(), odrReader[odrReader.GetName(i)].ToString()); dr[odrReader.GetName(i).ToString()] = odrReader[odrReader.GetName(i)].ToString(); } dt.Rows.Add(dr); } //关闭连接 C#操作Access之读取mdb odrReader.Close(); odcConnection.Close(); return(dt); } catch { return(dt); } }
//Function to create xml file - Used for log file writing public static void CreateNewXml(ref System.Data.DataSet ds) { System.Data.DataTable Dt = new System.Data.DataTable(); System.Data.DataRow dr; Dt.Columns.Add("SysDate", System.Type.GetType("System.String")); Dt.Columns.Add("Sysvalue", System.Type.GetType("System.Int32")); dr = Dt.NewRow(); dr["SysDate"] = DateTime.Now.ToString("dd-MM-yyyy"); dr["Sysvalue"] = 0; Dt.Rows.Add(dr); ds.Tables.Add(Dt); }
protected void btnExport_Click(object sender, EventArgs e) { System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierId"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"BusinessName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Phone"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactPhone"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"CityName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SupplierEventStrings.GetText(@"ClickNum"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SupplierEventStrings.GetText(@"ClickToCallNum"), typeof(string))); List <SupplierServiceUI> suppliers = new List <SupplierServiceUI>(); string searchName = txtSearchName.Text.Trim(); string searchPhone = txtSearchPhone.Text.Trim(); string searchId = txtSearchSupplierId.Text.Trim(); string searchCity = txtSearchCity.Text.Trim(); DateTime from, to = new DateTime(); DateTime.TryParse(datepickerFrom.Text.ToString(), out from); DateTime.TryParse(datepickerTo.Text.ToString(), out to); suppliers = ServiceController.GetServiceSuppliersAndNumEvents(searchName, searchPhone, searchId, searchCity, from, to, true); foreach (SupplierServiceUI supplier in suppliers) { System.Data.DataRow row = dt.NewRow(); row[0] = supplier.SupplierId; row[1] = supplier.BusinessName; row[2] = "\"" + supplier.Phone + "\""; row[3] = supplier.ContactName; row[4] = "\"" + supplier.ContactPhone + "\""; row[5] = supplier.CityName; row[6] = supplier.ClickNum; row[7] = supplier.ClickToCallNum; dt.Rows.Add(row); } //System.Data.DataRow sumRow = dt.NewRow(); //sumRow[0] = SuppliersStrings.GetText(@"SumSumPerMonth") + " " + suppliers.Sum(o => o.SumPerMonth); //dt.Rows.Add(sumRow); SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true); Response.Clear(); Response.AddHeader(@"content-disposition", @"attachment;filename=ServiceSuppliersReport_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension); Response.Charset = @"UTF-8"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = ex.FileContentType; Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble()); Response.Write(ex.ToString()); Response.End(); }
public static System.Data.DataTable DilSecenekleri() { System.Data.DataTable dt = new System.Data.DataTable("Diller"); dt.Columns.Add("Key", typeof(string)); dt.Columns.Add("Value", typeof(string)); System.Data.DataRow dr = dt.NewRow(); dr[0] = "tr-TR"; dr[1] = "Türkçe"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "en-US"; dr[1] = "İngilizce"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "de-DE"; dr[1] = "Almanca"; dt.Rows.Add(dr); return(dt); }
public static System.Data.DataTable RandevuDurumlari() { System.Data.DataTable dt = new System.Data.DataTable("RandevuDurumlari"); dt.Columns.Add("Key", typeof(byte)); dt.Columns.Add("Value", typeof(string)); System.Data.DataRow dr = dt.NewRow(); dr[0] = 1; dr[1] = "Randevu Onay Bekliyor!"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 2; dr[1] = "Randevunuz Onaylandı."; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 3; dr[1] = "Randevu İptal Edildi."; dt.Rows.Add(dr); return(dt); }
public static System.Data.DataTable MakaleDurumlari() { System.Data.DataTable dt = new System.Data.DataTable("MakaleDurumlari"); dt.Columns.Add("Key", typeof(byte)); dt.Columns.Add("Value", typeof(string)); System.Data.DataRow dr = dt.NewRow(); dr[0] = 0; dr[1] = "Standart Makale"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 1; dr[1] = "Editörün Seçimi"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 2; dr[1] = "Haftanın Konusu"; dt.Rows.Add(dr); return(dt); }
public static System.Data.DataTable HesapCinsiyetleri() { System.Data.DataTable dt = new System.Data.DataTable("HesapCinsiyetleri"); dt.Columns.Add("Key", typeof(byte)); dt.Columns.Add("Value", typeof(string)); System.Data.DataRow dr = dt.NewRow(); dr[0] = 0; dr[1] = "Belirtilmedi"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 1; dr[1] = "Erkek"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = 2; dr[1] = "Bayan"; dt.Rows.Add(dr); return(dt); }
public static System.Data.DataTable ExtractData(HttpContext context, string dbTableName, SQLHelper sqlHelper) { if (context == null || string.IsNullOrEmpty(dbTableName) || sqlHelper == null) { throw new ArgumentNullException(); } string sql = "select * from " + dbTableName + " where 1=2"; System.Data.DataTable dt = sqlHelper.ExecuteQuery(sql); if (dt != null) { dt.TableName = dbTableName; System.Data.DataRow dr = dt.NewRow(); foreach (System.Data.DataColumn column in dt.Columns) { string columnName = column.ColumnName; string value = context.Request.Params[columnName]; if (string.IsNullOrEmpty(value)) { value = context.Request.Params[string.Format("models[0][{0}]", columnName)]; } if (string.IsNullOrEmpty(value)) { dr[columnName] = DBNull.Value; } else { dr[columnName] = value; } } dt.Rows.Add(dr); dt.AcceptChanges(); } return(dt); }
private void layGiaoDich() { DataTable dt = new DataTable(); String sCommand = ""; if ((loaikh == "HH") && (loaikhcn_dn == 2)) { if (txtMakh.Text == "") { sCommand = "SELECT giaodich.*,khachhang.hoten,nguoilienhe.hoten,loaigiaodich.tenloai,DMKhoanmucCP.Diengiai from khachhang,giaodich,nguoilienhe,loaigiaodich,DMKhoanmucCP where giaodich.maloaigd=loaigiaodich.maloaigd and giaodich.makh=khachhang.makh and giaodich.manlh=nguoilienhe.manlh and giaodich.macp=dmkhoanmuccp.macp and giaodich.user_id='" + txtMaNV.Text + "'"; } else { sCommand = "SELECT giaodich.*,khachhang.hoten,nguoilienhe.hoten,loaigiaodich.tenloai,DMKhoanmucCP.Diengiai from khachhang,giaodich,nguoilienhe,loaigiaodich,DMKhoanmucCP where giaodich.maloaigd=loaigiaodich.maloaigd and giaodich.makh=khachhang.makh and giaodich.manlh=nguoilienhe.manlh and giaodich.macp=dmkhoanmuccp.macp and giaodich.user_id='" + txtMaNV.Text + "' and khachhang.makh='" + txtMakh.Text + "'"; } } else { if (loaikh == "TN") { if (txtMakh.Text == "") { sCommand = "SELECT giaodich.*,khachhangtiemnang.hoten,loaigiaodich.tenloai,DMKhoanmucCP.Diengiai from khachhangtiemnang,giaodich,loaigiaodich,DMKhoanmucCP where giaodich.maloaigd=loaigiaodich.maloaigd and giaodich.makh=khachhangtiemnang.makh and giaodich.macp=dmkhoanmuccp.macp and giaodich.user_id='" + txtMaNV.Text + "'"; } else { sCommand = "SELECT giaodich.*,khachhangtiemnang.hoten,loaigiaodich.tenloai,DMKhoanmucCP.Diengiai from khachhangtiemnang,giaodich,loaigiaodich,DMKhoanmucCP where giaodich.maloaigd=loaigiaodich.maloaigd and giaodich.makh=khachhangtiemnang.makh and giaodich.macp=dmkhoanmuccp.macp and giaodich.user_id='" + txtMaNV.Text + "' and khachhangtiemnang.makh='" + txtMakh.Text + "'"; } } else { if (txtMakh.Text == "") { sCommand = "SELECT giaodich.*,khachhang.hoten,loaigiaodich.tenloai,DMKhoanmucCP.Diengiai from khachhang,giaodich,loaigiaodich,DMKhoanmucCP where giaodich.maloaigd=loaigiaodich.maloaigd and giaodich.makh=khachhang.makh and giaodich.macp=dmkhoanmuccp.macp and giaodich.user_id='" + txtMaNV.Text + "'"; } else { sCommand = "SELECT giaodich.*,khachhang.hoten,loaigiaodich.tenloai,DMKhoanmucCP.Diengiai from khachhang,giaodich,loaigiaodich,DMKhoanmucCP where giaodich.maloaigd=loaigiaodich.maloaigd and giaodich.makh=khachhang.makh and giaodich.macp=dmkhoanmuccp.macp and giaodich.user_id='" + txtMaNV.Text + "' and khachhang.makh='" + txtMakh.Text + "'"; } } } if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } frmMain.conn.Open(); new SqlDataAdapter(sCommand, frmMain.conn).Fill(dt); frmMain.conn.Close(); System.Data.DataTable dskh = new System.Data.DataTable(); DataColumn col = null; col = new DataColumn("STT", typeof(int)); dskh.Columns.Add(col); col = new DataColumn("Loại giao dịch", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Nội dung", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Địa điểm", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Bắt đầu", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Kết thúc", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Đánh giá", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Số tiền", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Ghi chú", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Hình thức GD", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Độ ưu tiên", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Mã giao dịch", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Khoản mục chi phí", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Họ tên KH", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Mã KH", typeof(string)); dskh.Columns.Add(col); int iRows = dt.Rows.Count; for (int i = 0; i < iRows; i++) { try { DataRow row = dskh.NewRow(); row[0] = i + 1; //DataTable dt = new DataTable(); // sCommand = "select * from loaigiaodich where maloaigd='" + dt.Rows[i]["maloaigd"].ToString() + "'"; //frmMain.conn.Open(); //new SqlDataAdapter(sCommand, frmMain.conn).Fill(dt); //frmMain.conn.Close(); row[1] = dt.Rows[0]["tenloai"].ToString(); row[2] = dt.Rows[i]["noidung"].ToString(); row[3] = dt.Rows[i]["diadiem"].ToString(); row[4] = dt.Rows[i]["tgbatdau"].ToString(); row[5] = dt.Rows[i]["tgketthuc"].ToString(); row[6] = dt.Rows[i]["danhgia"].ToString(); row[7] = dt.Rows[i]["Chiphi"].ToString(); row[8] = dt.Rows[i]["Ghichu"].ToString(); row[9] = dt.Rows[i]["hinhthucGD"].ToString(); row[10] = dt.Rows[i]["Douutien"].ToString(); row[11] = dt.Rows[i]["magd"].ToString(); row[12] = dt.Rows[i]["diengiai"].ToString(); row[13] = dt.Rows[i]["hoten"].ToString(); row[14] = dt.Rows[i]["makh"].ToString(); dskh.Rows.Add(row); } catch { }; } dataGridViewX2.DataSource = dskh; dataGridViewX2.Columns[0].FillWeight = 20; dataGridViewX2.Columns[0].Width = 40; dataGridViewX2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridViewX2.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridViewX2.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridViewX2.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridViewX2.Columns[11].Visible = false; dataGridViewX2.Columns[14].Visible = false; dataGridViewX2.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; }
protected void Page_Load(object sender, EventArgs e) { try { // By default (false) it uses SQLite database (Database.db). You can switch to MS Access database (Database.mdb) by setting UseMDB = true // The SQLite loads dynamically its DLL from TreeGrid distribution, it chooses 32bit or 64bit assembly // The MDB can be used only on 32bit IIS mode !!! The ASP.NET service program must have write access to the Database.mdb file !!! bool UseMDB = false; // --- Response initialization --- Response.ContentType = "text/xml"; Response.Charset = "utf-8"; Response.AppendHeader("Cache-Control", "max-age=1, must-revalidate"); System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US"); // --- Database initialization --- string Path = System.IO.Path.GetDirectoryName(Context.Request.PhysicalPath); System.Data.IDbConnection Conn = null; System.Data.Common.DbDataAdapter Sql = null; System.Data.Common.DbCommandBuilder Bld = null; string SqlStr = "SELECT * FROM TableData"; System.Reflection.Assembly SQLite = null; // Required only for SQLite database if (UseMDB) // For MS Acess database { Conn = new System.Data.OleDb.OleDbConnection("Data Source=\"" + Path + "\\..\\Database.mdb\";Mode=Share Deny None;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Engine Type=5;Provider=\"Microsoft.Jet.OLEDB.4.0\";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"); Sql = new System.Data.OleDb.OleDbDataAdapter(SqlStr, (System.Data.OleDb.OleDbConnection)Conn); } else // For SQLite database { SQLite = System.Reflection.Assembly.LoadFrom(Path + "\\..\\..\\..\\Server\\SQLite" + (IntPtr.Size == 4 ? "32" : "64") + "\\System.Data.SQLite.DLL"); Conn = (System.Data.IDbConnection)Activator.CreateInstance(SQLite.GetType("System.Data.SQLite.SQLiteConnection"), "Data Source=" + Path + "\\..\\Database.db"); Sql = (System.Data.Common.DbDataAdapter)Activator.CreateInstance(SQLite.GetType("System.Data.SQLite.SQLiteDataAdapter"), SqlStr, Conn); //*/ } System.Data.DataTable D = new System.Data.DataTable(); Sql.Fill(D); // --- Save data to database --- System.Xml.XmlDocument X = new System.Xml.XmlDocument(); string XML = Request["TGData"]; if (XML != "" && XML != null) { X.LoadXml(HttpUtility.HtmlDecode(XML)); System.Xml.XmlNodeList Ch = X.GetElementsByTagName("Changes"); if (Ch.Count > 0) { foreach (System.Xml.XmlElement I in Ch[0]) { string id = I.GetAttribute("id"); System.Data.DataRow R; if (I.GetAttribute("Added") == "1") { R = D.NewRow(); R["ID"] = id; D.Rows.Add(R); } else { R = D.Select("[ID]='" + id + "'")[0]; } if (I.GetAttribute("Deleted") == "1") { R.Delete(); } else if (I.GetAttribute("Added") == "1" || I.GetAttribute("Changed") == "1") { if (I.HasAttribute("Project")) { R["Project"] = I.GetAttribute("Project"); } if (I.HasAttribute("Resource")) { R["Resource"] = I.GetAttribute("Resource"); } if (I.HasAttribute("Week")) { R["Week"] = System.Double.Parse(I.GetAttribute("Week")); } if (I.HasAttribute("Hours")) { R["Hours"] = System.Double.Parse(I.GetAttribute("Hours")); } } } } if (UseMDB) { new System.Data.OleDb.OleDbCommandBuilder((System.Data.OleDb.OleDbDataAdapter)Sql); // For MS Acess database } else { Activator.CreateInstance(SQLite.GetType("System.Data.SQLite.SQLiteCommandBuilder"), Sql); // For SQLite database } Sql.Update(D); // Updates changed to database D.AcceptChanges(); X.RemoveAll(); Response.Write("<Grid><IO Result='0'/></Grid>"); } // --- Load data from database --- else { System.Xml.XmlElement G, BB, B, I; G = X.CreateElement("Grid"); X.AppendChild(G); BB = X.CreateElement("Body"); G.AppendChild(BB); B = X.CreateElement("B"); BB.AppendChild(B); foreach (System.Data.DataRow R in D.Rows) { I = X.CreateElement("I"); B.AppendChild(I); I.SetAttribute("id", R[0].ToString()); I.SetAttribute("Project", R[1].ToString()); I.SetAttribute("Resource", R[2].ToString()); I.SetAttribute("Week", R[3].ToString()); I.SetAttribute("Hours", R[4].ToString()); } Response.Write(X.InnerXml); } } catch (Exception E) { Response.Write("<Grid><IO Result=\"-1\" Message=\"Error in TreeGrid example:

" + E.Message.Replace("&", "&").Replace("<", "<").Replace("\"", """) + "\"/></Grid>"); } }
/// <summary> /// Lemma操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lemmanew_Click(object sender, EventArgs e) { lemmanew.Enabled = false; #region 0 变量定义与表单校验 DateTime t1; //时间1 DateTime t2; //时间2 string titleStr; //标题 string nameStr; //用户名 string txtStr = this.txtcontent.Value.Trim(); //正文文本 //检验文档标题、用户名、正文是否输入完成 if (string.IsNullOrEmpty(homecity_name.Value) || homecity_name.Value == "Type the title or click to choose it") //标题为空或者为文本框提示值,即未输入标题 { PageAlert("你还未选择或输入文档标题!", this); homecity_name.Focus(); lemmanew.Enabled = true; return; } else { titleStr = homecity_name.Value; //标题 } if (string.IsNullOrEmpty(username.Value)) //用户名为空,即未输入有效用户名 { PageAlert("请先输入你的姓名,本系统不支持匿名操作!", this); username.Focus(); lemmanew.Enabled = true; return; } else { nameStr = username.Value; //用户名 } if (string.IsNullOrEmpty(txtcontent.Value)) //处理的文本还未输入 { PageAlert("你还未输入或导入需要处理的文本,请确认后再试!", this); txtcontent.Focus(); lemmanew.Enabled = true; return; } else { string regEx = @"((file|gopher|news|nntp|telnet|http|ftp|https|ftps|sftp)://)(([a-zA-Z0-9\._-]+\.[a-zA-Z]{2,6})|([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}))(:[0-9]{1,4})*(/[a-zA-Z0-9\&%_\./-~-]*)?"; txtStr = Regex.Replace(txtcontent.Value, regEx, ";");//正则表达式排除文中的网址 } #endregion #region 1 过滤文本判断是否包含有英文单词 t1 = DateTime.Now; string ignoreWordsFile = GetDbPath() + "words/ignoreWords.txt"; string ordinalWordsFile = GetDbPath() + "words/OrdinalWords.txt"; string symbolFile = GetDbPath() + "words/symbol.txt"; var txtlist = TextInput.ArticleToList(txtStr, ignoreWordsFile, ordinalWordsFile, symbolFile);//文本转化为字符串数组,将需要处理的单词存到数组中 t2 = DateTime.Now; string timeRecord = "文本过滤耗时:" + TimeSpend(t1, t2);//时间记录 //PageAlert(timeRecord, this); if (txtlist.Count == 0)//文本中不包含有英文单词 { PageAlert("文本中不包含需要处理的英文单词!", this); txtcontent.Focus(); lemmanew.Enabled = true; return; } #endregion #region 2 参照词库选择 int itemsCount = this.cblist.Items.Count; int maxIndex = 0; for (int i = 0; i < itemsCount; i++) { if (cblist.Items[i].Selected) { maxIndex = i + 1;//2016-10-17 13:16:43 增补高中词汇,并将级别序号变更为5、6、7、8 } } if (maxIndex == 0) { PageAlert("你还未选定要参照的词汇表,请选择后继续!", this); lemmanew.Enabled = true; return; } #endregion #region 3 保存要处理的文本 SPUser currentUser = SPContext.Current.Web.CurrentUser; //string loginName = currentUser.LoginName; //loginName = loginName.Substring(loginName.IndexOf('\\') + 1); //loginName = loginName.Replace(@"i:0#.w|", ""); string spName = currentUser.Name; if (nameStr != spName) { nameStr = nameStr + "_" + spName; } titleStr = TextInput.FilterSpecial(titleStr, ""); string filePath = GetDbPath() + @"export/"; //txt文件保存的路径 string nowStr = string.Format("{0:yyyyMMddHHmmssffff}", DateTime.Now); //时间格式字符串:年月日时分秒4位毫秒 string fileTitle = titleStr + "(" + nameStr + ")" + nowStr + ".txt";; //文章标题+ _ + 处理人姓名 + 处理人所属院校(登录名)+ 当前时间 t1 = DateTime.Now; TextInput.FileWrite(fileTitle, txtStr, filePath); //将即将处理的文本保存到服务器上的指定目录中; t2 = DateTime.Now; timeRecord = timeRecord + "文件保存时间耗时:" + TimeSpend(t1, t2); //PageAlert(timeRecord, this); inputDiv.Visible = false; #endregion #region 4 单词还原 t1 = DateTime.Now; string fileName = GetDbPath() + "words/AllWords.txt";//包含原型与变型以及对应等级的词汇表 int isEurope = 0; //if (ckEurope.Checked) //{ // isEurope = 1; //} Dictionary <int, object> allwordsList = WordBLL.SearchWordsWithTxt(txtlist, fileName, isEurope);//对词汇列表进行比对还原和级别确认,输出三个数据集:1、文本词汇对应级别,2、超纲词汇对应词频,3、处理过的单词原型对应级别 t2 = DateTime.Now; timeRecord = timeRecord + "Lemma耗时:" + TimeSpend(t1, t2); #endregion #region 5 Lemma和结果输出 if (allwordsList.Count > 0) { #region 5.1 输出词汇表 t1 = DateTime.Now; DataTable showWordsdt = (DataTable)allwordsList[1]; //DataTable = OutputResult.newDataTable(wordsdt, maxIndex); //gridview数据绑定 #region 5.1.1 无超纲或不可处理的词汇可输出 if (showWordsdt.Rows.Count == 0) { showWordsdt.Rows.Add(showWordsdt.NewRow()); wordgv.DataSource = showWordsdt; wordgv.DataBind(); int nColumnCount = wordgv.Rows[0].Cells.Count; wordgv.Rows[0].Cells.Clear(); wordgv.Rows[0].Cells.Add(new TableCell()); wordgv.Rows[0].Cells[0].ColumnSpan = nColumnCount; wordgv.Rows[0].Cells[0].Text = "本次处理的文档不包含超纲或无法处理的词汇!"; wordgv.RowStyle.Height = 30; wordgv.RowStyle.HorizontalAlign = HorizontalAlign.Center; } #endregion #region 5.1.2 有超纲或不可处理的词汇输出词表 else { DataView dv = showWordsdt.Copy().DefaultView; dv.RowFilter = "[level]<=0 or [level]>" + (maxIndex + 4); //筛选超纲词汇和未处理词汇 //先给它一个默认状态,因为下面的bin()方法,需要用到状态值。 ViewState["SortOrder"] = "Frequency"; ViewState["OrderDire"] = "Desc"; string sortStr = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"]; dv.Sort = sortStr; wordgv.DataSource = dv; totalW.Text = "Total:" + dv.Table.Rows.Count.ToString() + "Words"; wordgv.DataBind(); t2 = DateTime.Now; timeRecord = timeRecord + "词表输出:" + TimeSpend(t1, t2); /***************5.3.1 输出词汇级别分布饼图*****************/ //int totalwords = showWordsdt.Rows.Count; //int[] wordProfiles =OutputResult.WordProfiles(showWordsdt, maxIndex); //Drawpie(wordProfiles,maxIndex); //t1 = DateTime.Now; //timeRecord = timeRecord + "级别分布图输出:" + TimeSpend(t2, t1); /***************5.3.2 输出前十个最高频词频分布饼图*********************/ //DrawSequencePie(showWordsdt); //t2 = DateTime.Now; //timeRecord = timeRecord + "高频词频分布图输出:" + TimeSpend(t1, t2); } #endregion #endregion /*****************5.2 输出彩色标记文本*************************/ var showWordsList = (List <List <string> >)allwordsList[0];//文本处理后包含的级别及每个级别词频的列表集合 DataTable dt = OutputResult.InitWordsAnalysisTable(showWordsList, maxIndex, symbolFile); StringBuilder sb = new StringBuilder(); for (int k = 0; k < dt.Rows.Count; k++) { DataRow dr = dt.Rows[k]; sb.Append(OutputResult.Colored(dr[0] + "(" + dr[1] + ") ", int.Parse(dr[2].ToString()))); } tuliDiv.InnerHtml = sb.ToString();//OutputResult.Tuli(showWordsList, maxIndex, symbolFile); //输出图例颜色表 BindChart(dt, SeriesChartType.Pie, Chart1); //outDiv.InnerHtml = OutputResult.ResultDiv(showWordsList, maxIndex); //输出彩色文本 outDiv.InnerHtml = OutputResult.ResultDiv(showWordsList, maxIndex).ToString(); outDiv.Visible = true; outlb.Text = titleStr; t1 = DateTime.Now; timeRecord = timeRecord + "彩色标记文本输出:" + TimeSpend(t2, t1); //PageAlert(timeRecord,this); outputDiv.Visible = true; //OutputResult.VisibleOrNot(outputDiv,inputDiv); //ClientScript.RegisterStartupScript(ClientScript.GetType(), "", "<script>document.getElementById('inputDiv').style.display = 'none';document.getElementById('outputDiv').style.display = '';</script>", true);//隐藏输入界面,显示输出结果 Titlelb.Text = "Output"; //Dictionary<string, int> wordsTimes =(Dictionary<string, int>) ret[2]; //WordBLL.WriteIntoDB(wordsTimes); } lemmanew.Enabled = true; #endregion }
//public static DataTable ReadExcelToTable(string path)//excel存放的路径 //{ // try // { // //连接字符串 // string connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1';"; // Office 07及以上版本 不能出现多余的空格 而且分号注意 // //string connstring = Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1';"; //Office 07以下版本 // using (OleDbConnection conn = new OleDbConnection(connstring)) // { // conn.Open(); // DataTable sheetsName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" }); //得到所有sheet的名字 // string firstSheetName = sheetsName.Rows[0][2].ToString(); //得到第一个sheet的名字 // string sql = string.Format("SELECT * FROM [{0}]", firstSheetName); //查询字符串 // //string sql = string.Format("SELECT * FROM [{0}] WHERE [日期] is not null", firstSheetName); //查询字符串 // OleDbDataAdapter ada = new OleDbDataAdapter(sql, connstring); // DataSet set = new DataSet(); // ada.Fill(set); // return set.Tables[0]; // } // } // catch (Exception) // { // return null; // } //} //private Stopwatch wath = new Stopwatch(); /// <summary> /// 使用COM读取Excel /// </summary> /// <param name="excelFilePath">路径</param> /// <returns>DataTabel</returns> public static System.Data.DataTable GetExcelData(string excelFilePath) { Excel.Application app = new Excel.Application(); Excel.Sheets sheets; Excel.Workbook workbook = null; object oMissiong = System.Reflection.Missing.Value; System.Data.DataTable dt = new System.Data.DataTable(); //wath.Start(); try { if (app == null) { return(null); } workbook = app.Workbooks.Open(excelFilePath, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong, oMissiong); //将数据读入到DataTable中——Start sheets = workbook.Worksheets; Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(1);//读取第一张表 if (worksheet == null) { return(null); } string cellContent; int iRowCount = worksheet.UsedRange.Rows.Count; int iColCount = worksheet.UsedRange.Columns.Count; Excel.Range range; //负责列头Start DataColumn dc; int ColumnID = 1; range = (Excel.Range)worksheet.Cells[1, 1]; while (range.Text.ToString().Trim() != "") { dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = range.Text.ToString().Trim(); dt.Columns.Add(dc); range = (Excel.Range)worksheet.Cells[1, ++ColumnID]; } //End for (int iRow = 2; iRow <= iRowCount; iRow++) { DataRow dr = dt.NewRow(); for (int iCol = 1; iCol <= iColCount; iCol++) { range = (Excel.Range)worksheet.Cells[iRow, iCol]; cellContent = (range.Value2 == null) ? "" : range.Text.ToString(); dr[iCol - 1] = cellContent; } dt.Rows.Add(dr); } //wath.Stop(); //TimeSpan ts = wath.Elapsed; //将数据读入到DataTable中——End return(dt); } catch { return(null); } finally { workbook.Close(false, oMissiong, oMissiong); System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook); workbook = null; app.Workbooks.Close(); app.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(app); app = null; GC.Collect(); GC.WaitForPendingFinalizers(); } }
protected void bt_UploadExcel_Click(object sender, EventArgs e) { Session["DataTable-SellIn"] = null; Session["DataTable-SellOut"] = null; UpdatePanel3.Visible = false; bt_Import.Enabled = false; #region 保存文件 if (!FileUpload1.HasFile) { MessageBox.Show(this.Page, "请选择要上传的文件!"); return; } int FileSize = (FileUpload1.PostedFile.ContentLength / 1024); if (FileSize > ConfigHelper.GetConfigInt("MaxAttachmentSize")) { MessageBox.Show(this.Page, "上传的文件不能大于" + ConfigHelper.GetConfigInt("MaxAttachmentSize") + "KB!当前上传文件大小为:" + FileSize.ToString() + "KB"); return; } //判断文件格式 string FileName = FileUpload1.PostedFile.FileName; FileName = FileName.Substring(FileName.LastIndexOf('\\') + 1); FileName = FileName.Substring(0, FileName.LastIndexOf('.')); string FileExtName = FileUpload1.PostedFile.FileName.Substring(FileUpload1.PostedFile.FileName.LastIndexOf(".") + 1).ToLowerInvariant(); if (FileExtName != "xls") { MessageBox.Show(this, "对不起,必须上传扩展名为xls的Excel文件!"); return; } string path = ConfigHelper.GetConfigString("AttachmentPath"); if (path.StartsWith("~")) { path = Server.MapPath(path); } if (!path.EndsWith("\\")) { path = path + "\\"; } path += "ImportExcelSVM\\Upload\\" + Session["UserName"].ToString() + "\\"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } path += FileName + "." + FileExtName; FileUpload1.SaveAs(path); #endregion #region 读取Excel文件 string ErrorInfo = ""; lb_ErrorInfo.Text = ""; object missing = System.Reflection.Missing.Value; ApplicationClass ExcelApp = null; try { ExcelApp = new ApplicationClass(); ExcelApp.Visible = false; ExcelApp.DisplayAlerts = false; Workbook workbook1 = null; Worksheet worksheet1 = null, worksheet2 = null; try { workbook1 = ExcelApp.Workbooks.Open(path, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); #region 验证工作表数据格式 if (workbook1.Worksheets.Count != 2) { ErrorInfo += "Excel表格中必须且只能有2张工作表!"; goto End; } worksheet1 = (Worksheet)workbook1.Worksheets[1]; worksheet2 = (Worksheet)workbook1.Worksheets[2]; if (worksheet1.Name != "零售商进货") { ErrorInfo += "Excel表格中第1个工作表名称必须为【零售商进货】!"; goto End; } if (worksheet2.Name != "零售商销货") { ErrorInfo += "Excel表格中第2个工作表名称必须为【零售商销货】!"; goto End; } if (((Range)worksheet1.Cells[1, 1]).Text.ToString() != "零售商ID" || ((Range)worksheet1.Cells[1, 2]).Text.ToString() != "零售商编号" || ((Range)worksheet1.Cells[1, 3]).Text.ToString() != "零售商名称" || ((Range)worksheet1.Cells[1, 4]).Text.ToString() != "零售商分类" || ((Range)worksheet1.Cells[1, 5]).Text.ToString() != "归属月份") { ErrorInfo += "零售商进货工作表表头(1~5列)错误!"; goto End; } if (((Range)worksheet2.Cells[1, 1]).Text.ToString() != "零售商ID" || ((Range)worksheet2.Cells[1, 2]).Text.ToString() != "零售商编号" || ((Range)worksheet2.Cells[1, 3]).Text.ToString() != "零售商名称" || ((Range)worksheet2.Cells[1, 4]).Text.ToString() != "零售商分类" || ((Range)worksheet2.Cells[1, 5]).Text.ToString() != "归属月份" || ((Range)worksheet2.Cells[1, 6]).Text.ToString() != "导购ID" || ((Range)worksheet2.Cells[1, 7]).Text.ToString() != "导购姓名") { ErrorInfo += "零售商销货工作表表头(1~7列)错误!"; goto End; } string ParamValue = Addr_OrganizeCityParamBLL.GetValueByType(1, 26); ParamValue = string.IsNullOrEmpty(ParamValue) ? "0" : ParamValue; ParamValue = ParamValue.EndsWith(",") ? ParamValue.Remove(ParamValue.Length - 1) : ParamValue; IList <PDT_Product> productlists = PDT_ProductBLL.GetModelList(" Brand NOT IN(" + ParamValue + ") AND Brand IN (SELECT ID FROM dbo.PDT_Brand WHERE IsOpponent='1') AND State=1 AND ApproveFlag=1 ORDER BY ISNULL(SubUnit,999999),Code"); for (int i = 0; i < productlists.Count; i++) { if (((Range)worksheet1.Cells[1, 6 + i]).Text.ToString() != productlists[i].ShortName) { ErrorInfo += "零售商进货工作表表头,(" + (6 + i).ToString() + "列)产品名称错误!必须为:" + productlists[i].ShortName; goto End; } if (((Range)worksheet2.Cells[1, 8 + i]).Text.ToString() != productlists[i].ShortName) { ErrorInfo += "零售商进货工作表表头,(" + (8 + i).ToString() + "列)产品名称错误!必须为:" + productlists[i].ShortName; goto End; } } #endregion #region 创建DataTable System.Data.DataTable dtSellIn = new System.Data.DataTable(); dtSellIn.Columns.Add(new System.Data.DataColumn("序号", Type.GetType("System.Int32"))); dtSellIn.Columns.Add(new System.Data.DataColumn("零售商ID", Type.GetType("System.Int32"))); dtSellIn.Columns.Add(new System.Data.DataColumn("零售商编号", Type.GetType("System.String"))); dtSellIn.Columns.Add(new System.Data.DataColumn("零售商名称", Type.GetType("System.String"))); dtSellIn.Columns.Add(new System.Data.DataColumn("零售商分类", Type.GetType("System.String"))); dtSellIn.Columns.Add(new System.Data.DataColumn("归属月份", Type.GetType("System.String"))); System.Data.DataTable dtSellOut = new System.Data.DataTable(); dtSellOut.Columns.Add(new System.Data.DataColumn("序号", Type.GetType("System.Int32"))); dtSellOut.Columns.Add(new System.Data.DataColumn("零售商ID", Type.GetType("System.Int32"))); dtSellOut.Columns.Add(new System.Data.DataColumn("零售商编号", Type.GetType("System.String"))); dtSellOut.Columns.Add(new System.Data.DataColumn("零售商名称", Type.GetType("System.String"))); dtSellOut.Columns.Add(new System.Data.DataColumn("零售商分类", Type.GetType("System.String"))); dtSellOut.Columns.Add(new System.Data.DataColumn("归属月份", Type.GetType("System.String"))); dtSellOut.Columns.Add(new System.Data.DataColumn("导购ID", Type.GetType("System.Int32"))); dtSellOut.Columns.Add(new System.Data.DataColumn("导购姓名", Type.GetType("System.String"))); foreach (PDT_Product product in productlists) { dtSellIn.Columns.Add(new System.Data.DataColumn("[" + product.ShortName + "]", Type.GetType("System.Int32"))); dtSellOut.Columns.Add(new System.Data.DataColumn("[" + product.ShortName + "]", Type.GetType("System.Int32"))); } #endregion #region 读取Excel表格--零售商进货 int sellinrow = 1; int emptyrow = 0; while (true) { sellinrow++; if (((Range)worksheet1.Cells[sellinrow, 1]).Text.ToString() == string.Empty) { emptyrow++; if (emptyrow > 5) { break; } else { continue; } } int clientid = 0; if (!int.TryParse(((Range)worksheet1.Cells[sellinrow, 1]).Text.ToString(), out clientid)) { continue; } //DateTime selldate; //if (!DateTime.TryParse(((Range)worksheet1.Cells[sellinrow, 5]).Text.ToString(), out selldate)) //{ // continue; //} System.Data.DataRow row = dtSellIn.NewRow(); row[0] = sellinrow - 1; row[1] = clientid; row[2] = ((Range)worksheet1.Cells[sellinrow, 2]).Text.ToString(); row[3] = ((Range)worksheet1.Cells[sellinrow, 3]).Text.ToString(); row[4] = ((Range)worksheet1.Cells[sellinrow, 4]).Text.ToString(); row[5] = ((Range)worksheet1.Cells[sellinrow, 5]).Text.ToString(); for (int i = 0; i < productlists.Count; i++) { int quantity = 0; int.TryParse(((Range)worksheet1.Cells[sellinrow, 6 + i]).Text.ToString(), out quantity); row[6 + i] = quantity; } dtSellIn.Rows.Add(row); } Session["DataTable-SellIn"] = dtSellIn; #endregion #region 读取Excel表格--零售商销货 int selloutrow = 1; emptyrow = 0; while (true) { selloutrow++; if (((Range)worksheet2.Cells[selloutrow, 1]).Text.ToString() == string.Empty) { emptyrow++; if (emptyrow > 5) { break; } else { continue; } } int clientid = 0; if (!int.TryParse(((Range)worksheet2.Cells[selloutrow, 1]).Text.ToString(), out clientid)) { continue; } //DateTime selldate; //if (!DateTime.TryParse(((Range)worksheet2.Cells[selloutrow, 5]).Text.ToString(), out selldate)) //{ // continue; //} int promotorid = 0; if (((Range)worksheet2.Cells[selloutrow, 6]).Text.ToString() != "" && !int.TryParse(((Range)worksheet2.Cells[selloutrow, 6]).Text.ToString(), out promotorid)) { continue; } System.Data.DataRow row = dtSellOut.NewRow(); row[0] = selloutrow - 1; row[1] = clientid; row[2] = ((Range)worksheet2.Cells[selloutrow, 2]).Text.ToString(); row[3] = ((Range)worksheet2.Cells[selloutrow, 3]).Text.ToString(); row[4] = ((Range)worksheet2.Cells[selloutrow, 4]).Text.ToString(); row[5] = ((Range)worksheet2.Cells[selloutrow, 5]).Text.ToString(); row[6] = promotorid; row[7] = ((Range)worksheet2.Cells[selloutrow, 7]).Text.ToString(); for (int i = 0; i < productlists.Count; i++) { int quantity = 0; int.TryParse(((Range)worksheet2.Cells[selloutrow, 8 + i]).Text.ToString(), out quantity); row[8 + i] = quantity; } dtSellOut.Rows.Add(row); } Session["DataTable-SellIn"] = dtSellIn; Session["DataTable-SellOut"] = dtSellOut; #endregion End: ; } catch (System.Exception err) { string error = "Message:" + err.Message + "<br/>" + "Source:" + err.Source + "<br/>" + "StackTrace:" + err.StackTrace + "<br/>"; lb_ErrorInfo.Text = error; MessageBox.Show(this, "系统错误-4!" + err.Message); } finally { if (workbook1 != null) { workbook1.Close(false, missing, missing); } if (worksheet1 != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet1); } if (worksheet2 != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet2); } if (workbook1 != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook1); } worksheet1 = null; worksheet2 = null; workbook1 = null; } } catch (System.Exception err) { string error = "Message:" + err.Message + "<br/>" + "Source:" + err.Source + "<br/>" + "StackTrace:" + err.StackTrace + "<br/>"; lb_ErrorInfo.Text = error; MessageBox.Show(this, "系统错误-5!" + err.Message); } finally { if (ExcelApp != null) { ExcelApp.Workbooks.Close(); ExcelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelApp); ExcelApp = null; } GC.Collect(); //GC.WaitForPendingFinalizers(); if (ErrorInfo != "") { lb_ErrorInfo.Text = ErrorInfo; MessageBox.Show(this, "对不起,Excel文件打开错误,请确认格式是否正确。错误提示:" + ErrorInfo); bt_Import.Enabled = false; } else { BindGrid(); MessageBox.Show(this, "Excel文件上传并成功读取,请确认表格中的数据,无误后点【确认提交】按钮!"); bt_Import.Enabled = true; } } #endregion }
private void layCCThuong() { DataTable dt = new DataTable(); String sCommand = ""; if ((cbCN.Text == "Tất cả") || (cbCN.Text == "")) { sCommand = "SELECT * from CauHinhThuong"; } else { sCommand = "SELECT * from CauHinhThuong where macn='" + cbCN.Text + "'"; } if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } frmMain.conn.Open(); new SqlDataAdapter(sCommand, frmMain.conn).Fill(dt); frmMain.conn.Close(); System.Data.DataTable dskh = new System.Data.DataTable(); DataColumn col = null; col = new DataColumn("STT", typeof(int)); dskh.Columns.Add(col); col = new DataColumn("Mã", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Tên giải thưởng", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Diễn giải", typeof(string)); dskh.Columns.Add(col); col = new DataColumn("Số điểm", typeof(decimal)); dskh.Columns.Add(col); int iRows = dt.Rows.Count; for (int i = 0; i < iRows; i++) { try { DataRow row = dskh.NewRow(); row[0] = i + 1; row[1] = dt.Rows[i]["ma"].ToString(); row[2] = dt.Rows[i]["ten"].ToString(); row[3] = dt.Rows[i]["diengiai"].ToString(); //ngayhl = dt.Rows[i]["ThoiGian"].ToString().Substring(3, 2) + "/" + dt.Rows[i]["Thoigian"].ToString().Substring(0, 2) + "/" + dt.Rows[i]["Thoigian"].ToString().Substring(6, 4); row[4] = dt.Rows[i]["diem"].ToString(); dskh.Rows.Add(row); } catch { }; } dgvDanhsach.DataSource = dskh; dgvDanhsach.Columns[0].FillWeight = 30; dgvDanhsach.Columns[0].Width = 20; dgvDanhsach.Columns[1].Visible = false; dgvDanhsach.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dgvDanhsach.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; }
private void importsexcel(object obj) { // List<tblFBL5N> fbl5n_ctrllist = new List<tblFBL5N>(); fbl5n_ctrl md = new fbl5n_ctrl(); bool kq = md.deleteFbl5n(); datainportF inf = (datainportF)obj; string filename = inf.filename; // ExcelProvider ExcelProvide = new ExcelProvider(); //#endregion System.Data.DataTable sourceData = ExcelProvider.GetDataFromExcel(filename); System.Data.DataTable batable = new System.Data.DataTable(); batable.Columns.Add("Account", typeof(double)); batable.Columns.Add("Assignment", typeof(string)); batable.Columns.Add("PostingDate", typeof(DateTime)); // PF Inv Date batable.Columns.Add("PFInvDate", typeof(DateTime)); // PF Inv Number batable.Columns.Add("PFInvNumber", typeof(string)); // Invoice Registration No. batable.Columns.Add("InvoiceRegistration", typeof(string)); batable.Columns.Add("DocumentType", typeof(string)); batable.Columns.Add("BusinessArea", typeof(string)); batable.Columns.Add("DocumentNumber", typeof(double)); batable.Columns.Add("Amountinlocalcurrency", typeof(double)); batable.Columns.Add("Deposit", typeof(double)); int InvoiceRegistrationid = -1; int PFInvDateid = -1; int PFInvNumberid = -1; int Depositid = -1; int Accountid = -1; int Assignmentid = -1; int PostingDateid = -1; int DocumentTypeid = -1; int DocumentNumberid = -1; int BusinessAreaid = -1; int Amountinlocalcurrencyid = -1; int rowseet = sourceData.Rows.Count; if (rowseet > 20) { rowseet = 20; } for (int rowid = 0; rowid < rowseet; rowid++) { // headindex = 1; for (int columid = 0; columid < sourceData.Columns.Count; columid++) { #region string value = ""; try { value = sourceData.Rows[rowid][columid].ToString(); } catch (Exception) { value = ""; // throw; } // MessageBox.Show(value +":"+ rowid); if (value != null && value != "") { // #region setcolum if (value.Trim() == ("Account")) //Account { Accountid = columid; // headindex = rowid; } if (value.Trim() == ("Assignment")) { Assignmentid = columid; // headindex = 0; } if (value.Trim() == ("Posting Date")) { PostingDateid = columid; // headindex = 0; } if (value.Trim() == ("Deposit")) { Depositid = columid; // headindex = 0; } if (value.Trim() == ("Document Type")) { DocumentTypeid = columid; } if (value.Trim() == ("Document Number")) { DocumentNumberid = columid; } if (value.Trim() == ("Amount in local currency")) { Amountinlocalcurrencyid = columid; } if (value.Trim() == ("Business Area")) { BusinessAreaid = columid; } //// PF Inv Date // batable.Columns.Add("PFInvDate", typeof(DateTime)); if (value.Trim() == ("PF Inv Date")) { PFInvDateid = columid; } if (value.Trim() == ("PF Inv Number")) { PFInvNumberid = columid; } if (value.Trim() == ("Invoice Registration No.")) { InvoiceRegistrationid = columid; } } #endregion } // colum } // roww off heatder if (Accountid == -1) { MessageBox.Show("Dữ liệu thiếu cột Account", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (InvoiceRegistrationid == -1) { MessageBox.Show("Dữ liệu thiếu cột Invoice Registration No.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (Depositid == -1) { MessageBox.Show("Dữ liệu thiếu cột Deposit", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (Assignmentid == -1) { MessageBox.Show("Dữ liệu thiếu cột Assignment", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (DocumentNumberid == -1) { MessageBox.Show("Dữ liệu thiếu cột Document Number", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (DocumentTypeid == -1) { MessageBox.Show("Dữ liệu thiếu cột Document Type", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (BusinessAreaid == -1) { MessageBox.Show("Dữ liệu thiếu cột Business Area", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (Amountinlocalcurrencyid == -1) { MessageBox.Show("Dữ liệu thiếu cột Amount in local currencyid", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (PostingDateid == -1) { MessageBox.Show("Dữ liệu thiếu cột Posting Date", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (PFInvDateid == -1) { MessageBox.Show("Dữ liệu thiếu cột PF Inv Date", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (PFInvNumberid == -1) { MessageBox.Show("Dữ liệu thiếu cột PF Inv Number", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } for (int rowixd = 0; rowixd < sourceData.Rows.Count; rowixd++) { #region // string valuepricelist = Utils.GetValueOfCellInExcel(worksheet, rowid, columpricelist); string Account = sourceData.Rows[rowixd][Accountid].ToString(); if (Account != "" && Utils.IsValidnumber(Account) && sourceData.Rows[rowixd][DocumentTypeid].ToString().Trim() != "") { if (double.Parse(Account) > 0) { DataRow dr = batable.NewRow(); dr["Account"] = double.Parse(sourceData.Rows[rowixd][Accountid].ToString());//.Trim(); dr["Assignment"] = sourceData.Rows[rowixd][Assignmentid].ToString().Truncate(225).Trim(); dr["PFInvNumber"] = sourceData.Rows[rowixd][PFInvNumberid].ToString().Truncate(50).Trim(); dr["InvoiceRegistration"] = sourceData.Rows[rowixd][InvoiceRegistrationid].ToString().Truncate(50).Trim(); try { dr["PostingDate"] = Utils.chageExceldatetoData(sourceData.Rows[rowixd][PostingDateid].ToString()); } catch (Exception) { dr["PostingDate"] = ""; } try { dr["PFInvDate"] = Utils.chageExceldatetoData(sourceData.Rows[rowixd][PFInvDateid].ToString()); } catch (Exception) { dr["PFInvDate"] = ""; } dr["DocumentType"] = sourceData.Rows[rowixd][DocumentTypeid].ToString().Truncate(225).Trim(); if (Utils.IsValidnumber(sourceData.Rows[rowixd][DocumentNumberid].ToString())) { dr["DocumentNumber"] = double.Parse(sourceData.Rows[rowixd][DocumentNumberid].ToString());//.Trim(); } else { dr["DocumentNumber"] = 0; } if (Utils.IsValidnumber(sourceData.Rows[rowixd][Amountinlocalcurrencyid].ToString())) { dr["Amountinlocalcurrency"] = double.Parse(sourceData.Rows[rowixd][Amountinlocalcurrencyid].ToString());//.Trim(); } else { dr["Amountinlocalcurrency"] = 0; } dr["BusinessArea"] = sourceData.Rows[rowixd][BusinessAreaid].ToString().Truncate(225).Trim(); if (Utils.IsValidnumber(sourceData.Rows[rowixd][Depositid].ToString().Trim())) { dr["Deposit"] = double.Parse(sourceData.Rows[rowixd][Depositid].ToString().Trim()); } else { dr["Deposit"] = 0; } batable.Rows.Add(dr); } } #endregion } // Utils util = new Utils(); string destConnString = Utils.getConnectionstr(); //---------------fill data using (SqlBulkCopy bulkCopy = new SqlBulkCopy(destConnString)) { bulkCopy.BulkCopyTimeout = 0; bulkCopy.DestinationTableName = "tblFBL5N"; // Write from the source to the destination. bulkCopy.ColumnMappings.Add("[Account]", "[Account]"); bulkCopy.ColumnMappings.Add("[Assignment]", "[Assignment]"); bulkCopy.ColumnMappings.Add("[PostingDate]", "[Posting Date]"); bulkCopy.ColumnMappings.Add("[DocumentType]", "[Document Type]"); bulkCopy.ColumnMappings.Add("[DocumentNumber]", "[Document Number]"); bulkCopy.ColumnMappings.Add("[BusinessArea]", "[Business Area]"); bulkCopy.ColumnMappings.Add("[Amountinlocalcurrency]", "[Amount in local currency]"); bulkCopy.ColumnMappings.Add("[Deposit]", "[Deposit]"); bulkCopy.ColumnMappings.Add("[PFInvDate]", "[PFInvDate]"); bulkCopy.ColumnMappings.Add("[PFInvNumber]", "[PFInvNumber]"); bulkCopy.ColumnMappings.Add("[InvoiceRegistration]", "[InvoiceRegistration]"); // Invoice Registration No. // batable.Columns.Add("InvoiceRegistration", typeof(string)); //// PF Inv Number //batable.Columns.Add("PFInvNumber", typeof(string)); //PFInvNumberid = columid; try { bulkCopy.WriteToServer(batable); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Thông báo lỗi Bulk Copy !", MessageBoxButtons.OK, MessageBoxIcon.Error); Thread.CurrentThread.Abort(); } } }
}//end ObtenSumatoriaColumnas public static GridView ObtenSumatoriaColumnasEnteros(GridView gv, bool ShowTotalTextInFirstColumn, string FooterCSSClass = "", params int[] args) { // Declarations System.Data.DataTable dtTotals = new System.Data.DataTable(); System.Data.DataRow dr = dtTotals.NewRow(); int Temp = 0; // Create a column for each of the GridView's Cells for (int iColumn = 0; iColumn <= (gv.Rows[0].Cells.Count - 1); iColumn++) { dtTotals.Columns.Add("Column" + iColumn); } // Loop through each of the GridView's Rows for (int iRow = 0; iRow <= (gv.Rows.Count - 1); iRow++) { if (iRow == 0 && ShowTotalTextInFirstColumn == true) { dr["Column0"] = "Totals:"; } else { // Make sure the row type is a DataRow if (gv.Rows[iRow].RowType == DataControlRowType.DataRow) { // Loop through each Cell string ValorCelda = null; for (int iCurrentColumn = 0; iCurrentColumn <= (gv.Rows[0].Cells.Count - 1); iCurrentColumn++) { ValorCelda = gv.Rows[iRow].Cells[iCurrentColumn].Text.ToString().Replace("$", ""); if (ValorCelda == string.Empty) { ValorCelda = "0"; } // Add the value to the total if it is an Integer decimal z; if (decimal.TryParse(ValorCelda, out z) && !(iCurrentColumn == 0 & ShowTotalTextInFirstColumn == true)) { // If the current value is null, add the value to the total if (System.Convert.IsDBNull(dr["Column" + iCurrentColumn])) { dr["Column" + iCurrentColumn] = Convert.ToDecimal(ValorCelda); } else { // If we already have a total, add this value to that total Temp = Convert.ToInt32(dr["Column" + iCurrentColumn]); Temp += Convert.ToInt32(ValorCelda); dr["Column" + iCurrentColumn] = Temp; // Reset the temp variable Temp = 0; }//end if }//end if }//end for }//end if }//end if }//end for // Add the totals row to our totals DataTable dtTotals.Rows.Add(dr); // Turn on the footer in the GridView gv.ShowFooter = true; gv.FooterRow.Visible = true; // Add the totals to the footer row only in Columns of money for (int iFooterColumn = 0; iFooterColumn <= args.Length - 1; iFooterColumn++) { decimal X = default(decimal); System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("es-Mx"); X = Convert.ToInt32(dtTotals.Rows[0][args[iFooterColumn]]); //-->1366.1D gv.FooterRow.Cells[args[iFooterColumn]].Text = X.ToString(); //<--$ 1,366.10 //--> Esta es otra opcion de formato: //--> Grid.FooterRow.Cells(iFooterColumn).Text = "$" & FormatNumber(dtTotals.Rows(0).Item(iFooterColumn).ToString, 2) //Alinear al centro gv.FooterRow.Cells[args[iFooterColumn]].HorizontalAlign = HorizontalAlign.Center; gv.FooterStyle.Wrap = false; gv.FooterStyle.Width = 500; gv.FooterStyle.ForeColor = System.Drawing.Color.Red; gv.FooterStyle.BackColor = System.Drawing.Color.White; } // Add the CSS class //If Not String.IsNullOrEmpty(FooterCSSClass) Then // Grid.FooterRow.CssClass = FooterCSSClass //End If //Return the Grid return gv; }//end ObtenSumatoriaColumnasEnteros
/// <summary> /// 获取竞品项目,数据维度为备案 /// </summary> /// <param name="dt"></param> /// <param name="jpxm"></param> /// <returns></returns> public DataTable GET_JPXM_BX(System.Data.DataTable dt, List <JP_JPXM_INFO> jpxm) { foreach (var item in jpxm.OrderByDescending(m => m.id)) { if (item.ytcs[0] == "别墅") { if (item.xfytcs != null && item.xfytcs.Length > 0) { for (int i = 0; i < item.xfytcs.Length; i++) { DataRow dr1 = dt.NewRow(); #region 数据准备 //竞品业态 var temp_ba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); var temp_ba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); var temp_ba_bn = bn.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); //本周本案认购数据 #endregion dt.Rows.Add(GET_ROW_BA1(item.xfytcs[i], dr1, dt, temp_ba_bz, temp_ba_sz, null, null, temp_ba_bn, item)); } } else { DataRow dr1 = dt.NewRow(); #region 数据准备 //竞品业态 var temp_ba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_ba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_ba_ssz = Cache_data_cjjl.ssz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_ba_sssz = Cache_data_cjjl.sssz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_ba_bn = bn.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); #endregion dt.Rows.Add(GET_ROW_BA1(item.ytcs[0], dr1, dt, temp_ba_bz, temp_ba_sz, temp_ba_ssz, temp_ba_sssz, temp_ba_bn, item)); } } else if (item.ytcs[0] == "商务") { if (item.hxcs != null & item.hxcs.Length > 0) { for (int i = 0; i < item.hxcs.Length; i++) { DataRow dr1 = dt.NewRow(); #region 数据准备 //竞品业态 var temp_ba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]); var temp_ba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]); var temp_ba_ssz = Cache_data_cjjl.ssz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]); var temp_ba_sssz = Cache_data_cjjl.sssz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]); var temp_ba_bn = bn.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]); #endregion dt.Rows.Add(GET_ROW_BA1(item.hxcs[i], dr1, dt, temp_ba_bz, temp_ba_sz, temp_ba_ssz, temp_ba_sssz, temp_ba_bn, item)); } } else if (item.xfytcs != null && item.xfytcs.Length > 0) { for (int i = 0; i < item.xfytcs.Length; i++) { DataRow dr1 = dt.NewRow(); #region 数据准备 //竞品业态 var temp_ba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); var temp_ba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); var temp_ba_ssz = Cache_data_cjjl.ssz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); var temp_ba_sssz = Cache_data_cjjl.sssz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); var temp_ba_bn = bn.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); //本周本案认购数据 #endregion dt.Rows.Add(GET_ROW_BA1(item.xfytcs[i], dr1, dt, temp_ba_bz, temp_ba_sz, temp_ba_ssz, temp_ba_sssz, temp_ba_bn, item)); } } else { DataRow dr1 = dt.NewRow(); #region 数据准备 //竞品业态 var temp_ba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_ba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_ba_ssz = Cache_data_cjjl.ssz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_ba_sssz = Cache_data_cjjl.sssz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_ba_bn = bn.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); //本周本案认购数据 #endregion dt.Rows.Add(GET_ROW_BA1(string.Join(",", item.ytcs), dr1, dt, temp_ba_bz, temp_ba_sz, temp_ba_ssz, temp_ba_sssz, temp_ba_bn, item)); } } else { DataRow dr1 = dt.NewRow(); #region 数据准备 //竞品业态 //竞品业态 var temp_ba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.ytcs[0]); var temp_ba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.ytcs[0]); var temp_ba_ssz = Cache_data_cjjl.ssz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.ytcs[0]); var temp_ba_sssz = Cache_data_cjjl.sssz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.ytcs[0]); var temp_ba_bn = bn.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); #endregion dt.Rows.Add(GET_ROW_BA1(string.Join(",", item.ytcs), dr1, dt, temp_ba_bz, temp_ba_sz, temp_ba_ssz, temp_ba_sssz, temp_ba_bn, item)); } } return(dt); }
/// <summary> /// 将CSV文件的数据读取到DataTable中 /// </summary> /// <param name="fileName">CSV文件路径</param> /// <returns>返回读取了CSV数据的DataTable</returns> public System.Data.DataTable OpenCSV(string filePath) { System.Data.DataTable dt = new System.Data.DataTable(); FileStream fs = new FileStream(filePath, System.IO.FileMode.Open, System.IO.FileAccess.Read); //StreamReader sr = new StreamReader(fs, Encoding.UTF8); StreamReader sr = new StreamReader(fs); //记录每次读取的一行记录 string strLine = ""; //记录每行记录中的各字段内容 string[] aryLine = null; string[] tableHead = null; //标示列数 int columnCount = 0; //标示是否是读取的第一行 bool IsFirst = true; //逐行读取CSV中的数据 while ((strLine = sr.ReadLine()) != null) { if (IsFirst == true) { tableHead = SplitCsv(strLine); IsFirst = false; columnCount = tableHead.Length; //创建列 for (int i = 0; i < columnCount; i++) { DataColumn dc = new DataColumn(tableHead[i].ToString().Replace("\"", "").Trim()); dt.Columns.Add(dc); } } else { aryLine = SplitCsv(strLine); DataRow dr = dt.NewRow(); for (int j = 0; j < columnCount; j++) { dr[j] = aryLine[j].Replace("\"", "").Trim(); } dt.Rows.Add(dr); } } sr.Close(); fs.Close(); if (dt.Rows.Count == 0) { dt.TableName = Path.GetFileNameWithoutExtension(filePath); } else { string moid = dt.Rows[0][4].ToString(); if (moid != null && moid != "") { string[] moidArray = moid.Split(';'); string moidKey = ""; foreach (string item in moidArray) { moidKey += item.Split('=')[0] + ";"; } dt.TableName = moidKey.Remove(moidKey.Length - 1, 1); } //删除某一行 //dt.Rows.Remove(dt.Rows[0]); } return(dt); }
protected void GridviewbindOrderdata() { //frmSplash = new SplashScreen.SplashForm(this); //frmSplash.Show(); grd_order.Rows.Clear(); System.Data.DataTable tmptable = dtselect.Clone(); int startIndex = currentPageIndex * pageSize; int endIndex = currentPageIndex * pageSize + pageSize; if (endIndex > dtselect.Rows.Count) { endIndex = dtselect.Rows.Count; } for (int i = startIndex; i < endIndex; i++) { DataRow newRow = tmptable.NewRow(); GetNewRow(ref newRow, dtselect.Rows[i]); tmptable.Rows.Add(newRow); } // Excel_Data = ds; if (tmptable.Rows.Count > 0) { grd_order.Rows.Clear(); for (int i = 0; i < tmptable.Rows.Count; i++) { grd_order.Rows.Add(); grd_order.Rows[i].Cells[0].Value = i + 1; bool expidate = Convert.ToBoolean(tmptable.Rows[i]["Expidate"].ToString()); grd_order.Rows[i].Cells[1].Value = expidate; grd_order.Rows[i].Cells[2].Value = tmptable.Rows[i]["Order_Number"].ToString(); grd_order.Rows[i].Cells[3].Value = tmptable.Rows[i]["Client_Order_Number"].ToString(); if (User_Role_Id == 1) { grd_order.Rows[i].Cells[4].Value = tmptable.Rows[i]["Client_Name"].ToString(); grd_order.Rows[i].Cells[5].Value = tmptable.Rows[i]["Sub_ProcessName"].ToString(); } else { grd_order.Rows[i].Cells[4].Value = tmptable.Rows[i]["Client_Number"].ToString(); grd_order.Rows[i].Cells[5].Value = tmptable.Rows[i]["Subprocess_Number"].ToString(); } grd_order.Rows[i].Cells[6].Value = tmptable.Rows[i]["Date"].ToString(); grd_order.Rows[i].Cells[7].Value = tmptable.Rows[i]["Order_Type"].ToString(); grd_order.Rows[i].Cells[8].Value = tmptable.Rows[i]["STATECOUNTY"].ToString(); grd_order.Rows[i].Cells[9].Value = tmptable.Rows[i]["Order_Status"].ToString(); grd_order.Rows[i].Cells[10].Value = tmptable.Rows[i]["Progress_Status"].ToString(); grd_order.Rows[i].Cells[11].Value = tmptable.Rows[i]["Vendor_Name"].ToString(); grd_order.Rows[i].Cells[12].Value = tmptable.Rows[i]["Assigned_Date_Time"].ToString(); grd_order.Rows[i].Cells[13].Value = tmptable.Rows[i]["Order_ID"].ToString(); grd_order.Rows[i].Cells[0].Style.BackColor = System.Drawing.Color.PowderBlue; // grd_order.Rows[i].Cells[12].Style.BackColor = System.Drawing.Color.Red; } } else { grd_order.Rows.Clear(); grd_order.Visible = true; grd_order.DataSource = null; } lbl_count.Text = "Total Orders: " + dtselect.Rows.Count.ToString(); lblRecordsStatus.Text = (currentPageIndex + 1) + " / " + (int)Math.Ceiling(Convert.ToDecimal(dtselect.Rows.Count) / pageSize); // Invoke(new UpdateUIDelegate(UpdateUI), new object[] { true }); // frmSplash.Close(); // GridviewOrderUrgent(); }
public System.Data.DataTable GET_JPXM_BX(System.Data.DataTable dt, List <JP_JPXM_INFO> jpxm) { foreach (var item in jpxm) { if (item.ytcs == null || item.ytcs.Length <= 0) { Base_Log.Log("业态参数为空!跳过!竞品项目ID:" + item.id); continue; } if (item.ytcs[0] == "别墅") { for (int i = 0; i < item.xfytcs.Length; i++) { //这里根据要求来设置(若不需要计算面积区间,这里需要注释) if (item.zlmjqj == null || item.zlmjqj.Length <= 0) { Base_Log.Log("主力面积区间为空!跳过!竞品项目ID:" + item.id); continue; } foreach (var mjitem in item.zlmjqj) { #region 计算主力面积区间 DataRow dr1 = dt.NewRow(); JP_JPXM_INFO jp = new JP_JPXM_INFO(); jp = item; jp.zlmjqj = new string[] { mjitem }; #endregion #region 数据准备 //竞品业态 var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.xfytcs[i]); var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.xfytcs[i]); //本周本案认购数据 var temp_ba_bz = temp_rgsj_bz.FirstOrDefault(); var temp_ba_sz = temp_rgsj_sz.FirstOrDefault(); #endregion dt.Rows.Add(GET_ROW(string.Join(",", item.ytcs), dr1, dt, temp_ba_bz, temp_ba_sz, null, null, jp)); } } } else if (item.ytcs[0] == "商务") { if (item.hxcs != null && item.hxcs.Length > 0) { for (int i = 0; i < item.hxcs.Length; i++) { //这里根据要求来设置(若不需要计算面积区间,这里需要注释) if (item.zlmjqj == null || item.zlmjqj.Length <= 0) { Base_Log.Log("主力面积区间为空!跳过!竞品项目ID:" + item.id); continue; } foreach (var mjitem in item.zlmjqj) { #region 计算主力面积区间 DataRow dr1 = dt.NewRow(); JP_JPXM_INFO jp = new JP_JPXM_INFO(); jp = item; jp.zlmjqj = new string[] { mjitem }; #endregion #region 数据准备 //竞品业态 var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]); var temp_cjba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["hx"].ToString() == item.hxcs[i]); var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]); var temp_cjba_sz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["hx"].ToString() == item.hxcs[i]); var tempby = byba.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.hxcs[i]); //本周本案认购数据 var temp_ba_bz = temp_rgsj_bz.FirstOrDefault(); var temp_ba_sz = temp_rgsj_sz.FirstOrDefault(); #endregion dt.Rows.Add(GET_ROW(item.hxcs[i], dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, tempby, jp)); } } } else if (item.xfytcs != null && item.xfytcs.Length > 0) { for (int i = 0; i < item.xfytcs.Length; i++) { //这里根据要求来设置(若不需要计算面积区间,这里需要注释) if (item.zlmjqj == null || item.zlmjqj.Length <= 0) { Base_Log.Log("主力面积区间为空!跳过!竞品项目ID:" + item.id); continue; } foreach (var mjitem in item.zlmjqj) { #region 计算主力面积区间 DataRow dr1 = dt.NewRow(); JP_JPXM_INFO jp = new JP_JPXM_INFO(); jp = item; jp.zlmjqj = new string[] { mjitem }; #endregion #region 数据准备 //竞品业态 var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.xfytcs[i]); var temp_cjba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.xfytcs[i]); var temp_cjba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); var tempby = byba.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && m["xfyt"].ToString() == item.xfytcs[i]); //本周本案认购数据 var temp_ba_bz = temp_rgsj_bz.FirstOrDefault(); var temp_ba_sz = temp_rgsj_sz.FirstOrDefault(); #endregion dt.Rows.Add(GET_ROW(item.xfytcs[i], dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, tempby, jp)); } } } else { //这里根据要求来设置(若不需要计算面积区间,这里需要注释) if (item.zlmjqj == null || item.zlmjqj.Length <= 0) { Base_Log.Log("主力面积区间为空!跳过!竞品项目ID:" + item.id); continue; } foreach (var mjitem in item.zlmjqj) { #region 计算主力面积区间 DataRow dr1 = dt.NewRow(); JP_JPXM_INFO jp = new JP_JPXM_INFO(); jp = item; jp.zlmjqj = new string[] { mjitem }; #endregion #region 数据准备 //竞品业态 var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_cjba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_cjba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var tempby = byba.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); //本周本案认购数据 var temp_ba_bz = temp_rgsj_bz.FirstOrDefault(); var temp_ba_sz = temp_rgsj_sz.FirstOrDefault(); #endregion dt.Rows.Add(GET_ROW(string.Join(",", item.ytcs), dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, tempby, jp)); } } } else if (item.ytcs[0] == "商铺") { //这里根据要求来设置(若不需要计算面积区间,这里需要注释) if (item.zlmjqj == null || item.zlmjqj.Length <= 0) { Base_Log.Log("主力面积区间为空!跳过!竞品项目ID:" + item.id); continue; } foreach (var mjitem in item.zlmjqj) { #region 计算主力面积区间 DataRow dr1 = dt.NewRow(); JP_JPXM_INFO jp = new JP_JPXM_INFO(); jp = item; jp.zlmjqj = new string[] { mjitem }; #endregion #region 数据准备 //竞品业态 var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_cjba_bz = Cache_data_cjjl.bz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var temp_cjba_sz = Cache_data_cjjl.sz.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); var tempby = byba.AsEnumerable().Where(m => m["lpmc"].ToString() == item.lpcs[0] && item.ytcs.Contains(m["yt"].ToString())); //本周本案认购数据 var temp_ba_bz = temp_rgsj_bz.FirstOrDefault(); var temp_ba_sz = temp_rgsj_sz.FirstOrDefault(); #endregion dt.Rows.Add(GET_ROW(string.Join(",", item.ytcs), dr1, dt, temp_ba_bz, temp_ba_sz, temp_cjba_bz, temp_cjba_sz, tempby, jp)); } } else { //这里根据要求来设置(若不需要计算面积区间,这里需要注释) if (item.zlmjqj == null || item.zlmjqj.Length <= 0) { Base_Log.Log("主力面积区间为空!跳过!竞品项目ID:" + item.id); continue; } foreach (var mjitem in item.zlmjqj) { #region 计算主力面积区间 DataRow dr1 = dt.NewRow(); JP_JPXM_INFO jp = new JP_JPXM_INFO(); jp = item; jp.zlmjqj = new string[] { mjitem }; #endregion #region 数据准备 //竞品业态 var temp_rgsj_bz = Cache_data_rgsj.bz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.ytcs[0]); var temp_rgsj_sz = Cache_data_rgsj.sz.AsEnumerable().Where(m => m["xm"].ToString() == item.lpcs[0] && m["yt"].ToString() == item.ytcs[0]); //本周本案认购数据 var temp_ba_bz = temp_rgsj_bz.FirstOrDefault(); var temp_ba_sz = temp_rgsj_sz.FirstOrDefault(); #endregion dt.Rows.Add(GET_ROW(string.Join(",", item.ytcs), dr1, dt, temp_ba_bz, temp_ba_sz, null, null, jp)); } } } return(dt); }