Пример #1
0
        private string GetBankNameByRegnum(int regnum)
        {
            double internal_code = _serviceClient.RegNumToIntCode(regnum);

            if (internal_code == -1)
            {
                return("");
            }

            DataSet info_ds = _serviceClient.CreditInfoByIntCode(internal_code);

            string shema = info_ds.GetXmlSchema();

            shema = shema.Replace("encoding=\"utf-16\"", "encoding=\"utf-8\"");
            System.IO.File.WriteAllText("CreditInfoByIntCode.xsd", shema);

            if (info_ds == null)
            {
                return("");
            }

            return(info_ds.Tables[0].Rows[0]["OrgName"].ToString());
        }
        /// <summary>
        /// Ecriture du fichier au format DataSet
        /// </summary>
        /// <param name="fileName">nom pour le fichier</param>
        public void SaveXmlData(string fileName)
        {
            XmlWriter xw = XmlWriter.Create(fileName, settings);
            xmlDataDoc.WriteTo(xw);
            xw.Flush();
            xw.Close();

            
            StringWriter sw = new StringWriter();
            sw.Write(dataSet.GetXml());            
            sw.Flush(); sw.Close();
            StreamWriter outfile = new StreamWriter(fileName + ".2");
            outfile.Write(sw);
            outfile.Flush(); outfile.Close();

            StringWriter sw2 = new StringWriter();
            sw2.Write(dataSet.GetXmlSchema());
            sw2.Flush(); sw2.Close();
            StreamWriter outfile2 = new StreamWriter(fileName + ".xsd");
            outfile2.Write(sw2);
            outfile2.Flush(); outfile2.Close();

        }
Пример #3
0
 private void WriteDataset(DataSet ds)
 {
     this._output.Append("{");
     this.WritePair("$schema", ds.GetXmlSchema());
     this._output.Append(",");
     foreach (DataTable table in (InternalDataCollectionBase)ds.Tables)
     {
         this._output.Append("\"");
         this._output.Append(table.TableName);
         this._output.Append("\":[");
         foreach (DataRow row in (InternalDataCollectionBase)table.Rows)
         {
             this._output.Append("{");
             foreach (DataColumn column in (InternalDataCollectionBase)row.Table.Columns)
             {
                 this.WritePair(column.ColumnName, row[column]);
             }
             this._output.Append("}");
         }
         this._output.Append("]");
     }
     this._output.Append("}");
 }
Пример #4
0
        public void Init()
        {
            DataSet ds = HttpContext.Current.Session["dataset"] as DataSet;

            if (ds == null)
            {
                ds = CreateSampleDS();
                var r = ds.Tables["books"].NewRow();
                r["title"]       = "Twenty Thousand Leagues Under the Sea";
                r["description"] = "Twenty Thousand Leagues Under the Sea is a classic science fiction novel by French writer Jules Verne published in 1870. It tells the story of Captain Nemo and his submarine Nautilus, as seen from the perspective of Professor Pierre Aronnax.";
                r["rating"]      = 5;
                r["author_id"]   = 1;
                ds.Tables["books"].Rows.Add(r);

                var author1Row = ds.Tables["authors"].NewRow();
                author1Row["name"] = "Jules Verne";
                author1Row["sex"]  = "Male";
                ds.Tables["authors"].Rows.Add(author1Row);

                var author2Row = ds.Tables["authors"].NewRow();
                author2Row["name"] = "Steven King";
                author2Row["sex"]  = "Male";
                ds.Tables["authors"].Rows.Add(author2Row);

                ds.AcceptChanges();
                HttpContext.Current.Session["dataset"] = ds;
            }

            AppContext.ComponentFactory.GetComponent <NI.Data.DataSetDalc>("dsDalc").PersistedDS   = ds;
            AppContext.ComponentFactory.GetComponent <NI.Data.DataSetFactory>("dsFactory").Schemas = new[] {
                new NI.Data.DataSetFactory.SchemaDescriptor()
                {
                    TableNames = new[] { "books", "authors", "book_to_author" },
                    XmlSchema  = ds.GetXmlSchema()
                }
            };
        }
    protected override void OnPreRender(EventArgs e)
    {
        string reportName = ValidationHelper.GetString(usReports.Value, String.Empty);

        mReportInfo = ReportInfoProvider.GetReportInfo(reportName);
        if (mReportInfo != null)
        {
            ReportID = mReportInfo.ReportID;

            usItems.Enabled = true;

            // Test if there is any item visible in report parameters
            FormInfo fi = new FormInfo(mReportInfo.ReportParameters);

            // Hide if there are no visible parameters
            pnlParametersButtons.Visible = fi.GetFields(true, false).Any();
        }
        else
        {
            if (ReportID == 0)
            {
                pnlParametersButtons.Visible = false;
                usItems.Enabled = false;
            }
        }

        ScriptHelper.RegisterClientScriptBlock(this, typeof(String), "ReportItemSelector_Refresh", "function refresh () {" + ControlsHelper.GetPostBackEventReference(pnlUpdate, String.Empty) + "}", true);

        if (!mDisplay)
        {
            pnlReports.Visible           = false;
            pnlParametersButtons.Visible = false;
            usItems.Enabled = true;
        }

        if (!ShowItemSelector)
        {
            pnlItems.Visible = false;
        }

        BuildConditions();

        if (mReportInfo == null)
        {
            usItems.SpecialFields.Add(new SpecialField {
                Text = "(" + mFirstItemText + ")", Value = "0"
            });
        }

        if (ShowItemSelector)
        {
            ReloadItems();
        }

        var currentGuid = CurrentGuid();

        if (mSetValues)
        {
            WindowHelper.Add(currentGuid, CurrentDataSet);
            ScriptHelper.RegisterDialogScript(Page);
            ScriptHelper.RegisterStartupScript(Page, typeof(Page), "OpenModalWindowReportItem", ScriptHelper.GetScript("modalDialog('" + ResolveUrl("~/CMSModules/Reporting/Dialogs/ReportParametersSelector.aspx?ReportID=" + ReportID + "&guid=" + currentGuid) + "','ReportParametersDialog', 700, 500);"));
            mKeepDataInWindowsHelper = true;
        }

        // Apply reportid condition if report was selected via uniselector
        if (mReportInfo != null)
        {
            DataSet ds = CurrentDataSet;

            ViewState["ParametersXmlData"]   = null;
            ViewState["ParametersXmlSchema"] = null;

            if (!DataHelper.DataSourceIsEmpty(ds))
            {
                ViewState["ParametersXmlData"]   = ds.GetXml();
                ViewState["ParametersXmlSchema"] = ds.GetXmlSchema();
            }

            if (!mKeepDataInWindowsHelper)
            {
                WindowHelper.Remove(currentGuid);
            }

            if (!DataHelper.DataSourceIsEmpty(ds))
            {
                ds = DataHelper.DataSetPivot(ds, new [] { "ParameterName", "ParameterValue" });
                ugParameters.DataSource = ds;
                ugParameters.ReloadData();
                pnlParameters.Visible = true;
            }
            else
            {
                pnlParameters.Visible = false;
            }
        }
        else
        {
            pnlParameters.Visible = false;
        }

        if (pnlParameters.Visible || pnlParametersButtons.Visible)
        {
            pnlItems.AddCssClass("form-group");
        }
        else
        {
            pnlItems.RemoveCssClass("form-group");
        }

        base.OnPreRender(e);
    }
