private void BindGrid5(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 COUNT(*) AS COUNTS FROM [HJ_BM_DB].[dbo].[tb_NOTE],[HJ_BM_DB].[dbo].[tb_COMPANY] LEFT JOIN [HJ_BM_DB].[dbo].[tb_USER] ON [USER_ID]=[OWNER_ID] WHERE [tb_COMPANY].COMPANY_ID=[tb_NOTE].COMPANY_ID AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)>=@SDATE AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)<=@EDATE AND [tb_NOTE].[COMPANY_ID]<>'0' "; m_db.AddParameter("@SDATE", SDATE); m_db.AddParameter("@EDATE", EDATE); DataTable dt = new DataTable(); dt.Load(m_db.ExecuteReader(cmdTxt)); Grid5.DataSource = dt; Grid5.DataBind(); }
private void BindGrid5() { 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", "內襯"); //m_db.AddParameter("@EDATE", EDATE); DataTable dt = new DataTable(); dt.Load(m_db.ExecuteReader(cmdTxt.ToString())); Grid5.DataSource = dt; Grid5.DataBind(); }
private void btnDesnaStrelica_Click(object sender, RoutedEventArgs e) { vrednost -= 750; brojac++; if (brojac == 3) { btnDesnaStrelica.Visibility = Visibility.Hidden; } else if (brojac == 0 || brojac == 1) { btnLevaStrelica.Visibility = Visibility.Visible; btnDesnaStrelica.Visibility = Visibility.Visible; } DoubleAnimation doubleAnimation = new DoubleAnimation(); PowerEase powerEase = new PowerEase(); powerEase.EasingMode = EasingMode.EaseInOut; powerEase.Power = 10; doubleAnimation.To = vrednost; doubleAnimation.Duration = new Duration(new TimeSpan(0, 0, 0, 0, 700)); // doubleAnimation.EasingFunction = powerEase; Grid1.BeginAnimation(Canvas.LeftProperty, doubleAnimation); Grid2.BeginAnimation(Canvas.LeftProperty, doubleAnimation); Grid3.BeginAnimation(Canvas.LeftProperty, doubleAnimation); Grid4.BeginAnimation(Canvas.LeftProperty, doubleAnimation); Grid5.BeginAnimation(Canvas.LeftProperty, doubleAnimation); Grid6.BeginAnimation(Canvas.LeftProperty, doubleAnimation); Grid7.BeginAnimation(Canvas.LeftProperty, doubleAnimation); }
protected void TabStrip1_TabIndexChanged(object sender, EventArgs e) { if (TabStrip1.ActiveTabIndex == 0) { } else if (TabStrip1.ActiveTabIndex == 1) { //查询关联备件 string sbmc = ""; int 所属单位 = 0; int[] selections = Grid1.SelectedRowIndexArray; foreach (int rowIndex in selections) { sbmc = Grid1.DataKeys[rowIndex][4].ToString(); 所属单位 = Convert.ToInt16(Grid1.DataKeys[rowIndex][10]); } Grid2.DataSource = bll.设备名称关联备件(sbmc, 所属单位); Grid2.DataBind(); } else if (TabStrip1.ActiveTabIndex == 2) { //维修情况 //string sbbh = ""; //int[] selections = Grid1.SelectedRowIndexArray; //foreach (int rowIndex in selections) //{ // sbbh = Grid1.DataKeys[rowIndex][3].ToString(); //} Grid3.DataSource = bll.设备编号关联维修情况(设备编号.Text); Grid3.DataBind(); } else if (TabStrip1.ActiveTabIndex == 3) { //设备BOM } else if (TabStrip1.ActiveTabIndex == 4) { //备件消耗 Grid4.DataSource = bll.设备编号查询备件消耗(设备编号.Text); Grid4.DataBind(); } else if (TabStrip1.ActiveTabIndex == 5) { //预防性维修 string sbbc = 设备名称.Text; //text.Text = bll.查询单台设备平均故障时间("999-1252", "喷枪"); List <预防性维修> listmodel = bll.查询设备平均故障时间(sbbc); Grid5.DataSource = listmodel; Grid5.DataBind(); //List<预防性维修> listmodel = bll.查询设备平均故障时间("车体喷砂系统"); } }
public void LoadOrderDep01(string ORDDER_ID) { if (String.IsNullOrEmpty(ORDDER_ID)) { Grid4.DataSource = null; Grid5.DataSource = null; Grid4.DataBind(); Grid5.DataBind(); } ORDER_DEP01Bll.GetInstence().BandGrid(this, Grid4, 1, ORDDER_ID); ORDER_DEP01Bll.GetInstence().BandGrid(this, Grid5, 2, ORDDER_ID); }
protected void CheckBox3_CheckedChanged(object sender, CheckedEventArgs e) { if (CheckBox3.Checked == true) { GridColumn column = Grid5.FindColumn("负责人");//根据条件来隐藏列 column.Hidden = !column.Hidden; } else { GridColumn column = Grid5.FindColumn("负责人");//根据条件来隐藏列 column.Hidden = !column.Hidden; } }
protected void Button9_Click1(object sender, EventArgs e) { int ID = Convert.ToInt32(HttpContext.Current.Session["UserID"]); School资产报修BLL bll = new School资产报修BLL(); string xa = bll.用户权限(ID); object a = Grid1.SelectedRow.DataKeys[0]; int xx = Convert.ToInt32(a); int sort = Convert.ToInt32(Grid1.SelectedRow.DataKeys[9]); string nm = HttpContext.Current.Session["姓名"].ToString(); string ren = bll.ren(xx); if (xa == "资产管理员" && sort == 1) { DataSet ds = bll.查维修人(); DataTable dt = ds.Tables[0]; Grid5.DataSource = dt; Grid5.DataBind(); Window4.Hidden = false; } else if (xa == "维修人员" && sort == 2) { School待办业务BLL blla = new School待办业务BLL(); TextBox2.Text = nm; TextBox1.Text = blla.获取维修人电话(nm); Window5.Hidden = false; } else if (sort == 3 && ren == nm) { DateTime dtime = DateTime.Now; string sj = dtime.Year + "-" + dtime.Month + "-" + dtime.Day; DatePicker2.EmptyText = sj; if (DatePicker2.Text == "") { DatePicker2.Text = DatePicker2.EmptyText; } Window6.Hidden = false; } else { Alert.ShowInTop("您没有此权限!"); } }
private void bindEvaluateTableToGrid() { string exception = ""; EvaluateTable evaluateTable = new EvaluateTable(); string evaluatedID = Request.QueryString["id"]; if (EvaluationManagementCtrl.GetEvaluateTable(evaluatedID, ref evaluateTable, ref exception)) { ViewState["KeyWeight"] = evaluateTable.KeyWeight; ViewState["ResponseWeight"] = evaluateTable.KeyWeight; ViewState["QualifyWeight"] = evaluateTable.QualifyWeitht; ViewState["AttitudeWeight"] = evaluateTable.AttitudeWeight; ViewState["RejectWeight"] = evaluateTable.RejectWeight; Label_EvaluatedName.Text = evaluateTable.EvaluatedName; Label_PostName.Text = evaluateTable.PostName; Label_LaborDep.Text = evaluateTable.LaborDep; Label_LaborUnit.Text = evaluateTable.LaborUnit; RadioButtonList_Relation.SelectedValue = Request.QueryString["relation"]; Label_Period.Text = evaluateTable.StartTime + " ~ " + evaluateTable.StopTime; //关键岗位职责指标 DataTable table1 = new DataTable(); table1.Columns.Add("Title"); table1.Columns.Add("Quota"); foreach (Quota item in evaluateTable.KeyResponse) { table1.Rows.Add(item.Title, item.Content[0]); } Grid1.DataSource = table1; Grid1.DataBind(); //关键岗位胜任能力指标 DataTable table2 = new DataTable(); table2.Columns.Add("Title"); table2.Columns.Add("Quota1"); table2.Columns.Add("Quota2"); table2.Columns.Add("Quota3"); table2.Columns.Add("Quota4"); foreach (Quota item in evaluateTable.KeyQualify) { table2.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]); } Grid2.DataSource = table2; Grid2.DataBind(); //关键岗位工作态度指标 DataTable table3 = new DataTable(); table3.Columns.Add("Title"); table3.Columns.Add("Quota1"); table3.Columns.Add("Quota2"); table3.Columns.Add("Quota3"); table3.Columns.Add("Quota4"); foreach (Quota item in evaluateTable.KeyAttitude) { table3.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]); } Grid3.DataSource = table3; Grid3.DataBind(); //岗位职责指标 DataTable table4 = new DataTable(); table4.Columns.Add("Title"); table4.Columns.Add("Quota"); foreach (Quota item in evaluateTable.Response) { table4.Rows.Add(item.Title, item.Content[0]); } Grid4.DataSource = table4; Grid4.DataBind(); //岗位胜任能力指标 DataTable table5 = new DataTable(); table5.Columns.Add("Title"); table5.Columns.Add("Quota1"); table5.Columns.Add("Quota2"); table5.Columns.Add("Quota3"); table5.Columns.Add("Quota4"); foreach (Quota item in evaluateTable.Qualify) { table5.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]); } Grid5.DataSource = table5; Grid5.DataBind(); //岗位工作态度指标 DataTable table6 = new DataTable(); table6.Columns.Add("Title"); table6.Columns.Add("Quota1"); table6.Columns.Add("Quota2"); table6.Columns.Add("Quota3"); table6.Columns.Add("Quota4"); foreach (Quota item in evaluateTable.Attitude) { table6.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]); } Grid6.DataSource = table6; Grid6.DataBind(); //否决指标 DataTable table7 = new DataTable(); table7.Columns.Add("Title"); table7.Columns.Add("Quota"); table7.Rows.Add("严重违反规章制度", "累计旷工3天以上的;\n严重失职,营私舞弊,给本单位造成3000元以上经济损失或者其它严重后果的;\n同时与其他用人单位建立劳动关系,对完成本单位工作任务造成严重影响,或者经本单位提出,拒不改正的;\n违背职业道德,行贿、受贿价值超过3000元以上的;\n被依法追究刑事责任的;"); table7.Rows.Add(evaluateTable.Reject[0].Title, evaluateTable.Reject[0].Content[0]); Grid7.DataSource = table7; Grid7.DataBind(); System.Web.UI.WebControls.DropDownList ddl = Grid7.Rows[1].FindControl("DropDownList_Reject") as System.Web.UI.WebControls.DropDownList; ddl.Visible = false; } }
protected void TabStrip2_TabIndexChanged(object sender, EventArgs e) { if (TabStrip2.ActiveTabIndex == 0) { } else if (TabStrip2.ActiveTabIndex == 1) { //查询 拍照补录 // 1.获取数据总数 // Grid3.RecordCount = 700;//测试,去数据库获取总数 // 2.获取当前分页数据 DataSet ds = bll.拍照补录查询(""); DataTable dt = ds.Tables[0].Copy();//复制一份table DataTable source = dt; // 3.绑定到Grid Grid3.DataSource = source;//DataTable Grid3.DataBind(); } else if (TabStrip2.ActiveTabIndex == 2) { DataSet dspk = bll.盘亏处理查询(""); DataTable dtpk = dspk.Tables[0].Copy(); //复制一份table Grid4.DataSource = dtpk; //DataTable Grid4.DataBind(); } else if (TabStrip2.ActiveTabIndex == 3) { //Grid5 Grid5.DataSource = bll.查询盘点报告();//DataTable Grid5.DataBind(); //绑定条件数据 List <School学校名称表> xxmc = bll.查询学校名称(); 单位.DataTextField = "学校名称"; 单位.DataValueField = "ID"; 单位.DataSource = xxmc; 单位.DataBind(); School资产转移BLL bllzy = new School资产转移BLL(); List <School一级部门表> gsbm = bllzy.byzc(); 部门.DataTextField = "名称"; 部门.DataValueField = "ID"; 部门.DataSource = gsbm; 部门.DataBind(); List <School一级类别表> yjlb = bll.查询一级类别(); 一级.DataTextField = "名称"; 一级.DataValueField = "ID"; 一级.DataSource = yjlb; 一级.DataBind(); List <School建筑物信息表> 查询建筑物 = bll.查询建筑物信息表(); 存放地点.DataTextField = "名称"; 存放地点.DataValueField = "ID"; 存放地点.DataSource = 查询建筑物; 存放地点.DataBind(); } }
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."); } }
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."); } }
protected void gridCallBack_Callback(object sender, CallBackEventArgs e) { hfMessage.Value = ""; int n = OrgList.SelectedIndex; try { if (e.Parameters[0] != "") { if (e.Parameters[1] == "Up") { UpData(e.Parameters[0]); } else if (e.Parameters[1] == "Down") { DownData(e.Parameters[0]); } else { DeleteData(e.Parameters[0]); } } else if (e.Parameters[0] == "") { BindGrid(n); } if (n == 0) { Grid1.RenderControl(e.Output); } else if (n == 1) { Grid2.RenderControl(e.Output); } else if (n == 2) { Grid3.RenderControl(e.Output); } else if (n == 3) { Grid4.RenderControl(e.Output); } else if (n == 4) { Grid5.RenderControl(e.Output); } else if (n == 5) { Grid6.RenderControl(e.Output); } else if (n == 6) { Grid7.RenderControl(e.Output); } else if (n == 7) { Grid8.RenderControl(e.Output); } else if (n == 8) { Grid9.RenderControl(e.Output); } else if (n == 9) { Grid10.RenderControl(e.Output); } else if (n == 10) { Grid11.RenderControl(e.Output); } else if (n == 11) { Grid12.RenderControl(e.Output); } else if (n == 12) { Grid13.RenderControl(e.Output); } else if (n == 13) { Grid14.RenderControl(e.Output); } } catch { BindGrid(n); } hfMessage.RenderControl(e.Output); }
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; } }
//确认申报 protected void Button1_Click(object sender, EventArgs e) { if (类别.SelectedValue.ToString() == "待报废") { if (类别.SelectedValue.ToString() == "待报废") { OffSession(); string 职务 = Session["职务"].ToString(); List <int> intlist = new List <int>(); int[] selections = Grid2.SelectedRowIndexArray; Console.Write(selections.Length); if (selections.Length == 0) { Alert.Show("请选择"); } else { Window2.Hidden = false; Console.Write(selections); foreach (int rowIndex in selections) { int ID = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]); intlist.Add(ID); } List <School办公设备信息表> listdata = bll.资产申报确定设备(intlist, 类别.SelectedValue); string flowstate = 类别.SelectedValue; //int 总数 = 0; //int 总价 = 0; float 总数 = 0.0f; float 总价 = 0.0f; if (listdata != null) { foreach (School办公设备信息表 itemjj in listdata) { 总数 += itemjj.数量; 总价 += Convert.ToInt32(itemjj.价格); } } Grid3.DataSource = listdata;//DataTable Grid3.DataBind(); Grid4.DataSource = listdata;//DataTable Grid4.DataBind(); JObject summary = new JObject(); //summary.Add("major", "全部合计"); summary.Add("数量", 总数.ToString("F2")); summary.Add("价格", 总价.ToString("F2")); Grid3.SummaryData = summary; Grid4.SummaryData = summary; //Grid7.SummaryData = summary; //Grid8.SummaryData = summary; //待报废Grid3 报废流程状态.Text = "待审核"; 报废流程状态.Enabled = false; 报废_申报单位.Text = Session["二级部门名称"].ToString(); 报废_申报单位.Enabled = false; 报废_申报日期.Text = DateTime.Now.ToShortDateString(); 报废单据编号.Text = SchoolUtility.strbumber("ZCCZBF");; 报废单据编号.Enabled = false; 报废_申请人.Text = HttpContext.Current.Session["姓名"].ToString(); 报废_申请人.Enabled = false; 报废_职务.Text = 职务; 报废_职务.Enabled = false; } } } else if (类别.SelectedValue.ToString() == "待调拨") { OffSession(); string 职务 = Session["职务"].ToString(); if (职务 == "资产管理员") { School清查盘点BLL pdbll = new School清查盘点BLL(); List <School一级部门表> xxmc = SchoolUtility.查询一级部门不带全部();; 调拨调入单位.DataTextField = "名称"; 调拨调入单位.DataValueField = "ID"; 调拨调入单位.DataSource = xxmc; 调拨调入单位.DataBind(); List <int> intlist = new List <int>(); int[] selections = Grid2.SelectedRowIndexArray; if (selections.Length == 0) { Alert.Show("请选择"); } else { Window3.Hidden = false; foreach (int rowIndex in selections) { int ID = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]); intlist.Add(ID); } List <School办公设备信息表> listdata = bll.资产申报确定设备(intlist, 类别.SelectedValue); string flowstate = 类别.SelectedValue; Grid5.DataSource = listdata;//DataTable Grid5.DataBind(); Grid6.DataSource = listdata; Grid6.DataBind(); //当前用户部门是调出单位 调入单位操作人选填 调拨流程状态.Text = "待审核"; 调拨流程状态.Enabled = false; 调拨调出单位.Text = Session["二级部门名称"].ToString(); 调拨调出单位.Enabled = false; 调拨申报日期.Text = DateTime.Now.ToShortDateString(); 调拨验收日期.Text = DateTime.Now.ToShortDateString(); DateTime dt = DateTime.Now; string y = dt.Year.ToString(); string m = dt.Month.ToString(); string d = dt.Day.ToString(); string h = dt.Hour.ToString(); string mm = dt.Minute.ToString(); 调拨单据编号.Text = SchoolUtility.strbumber("ZCCZDB"); 调拨单据编号.Enabled = false; 调拨_申请人.Text = HttpContext.Current.Session["姓名"].ToString(); 调拨_申请人.Enabled = false; 调拨职务.Enabled = false; 调拨电话.Enabled = false; 调拨职务.Text = HttpContext.Current.Session["职务"].ToString(); try { 调拨电话.Text = HttpContext.Current.Session["联系电话"].ToString(); } catch (Exception) { 调拨电话.Text = ""; } } } else { Alert.Show("您没有资产处置-调拨处理的权限,请联系资产管理员", MessageBoxIcon.Warning); } } }