示例#1
0
    private void BindGrid10()
    {
        string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();

        Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);

        StringBuilder cmdTxt = new StringBuilder();
        StringBuilder QUERYS = new StringBuilder();


        cmdTxt.AppendFormat(@" 
                            SELECT 
                            [ID]
                            ,[KINDS]
                            ,[NAMES]
                            ,[MOQS]
                            ,[INDAYS]
                            ,[COMMENTS]
                            FROM [TKBUSINESS].[dbo].[TBPURMOQ]
                            WHERE [KINDS]=@KINDS
                            ORDER BY [ID]
                            ");



        m_db.AddParameter("@KINDS", "OEM");
        //m_db.AddParameter("@EDATE", EDATE);

        DataTable dt = new DataTable();

        dt.Load(m_db.ExecuteReader(cmdTxt.ToString()));

        Grid10.DataSource = dt;
        Grid10.DataBind();
    }
示例#2
0
 protected void Grid2_RowCommand(object sender, GridCommandEventArgs e)
 {
     if (e.CommandName == "Action1")
     {
         object[] keys = Grid2.DataKeys[e.RowIndex];
         int      ID   = Convert.ToInt32(keys[0].ToString());//获取ID
         if (ID > 0 && ID != 9999)
         {
             List <School盘点人员进度> pdry = bll.查询盘点人员进度(ID);
             Grid10.DataSource = pdry;//DataTable
             Grid10.DataBind();
             Window7.Hidden = false;
         }
     }
     else
     {
     }
 }
示例#3
0
    private void BindGrid10(string SDATE, string EDATE)
    {
        string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString();

        Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);

        string cmdTxt = @"
                        SELECT [ORDERS],[USER_ID],[USER_NAME],[USER_ACCOUNT],[COMPANY_ID],[COMPANY_NAME],[ERPNO],NOTES
                        FROM (
                        SELECT  [ORDERS],[USER_ID],[USER_NAME],[USER_ACCOUNT],[COMPANY_ID],[COMPANY_NAME],[ERPNO]
                        ,(SELECT COUNT([tb_NOTE].[COMPANY_ID]) FROM [HJ_BM_DB].[dbo].[tb_NOTE] WHERE   [tb_NOTE].COMPANY_ID=[tb_COMPANY].COMPANY_ID  AND [OWNER_ID]=[USER_ID]  AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)>=@SDATE AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)<=@EDATE) AS 'NOTES'
                        FROM [HJ_BM_DB].[dbo].[COPSALES]
                        LEFT JOIN [HJ_BM_DB].[dbo].[tb_COMPANY] ON [STATUS]='1' AND OWNER_ID=USER_ID 
                        ) AS TEMP
                        WHERE NOTES<=0
                        ORDER BY [ORDERS],NOTES DESC,[COMPANY_NAME]   
                        

                        ";

        //DateTime SD = Convert.ToDateTime(SDATE);
        //SD = SD.AddDays(7);
        //DateTime ED = Convert.ToDateTime(EDATE);
        //ED = ED.AddDays(7);

        DateTime FirstDay = DateTime.Now.AddDays(-DateTime.Now.Day + 1);
        DateTime LastDay  = DateTime.Now.AddMonths(1).AddDays(-DateTime.Now.AddMonths(1).Day);

        string SSDATE = FirstDay.ToString("yyyy/MM/dd");
        string EEDATE = LastDay.ToString("yyyy/MM/dd");

        m_db.AddParameter("@SDATE", SSDATE);
        m_db.AddParameter("@EDATE", EEDATE);

        DataTable dt = new DataTable();

        dt.Load(m_db.ExecuteReader(cmdTxt));

        Grid10.DataSource = dt;
        Grid10.DataBind();
    }