Пример #6
0
 private void InitParentDataTableSchema(out XmlDocument schemaDocInit, out XmlNamespaceManager namespaceManagerToInit)
 {
     var ds = new DataSet();
     ds.Tables.Add(DataProvider.CreateParentDataTable());
     string strXML = ds.GetXmlSchema();
     schemaDocInit = new XmlDocument();
     schemaDocInit.LoadXml(strXML);
     namespaceManagerToInit = new XmlNamespaceManager(schemaDocInit.NameTable);
     namespaceManagerToInit.AddNamespace("xs", "http://www.w3.org/2001/XMLSchema");
     namespaceManagerToInit.AddNamespace("msdata", "urn:schemas-microsoft-com:xml-msdata");
 }
Пример #7
0
        private void WriteDataset(DataSet ds)
        {
            _output.Append('{');
            if (_params.UseExtensions)
            {
                WritePair("$schema", _params.UseOptimizedDatasetSchema ? (object)GetSchema(ds) : ds.GetXmlSchema());
                _output.Append(',');
            }
            bool tablesep = false;

            foreach (DataTable table in ds.Tables)
            {
                if (tablesep)
                {
                    _output.Append(',');
                }
                tablesep = true;
                WriteDataTableData(table);
            }
            // end dataset
            _output.Append('}');
        }
Пример #8
0
        public static void InsertEligFileContent()
        {
            HRAEligFile eobj          = new HRAEligFile();
            DataSet     ds1           = new DataSet(); ds1.Clear(); ds1 = GetEligAddrData();
            DataSet     ds2           = new DataSet(); ds2.Clear(); ds2 = GetEligStatData();
            DataSet     dschange1     = new DataSet(); dschange1 = eobj.GetAddrChgData(ds1);
            DataSet     dschange2     = new DataSet(); dschange2 = eobj.GetStatChgData(ds2);
            string      _filecontent1 = ds1.GetXml();
            string      _filecontent2 = ds2.GetXml();
            string      _filecontent3;

            if (dschange1.Tables[0].Rows.Count > 0)
            {
                _filecontent3 = dschange1.GetXml();
            }
            else
            {
                _filecontent3 = dschange1.GetXmlSchema();
            }
            string _filecontent4;

            if (dschange2.Tables[0].Rows.Count > 0)
            {
                _filecontent4 = dschange2.GetXml();
            }
            else
            {
                _filecontent4 = dschange2.GetXmlSchema();
            }
            string     _uid = HttpContext.Current.User.Identity.Name;
            ldapClient lobj = new ldapClient();
            UserRecord ud   = new UserRecord();


            ud = lobj.SearchUser(_uid);
            string _username = ud.FirstName + ", " + ud.LastName;

            string cmdstr1 = "DELETE FROM [hra_content] WHERE [category] = 'HRAElig'";
            string cmdstr2 = "INSERT INTO [hra_content] "
                             + "([category] "
                             + ",[source] "
                             + ",[content] "
                             + ",[createduser]) "
                             + "VALUES "
                             + "('HRAElig' "
                             + ",'EligAddr' "
                             + ",@filecontent1 "
                             + ",@username)";
            string cmdstr3 = "INSERT INTO [hra_content] "
                             + "([category] "
                             + ",[source] "
                             + ",[content] "
                             + ",[createduser]) "
                             + "VALUES "
                             + "('HRAElig' "
                             + ",'EligStat' "
                             + ",@filecontent2 "
                             + ",@username)";
            string cmdstr4 = "INSERT INTO [hra_content] "
                             + "([category] "
                             + ",[source] "
                             + ",[content] "
                             + ",[createduser]) "
                             + "VALUES "
                             + "('HRAElig' "
                             + ",'ChgEligAddr' "
                             + ",@filecontent3 "
                             + ",@username)";
            string cmdstr5 = "INSERT INTO [hra_content] "
                             + "([category] "
                             + ",[source] "
                             + ",[content] "
                             + ",[createduser]) "
                             + "VALUES "
                             + "('HRAElig' "
                             + ",'ChgEligStat' "
                             + ",@filecontent4 "
                             + ",@username)";



            try
            {
                if (connect == null || connect.State == ConnectionState.Closed)
                {
                    connect.Open();
                }
                command = new SqlCommand(cmdstr1, connect);
                command.ExecuteNonQuery(); command.Dispose();
                command = new SqlCommand(cmdstr2, connect);
                command.Parameters.AddWithValue("@filecontent1", _filecontent1);
                command.Parameters.AddWithValue("@username", _username);
                command.ExecuteNonQuery(); command.Dispose();
                command = new SqlCommand(cmdstr3, connect);
                command.Parameters.AddWithValue("@filecontent2", _filecontent2);
                command.Parameters.AddWithValue("@username", _username);
                command.ExecuteNonQuery(); command.Dispose();
                command = new SqlCommand(cmdstr4, connect);
                command.Parameters.AddWithValue("@filecontent3", _filecontent3);
                command.Parameters.AddWithValue("@username", _username);
                command.ExecuteNonQuery(); command.Dispose();
                command = new SqlCommand(cmdstr5, connect);
                command.Parameters.AddWithValue("@filecontent4", _filecontent4);
                command.Parameters.AddWithValue("@username", _username);
                command.ExecuteNonQuery(); command.Dispose();
            }
            finally
            {
                connect.Close();
            }
        }
