Example #1
0
        private void writeLog(string userId, string sTag)
        {
            string str  = "'" + DateTime.Now.ToString() + "'";
            string str2 = "";

            Dns.GetHostName();
            IPAddress[] addressArray = Dns.GetHostByName(Dns.GetHostName()).AddressList;
            if (addressArray.Length == 1)
            {
                str2 = addressArray[0].ToString();
            }
            else
            {
                str2 = addressArray[1].ToString();
            }
            this.oDb = this.connConfig.getDBOperator();
            this.oDb.Open();
            IDbCommand command = null;
            string     str3    = new MaxNo(this.connConfig, this.xdoc, this.session).getRecnum1("LOG", this.oDb.Connection.CreateCommand());
            string     sql     = "";

            if (sTag == "login")
            {
                sql = "insert into FCQ_USERLOGNOTE (id,userId,loginTime,loginIp) Values('" + str3 + "','" + userId + "'," + str + ",'" + str2 + "')";
            }
            else if (sTag == "logout")
            {
                sql = "insert into FCQ_USERLOGNOTE (id,userId,logoutTime,loginIp) Values('" + str3 + "','" + userId + "'," + str + ",'" + str2 + "')";
            }
            else
            {
                sql = "insert into FCQ_USERLOGNOTE (id,userId,loginTime,loginIp,moduleId) Values('" + str3 + "','" + userId + "'," + str + ",'" + str2 + "','" + sTag + "')";
            }
            try
            {
                command             = this.oDb.Connection.CreateCommand();
                command.Connection  = (this.oDb.Connection);
                command.CommandText = (sql);
                command.ExecuteNonQuery();
            }
            catch (Exception exception)
            {
                throw new SqlRunException(sql, exception.Message);
            }
            finally
            {
                try
                {
                    this.oDb.Close();
                }
                catch (Exception)
                {
                }
            }
        }
Example #2
0
        private string saveOrgInfo(ConnectionConfig connConfig, XmlDocument xdoc)
        {
            string        str     = "";
            StringBuilder builder = new StringBuilder();

            builder.Append(
                "Insert into fcq_org (org_name,link_man,email,java_dotnet,db_type,item_name,item_www,phone,org_www,qq,org_id,create_date) values ( ");
            for (int i = 0; i < 10; i++)
            {
                builder.Append("'" + xdoc.DocumentElement.ChildNodes.Item(i).InnerText + "',");
            }
            DBOperator @operator = null;
            IDbCommand myComm    = null;

            try
            {
                @operator = connConfig.getDBOperator();
                @operator.Open();
                myComm            = @operator.Connection.CreateCommand();
                myComm.Connection = (@operator.Connection);
                MaxNo no = new MaxNo(connConfig, xdoc, this.Session);
                builder.Append("'" + no.getRecnum1("ORG", myComm) + "',");
                builder.Append("'" + cn.com.fcsoft.util.Tools.getServerTime() + "')");
                string str2 = builder.ToString();
                myComm.CommandText = (str2);
                myComm.ExecuteNonQuery();
                myComm.Dispose();
                @operator.Close();
            }
            catch (Exception exception)
            {
                str = exception.Message;
            }
            finally
            {
                try
                {
                    @operator.Close();
                }
                catch (Exception)
                {
                }
            }
            return(str);
        }