示例#4
0
    //Show Events .........................................................................................................................................
    protected void BtnEvents_Click(object sender, EventArgs e)
    {
        SqlConnection  con = new SqlConnection();
        SqlDataAdapter sda = new SqlDataAdapter();
        DataSet        ds  = new DataSet();


        try
        {
            con.ConnectionString = WebConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            con.Open();

            SqlCommand cmd = new SqlCommand("Show_Event", con);
            cmd.CommandType = System.Data.CommandType.StoredProcedure;

            cmd.Parameters.Add(new SqlParameter("@event_id", Events1.Text));

            if (Events1.Text == "" | Convert.ToInt32(Events1.Text) > 2)
            {
                HttpContext.Current.Response.Write("<SCRIPT LANGUAGE=''JavaScript''> alert('Enter A Valid Event')</SCRIPT>");
            }
            else
            {
                cmd.ExecuteNonQuery();

                //cnn.ConnectionString = "Data Source=(localdb)\\ProjectsV13;Initial Catalog=IEgypt_64;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
                //cnn.Open();
                try
                {
                    SqlCommand cmd1 = new SqlCommand("Show_Event", con);
                    cmd1.CommandType = System.Data.CommandType.StoredProcedure;
                    cmd1.Parameters.Add(new SqlParameter("@event_id", Events1.Text));

                    SqlDataAdapter sda1 = new SqlDataAdapter(cmd1);
                    cmd1.ExecuteNonQuery();
                    DataTable dt1 = new DataTable();
                    sda1.Fill(dt1);
                    Grid10.DataSource = dt1;
                    Grid10.DataBind();
                }
                catch (Exception e1)
                {
                    HttpContext.Current.Response.Write("<SCRIPT LANGUAGE=''JavaScript''> alert('SQl Query Fail')</SCRIPT>");
                }
                try
                {
                }
                catch (Exception e1)
                {
                    HttpContext.Current.Response.Write("<SCRIPT LANGUAGE=''JavaScript''> alert('Table creation Failed')</SCRIPT>");
                }
                //cnn.Close();
                HttpContext.Current.Response.Write("<SCRIPT LANGUAGE=''JavaScript''> alert('Events are here!!')</SCRIPT>");
            }
        }
        catch (Exception e1)
        {
            HttpContext.Current.Response.Write("<SCRIPT LANGUAGE=''JavaScript''> alert('OOps an Error Has Occured Try Again Later :)')</SCRIPT>");
        }
        con.Close();
    }
示例#5
0
        private void LoadDataList()
        {
            try
            {
                DataSet _DataList = null;
                _DataList = DatabaseManager.Data.DBAccessManager.RetrieveDashBoardDataByEmpID(Int32.Parse(Page.User.Identity.Name.ToString()), Int32.Parse(businessUnitDDList.SelectedValue), Int32.Parse(DivisionLocationList.SelectedValue));

                if (_DataList.Tables.Count > 0)
                {
                    if (_DataList.Tables[0].Rows.Count > 0) // Employee Divisional Chart
                    {
                        DataTable _DataTable = _DataList.Tables[0];
                        Division_EmpListChart(_DataTable);
                    }
                    else
                    {
                        EmpListChart1.Items.Clear();
                    }

                    if (_DataList.Tables[1].Rows.Count > 0) // Employee Location  Chart
                    {
                        DataTable _DataTable = _DataList.Tables[1];
                        Location_EmpListChart(_DataTable);
                    }
                    else
                    {
                        EmpListChart2.Items.Clear();
                    }

                    if (_DataList.Tables[2].Rows.Count > 0) // Employee Age Profile  Chart
                    {
                        DataTable _DataTable = _DataList.Tables[2];
                        AgeProfile_EmpListChart(_DataTable);
                    }
                    else
                    {
                        EmpListChart3.Items.Clear();
                    }

                    if (_DataList.Tables[3].Rows.Count > 0) // Employee Service Profile  Chart
                    {
                        DataTable _DataTable = _DataList.Tables[3];
                        ServiceProfile_EmpListChart(_DataTable);
                    }
                    else
                    {
                        EmpListChart4.Items.Clear();
                    }

                    if (_DataList.Tables[4].Rows.Count > 0) // Expiring Labor Cards in the next 6 months.
                    {
                        DataTable _DataTable = _DataList.Tables[4];
                        Grid3.DataSource = _DataTable;
                        Grid3.DataBind();
                    }
                    else
                    {
                        Grid3.DataSource = null;
                        Grid3.DataBind();
                    }

                    if (_DataList.Tables[5].Rows.Count > 0) // Expiring Visa in the next 6 months.
                    {
                        DataTable _DataTable = _DataList.Tables[5];
                        Grid4.DataSource = _DataTable;
                        Grid4.DataBind();
                    }
                    else
                    {
                        Grid4.DataSource = null;
                        Grid4.DataBind();
                    }


                    if (_DataList.Tables[6].Rows.Count > 0) // Expiring Passports in the next 6 months.
                    {
                        DataTable _DataTable = _DataList.Tables[6];
                        Grid5.DataSource = _DataTable;
                        Grid5.DataBind();
                    }
                    else
                    {
                        Grid5.DataSource = null;
                        Grid5.DataBind();
                    }

                    if (_DataList.Tables[7].Rows.Count > 0) // Pending Leave in the current week.
                    {
                        DataTable _DataTable = _DataList.Tables[7];
                        Grid1.DataSource = _DataTable;
                        Grid1.DataBind();
                    }
                    else
                    {
                        Grid1.DataSource = null;
                        Grid1.DataBind();
                    }


                    if (_DataList.Tables[8].Rows.Count > 0) // Upcoming Holidays
                    {
                        DataTable _DataTable = _DataList.Tables[8];
                        Grid2.DataSource = _DataTable;
                        Grid2.DataBind();
                    }
                    else
                    {
                        Grid2.DataSource = null;
                        Grid2.DataBind();
                    }

                    if (_DataList.Tables[10].Rows.Count > 0) // Upcoming Probation endings
                    {
                        DataTable _DataTable = _DataList.Tables[10];
                        Grid7.DataSource = _DataTable;
                        Grid7.DataBind();
                    }
                    else
                    {
                        Grid7.DataSource = null;
                        Grid7.DataBind();
                    }
                    if (_DataList.Tables[11].Rows.Count > 0) // Business Visa Expiry
                    {
                        DataTable _DataTable = _DataList.Tables[11];
                        Grid10.DataSource = _DataTable;
                        Grid10.DataBind();
                    }
                    else
                    {
                        Grid10.DataSource = null;
                        Grid10.DataBind();
                    }
                }
            }
            catch (Exception exception)
            {
                ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
            }
        }