Пример #9
0
    protected override void OnPreRender(EventArgs e)
    {
        pnlReports.Attributes.Add("style", "margin-bottom:3px");

        string reportName = ValidationHelper.GetString(usReports.Value, String.Empty);

        ri = ReportInfoProvider.GetReportInfo(reportName);
        if (ri != null)
        {
            usItems.Enabled = true;

            // Test if there is any item visible in report parameters
            FormInfo fi = new FormInfo(ri.ReportParameters);

            // Get dataset from cache
            DataSet ds = (DataSet)WindowHelper.GetItem(CurrentGuid());
            DataRow dr = fi.GetDataRow();
            fi.LoadDefaultValues(dr);
            bool             itemVisible = false;
            List <IFormItem> items       = fi.ItemsList;
            foreach (IFormItem item in items)
            {
                FormFieldInfo ffi = item as FormFieldInfo;
                if (ffi != null)
                {
                    if (ffi.Visible)
                    {
                        itemVisible = true;
                        break;
                    }
                }
            }

            ReportID = ri.ReportID;

            if (!itemVisible)
            {
                plcParametersButtons.Visible = false;
            }
            else
            {
                plcParametersButtons.Visible = true;
            }
        }
        else
        {
            if (ReportID == 0)
            {
                plcParametersButtons.Visible = false;
                usItems.Enabled = false;
            }
        }

        ltlScript.Text = ScriptHelper.GetScript("function refresh () {" + ControlsHelper.GetPostBackEventReference(pnlUpdate, String.Empty) + "}");
        usReports.DropDownSingleSelect.AutoPostBack = true;

        if (!mDisplay)
        {
            pnlReports.Visible           = false;
            plcParametersButtons.Visible = false;
            usItems.Enabled = true;
        }

        if (!ShowItemSelector)
        {
            pnlItems.Visible = false;
        }

        usItems.IsLiveSite                 = IsLiveSite;
        usReports.IsLiveSite               = IsLiveSite;
        ugParameters.GridName              = "~/CMSModules/Reporting/FormControls/ReportParametersList.xml";
        ugParameters.ZeroRowsText          = String.Empty;
        ugParameters.PageSize              = "##ALL##";
        ugParameters.Pager.DefaultPageSize = -1;

        BuildConditions();

        if (ri == null)
        {
            string[,] itemSpecialFields = new string[1, 2];
            itemSpecialFields[0, 0]     = "(" + firstItemText + ")";
            itemSpecialFields[0, 1]     = "0";
            usItems.SpecialFields       = itemSpecialFields;
        }

        if (ShowItemSelector)
        {
            ReloadItems();
        }

        if (setValues)
        {
            WindowHelper.Add(CurrentGuid(), CurrentDataSet);
            ScriptHelper.RegisterStartupScript(Page, typeof(Page), "OpenModalWindowReportItem", ScriptHelper.GetScript("modalDialog('" + ResolveUrl("~/CMSModules/Reporting/Dialogs/ReportParametersSelector.aspx?ReportID=" + ReportID + "&guid=" + CurrentGuid().ToString()) + "','ReportParametersDialog', 700, 500);"));
            keepDataInWindowsHelper = true;
        }

        // Apply reportid condition if report was selected via uniselector
        if (ri != null)
        {
            FormInfo fi = new FormInfo(ri.ReportParameters);
            DataRow  dr = fi.GetDataRow();
            DataSet  ds = CurrentDataSet;

            ViewState["ParametersXmlData"]   = null;
            ViewState["ParametersXmlSchema"] = null;

            if (!DataHelper.DataSourceIsEmpty(ds))
            {
                ViewState["ParametersXmlData"]   = ds.GetXml();
                ViewState["ParametersXmlSchema"] = ds.GetXmlSchema();
            }

            if (!keepDataInWindowsHelper)
            {
                WindowHelper.Remove(CurrentGuid().ToString());
            }

            if (!DataHelper.DataSourceIsEmpty(ds))
            {
                ds = DataHelper.DataSetPivot(ds, new string[] { "ParameterName", "ParameterValue" });
                ugParameters.DataSource = ds;
                ugParameters.ReloadData();
                pnlParameters.Visible = true;
            }
            else
            {
                pnlParameters.Visible = false;
            }
        }
        else
        {
            pnlParameters.Visible = false;
        }

        base.OnPreRender(e);
    }
