NewRow() public method

Creates a new with the same schema as the table.
public NewRow ( ) : DataRow
return DataRow
Beispiel #1
1
        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"] = "";
        }
Beispiel #2
0
        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");
        }
Beispiel #7
0
        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);

                    }
                }

            }
        }
Beispiel #9
0
        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;
        }
Beispiel #11
0
 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);
 }
Beispiel #12
0
        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);
        }
Beispiel #13
0
 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();
        }
Beispiel #15
0
 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";
 }
Beispiel #16
0
	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 ();
	}
Beispiel #17
0
        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;
        }
Beispiel #18
0
    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;
        }
Beispiel #20
0
    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");
        }
Beispiel #22
0
    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");

        }
Beispiel #24
0
        /// <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"]);
              }
        }
Beispiel #25
0
 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";
 }
Beispiel #26
0
        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();
            }
        }
Beispiel #28
0
    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;
    }
Beispiel #29
0
 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);
 }
Beispiel #30
0
    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);
    }
Beispiel #31
0
 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"]));
 }
Beispiel #32
0
    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);
    }
Beispiel #33
0
    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();
    }
Beispiel #34
0
    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();
    }
Beispiel #35
0
    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);
        }
    }
Beispiel #36
0
 //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);
 }
Beispiel #37
0
    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();
    }
Beispiel #38
0
    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);
    }
Beispiel #39
0
    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);
    }
Beispiel #40
0
    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);
    }
Beispiel #41
0
    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);
    }
Beispiel #43
0
        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;
        }
Beispiel #44
0
    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:&#x0a;&#x0a;" + E.Message.Replace("&", "&amp;").Replace("<", "&lt;").Replace("\"", "&quot;") + "\"/></Grid>");
        }
    }
Beispiel #45
0
        /// <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
        }
Beispiel #46
0
        //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
    }
Beispiel #48
0
        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();
                }
            }
        }
Beispiel #50
0
    }//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);
        }
Beispiel #52
0
        /// <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);
        }