예제 #1
0
파일: Backup.aspx.cs 프로젝트: ttrr1/Midea
    protected void Page_Load(object sender, EventArgs e)
    {
        ManageHelper.CheckAdminLogin();
        ManageHelper.CheckAdminPower("system_databasebackup");

        if (ManageHelper.PageAct() != "bak")
        {
            return;
        }
        WebConfig.SetString("DatabaseBackupPath", DatabaseBackupPath);

        var db = new Sys.BLL.Common();

        try
        {
            var bakfile = db.DatabaseBackup(DatabaseBackupPath);
            Response.Write("yes");
            ManageHelper.AddLog("system_databasebackup", "数据库备份成功,路径:" + bakfile);
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            ManageHelper.AddLog("system_databasebackup", "数据库备份失败,路径:" + DatabaseBackupPath);
            Response.End();
        }


        Response.End();
    }
예제 #2
0
파일: DelLog.aspx.cs 프로젝트: ttrr1/Midea
    protected void Page_Load(object sender, EventArgs e)
    {
        ManageHelper.CheckAdminLogin();
        ManageHelper.CheckAdminPower("system_databasedellog");
        if (ManageHelper.PageAct() != "del")
        {
            return;
        }
        ManageHelper.CheckAdminPower("system_databasedellog");
        var db = new Sys.BLL.Common();


        try
        {
            db.DatabaseLogDel();
            Response.Write("yes");
            ManageHelper.AddLog("system_databasedellog", "清除数据库日志成功");
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            ManageHelper.AddLog("system_databasedellog", "清除数据库日志失败");
            Response.End();
        }


        Response.End();
    }
예제 #3
0
    /// <summary>
    /// 查询
    /// </summary>
    public void SearchData()
    {
        //查询条件
        var key      = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
        var userType = PageRequest.GetString("userType");
        //分页
        var pageIndex = PageRequest.GetInt("pageIndex", 1) + 1;
        var pageSize  = PageRequest.GetInt("pageSize", 1);
        //字段排序
        var sortField = PageRequest.GetString("sortField");
        var sortOrder = PageRequest.GetString("sortOrder");
        var order     = "";

        if (String.IsNullOrEmpty(sortField) == false)
        {
            if (sortOrder != "desc")
            {
                sortOrder = "asc";
            }
            order = " u." + sortField + " " + sortOrder;
        }
        else
        {
            order += " u.createtime desc";
        }
        var strWhere = "1=1";

        if (!string.IsNullOrEmpty(userType))
        {
            strWhere += " and  u.RoleId=" + userType;
        }
        if (!string.IsNullOrEmpty(key))
        {
            strWhere += " and  charIndex('" + key + "',u.UserName) > 0";
        }

        if (pageSize == 1)
        {
            pageSize = 100;
        }
        var dt      = new Sys.BLL.UserInfo().GetListForMoreTable(pageSize, pageIndex, strWhere, order);
        var dataAll = MyDBUtils.DataTable2ArrayList(dt);
        var result  = new Hashtable();

        result["data"] = dataAll;
        var total = new Sys.BLL.Common().GetCount("UserInfo u", strWhere);

        result["total"] = total;
        //JSON
        var json = PluSoft.Utils.JSON.Encode(result);

        Response.Write(json);
    }
예제 #4
0
    /// <summary>
    /// 查询
    /// </summary>
    public void SearchData()
    {
        //查询条件
        var orderStatus = PageRequest.GetString("orderStatus");
        var projectName = PageRequest.GetString("projectName");
        var cmbDate     = PageRequest.GetString("cmbDate");
        //分页
        var pageIndex = PageRequest.GetInt("pageIndex", 1) + 1;
        var pageSize  = PageRequest.GetInt("pageSize", 1);
        //字段排序
        var sortField = PageRequest.GetString("sortField");
        var sortOrder = PageRequest.GetString("sortOrder");
        var order     = "";

        if (String.IsNullOrEmpty(sortField) == false)
        {
            if (sortOrder != "desc")
            {
                sortOrder = "asc";
            }
            order = " u." + sortField + " " + sortOrder;
        }
        else
        {
            order += " CreateDate desc";
        }
        var strWhere = "1=1";

        if (!string.IsNullOrEmpty(orderStatus))
        {
            if (orderStatus.Equals("0"))
            {
                strWhere += " and  OrderStatus is null";
            }
            else
            {
                strWhere += " and  OrderStatus=" + orderStatus;
            }
        }
        if (!string.IsNullOrEmpty(projectName))
        {
            strWhere += string.Format(" and ProjectName like '%{0}%' ", DataSecurity.FilterBadChar(projectName));
        }
        if (!string.IsNullOrEmpty(cmbDate))
        {
            //1day,3day,1week,1month,halfyear,oneyear
            if (cmbDate.Equals("1day"))
            {
                strWhere += " and CreateDate>=DATEADD(DAY,-1,GETDATE())";
            }
            else if (cmbDate.Equals("3day"))
            {
                strWhere += " and CreateDate>=DATEADD(DAY,-3,GETDATE())";
            }
            else if (cmbDate.Equals("1week"))
            {
                strWhere += " and CreateDate>=DATEADD(DAY,-7,GETDATE())";
            }
            else if (cmbDate.Equals("1month"))
            {
                strWhere += " and CreateDate>=DATEADD(DAY,-30,GETDATE())";
            }
            else if (cmbDate.Equals("halfyear"))
            {
                strWhere += " and CreateDate>=DATEADD(DAY,-180,GETDATE())";
            }
            else if (cmbDate.Equals("oneyear"))
            {
                strWhere += " and CreateDate>=DATEADD(DAY,-365,GETDATE())";
            }
        }
        if (pageSize == 1)
        {
            pageSize = 100;
        }
        var dt      = new Sys.BLL.Orders().GetListForMoreTable(pageSize, pageIndex, strWhere, order);
        var dataAll = MyDBUtils.DataTable2ArrayList(dt);
        var result  = new Hashtable();

        result["data"] = dataAll;
        var total = new Sys.BLL.Common().GetCount("Orders o", strWhere);

        result["total"] = total;
        //JSON
        var json = PluSoft.Utils.JSON.Encode(result);

        Response.Write(json);
    }