Пример #10
0
        static void Main(string[] args)
        {
            DataSet shopDB = new DataSet("books");

            Console.WriteLine(shopDB.GetXmlSchema());

            DataTable customers = new DataTable("Customers");

            customers.Columns.Add(new DataColumn()
            {
                AllowDBNull       = false,
                AutoIncrement     = true,
                AutoIncrementSeed = 1,
                AutoIncrementStep = 1,
                ColumnName        = "id",
                DataType          = typeof(int),
                Unique            = true
            });
            customers.Columns.Add("name", typeof(string));
            shopDB.Tables.Add(customers);

            DataTable employees = new DataTable("Employees");

            employees.Columns.Add(new DataColumn()
            {
                AllowDBNull       = false,
                AutoIncrement     = true,
                AutoIncrementSeed = 1,
                AutoIncrementStep = 1,
                ColumnName        = "id",
                DataType          = typeof(int),
                Unique            = true
            });
            employees.Columns.Add("name", typeof(string));
            shopDB.Tables.Add(employees);

            DataTable products = new DataTable("Products");

            products.Columns.Add(new DataColumn()
            {
                AllowDBNull       = false,
                AutoIncrement     = true,
                AutoIncrementSeed = 1,
                AutoIncrementStep = 1,
                ColumnName        = "id",
                DataType          = typeof(int),
                Unique            = true
            });
            products.Columns.Add("name", typeof(string));
            shopDB.Tables.Add(products);

            DataTable orders = new DataTable("Orders");

            orders.Columns.Add(new DataColumn()
            {
                AllowDBNull       = false,
                AutoIncrement     = true,
                AutoIncrementSeed = 1,
                AutoIncrementStep = 1,
                ColumnName        = "id",
                DataType          = typeof(int),
                Unique            = true
            });
            orders.Columns.Add("customerId", typeof(int));
            orders.Columns.Add("productId", typeof(int));
            shopDB.Tables.Add(orders);

            DataTable details = new DataTable("Details");

            details.Columns.Add(new DataColumn()
            {
                AllowDBNull       = false,
                AutoIncrement     = true,
                AutoIncrementSeed = 1,
                AutoIncrementStep = 1,
                ColumnName        = "id",
                DataType          = typeof(int),
                Unique            = true
            });
            details.Columns.Add("orderId", typeof(int));
            details.Columns.Add("orderDate", typeof(DateTime));
            shopDB.Tables.Add(details);


            shopDB.Relations.Add("Orders_Details_fk",
                                 shopDB.Tables["Orders"].Columns["id"],
                                 shopDB.Tables["Details"].Columns["orderId"]);

            shopDB.Relations.Add("Customers_Orders_fk",
                                 shopDB.Tables["Customers"].Columns["id"],
                                 shopDB.Tables["Orders"].Columns["customerId"]);

            shopDB.Relations.Add("Products_Orders_fk",
                                 shopDB.Tables["Products"].Columns["id"],
                                 shopDB.Tables["Orders"].Columns["productId"]);

            return;
        }
Пример #11
0
 public void AutoIncrementStep()
 {
     DataSet ds = new DataSet("testds");
     DataTable tbl = ds.Tables.Add("testtbl");
     DataColumn col = tbl.Columns.Add("id", typeof(int));
     col.AutoIncrement = true;
     col.AutoIncrementSeed = -1;
     col.AutoIncrementStep = -1;
     tbl.Columns.Add("data", typeof(string));
     Assert.True(ds.GetXmlSchema().IndexOf("AutoIncrementStep") > 0);
 }
Пример #12
0
        /*
         *  Method:     notIncluded_Command
         *  Purpose:    The creatures dataset has various commands that can
         *  be performed by clicking on a hyperlink within a given row.  This
         *  particular function looks for the Command of "Add" and then adds
         *  the creature to the list of selected creatures.
         */

        protected void notIncluded_Command(Object sender, DataGridCommandEventArgs e)
        {
            if (((LinkButton)e.CommandSource).CommandName == "Add")
            {
                DataSet includedData = LoadXmlDataFromViewState();
                if (includedData != null)
                {
                    // First check to see how many we have
                    // If 10 then exit
                    if (includedData.Tables["Species"].Rows.Count >= 10)
                    {
                        return;
                    }

                    // Ensure primary key
                    includedData.Tables["Species"].DefaultView.Sort = "SpeciesName DESC";
                    includedData.Tables["Species"].PrimaryKey       = new DataColumn[]
                    {
                        includedData.Tables["Species"].Columns[
                            "SpeciesName"]
                    };
                    // Check to see if we already have this one
                    if (
                        includedData.Tables["Species"].Rows.Find(
                            HttpUtility.HtmlDecode(((DataBoundLiteralControl)e.Item.Cells[2].Controls[0]).Text)) !=
                        null)
                    {
                        return;
                    }
                }

                SqlConnection myConnection = new SqlConnection(ServerSettings.SpeciesDsn);

                myConnection.Open();

                SqlCommand     command = new SqlCommand("TerrariumGrabLatestSpeciesData", myConnection);
                SqlDataAdapter adapter = new SqlDataAdapter(command);
                command.CommandType = CommandType.StoredProcedure;

                SqlParameter parmSpecies = command.Parameters.Add("@SpeciesName", SqlDbType.VarChar, 50);
                parmSpecies.Value =
                    HttpUtility.HtmlDecode(((DataBoundLiteralControl)e.Item.Cells[2].Controls[0]).Text.Trim());

                DataSet tempData = new DataSet();
                adapter.Fill(tempData, "Species");

                if (includedData != null)
                {
                    includedData.Merge(tempData);
                }
                else
                {
                    includedData = tempData;
                }

                myConnection.Close();

                included.DataSource = includedData;
                included.DataBind();

                ViewState["SelectedSpecies"]       = includedData.GetXml();
                ViewState["SelectedSpeciesSchema"] = includedData.GetXmlSchema();
            }
        }
