protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { WX.Model.DutyDetail.MODEL dd = WX.Model.DutyDetail.GetModel("select * from TE_DutyDetail where Id=" + WX.Main.CurUser.UserModel.DutyId.ToString()); System.Data.DataTable dt2; if (Request["rtype"] == "3")//领导管理层 { dt2 = ULCode.QDA.XSql.GetDataTable("select pp.*,tu.RealName from PLAN_Plan pp left join TU_Users tu on pp.UserID=tu.UserID where RangeType=1 and PlanState=1 order by RangeType desc"); MenuBar1.Key = "plan_cmp"; } else//主管 { string ids = ULCode.QDA.XSql.GetXDataTable("select ID from TE_Departments where ParentID=" + WX.Main.CurUser.UserModel.DepartmentID.ToString()).ToColValueList(",", 0); string ids2 = ULCode.QDA.XSql.GetXDataTable("select DepartentID from TU_User_X_DutyDetail tu left join TE_DutyDetail te on te.ID=tu.DutyDetailID where tu.UserID='" + WX.Main.CurUser.UserID + "'").ToColValueList(",", 0); dt2 = ULCode.QDA.XSql.GetDataTable("select pp.*,tu.RealName from PLAN_Plan pp left join TU_Users tu on pp.UserID=tu.UserID where RangeType=1 and PlanState=1 and tu.DepartmentID in(" + WX.Main.CurUser.UserModel.DepartmentID.ToString() + (ids != "" ? "," + ids : "") + (ids2 != "" ? "," + ids2 : "") + ") order by RangeType desc"); } Gv_duty.DataSource = dt2; Gv_duty.DataBind(); if (Gv_duty.Rows.Count > 0) { Gv_duty.HeaderRow.TableSection = TableRowSection.TableHeader; Gv_duty.HeaderStyle.Height = Unit.Pixel(40); } } }
private void BindTask() { string sql = "select * from PLAN_Task where PlanID=" + WX.Request.rPlanId + " order by id"; System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable(sql); Gv_duty.DataSource = dt; Gv_duty.DataBind(); }
private void BindTask() { string sql = "select * from PLAN_Task where State=1 and PlanID=" + WX.Request.rPlanId + " order by Statetime"; System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable(sql); Gv_duty.DataSource = dt; Gv_duty.DataBind(); int iCount = 4; int iAll = 10; String r = String.Format("完成{0}个,总计{1}个", iCount, iAll); }
private void gridviewBind(WX.Model.Plan.MODEL plan) { lititle.Text = plan.Title.ToString(); lititle.NavigateUrl = "#"; imgwidth = (Convert.ToDouble(plan.Current.ToString()) / Convert.ToDouble(plan.Total.ToString())) * 100; lijindu.Text = " 进度:" + imgwidth.ToString("f0") + "%"; licontent.Text = plan.Content.ToString().Replace("\n", "<br/>"); System.Data.DataTable dtApp = WX.Model.Appraise.GetList(plan.id.ToInt32()); Apptable.Text = ""; for (int i = 0; i < dtApp.Rows.Count; i++) { Apptable.Text += "<li><a title=\"" + dtApp.Rows[i]["Content"] + "\">" + WX.CommonUtils.GetRealNameListByUserIdList(dtApp.Rows[i]["UserID"].ToString()) + ":" + dtApp.Rows[i]["Content"] + " </a><img src=\"/images/Appraise" + dtApp.Rows[i]["Appraise"] + ".jpg\" /><span>" + Convert.ToDateTime(dtApp.Rows[i]["AddTime"]).ToString("yyyy-MM-dd") + "</span></li>"; } string now = DateTime.Now.ToString("yyyy-MM-dd"); WX.Main.CurUser.LoadDutyDetailUser(); if (plan.PlanState.ToInt32() == -1 && plan.UserID.ToString() == WX.Main.CurUser.UserID) { liPlanState.Text = "<b style='color:red;'>审核未通过</b>。原因:" + plan.Reason.ToString() + " <请重新编辑然后提交><br/>"; } //if (plan.Type.ToString() == "2") liSummary.Text = plan.Summary.ToString() == "" ? (DateTime.Now >= plan.Stoptime.ToDateTime().AddDays(-2) && plan.UserID.ToString() == WX.Main.CurUser.UserID ? "<b>总结:</b><a href='Plan_EditSummary.aspx?PlanId=" + plan.id.ToString() + "' style='color:blue;'>创建总结</a>" : "") : "<b>总结:</b>" + plan.Summary.ToString() + (plan.Appraise.ToString() == "" && plan.UserID.ToString() == WX.Main.CurUser.UserID ? "<a href='Plan_EditSummary.aspx?PlanId=" + plan.id.ToString() + "' style='color:blue;'>编辑</a>" : ""); //else if (plan.Type.ToString() == "3") // liSummary.Text = plan.Summary.ToString() == "" ? (DateTime.Now >= plan.Stoptime.ToDateTime().AddDays(-2) && plan.UserID.ToString() == WX.Main.CurUser.UserID ? "<b>总结:</b><a href='Plan_EditSummary.aspx?PlanId=" + plan.id.ToString() + "' style='color:blue;'>创建总结</a>" : "") : "<b>总结:</b>" + plan.Summary.ToString() + (plan.Appraise.ToString() == "" && plan.UserID.ToString() == WX.Main.CurUser.UserID ? "<a href='Plan_EditSummary.aspx?PlanId=" + plan.id.ToString() + "' style='color:blue;'>编辑</a>" : ""); liAppraise.Text = plan.Appraise.ToString() == "" ? (!plan.Summary.isEmpty && WX.Main.CurUser.DutyDetailUser.DutyCatagoryID.ToInt32() == 1 ? "<br/><b>评价:</b><a href='Plan_EditAppraise.aspx?PlanId=" + plan.id.ToString() + "' style='color:blue;'>现在点评</a>" : "") : "<br/><b>评价:</b>" + plan.Appraise.ToString(); string wherestr = " where PlanID=" + plan.id.ToString(); System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable("select * from PLAN_Task" + wherestr + " order by id"); Gv_duty.DataSource = dt; Gv_duty.DataBind(); if (Request["estate"] != null) { Gv_duty.Columns[2].Visible = true; } if (plan.Type.ToInt32() < 3) { divjd.Visible = false; } if (plan.PlanState.ToInt32() < 2) { Gv_duty.Columns[2].Visible = false; } }
private void FillData() { this.DT_Duties = ULCode.QDA.XSql.GetDataTable("select ID,Name,DutyCatagoryID from te_duties "); //添加职务分类行 DataTable dtC = WX.Data.Dict.GetDataTable_DutyCatagory(); foreach (DataRow dr in dtC.Rows) { BoundField bf = new BoundField(); bf.HeaderText = Convert.ToString(dr["Name"]); bf.DataField = "DC" + Convert.ToString(dr["ID"]); Gv_duty.Columns.Add(bf); } //添加部门列 System.Data.DataTable dtR = WX.Model.DutyDetail.GetDeptList(); Gv_duty.DataSource = dtR; Gv_duty.DataBind(); Gv_duty.HeaderRow.TableSection = TableRowSection.TableHeader; Gv_duty.HeaderStyle.Height = Unit.Pixel(40); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { WX.Model.Plan.MODEL plan = WX.Request.rPlan; lititle.Text = plan.Title.ToString(); lirealname.Text = WX.CommonUtils.GetRealNameListByUserIdList(plan.UserID.ToString()); licurr.Text = plan.Current.ToString(); litotal.Text = plan.Total.ToString(); licontent.Text = plan.Content.ToString(); litype.Text = plan.Type.ToString() == "3" ? "月计划" : (plan.Type.ToString() == "2" ? "周计划" : "日计划"); liStarttime.Text = plan.Starttime.ToDateTime().ToString("yyyy-MM-dd"); liStoptime.Text = plan.Stoptime.ToDateTime().ToString("yyyy-MM-dd"); lisummary.Text = plan.Summary.ToString(); string wherestr = " where PlanID=" + plan.id.ToString(); System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable("select * from PLAN_Task" + wherestr + " order by id"); Gv_duty.DataSource = dt; Gv_duty.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!this.Master.A_Edit) { Response.Write("你没有权限访问此功能!"); Response.End(); return; } int companyId = WX.Request.rCompanyId; int dutyId = WX.Request.rDutyId; if (!IsPostBack) { WX.Model.Duty.MODEL model = WX.Request.rDuty; this.DutyId.Text = model.ID.value.ToString(); this.DutyName.Text = model.Name.value.ToString(); string sSql = "exec [dbo].[sp_get_tree_multi_table] 'TE_Menus','ID','Name','ParentID','OrderId',0,1,3"; DataTable dt = ULCode.QDA.XSql.GetDataTable(sSql); this.Gv_duty.RowDataBound += new GridViewRowEventHandler(WX.Ctrl.GridView_DynamicColor_RowDataBound); Gv_duty.DataSource = dt; Gv_duty.DataBind(); } }
public void gridviewBind() { if (Request["PlanId"] == null || Request["PlanId"] == "") { Response.Write("<br/><center><b>任务不存在,请创建!</b></center><br/>"); div1.Visible = false; } else { string wherestr = " where PlanID=" + WX.Request.rPlanId; DataTable dt = ULCode.QDA.XSql.GetDataTable("select * from PLAN_Task" + wherestr + " order by id"); Gv_duty.DataSource = dt; Gv_duty.DataBind(); if (Request["methed"] == null) { Gv_duty.Columns[3].Visible = false; div1.Visible = false; } if (Request["estate"] == null) { Gv_duty.Columns[2].Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!this.Master.A_Edit) { Response.Write("你没有权限访问此功能!"); Response.End(); return; } int companyId = WX.Request.rCompanyId; int dutyId = WX.Request.rDutyId; if (!IsPostBack) { WX.Model.Duty.MODEL model = WX.Request.rDuty; //WX.Model.Duty.GetModel("select * from [TE_Duties] where ID="+Request["id"]); this.dutyId.Text = model.ID.value.ToString(); this.dutyName.Text = model.Name.value.ToString(); string sSql = "exec [dbo].[sp_get_tree_multi_table] 'TE_Functions','ID','Name','ParentID','OrderId',0,1,3"; DataTable dt = ULCode.QDA.XSql.GetDataTable(sSql); Gv_duty.DataSource = dt; Gv_duty.DataBind(); } }
public void gridviewBind() { try { companyid = int.Parse(Request["CompanyID"]); } catch { Response.Write("你没有权限访问此功能!"); Response.End(); return; } string wherestr = " where CompanyID=" + companyid; DataTable dt = ULCode.QDA.XSql.GetDataTable("select TE_Duties.*,TE_DutyCatagory.Name as DutyCatagoryName,TE_DutyCatagory.Sort as DutyCatagoryNo,HR_Grade.Name as GradeName from TE_Duties " + " left join TE_DutyCatagory on TE_Duties.[DutyCatagoryID]=TE_DutyCatagory.ID " + " left join HR_Grade on HR_Grade.Sort=TE_Duties.GradeID" + wherestr + " order by DutyCatagoryNo desc,GradeID"); Gv_duty.DataSource = dt; this.Gv_duty.RowDataBound += new GridViewRowEventHandler(WX.Ctrl.GridView_DynamicColor_RowDataBound); Gv_duty.DataBind(); Gv_duty.HeaderRow.TableSection = TableRowSection.TableHeader; Gv_duty.HeaderStyle.Height = Unit.Pixel(40); }