private void BindGrid6() { 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())); Grid6.DataSource = dt; Grid6.DataBind(); }
//protected void Button7_Click(object sender, EventArgs e) //{ // //string selectedId = Tree1.SelectedNodeID; // //if (!String.IsNullOrEmpty(selectedId)) // //{ // // string message = "选中的节点:" + Tree1.FindNode(selectedId).Text; // // //Alert.Show(message); // //} // //else // //{ // // Alert.Show("chengg!"); // //} //} protected void Tree1_NodeCommand(object sender, TreeCommandEventArgs e) { //int id = Convert.ToInt32(e.Node.NodeID); DataSet ds = bll.筛选存放地点(Convert.ToInt32(e.Node.NodeID)); DataTable dt = ds.Tables[0].Copy();//复制一份table DataTable source = dt; // 3.绑定到Grid Grid6.DataSource = source;//DataTable Grid6.DataBind(); //Alert.Show(e.Node.NodeID); }
private void BindGrid6(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 [USER_NAME],PRECOUNTS,COUNTS,CONVERT(decimal(16,2),(CASE WHEN PRECOUNTS>0 THEN (CONVERT(decimal(16,2),COUNTS)/CONVERT(decimal(16,2),PRECOUNTS)*100) ELSE COUNTS END)) AS 'PCTS' FROM ( SELECT [USER_NAME] ,(SELECT COUNT(*) FROM [UOF].[dbo].[TB_EIP_SCH_WORK] WHERE [SUBJECT] LIKE '%拜訪%' AND CONVERT(nvarchar,[START_TIME],111)>=@SDATE AND CONVERT(nvarchar,[START_TIME],111)<=@EDATE AND [EXECUTE_USER]=[USER_GUID]) AS PRECOUNTS ,COUNT([COMPANY_NAME] ) 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' GROUP BY [USER_NAME] ,[USER_GUID] ) AS TEMP WHERE [USER_NAME] COLLATE Chinese_Taiwan_Stroke_CI_AS IN (SELECT [USER_NAME] FROM [HJ_BM_DB].[dbo].[COPSALES]) ORDER BY [USER_NAME] "; m_db.AddParameter("@SDATE", SDATE); m_db.AddParameter("@EDATE", EDATE); DataTable dt = new DataTable(); dt.Load(m_db.ExecuteReader(cmdTxt)); Grid6.DataSource = dt; Grid6.DataBind(); }
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; } }
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); } } }