Пример #13
0
        protected void Page_Load(object sender, System.EventArgs e)
        {
            if (IsPostBack)
            {
                try
                {
                    DataSet ds = null;
                    ExceptionHelper.TrueThrow(importFile.PostedFile.FileName.Trim() == string.Empty, "对不起,系统没有上传文件!");

                    string strFileName, strFileExtension, strNewFileName;
                    strFileName = Path.GetFileName(importFile.PostedFile.FileName);

                    strFileExtension = System.IO.Path.GetExtension(strFileName);
                    ExceptionHelper.TrueThrow(strFileExtension.ToUpper() != ".XLS", "对不起,您上传的文件格式不正确,请上传标准Excel文件!");

                    string strTempPath = Path.GetTempPath();
                    strNewFileName = Guid.NewGuid().ToString().Replace("-", "") + strFileExtension;
                    try
                    {
                        importFile.PostedFile.SaveAs(strTempPath + strNewFileName);

                        string          strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strTempPath + strNewFileName + ";Extended Properties=Excel 8.0;";
                        OleDbConnection oConn   = new OleDbConnection(strConn);
                        try
                        {
                            oConn.Open();
                            OleDbCommand     oCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", oConn);
                            OleDbDataAdapter oAdapter   = new OleDbDataAdapter();
                            oAdapter.SelectCommand = oCmdSelect;
                            ds = new DataSet();
                            oAdapter.Fill(ds, "XLData");
#if DEBUG
                            Debug.WriteLine(ds.GetXmlSchema(), "");
                            Debug.WriteLine(ds.GetXml(), "");
#endif
                        }
                        finally
                        {
                            oConn.Close();
                            oConn.Dispose();
                        }
                        using (TransactionScope scope = TransactionScopeFactory.Create())
                        {
                            DataCheckAndPutInDB(ds);
                            scope.Complete();
                        }
                        middleTD.InnerHtml = "数据文件导入成功!";
                    }
                    finally
                    {
                        if (File.Exists(strTempPath + strNewFileName))
                        {
                            File.Delete(strTempPath + strNewFileName);
                        }
                    }
                }
                catch (Exception ex)
                {
                    middleTD.InnerHtml = ex.Message;
                }
                finally
                {
                    btnOK.Visible = false;
                }
            }
            else
            {
                CheckImportUserRole();
            }
        }
Пример #14
0
        public JsonResult ReadFileXml()
        {
            try
            {
                Dictionary <string, string> dicAppSet = null;
                if (dicAppSet == null || dicAppSet.Count == 0)
                {
                    general gn = new general();
                    dicAppSet = gn.ReadAppseting();
                    if (dicAppSet == null || dicAppSet.Count == 0)
                    {
                        Json("{\"result\":\"OK\",\"data\":\"Đọc appsetting lỗi\"}");
                    }
                }

                string fileName = "";
                for (int i = 0; i < Request.Files.Count; i++)
                {
                    HttpPostedFileBase file = Request.Files[i]; //Uploaded file
                                                                //Use the following properties to get file's name, size and MIMEType
                    int fileSize = file.ContentLength;
                    fileName = file.FileName;
                    string           mimeType    = file.ContentType;
                    System.IO.Stream fileContent = file.InputStream;


                    //To save file, use SaveAs method
                    string filePath = dicAppSet["path_saveonserver"] + fileName;
                    file.SaveAs(filePath); //File will be saved in application root
                    var itemp = this.Request.Form;
                    var parr  = new Dictionary <string, string>();
                    foreach (var key in itemp.AllKeys)
                    {
                        parr.Add(key.ToLower(), itemp[key]);
                    }

                    XmlDocument doc = new XmlDocument();
                    doc.Load(filePath);

                    var     dsHead = new DataSet();
                    DataSet ds     = new DataSet();
                    ds.ReadXml(new XmlNodeReader(doc));

                    var dt = new DataTable("dt");
                    dt.Columns.Add("Header");
                    dt.Rows.Add(ds.GetXmlSchema());
                    ds.Tables.Add(dt);

                    general gn   = new general();
                    var     data = gn.ConvertDatasetToListJsonNoLower(ds);
                    if (data == null)
                    {
                        return(Json("{\"result\":\"ERROR\",\"data\":\"Lỗi khi ConvertDatasetToListJson\"}"));
                    }
                    var json      = gn.ConvertListToJson(data);
                    var strResult = Json("{\"result\":\"OK\",\"data\":" + json + "}");

                    System.IO.File.Delete(filePath);
                    return(strResult);
                }
                return(Json("{\"result\":\"OK\",\"data\":\"Không nhận được file\"}"));
            }
            catch (Exception ex)
            {
                return(Json("{\"result\":\"ERROR\",\"data\":\"" + ex.Message + "\"}"));
            }
        }
Пример #15
0
        private void WriteDataset(DataSet ds)
        {
            Append('{');
            if (jsonParameters.UseExtensions)
            {
                WritePair("$schema", jsonParameters.UseOptimizedDatasetSchema ? (object)GetSchema(ds) : ds.GetXmlSchema());
                Append(',');
            }
            bool tablesep = false;

            foreach (DataTable table in ds.Tables)
            {
                if (tablesep)
                {
                    Append(",");
                }
                tablesep = true;
                WriteDataTableData(table);
            }
            Append('}');
        }