Example #3
0
        private void Page_Load(object sender, EventArgs e)
        {
            string      url  = null;
            string      str2 = null;
            XmlDocument xdoc = null;

            try
            {
                string    str8;
                QuerySql  sql;
                SqlToTree tree;
                str2 = base.Request.Params["key"];
                if ((str2 == null) || (str2.Length == 0))
                {
                    str2 = base.Request.QueryString.ToString();
                }
                if (str2 == "HelloWorld")
                {
                    base.Response.ContentType = ("text/html;charset=UTF-8");
                    base.Response.Write("HelloWorld");
                    return;
                }
                Logger.debug("后台 key=" + str2);
                if (str2 == "logger")
                {
                    string src = new StreamReader(base.Request.InputStream).ReadToEnd();
                    Logger.debug("前台:" + Escape.unescape(src));
                    return;
                }
                this.initConfigFileEbiao(base.Request);
                ConnectionConfig.initConfigFile(base.Request, this.Session);
                string           str4       = null;
                string           dsName     = base.Request.Params["datasourceName"];
                ConnectionConfig connConfig = null;
                connConfig = new ConnectionConfig(dsName);
                if (str2 == "DbToFile")
                {
                    new DbStru(connConfig, null, base.Request).DbToFile(base.Response);
                    return;
                }
                bool flag = ((((str2 == "loadFileStream") || (str2 == "getTempImage")) ||
                              ((str2 == "saveasExcelAll") || (str2 == "saveasExcel"))) ||
                             (((str2 == "saveasPdf") || (str2 == "run")) ||
                              ((str2 == "calcStr") || (str2 == "importExcel")))) || (str2 == "genHtmlFile");
                RunReport report = new RunReport(base.Request, this.Session, connConfig.getDBOperator());
                switch (str2)
                {
                case "loadFileStream":
                    report.loadFileStream(base.Request, base.Response);
                    return;

                case "getTempImage":
                    report.getTempImage(base.Request, base.Response);
                    return;

                case "saveasExcelAll":
                    report.saveasExcel(base.Request, base.Response, false);
                    return;

                case "saveasExcel":
                    report.saveasExcel(base.Request, base.Response, true);
                    return;

                case "saveasPdf":
                    report.saveasPdf(base.Request, base.Response);
                    return;

                case "run":
                    url = report.run(base.Request);
                    break;

                case "calcStr":
                    url = report.calcStr(base.Request);
                    break;

                case "importExcel":
                {
                    string sDest = base.Request["excelfile"];
                    sDest = PathTool.getRealPath(base.Request, FileAction.basePath + sDest);
                    string str7 = base.Request["spath"];
                    url = ImportExcel.FileConvert(PathTool.getRealPath(base.Request, FileAction.basePath + str7),
                                                  sDest);
                    break;
                }

                case "genHtmlFile":
                    Logger.debug("开始成批运算报表:");
                    url = report.genHtmlFile(base.Request);
                    break;
                }
                if (flag)
                {
                    goto Label_0BE9;
                }
                if (((((str2 != "setSession") && (str2 != "getSession")) &&
                      ((str2 != "uploadFile") && (str2 != "readImage"))) &&
                     ((str2 != "readClob") && (str2 != "saveFile"))) && (str2 != "zkLoadMod"))
                {
                    str4 = new StreamReader(base.Request.InputStream).ReadToEnd();
                    Logger.debug("XML串: " + str4);
                    if ((str2 != "saveRunInfo") && (str2 != "readDomainRes"))
                    {
                        xdoc = new XmlDocument();
                        xdoc.LoadXml(str4);
                    }
                }
                if (str2 != "loadingBatchAction")
                {
                    goto Label_05FE;
                }
                StringBuilder builder = new StringBuilder("<root>");
                int           num     = 0;
Label_041D:
                if (num >= xdoc.DocumentElement.ChildNodes.Count)
                {
                    goto Label_05E9;
                }
                XmlDocument document2 = new XmlDocument();
                document2.LoadXml(xdoc.DocumentElement.ChildNodes.Item(num).OuterXml);
                try
                {
                    dsName = xdoc.DocumentElement.ChildNodes.Item(num).Attributes["datasourceName"].Value;
                }
                catch (Exception)
                {
                }
                goto Label_0573;
Label_048C:
                builder.Append(sql.fillcombox());
                goto Label_055B;
Label_04A0:
                if (str8 == "getDsns")
                {
                    builder.Append(connConfig.getDsns());
                }
                else if (str8 == "fc_select")
                {
                    builder.Append(sql.fc_select());
                }
                else if (str8 == "dataset_fields1")
                {
                    builder.Append(sql.dataset_fields1());
                }
                else if (str8 == "dataset_select")
                {
                    builder.Append(sql.dataset_select());
                }
                else if (str8 == "sqltotreedata")
                {
                    builder.Append(tree.sqltotreedata());
                }
                else if (str8 == "getTreeXml")
                {
                    builder.Append(tree.getTreeXml());
                }
Label_055B:
                builder.Append("</root>");
                num++;
                goto Label_041D;
Label_0573:
                str8       = xdoc.DocumentElement.ChildNodes.Item(num).Attributes["key"].Value;
                connConfig = new ConnectionConfig(dsName);
                sql        = new QuerySql(connConfig, document2, base.Request, this.Session);
                tree       = new SqlToTree(connConfig, document2);
                builder.Append("<root>");
                if (str8 != "fillcombox")
                {
                    goto Label_04A0;
                }
                goto Label_048C;
Label_05E9:
                builder.Append("</root>");
                url = builder.ToString();
Label_05FE:
                if (str2 == "getDsns")
                {
                    url = connConfig.getDsns();
                }
                if (str2 == "isRunForm")
                {
                    url = PermitForm.isRunForm(base.Request, this.Session, connConfig.getDBOperator());
                }
                if (str2 == "isRunReport")
                {
                    url = PermitReport.isRunReport(base.Request, this.Session, connConfig.getDBOperator());
                }
                EbiaoFile file = new EbiaoFile(connConfig.getDBOperator(), xdoc, base.Request);
                if (str2 == "saveFile")
                {
                    url = file.saveFile();
                }
                if (str2 == "loadFile")
                {
                    url = file.loadFile();
                }
                if (str2 == "ToInDs")
                {
                    url = file.ToInDs();
                }
                QuerySql sql2 = new QuerySql(connConfig, xdoc, base.Request, this.Session);
                if (str2 == "fillcombox")
                {
                    url = sql2.fillcombox();
                }
                if (str2 == "sqltoxml")
                {
                    url = sql2.sqltoxml();
                }
                if (str2 == "SqlToField")
                {
                    url = sql2.SqlToField();
                }
                if (str2 == "fc_select")
                {
                    url = sql2.fc_select();
                }
                if (str2 == "dataset_fields1")
                {
                    url = sql2.dataset_fields1();
                }
                if (str2 == "dataset_select")
                {
                    url = sql2.dataset_select();
                }
                if (str2 == "doUploadInfo")
                {
                    url = sql2.doUploadInfo();
                }
                if (str2 == "crosstab")
                {
                    url = sql2.crosstab();
                }
                ExportData data = new ExportData(xdoc, base.Request, this.Session);
                if (str2 == "exportData")
                {
                    data.run();
                }
                ImportData data2 = new ImportData(base.Request, this.Session, connConfig);
                if (str2 == "importData")
                {
                    url = data2.run();
                }
                WebDesign design = new WebDesign(connConfig, xdoc, base.Request);
                if (str2 == "designdjsave")
                {
                    url = design.designdjsave();
                }
                if (str2 == "loadClob")
                {
                    url = design.loadClob();
                }
                cn.com.fcsoft.ajax.PathFile file2 = new cn.com.fcsoft.ajax.PathFile(xdoc);
                if (str2 == "GetUrl")
                {
                    url = file2.GetUrl(base.Request);
                }
                DbStru stru2 = new DbStru(connConfig, xdoc, base.Request);
                if (str2 == "GetAllTables")
                {
                    url = stru2.GetAllTables();
                }
                if (str2 == "GetFieldName")
                {
                    url = stru2.GetFieldName();
                }
                if (str2 == "setDbStru")
                {
                    url = stru2.setDbStru();
                }
                SubmitData data3 = new SubmitData(connConfig, xdoc, base.Request, this.Session);
                if (str2 == "doSaveData")
                {
                    url = data3.doSaveData();
                }
                FileAction action = new FileAction(xdoc, base.Request);
                if (str2 == "readdesignhtml")
                {
                    url = action.readdesignhtml();
                }
                if (str2 == "savedesignhtml")
                {
                    url = action.savedesignhtml();
                }
                if (str2 == "genDjHtmlFile")
                {
                    url = action.genDjHtmlFile();
                }
                if (str2 == "GetFileContent")
                {
                    url = action.GetFileContent();
                }
                if (str2 == "DelUploadFile")
                {
                    url = action.DelUploadFile();
                }
                if (str2 == "uploadFile")
                {
                    url = action.uploadFile();
                }
                if (str2 == "fileExist")
                {
                    url = action.fileExist();
                }
                MaxNo no = new MaxNo(connConfig, xdoc, this.Session);
                if (str2 == "getMaxIntNo")
                {
                    url = no.getMaxIntNo();
                }
                if (str2 == "getRecnum")
                {
                    url = no.getRecnum();
                }
                if (str2 == "getAutoNum")
                {
                    url = no.getAutoNum();
                }
                SqlToTree tree2 = new SqlToTree(connConfig, xdoc);
                if (str2 == "sqltotreedata")
                {
                    url = tree2.sqltotreedata();
                }
                if (str2 == "getTreeXml")
                {
                    url = tree2.getTreeXml();
                }
                DoSession session = new DoSession(base.Request, this.Session);
                if (str2 == "setSession")
                {
                    url = session.setSession();
                }
                if (str2 == "getSession")
                {
                    url = session.getSession();
                }
                cn.com.fcsoft.ajax.ImageField field = new cn.com.fcsoft.ajax.ImageField(connConfig, base.Request);
                if (str2 == "readImage")
                {
                    field.readImage(base.Response);
                }
                if (str2 == "writeImage")
                {
                    url = field.writeImage();
                }
                ClobField field2 = new ClobField(connConfig, base.Request);
                if (str2 == "readClob")
                {
                    url = field2.readClob();
                }
                if (str2 == "writeClob")
                {
                    url = field2.writeClob();
                }
                EformRole role = new EformRole
                {
                    session = this.Session,
                    request = base.Request,
                    xdoc    = xdoc,
                    oDb     = connConfig.getDBOperator()
                };
                if (str2 == "roleSet")
                {
                    url = role.roleSet();
                }
                if (str2 == "roleCheckEmployee")
                {
                    url = role.roleCheckEmployee();
                }
                if (str2 == "getAllPubParamValue")
                {
                    url = role.getAllPubParamValue();
                }
                if (str2 == "batchExecSql")
                {
                    if (EformRole.getPubParamValue(this.Session, "用户.ID") != "systemadmin")
                    {
                        throw new Exception("只有用户 admin 才有权做此操作!");
                    }
                    string         str10       = xdoc.DocumentElement.ChildNodes.Item(0).InnerText;
                    DBOperator     @operator   = null;
                    IDbCommand     command     = null;
                    IDbTransaction transaction = null;
                    try
                    {
                        @operator = connConfig.getDBOperator();
                        @operator.Open();
                        command             = @operator.Connection.CreateCommand();
                        command.Connection  = (@operator.Connection);
                        transaction         = @operator.Connection.BeginTransaction();
                        command.Transaction = (transaction);
                        command.CommandText = (str10);
                        command.ExecuteNonQuery();
                        transaction.Commit();
                        command.Dispose();
                        @operator.Close();
                    }
                    catch (Exception exception)
                    {
                        try
                        {
                            transaction.Rollback();
                        }
                        catch (Exception)
                        {
                        }
                        throw exception;
                    }
                    finally
                    {
                        try
                        {
                            @operator.Close();
                        }
                        catch (Exception)
                        {
                        }
                    }
                }
            }
            catch (Exception exception2)
            {
                Logger.error(exception2.StackTrace);
                url = JSON.errInfoToJson(exception2);
            }
Label_0BE9:
            if ((url != null) || (str2 != "readImage"))
            {
                /*
                 *  Bill.aspx?key=run&spath=/rpt/s_simplelist.htm&tempfilepath=/tmp/file/&pageno=1&cacheid=&e_paramid=
                 *  ebrun.htm?name=s_simplelist
                 */
                base.Response.ContentType = ("text/html;charset=UTF-8");
                File.WriteAllText(@"E:\DB\PlatForm\FlexCell.NET\ebiao\bin\cleaned\src\Web\" + str2 + "_test.htm", url);
                base.Response.Write(url);
            }
        }