示例#6
0
        private void LoadDataList()
        {
            try
            {
                DataSet _DataList = null;
                _DataList = DatabaseManager.Data.DBAccessManager.RetrieveDashBoardDataByEmpID(Int32.Parse(Page.User.Identity.Name.ToString()), Int32.Parse(businessUnitDDList.SelectedValue), Int32.Parse(DivisionLocationList.SelectedValue));

                if (_DataList.Tables.Count > 0)
                {
                    if (_DataList.Tables[0].Rows.Count > 0) // Employee Divisional PieChart
                    {
                        PieXML = "";
                        DataTable _DataTable = _DataList.Tables[0];
                        PieXML          = CreatePieGraph1(_DataTable, "Employee Count Breakdown By Business Unit/Dept", "", "Count", "Division/Dept");
                        FCLiteral1.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "DivisionDeptChart", PieWidth, PieHeight, false);
                    }
                    else
                    {
                        FCLiteral1.Visible = false;
                    }
                    if (_DataList.Tables[1].Rows.Count > 0) // Employee Location PieChart
                    {
                        PieXML = "";
                        DataTable _DataTable = _DataList.Tables[1];
                        PieXML          = CreatePieGraph1(_DataTable, "Employee Count Breakdown By Country", "", "Country", "Count");
                        FCLiteral2.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "CountryChart", PieWidth, PieHeight, false);
                    }
                    else
                    {
                        FCLiteral2.Visible = false;
                    }
                    if (_DataList.Tables[2].Rows.Count > 0) // Employee Age Profile PieChart
                    {
                        DataTable _DataTable = _DataList.Tables[2];
                        CreateBarGraph1(_DataTable);
                    }
                    else
                    {
                        FCLiteral3.Visible = false;
                    }
                    if (_DataList.Tables[3].Rows.Count > 0) // Employee Service Profile PieChart
                    {
                        PieXML = "";
                        DataTable _DataTable = _DataList.Tables[3];
                        PieXML          = CreatePieGraph1(_DataTable, "Employee Service Year Profile", "", "Count", "Division/Dept");
                        FCLiteral4.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "ServiceChart", PieWidth, PieHeight, false);
                    }
                    else
                    {
                        FCLiteral4.Visible = false;
                    }

                    if (_DataList.Tables[4].Rows.Count > 0) // Expiring Labor Cards in the next 6 months.
                    {
                        DataTable _DataTable = _DataList.Tables[4];
                        Grid3.DataSource = _DataTable;
                        Grid3.DataBind();
                    }
                    else
                    {
                        Grid3.DataSource = null;
                        Grid3.DataBind();
                    }

                    if (_DataList.Tables[5].Rows.Count > 0) // Expiring Visa in the next 6 months.
                    {
                        DataTable _DataTable = _DataList.Tables[5];
                        Grid4.DataSource = _DataTable;
                        Grid4.DataBind();
                    }
                    else
                    {
                        Grid4.DataSource = null;
                        Grid4.DataBind();
                    }


                    if (_DataList.Tables[6].Rows.Count > 0) // Expiring Passports in the next 6 months.
                    {
                        DataTable _DataTable = _DataList.Tables[6];
                        Grid5.DataSource = _DataTable;
                        Grid5.DataBind();
                    }
                    else
                    {
                        Grid5.DataSource = null;
                        Grid5.DataBind();
                    }

                    if (_DataList.Tables[7].Rows.Count > 0) // Pending Leave in the current week.
                    {
                        DataTable _DataTable = _DataList.Tables[7];
                        Grid1.DataSource = _DataTable;
                        Grid1.DataBind();
                    }
                    else
                    {
                        Grid1.DataSource = null;
                        Grid1.DataBind();
                    }


                    if (_DataList.Tables[8].Rows.Count > 0) // Upcoming Holidays
                    {
                        DataTable _DataTable = _DataList.Tables[8];
                        Grid2.DataSource = _DataTable;
                        Grid2.DataBind();
                    }
                    else
                    {
                        Grid2.DataSource = null;
                        Grid2.DataBind();
                    }

                    if (_DataList.Tables[10].Rows.Count > 0) // Upcoming Probation endings
                    {
                        DataTable _DataTable = _DataList.Tables[10];
                        Grid7.DataSource = _DataTable;
                        Grid7.DataBind();
                    }
                    else
                    {
                        Grid7.DataSource = null;
                        Grid7.DataBind();
                    }
                    if (_DataList.Tables[11].Rows.Count > 0) // Business Visa Expiry
                    {
                        DataTable _DataTable = _DataList.Tables[11];
                        Grid10.DataSource = _DataTable;
                        Grid10.DataBind();
                    }
                    else
                    {
                        Grid10.DataSource = null;
                        Grid10.DataBind();
                    }
                }
            }
            catch (Exception exception)
            {
                ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
            }
        }