Пример #16
0
        void ButtonOk_ServerClick(object sender, EventArgs e)
        {
            wsTRFRichiesta ws = new wsTRFRichiesta();
            //ws.Credentials = new System.Net.NetworkCredential("wsMps", "Password03");
            //string test = RichiestaViaggio.List().GetXml();
            string serverWs = Convert.ToString(ConfigurationManager.AppSettings["ApplicationPath"]);

            ws.Credentials = CredentialCache.DefaultNetworkCredentials;//(currently logged on user)
            DataSet dsInput  = new DataSet();
            DataSet dsOutput = new DataSet();

            if (DdlMetodo.SelectedValue == "0")
            {
                if (DdlEvento.SelectedValue == "0")
                {
                    dsInput.ReadXmlSchema(serverWs + @"XmlData\TRF_Schema.xsd");
                    dsInput.ReadXml(serverWs + @"XmlData\DatiRichiesta.xml");
                }
                else if (DdlEvento.SelectedValue == "1")
                {
                    dsInput.ReadXmlSchema(serverWs + @"XmlData\TRF_Schema.xsd");
                    dsInput.ReadXml(serverWs + @"XmlData\DatiRichiestaErrore1.xml");
                }
                else if (DdlEvento.SelectedValue == "2")
                {
                    dsInput.ReadXmlSchema(serverWs + @"XmlData\TRF_Schema.xsd");
                }
                else if (DdlEvento.SelectedValue == "3")
                {
                    dsInput.ReadXmlSchema(serverWs + @"XmlData\TRF_Schema.xsd");
                    dsInput.ReadXml(serverWs + @"XmlData\DatiRichiestaErrore3.xml");
                }

                if (TextIdMissione.Value != string.Empty)
                {
                    if (dsInput.Tables.Contains("Richiesta"))
                    {
                        if (dsInput.Tables["Richiesta"].Rows.Count > 0)
                        {
                            dsInput.Tables["Richiesta"].Rows[0]["IdMissione"] = TextIdMissione.Value;
                        }
                    }
                }
                dsOutput = ws.WsNuovaRichiesta(dsInput);
            }
            if (DdlMetodo.SelectedValue == "1")
            {
                dsOutput = ws.WsAnnullaRichiesta(TextIdMissione.Value);
            }
            if (DdlMetodo.SelectedValue == "2")
            {
                dsOutput = ws.WsSbloccaRichiesta(TextIdMissione.Value);
            }
            if (DdlMetodo.SelectedValue == "3")
            {
                dsOutput = ws.WsVisualizzaRichiesta(TextIdMissione.Value);
            }
            if (DdlMetodo.SelectedValue == "4")
            {
                dsInput.ReadXmlSchema(serverWs + @"XmlData\TRF_Schema.xsd");
                dsInput.ReadXml(serverWs + @"XmlData\DatiRichiestaModifica.xml");

                if (TextIdMissione.Value != string.Empty)
                {
                    if (dsInput.Tables.Contains("Richiesta"))
                    {
                        if (dsInput.Tables["Richiesta"].Rows.Count > 0)
                        {
                            dsInput.Tables["Richiesta"].Rows[0]["IdMissione"] = TextIdMissione.Value;
                        }
                    }
                }

                dsOutput = ws.WsModificaRichiesta(dsInput);
            }
            if (DdlMetodo.SelectedValue == "5")
            {
                dsOutput = ws.WsRichiestaFruita(TextIdMissione.Value);
            }
            if (DdlMetodo.SelectedValue == "6")
            {
                dsOutput = ws.WsRichiestaFruita(TextIdMissione.Value);
            }
            if (DdlMetodo.SelectedValue == "7")
            {
                dsOutput = ws.WsNotificaRichieste(TextUserName.Value, TextDomain.Value);
            }
            TextAreaResultData.InnerText   = dsOutput.GetXml();
            TextAreaResultSchema.InnerText = dsOutput.GetXmlSchema();
        }
Пример #17
0
        private string SqlSelect(HttpContext context)
        {
            string sqlcmd = context.Request["sqlcmd"];

            sqlcmd = Common.Base.DESEncrypt.Decrypt(sqlcmd); //解密;
            string sqlcmdpars = context.Request["sqlcmdpars"];

            if (sqlcmdpars != null)
            {
                sqlcmdpars = Common.Base.DESEncrypt.Decrypt(sqlcmdpars); //解密;
            }
            try
            {
                DataTable dt = null;
                if (sqlcmdpars != null)
                {
                    SqlParameter[] pars = Common.Base.SqlParameterConvert.ConvertDbParameterXmlToSqlParameterArray(sqlcmdpars);
                    dt = DBHelper.DataTableDBExecuteSqlCommand(sqlcmd, pars);
                }
                else
                {
                    dt = DBHelper.DataTableDBExecuteSqlCommand(sqlcmd);
                }


                DataSet ds = new DataSet("data");
                dt.TableName = "item";
                ds.Tables.Add(dt);

                string XmlSchema = ds.GetXmlSchema();
                string XmlData   = ds.GetXml();

                return(XmlSchema + "<xmlsplit></xmlsplit>" + XmlData);
            }
            catch (Exception exp)
            {
                //异常输出
                //context.Response.Write();
                //异常输出
                string xmlStr = @"<?xml version=" + "\"1.0\" encoding=\"UTF-8\"?>";
                xmlStr += "<data>";
                xmlStr += "<summary>";
                xmlStr += Common.Base.XmlHelper.AddField("result", "false");
                if (exp.InnerException != null)
                {
                    xmlStr += Common.Base.XmlHelper.AddField("message", exp.InnerException.Message);
                }
                else
                {
                    xmlStr += Common.Base.XmlHelper.AddField("message", exp.Message);
                }
                xmlStr += Common.Base.XmlHelper.AddField("rows", "0");
                xmlStr += "</summary>";
                xmlStr += "</data>";

                return(xmlStr);
                //throw;
            }

            return("");
        }
Пример #18
0
        public bool loadXMLRSS2_0(channel ch, string rss)
        {
            using (DataSet rssData = new DataSet())
            {
                System.IO.StringReader sr = new System.IO.StringReader(rss);
                DataSet ds2 = new DataSet();

                rssData.ReadXmlSchema("RSS-2_0-Schema.xsd");
                //rssData.InferXmlSchema(sr, null);
                rssData.EnforceConstraints = false;
                rssData.ReadXml(sr, XmlReadMode.Auto);
                string str = rssData.GetXmlSchema();
                if (rssData.Tables.Contains("channel"))
                {
                    foreach (DataRow dataRow in rssData.Tables["channel"].Rows)
                    {
                        //ch.title = dataRowContains("title", dataRow, rssData);//Convert.ToString(dataRow["title"]);

                        //rss_sub.set_title(ch.title);
                        ch.description   = dataRowContains("description", dataRow, rssData);   //Convert.ToString(dataRow["description"]);
                        ch.link          = dataRowContains("link", dataRow, rssData);          //Convert.ToString(dataRow["link"]);
                        ch.lastBuildDate = dataRowContains("lastBuildDate", dataRow, rssData); //Convert.ToString(dataRow["lastBuildDate"]);
                        ch.pubDate       = dataRowContains("pubDate", dataRow, rssData);       //Convert.ToString(dataRow["pubDate"]);
                        ch.ttl           = dataRowContains("ttl", dataRow, rssData);           //Convert.ToString(dataRow["ttl"]);



                        foreach (DataRow im in rssData.Tables["image"].Rows)
                        {
                            ch.imageUrl   = im["url"].ToString();
                            ch.imageTitle = im["title"].ToString();
                        }


                        int counter = 0;
                        if (ch.pubDate.Length > 6)
                        {
                            ch.pubDate = ch.pubDate.Substring(0, ch.pubDate.Length - 6);
                        }
                        foreach (DataRow itemRow in rssData.Tables["item"].Rows)
                        {
                            Item inside = new Item();
                            inside.titleI = dataRowContains("title", itemRow, rssData);     //Convert.ToString(itemRow["title"]);
                            string desc = dataRowContains("description", itemRow, rssData); // Convert.ToString(itemRow["description"]);
                            processDescription(desc, inside);
                            inside.linkI = dataRowContains("link", itemRow, rssData);       //Convert.ToString(itemRow["link"]);
                            inside.guidI = dataRowContains("guid", itemRow, rssData);       //Convert.ToString(itemRow["guid"]);
                            //inside.guidI = Convert.ToString(rssData.Tables["guid"].Rows[counter].ItemArray[1]);
                            inside.pubDateI = dataRowContains("pubDate", itemRow, rssData); //Convert.ToString(itemRow["pubDate"]);
                            if (inside.pubDateI.Length > 6)
                            {
                                inside.pubDateI = inside.pubDateI.Substring(0, inside.pubDateI.Length - 6);
                            }

                            inside.subscription = ch.title;
                            ch.item.Add(inside);
                            counter++;
                            if (counter > ch.maxItems)
                            {
                                break;
                            }
                        }

                        /*channel rem = channels.Where(c => c.title == name).FirstOrDefault();
                         * if (rem != null)
                         * {
                         *  channels.Remove(rem);
                         * }
                         * if (findChannelName(ch.title) == null)
                         * {
                         *
                         *  channels.Add(ch);
                         * }
                         */
                    }
                }
                return(true);
            }
        }
Пример #19
0
        public void Bug420862()
        {
            DataSet ds = new DataSet("d");
            DataTable dt = ds.Tables.Add("t");
            dt.Columns.Add("c", typeof(ushort));

            XmlSchema xs = XmlSchema.Read(new StringReader(ds.GetXmlSchema()), null);
#pragma warning disable 0618
            xs.Compile(null);
#pragma warning restore 0618

            // follow the nesting of the schema in the foreach
            foreach (XmlSchemaElement d in xs.Items)
            {
                Assert.Equal("d", d.Name);
                XmlSchemaChoice dsc = (XmlSchemaChoice)((XmlSchemaComplexType)d.SchemaType).Particle;
                foreach (XmlSchemaElement t in dsc.Items)
                {
                    Assert.Equal("t", t.Name);
                    XmlSchemaSequence tss = (XmlSchemaSequence)((XmlSchemaComplexType)t.SchemaType).Particle;
                    foreach (XmlSchemaElement c in tss.Items)
                    {
                        Assert.Equal("c", c.Name);
                        Assert.Equal("unsignedShort", c.SchemaTypeName.Name);
                        return;
                    }
                }
            }
            Assert.False(true);
        }
Пример #20
0
        public bool loadXMLAtom(channel ch, string rss)
        {
            using (DataSet rssData = new DataSet())
            {
                System.IO.StringReader sr = new System.IO.StringReader(rss);
                DataSet ds2 = new DataSet();
                rssData.ReadXml(sr, XmlReadMode.Auto);
                string str = rssData.GetXmlSchema();

                if (rssData.Tables.Contains("feed"))
                {
                    foreach (DataRow dataRow in rssData.Tables["feed"].Rows)
                    {
                        int c = rssData.Tables.Count;

                        if (rssData.Tables.Contains("link"))
                        {
                            foreach (DataRow dr in rssData.Tables["link"].Rows)
                            {
                                ch.link = dataRowContains("href", dr, rssData);
                                break;
                            }
                        }
                        //dataRowContains("title", dataRow, rssData);
                        //rss_sub.set_title(ch.title);
                        ch.description = dataRowContains("subtitle", dataRow, rssData); //Convert.ToString(dataRow["subtitle"]);
                        ch.pubDate     = dataRowContains("updated", dataRow, rssData);  //Convert.ToString(dataRow["updated"]);
                        int counter = 0;
                        if (rssData.Tables.Contains("entry"))
                        {
                            foreach (DataRow itemRow in rssData.Tables["entry"].Rows)
                            {
                                Item inside = new Item();
                                inside.titleI       = dataRowContains("title", itemRow, rssData);   //Convert.ToString(itemRow["title"]);
                                inside.descriptionI = dataRowContains("summary", itemRow, rssData); //Convert.ToString(itemRow["summary"]);
                                inside.linkI        = dataRowContains("id", itemRow, rssData);      //Convert.ToString(rssData.Tables["id"]);
                                inside.pubDateI     = dataRowContains("updated", itemRow, rssData); //Convert.ToString(itemRow["updated"]);
                                if (inside.pubDateI == "")
                                {
                                    inside.pubDateI = dataRowContains("issued", itemRow, rssData);
                                }
                                inside.subscription = ch.title;
                                if (rssData.Tables.Contains("link"))
                                {
                                    foreach (DataRow dr in rssData.Tables["link"].Rows)
                                    {
                                        if (dr["href"].ToString().Contains(".html"))
                                        {
                                            inside.linkI = dr["href"].ToString();
                                        }
                                    }
                                }
                                if (rssData.Tables.Contains("author"))
                                {
                                    //foreach (DataRow authorRow in rssData.Tables["author"].Rows)
                                    DataRow authorRow = rssData.Tables["author"].Rows[0];
                                    //foreach (DataRow authorRow in itemRow["author"])
                                    {
                                        author auth = new author();
                                        auth.name  = dataRowContains("name", authorRow, rssData);
                                        auth.email = dataRowContains("email", authorRow, rssData);
                                        inside.authors.Add(auth);
                                    }
                                }
                                ch.item.Add(inside);

                                counter++;
                                if (counter > ch.maxItems)
                                {
                                    break;
                                }
                            }
                        }

                        /*if (findChannelName(ch.title) == null)
                         * {
                         *  channels.Add(ch);
                         * }*/
                    }
                }
                return(true);
            }
        }