示例#7
0
 private void BindGrid(int n)
 {
     if (n == 0)
     {
         EducationLevelBLL      objBLL  = new EducationLevelBLL();
         IList <EducationLevel> objList = objBLL.GetAllEducationLevel();
         Grid1.DataSource = objList;
         Grid1.DataBind();
         Grid1.Visible = true;
         Grid2.Visible = false;
         Grid3.Visible = false;
         Grid4.Visible = false;
         Grid5.Visible = false;
         Grid6.Visible = false;
         Grid7.Visible = false;
         Grid8.Visible = false;
         Grid9.Visible = false;
     }
     if (n == 1)
     {
         PoliticalStatusBLL      objBLL  = new PoliticalStatusBLL();
         IList <PoliticalStatus> objList = objBLL.GetAllPoliticalStatus();
         Grid2.DataSource = objList;
         Grid2.DataBind();
         Grid1.Visible = false;
         Grid2.Visible = true;
         Grid3.Visible = false;
         Grid4.Visible = false;
         Grid5.Visible = false;
         Grid6.Visible = false;
         Grid7.Visible = false;
         Grid8.Visible = false;
         Grid9.Visible = false;
     }
     if (n == 2)
     {
         WorkGroupLeaderLevelBLL      objBLL  = new WorkGroupLeaderLevelBLL();
         IList <WorkGroupLeaderLevel> objList = objBLL.GetAllWorkGroupLeaderLevel();
         Grid3.DataSource = objList;
         Grid3.DataBind();
         Grid1.Visible = false;
         Grid2.Visible = false;
         Grid3.Visible = true;
         Grid4.Visible = false;
         Grid5.Visible = false;
         Grid6.Visible = false;
         Grid7.Visible = false;
         Grid8.Visible = false;
         Grid9.Visible = false;
     }
     if (n == 3)
     {
         TechnicianTypeBLL      objBLL  = new TechnicianTypeBLL();
         IList <TechnicianType> objList = objBLL.GetAllTechnicianType();
         Grid4.DataSource = objList;
         Grid4.DataBind();
         Grid1.Visible = false;
         Grid2.Visible = false;
         Grid3.Visible = false;
         Grid4.Visible = true;
         Grid5.Visible = false;
         Grid6.Visible = false;
         Grid7.Visible = false;
         Grid8.Visible = false;
         Grid9.Visible = false;
     }
     if (n == 4)
     {
         TechnicianTitleTypeBLL      objBLL  = new TechnicianTitleTypeBLL();
         IList <TechnicianTitleType> objList = objBLL.GetAllTechnicianTitleType();
         Grid5.DataSource = objList;
         Grid5.DataBind();
         Grid1.Visible = false;
         Grid2.Visible = false;
         Grid3.Visible = false;
         Grid4.Visible = false;
         Grid5.Visible = true;
         Grid6.Visible = false;
         Grid7.Visible = false;
         Grid8.Visible = false;
         Grid9.Visible = false;
     }
     if (n == 5)
     {
         EducationEmployeeTypeBLL      objBLL  = new EducationEmployeeTypeBLL();
         IList <EducationEmployeeType> objList = objBLL.GetAllEducationEmployeeType();
         Grid6.DataSource = objList;
         Grid6.DataBind();
         Grid1.Visible = false;
         Grid2.Visible = false;
         Grid3.Visible = false;
         Grid4.Visible = false;
         Grid5.Visible = false;
         Grid6.Visible = true;
         Grid7.Visible = false;
         Grid8.Visible = false;
         Grid9.Visible = false;
     }
     if (n == 6)
     {
         CommitteeHeadShipBLL      objBLL  = new CommitteeHeadShipBLL();
         IList <CommitteeHeadShip> objList = objBLL.GetAllCommitteeHeadShip();
         Grid7.DataSource = objList;
         Grid7.DataBind();
         Grid1.Visible = false;
         Grid2.Visible = false;
         Grid3.Visible = false;
         Grid4.Visible = false;
         Grid5.Visible = false;
         Grid6.Visible = false;
         Grid7.Visible = true;
         Grid8.Visible = false;
         Grid9.Visible = false;
     }
     if (n == 7)
     {
         RandomExamModularTypeBLL      objBLL  = new RandomExamModularTypeBLL();
         IList <RandomExamModularType> objList = objBLL.GetAllRandomExamModularType();
         Grid8.DataSource = objList;
         Grid8.DataBind();
         Grid1.Visible = false;
         Grid2.Visible = false;
         Grid3.Visible = false;
         Grid4.Visible = false;
         Grid5.Visible = false;
         Grid6.Visible = false;
         Grid7.Visible = false;
         Grid8.Visible = true;
         Grid9.Visible = false;
     }
     if (n == 8)
     {
         OracleAccess oracle = new OracleAccess();
         DataTable    dt     = oracle.RunSqlDataSet("select * from zj_trainplan_type order by trainplan_type_id").Tables[0];
         Grid9.DataSource = dt;
         Grid9.DataBind();
         Grid1.Visible = false;
         Grid2.Visible = false;
         Grid3.Visible = false;
         Grid4.Visible = false;
         Grid5.Visible = false;
         Grid6.Visible = false;
         Grid7.Visible = false;
         Grid8.Visible = false;
         Grid9.Visible = true;
     }
     if (n == 9)
     {
         OracleAccess oracle = new OracleAccess();
         DataTable    dt     = oracle.RunSqlDataSet("select * from zj_safe_level order by order_index").Tables[0];
         Grid10.DataSource = dt;
         Grid10.DataBind();
         Grid1.Visible  = false;
         Grid2.Visible  = false;
         Grid3.Visible  = false;
         Grid4.Visible  = false;
         Grid5.Visible  = false;
         Grid6.Visible  = false;
         Grid7.Visible  = false;
         Grid8.Visible  = false;
         Grid9.Visible  = false;
         Grid10.Visible = true;
     }
     if (n == 10)
     {
         OracleAccess oracle = new OracleAccess();
         DataTable    dt     = oracle.RunSqlDataSet("select * from zj_certificate order by order_index").Tables[0];
         Grid11.DataSource = dt;
         Grid11.DataBind();
         Grid1.Visible  = false;
         Grid2.Visible  = false;
         Grid3.Visible  = false;
         Grid4.Visible  = false;
         Grid5.Visible  = false;
         Grid6.Visible  = false;
         Grid7.Visible  = false;
         Grid8.Visible  = false;
         Grid9.Visible  = false;
         Grid10.Visible = false;
         Grid11.Visible = true;
     }
     if (n == 11)
     {
         OracleAccess oracle = new OracleAccess();
         DataTable    dt     = oracle.RunSqlDataSet(@"select a.*,b.certificate_name from zj_certificate_level a 
                                               left join zj_certificate b on a.certificate_id=b.certificate_id order by a.order_index").Tables[0];
         Grid12.DataSource = dt;
         Grid12.DataBind();
         Grid1.Visible  = false;
         Grid2.Visible  = false;
         Grid3.Visible  = false;
         Grid4.Visible  = false;
         Grid5.Visible  = false;
         Grid6.Visible  = false;
         Grid7.Visible  = false;
         Grid8.Visible  = false;
         Grid9.Visible  = false;
         Grid10.Visible = false;
         Grid11.Visible = false;
         Grid12.Visible = true;
     }
     if (n == 12)
     {
         OracleAccess oracle = new OracleAccess();
         DataTable    dt     = oracle.RunSqlDataSet(" select * from zj_certificate_unit order by order_index").Tables[0];
         Grid13.DataSource = dt;
         Grid13.DataBind();
         Grid1.Visible  = false;
         Grid2.Visible  = false;
         Grid3.Visible  = false;
         Grid4.Visible  = false;
         Grid5.Visible  = false;
         Grid6.Visible  = false;
         Grid7.Visible  = false;
         Grid8.Visible  = false;
         Grid9.Visible  = false;
         Grid10.Visible = false;
         Grid11.Visible = false;
         Grid12.Visible = false;
         Grid13.Visible = true;
     }
     if (n == 13)
     {
         OracleAccess oracle = new OracleAccess();
         DataTable    dt     = oracle.RunSqlDataSet(" select * from zj_train_unit order by order_index").Tables[0];
         Grid14.DataSource = dt;
         Grid14.DataBind();
         Grid1.Visible  = false;
         Grid2.Visible  = false;
         Grid3.Visible  = false;
         Grid4.Visible  = false;
         Grid5.Visible  = false;
         Grid6.Visible  = false;
         Grid7.Visible  = false;
         Grid8.Visible  = false;
         Grid9.Visible  = false;
         Grid10.Visible = false;
         Grid11.Visible = false;
         Grid12.Visible = false;
         Grid13.Visible = false;
         Grid14.Visible = true;
     }
 }
示例#8
0
        protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
        {
            if (e.CommandName == "Action1")
            {
                OffSession();

                string   username = Session["姓名"].ToString();
                object[] keys     = Grid1.DataKeys[e.RowIndex];
                string   职务       = Session["职务"].ToString();
                int      ID       = Convert.ToInt32(keys[0].ToString());//获取ID
                FlowID.Text = ID.ToString();
                School申报审批BLL sbspbll = new School申报审批BLL();
                string        xa      = "";
                string        SID     = keys[1].ToString(); //获取SID
                资产ID.Text = SID;
                string Mark = keys[5].ToString();           //获取FlowName
                FlowName.Text = Mark;
                Sort.Text     = keys[2].ToString();
                #region 报废判断
                if (Mark == "资产处置-报废")
                {
                    int sort = Convert.ToInt32(keys[2]);
                    Sort.Text = sort.ToString();
                    if (sort == 2)
                    {
                        //Button14.Hidden = true;
                        //Button6.Hidden = false;
                    }
                    else
                    {
                        Button2.Hidden = true;
                    }

                    if (keys[11] == null)
                    {
                        原因说明_bfckxq.Text = "";
                    }
                    else
                    {
                        原因说明_bfckxq.Text = keys[11].ToString();
                    }

                    分管领导_bfckxq.Text     = keys[25].ToString();
                    分管领导处理意见_bfckxq.Text = keys[24].ToString();
                    分管领导操作时间_bfckxq.Text = keys[26].ToString();
                    电话_bfckxq.Text       = keys[13].ToString();

                    职务_bfckxq.Text       = keys[13].ToString();
                    事项名称_bfckxq.Text     = keys[17].ToString();
                    主管部门_bfckxq.Text     = keys[29].ToString();
                    主管部门处理意见_bfckxq.Text = keys[27].ToString();

                    主管部门操作时间_bfckxq.Text = keys[28].ToString();
                    财政部门意见_bfckxq.Text   = keys[30].ToString();
                    财政部门_bfckxq.Text     = keys[31].ToString();
                    财政部门操作时间_bfckxq.Text = keys[32].ToString();

                    if (职务 == "分管领导" && sort == 1)
                    {
                        Button15.Hidden = false;
                    }
                    else if (职务 == "主管部门" && sort == 2)
                    {
                        Button15.Hidden = false;
                    }
                    else if (职务 == "财务人员" && sort == 3)
                    {
                        Button15.Hidden = false;
                    }
                    else if (sort == 0)
                    {
                        Button15.Hidden = true;
                    }
                    else
                    {
                        Button15.Hidden = false;
                    }

                    流程状态_abfckxq.Text = keys[3].ToString();
                    单据编号_bfckxq.Text  = keys[4].ToString();
                    float 总数 = 0.0f;
                    float 总价 = 0.0f;
                    总数               = float.Parse(keys[6].ToString());
                    总价               = float.Parse(keys[7].ToString());
                    申报日期_ckxq.Text   = keys[8].ToString();
                    申报单位_bfckxq.Text = keys[9].ToString();
                    申请人_bfckxq.Text  = keys[10].ToString();
                    List <School办公设备信息表> listdata = bll.处置申报查询(SID, keys[5].ToString());

                    Grid7.DataSource = listdata;
                    Grid7.DataBind();

                    Grid8.DataSource = listdata;
                    Grid8.DataBind();
                    JObject summary = new JObject();
                    summary.Add("major", "全部合计");
                    summary.Add("数量_bfckxq", 总数.ToString("F2"));
                    summary.Add("价格_bfckxq", 总价.ToString("F2"));
                    Grid7.SummaryData = summary;
                    Grid8.SummaryData = summary;
                    Window4.Hidden    = false;
                    string zcid = keys[1].ToString();
                    资产ID.Text = zcid;
                }
                #endregion
                #region 调拨
                else if (Mark == "资产处置-调拨")
                {
                    /*
                     * ID(0),SID(1),Sort(2),流程状态(3),单据编号(4),FlowName(5),总数(6),总价(7),申报日期(8),申报单位(9),申请人(10)
                     * ,原因说明(11),职务(12),电话(13),验收日期(14),调入单位(15),调出单位(16),事项名称(17)
                     * ,调出单位分管领导意见(18),调出单位分管领导(19),调出单位分管领导处理时间(20),调入单位管理员意见(21),调入单位管理员(22)
                     * ,调入单位管理员处理时间(23),调入单位分管领导意见(24),调入单位分管领导(25),调入单位分管领导处理时间(26),主管部门意见(27)
                     * ,主管部门处理时间(28),主管部门(29),财政部门意见(30),财政部门(31),财政部门处理时间(32)
                     */
                    Window5.Hidden = false;
                    int sort = Convert.ToInt32(keys[2]);
                    btntanchuang.Text    = "处理";
                    btntanchuang.Enabled = false;
                    if (sort == 1)
                    {
                        //分管领导处理
                        if (职务 == "分管领导")
                        {
                            btntanchuang.Text    = "分管领导处理";
                            btntanchuang.Enabled = true;
                        }
                    }
                    else if (sort == 2)
                    {
                        //资产管理员处理
                        if (职务 == "资产管理员")
                        {
                            btntanchuang.Text    = "资产管理员处理";
                            btntanchuang.Enabled = true;
                        }
                    }
                    //调入单位分管领导
                    else if (sort == 3)
                    {
                        if (职务 == "分管领导")
                        {
                            btntanchuang.Text    = "分管领导处理";
                            btntanchuang.Enabled = true;
                        }
                    }
                    else if (sort == 4)
                    {
                        if (职务 == "主管部门")
                        {
                            btntanchuang.Text    = "主管部门处理";
                            btntanchuang.Enabled = true;
                        }
                    }
                    else if (sort == 5)
                    {
                        if (职务 == "财务人员")
                        {
                            btntanchuang.Text    = "财政部门处理";
                            btntanchuang.Enabled = true;
                        }
                    }
                    else if (sort == 6)
                    {
                        //string aID = Session["ID"].ToString();
                        //int zcczID = Convert.ToInt32(Session["UserID"].ToString());
                        //string fname = sbspbll.资产处置调出单位(zcczID);
                        if (职务 == "资产管理员" && keys[10].ToString() == username)
                        {
                            btntanchuang.Text    = "资产管理员处理";
                            btntanchuang.Enabled = true;
                        }
                    }
                    else if (sort == 7)
                    {
                        //string aID = Session["ID"].ToString();
                        //int zcczID = Convert.ToInt32(Session["UserID"].ToString());
                        //string fname = sbspbll.资产处置调入单位(zcczID);
                        if (职务 == "资产管理员" && keys[22].ToString() == username)
                        {
                            btntanchuang.Text    = "资产管理员处理";
                            btntanchuang.Enabled = true;
                        }
                    }
                    else if (sort == 0)
                    {
                        btntanchuang.Hidden = true;
                    }



                    else
                    {
                        Button2.Hidden = true;
                    }

                    /*
                     *  ID(0),SID(1),Sort(2),流程状态(3),单据编号(4),FlowName(5),总数(6),总价(7),申报日期(8),申报单位(9),申请人(10)
                     * ,原因说明(11),职务(12),电话(13),验收日期(14),调入单位(15),调出单位(16),事项名称(17)
                     * ,调出单位分管领导意见(18),调出单位分管领导(19),调出单位分管领导处理时间(20),调入单位管理员意见(21),调入单位管理员(22)
                     * ,调入单位管理员处理时间(23),调入单位分管领导意见(24),调入单位分管领导(25),调入单位分管领导处理时间(26),主管部门意见(27)
                     * ,主管部门处理时间(28),主管部门(29),财政部门意见(30),财政部门(31),财政部门处理时间(32)
                     */

                    流程状态_dbckxq.Text = keys[3].ToString();
                    单据编号_dbckxq.Text = keys[4].ToString();
                    int 总数 = 0;
                    int 总价 = 0;
                    总数 = Convert.ToInt32(keys[6].ToString());
                    总价 = Convert.ToInt32(keys[7].ToString());
                    申报日期_dbckxq.Text = keys[8].ToString();
                    申请人_dbckxq.Text  = keys[10].ToString();
                    调拨原因说明.Text      = keys[11].ToString();
                    职务_dbckxq.Text   = keys[12].ToString();
                    电话_dbckxq.Text   = keys[13].ToString();
                    验收日期_dbckxq.Text = keys[14].ToString();
                    调入单位_dbckxq.Text = keys[15].ToString();
                    调出单位_dbckxq.Text = keys[16].ToString();
                    事项名称_dbckxq.Text = keys[17].ToString();

                    调出单位分管领导意见.Text   = keys[18].ToString();
                    调出单位分管领导.Text     = keys[19].ToString();
                    调出单位分管领导处理时间.Text = keys[20].ToString();

                    调入单位管理员意见.Text   = keys[21].ToString();
                    调入单位管理员.Text     = keys[22].ToString();
                    调入单位管理员处理时间.Text = keys[23].ToString();

                    调入单位分管领导意见.Text   = keys[24].ToString();
                    调入单位分管领导.Text     = keys[25].ToString();
                    调入单位分管领导处理时间.Text = keys[26].ToString();

                    调拨主管部门意见.Text = keys[27].ToString();
                    主管部门处理时间.Text = keys[28].ToString();
                    主管部门.Text     = keys[29].ToString();

                    调拨财政部门意见.Text = keys[30].ToString();
                    财政部门.Text     = keys[31].ToString();
                    财政部门处理时间.Text = keys[32].ToString();



                    List <School办公设备信息表> listdata = bll.处置申报查询(SID, keys[5].ToString());
                    Grid9.DataSource = listdata;
                    Grid9.DataBind();
                    Grid10.DataSource = listdata;
                    Grid10.DataBind();
                    JObject summary = new JObject();
                    summary.Add("major", "全部合计");
                    summary.Add("数量_db", 总数.ToString("F2"));
                    summary.Add("价格_db", 总价.ToString("F2"));
                    Grid9.SummaryData  = summary;
                    Grid10.SummaryData = summary;
                }
                #endregion
            }
        }
示例#9
0
        protected void 查看详情_Click(object sender, EventArgs e)
        {
            string FlowID = Request.QueryString["FlowID"];

            if (FlowID != "" && FlowID != null)
            {
                ID = FlowID;
            }
            else
            {
                ID = Request.QueryString["ID"];
            }
            //
            //string SID = Request.QueryString["SID"];
            Window1.Hidden = false;
            string           SID       = bll.资产处置SID(Convert.ToInt32(ID));
            List <流程进度查看详情表> listdatas = bll.资产处置待报废查看详情(ID, SID);


            流程状态_dbckxq.Text = listdatas[0].流程状态.ToString();
            单据编号_dbckxq.Text = listdatas[0].单据编号.ToString();
            float 总数 = 0.0f;
            float 总价 = 0.0f;

            总数                = float.Parse(listdatas[0].总数.ToString());
            总价                = float.Parse(listdatas[0].总价.ToString());
            调出单位分管领导.Text     = listdatas[0].调出单位分管领导.ToString();
            调出单位分管领导意见.Text   = listdatas[0].调出单位分管领导意见.ToString();
            调出单位分管领导处理时间.Text = listdatas[0].调出单位分管领导处理时间.ToString();

            调入单位分管领导意见.Text   = listdatas[0].调入单位分管领导意见.ToString();
            调入单位分管领导.Text     = listdatas[0].调入单位分管领导.ToString();
            调入单位分管领导处理时间.Text = listdatas[0].调入单位分管领导处理时间.ToString();
            调入单位管理员意见.Text    = listdatas[0].调入单位管理员意见.ToString();
            调入单位管理员.Text      = listdatas[0].调入单位管理员.ToString();
            调入单位管理员处理时间.Text  = listdatas[0].调入单位管理员处理时间.ToString();


            电话_dbckxq.Text = listdatas[0].电话.ToString();

            职务_dbckxq.Text   = listdatas[0].职务.ToString();
            事项名称_dbckxq.Text = listdatas[0].事项名称.ToString();
            主管部门.Text        = listdatas[0].主管部门.ToString();
            调拨主管部门意见.Text    = listdatas[0].主管部门意见.ToString();

            主管部门处理时间.Text = listdatas[0].主管部门处理时间.ToString();
            调拨财政部门意见.Text = listdatas[0].财政部门意见.ToString();
            财政部门.Text     = listdatas[0].财政部门.ToString();
            财政部门处理时间.Text = listdatas[0].财政部门处理时间.ToString();
            //原因说明_bfckxq.Text = listdatas[0].原因说明.ToString();
            申请人_dbckxq.Text = listdatas[0].申请人.ToString();
            //申报单位_bfckxq.Text = listdatas[0].申报单位.ToString();
            调出单位_dbckxq.Text = listdatas[0].调出单位.ToString();
            调入单位_dbckxq.Text = listdatas[0].调入单位.ToString();
            申报日期_dbckxq.Text = listdatas[0].申报日期.ToString();
            验收日期_dbckxq.Text = listdatas[0].验收日期.ToString();

            string FlowName = listdatas[0].FlowName.ToString();

            School申报审批BLL        sbspbll  = new School申报审批BLL();
            List <School办公设备信息表> listdata = sbspbll.处置申报查询(SID, FlowName);

            Grid9.DataSource = listdata;
            Grid9.DataBind();
            Grid10.DataSource = listdata;
            Grid10.DataBind();

            JObject summary = new JObject();

            summary.Add("major", "全部合计");
            summary.Add("数量_dbckxq", 总数.ToString("F2"));
            summary.Add("价格_dbckxq", 总价.ToString("F2"));
            Grid9.SummaryData  = summary;
            Grid10.SummaryData = summary;
        }