Пример #21
0
 private void WriteDataset(DataSet ds)
 {
     _output.Append('{');
     if (useExtension)
     {
         WritePair("$schema", useMinimalDataSetSchema ? (object)GetSchema(ds) : ds.GetXmlSchema());
         _output.Append(',');
     }
     foreach (DataTable table in ds.Tables)
     {
         WriteDataTableData(table);
     }
     // end dataset
     _output.Append('}');
 }
Пример #22
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                svcSCPPHH.SCPP_HHClient d = new svcSCPPHH.SCPP_HHClient();
                BC.SCPP_HH bc             = new BC.SCPP_HH();
                DataSet    ds             = new DataSet();//d.SyncServHH(DropDownList1.SelectedValue.ToString(), DateTime.Today.Date.AddDays(-20), DateTime.Today, DateTime.Today);
                //DataSet ds = bc.SyncServHH(DropDownList1.SelectedValue.ToString(), DateTime.Today.Date.AddDays(-20), DateTime.Today, DateTime.Today);
                //List<DataSet> lds = d.SyncServHHLDS(DateTime.Today.Date.AddDays(-30), DateTime.Today, DateTime.Today);
                //List<StringReader[]> lxmlDS = bc.SyncServHH(DateTime.Today.Date.AddDays(-30), DateTime.Today, DateTime.Today);
                //DataSet beRes = new DataSet();
                //List<DataSet> lds = new List<DataSet>();
                //foreach (StringReader[] xmlSR in lxmlDS)
                //{
                //    beRes.Clear();
                //    beRes = new DataSet();
                //    beRes.ReadXmlSchema(xmlSR[0]);
                //    beRes.ReadXml(xmlSR[1], XmlReadMode.Auto);
                //    lds.Add(beRes);
                //}
                //DataTable dt = d.TablasCatalogosHH();

                DataTable dt = null;
                try
                {
                    dt = d.Login("a", "a");
                }
                catch { }
                try
                { dt = d.ObtenerSupervisorPorDefecto(42); }
                catch { }
                DataSet xmlDS = new DataSet();
                DataSet ds2   = new DataSet();
                try
                {
                    StringReader   xmlSchema  = new StringReader(ds.GetXmlSchema().ToString());
                    StringReader   xmlInfo    = new StringReader(ds.GetXml().ToString());
                    StringReader[] xmlDataSet = { xmlSchema, xmlInfo };

                    ds2.ReadXmlSchema(xmlDataSet[0]);
                    ds2.ReadXml(xmlDataSet[1], XmlReadMode.Auto);
                }
                catch { }

                if (ds2.Tables.Count > 0)
                {
                    UltraWebGrid1.DataSource = ds2.Tables[0];
                    String tableName = ds2.Tables[1].TableName.Substring(3).ToString();
                    ObtenerUpdate(ds2.Tables[1], tableName);
                    UltraWebGrid2.DataSource = ds2.Tables[1];
                    UltraWebGrid3.DataSource = ds2.Tables[2];
                }
                int i = d.ActualizarColorPieza(21, 3);
                UltraWebGrid1.DataBind();
                UltraWebGrid2.DataBind();
                UltraWebGrid3.DataBind();
            }
            catch (Exception er)
            {
                CallBackManager.AddScriptBlock(this.Page, WebAsyncRefreshPanel1, "<script type='text/javascript'>alert('" + er.Message.Replace("'", "\"") + "');</script>");
                Console.Write("Error:" + er.Message);
            }
        }
Пример #23
0
        private void WriteDataset(DataSet ds)
        {
            _output.WriteByte(TOKENS.DOC_START);
            {
                WritePair("$schema", _params.UseOptimizedDatasetSchema ? (object)GetSchema(ds) : ds.GetXmlSchema());
                WriteComma();
            }
            bool tablesep = false;

            foreach (DataTable table in ds.Tables)
            {
                if (tablesep)
                {
                    WriteComma();
                }
                tablesep = true;
                WriteDataTableData(table);
            }
            // end dataset
            _output.WriteByte(TOKENS.DOC_END);
        }
 public string GetSchema()
 {
     return(dataSet.GetXmlSchema());
 }
Пример #25
0
        void WriteDataset(DataSet ds)
        {
            OutputChar('{');
            if (_useExtensions)
            {
                WriteField(JsonDict.ExtSchema, _manager.UseOptimizedDatasetSchema ? (object)GetSchema(ds) : ds.GetXmlSchema());
                OutputChar(',');
            }
            var tablesep = false;

            foreach (DataTable table in ds.Tables)
            {
                if (tablesep)
                {
                    OutputChar(',');
                }
                tablesep = true;
                WriteDataTableData(table);
            }
            // end dataset
            OutputChar('}');
        }
Пример #26
0
        private void WriteDataset(DataSet ds)
        {
            _output.Append('{');
            if (useExtension)
            {
                WritePair("$schema", useMinimalDataSetSchema ? (object)GetSchema(ds) : ds.GetXmlSchema());
                _output.Append(',');
            }
            foreach (DataTable table in ds.Tables)
            {
                _output.Append('\"');
                _output.Append(table.TableName);
                _output.Append("\":[");
                DataColumnCollection cols = table.Columns;
                foreach (DataRow row in table.Rows)
                {
                    _output.Append('[');

                    bool pendingSeperator = false;
                    foreach (DataColumn column in cols)
                    {
                        if (pendingSeperator)
                        {
                            _output.Append(',');
                        }
                        WriteValue(row[column]);
                        pendingSeperator = true;
                    }
                    _output.Append(']');
                }

                _output.Append(']');
            }
            // end dataset
            _output.Append('}');
        }