protected void Button9_Click(object sender, EventArgs e) { Window1.Hidden = false; School清查盘点BLL pdbll = new School清查盘点BLL(); List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表(); 报修地址.DataTextField = "名称"; 报修地址.DataValueField = "ID"; 报修地址.DataSource = 查询建筑物; 报修地址.DataBind(); 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 = "ZCBX" + y + m + d + h + mm; 报修单号.Enabled = false; OffSession(); string nm = HttpContext.Current.Session["姓名"].ToString(); if (nm == "" || nm == null) { Alert.ShowInTop("验证过期,请重新登陆!"); return; } 报修人.Text = HttpContext.Current.Session["姓名"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { fr0.Hidden = false; Grid2.Hidden = true; Grid3.Hidden = true; DataSet ds = gzysbll.DataSet购置验收查询("流程状态-全部", "", ""); DataTable dt = ds.Tables[0].Copy();//复制一份table DataTable source = dt; // 3.绑定到Grid Grid1.DataSource = dt;//DataTable Grid1.DataBind(); // 3.绑定到Grid Grid1.DataSource = dt;//DataTable Grid1.DataBind(); //二级.Enabled = false; //三级.Enabled = false; 负责人.Enabled = false; 房间.Enabled = false; School清查盘点BLL pdbll = new School清查盘点BLL(); List <School一级部门表> xxmc = pdbll.查询一级部门(); 部门.DataTextField = "名称"; 部门.DataValueField = "ID"; 部门.DataSource = xxmc; 部门.DataBind(); 部门.EmptyText = "全部"; //List<School一级类别表> yjlb = pdbll.查询一级类别(); //一级.DataTextField = "名称"; //一级.DataValueField = "ID"; //一级.DataSource = yjlb; //一级.DataBind(); //一级.EmptyText = "全部"; List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表(); 存放地点.DataTextField = "名称"; 存放地点.DataValueField = "ID"; 存放地点.DataSource = 查询建筑物; 存放地点.DataBind(); 存放地点.EmptyText = "全部"; //二级.Enabled = false; //三级.Enabled = false; 负责人.Enabled = false; 房间.Enabled = false; //二级.EmptyText = "全部"; //三级.EmptyText = "全部"; 负责人.EmptyText = "全部"; 房间.EmptyText = "全部"; } }
protected void btnIcon1_Click(object sender, EventArgs e) { School资产处置BLL bll = new School资产处置BLL(); DataSet ds = bll.查询全部资产信息(); DataTable dt = ds.Tables[0].Copy();//复制一份table DataTable source = dt; // 3.绑定到Grid Grid4.DataSource = dt;//DataTable Grid4.DataBind(); //绑定条件 School清查盘点BLL pdbll = new School清查盘点BLL(); List <School一级部门表> xxmc = pdbll.查询一级部门(); 部门.DataTextField = "名称"; 部门.DataValueField = "ID"; 部门.DataSource = xxmc; 部门.DataBind(); List <School一级类别表> yjlb = pdbll.查询一级类别(); 一级.DataTextField = "名称"; 一级.DataValueField = "ID"; 一级.DataSource = yjlb; 一级.DataBind(); List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表(); 存放地点.DataTextField = "名称"; 存放地点.DataValueField = "ID"; 存放地点.DataSource = 查询建筑物; 存放地点.DataBind(); 二级.Enabled = false; 级.Enabled = false; 负责人.Enabled = false; 房间.Enabled = false; 二级.EmptyText = "全部"; 级.EmptyText = "全部"; 负责人.EmptyText = "全部"; 房间.EmptyText = "全部"; Window2.Hidden = false; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { OffSession(); 二级分类.Enabled = false; 级分类.Enabled = false; 负责人_a.Enabled = false; 房间.Enabled = false; BindGrid(); //BindGrid(); //btnCheckSelection.OnClientClick = Grid2.GetNoSelectionAlertReference("请至少选择一项!"); School清查盘点BLL pdbll = new School清查盘点BLL(); List <School一级部门表> xxmc = pdbll.查询一级部门(); 部门归属.DataTextField = "名称"; 部门归属.DataValueField = "ID"; 部门归属.DataSource = xxmc; 部门归属.DataBind(); 部门归属.EmptyText = "全部"; List <School一级类别表> yjlb = pdbll.查询一级类别(); 一级分类.DataTextField = "名称"; 一级分类.DataValueField = "ID"; 一级分类.DataSource = yjlb; 一级分类.DataBind(); 一级分类.EmptyText = "全部"; List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表(); 存放地点_a.DataTextField = "名称"; 存放地点_a.DataValueField = "ID"; 存放地点_a.DataSource = 查询建筑物; 存放地点_a.DataBind(); 存放地点_a.EmptyText = "全部"; 二级分类.Enabled = false; 级分类.Enabled = false; 负责人_a.Enabled = false; 房间.Enabled = false; 二级分类.EmptyText = "全部"; 级分类.EmptyText = "全部"; 负责人_a.EmptyText = "全部"; 房间.EmptyText = "全部"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { 二级.Enabled = false; 级.Enabled = false; 负责人.Enabled = false; 房间.Enabled = false; btnCheckSelection.OnClientClick = Grid1.GetNoSelectionAlertInTopReference("没有选中项!"); BindGrid(); School清查盘点BLL pdbll = new School清查盘点BLL(); List <School一级部门表> xxmc = pdbll.查询一级部门(); 部门.DataTextField = "名称"; 部门.DataValueField = "ID"; 部门.DataSource = xxmc; 部门.DataBind(); 部门.EmptyText = "全部"; List <School一级类别表> yjlb = pdbll.查询一级类别(); 一级.DataTextField = "名称"; 一级.DataValueField = "ID"; 一级.DataSource = yjlb; 一级.DataBind(); 一级.EmptyText = "全部"; List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表(); 存放地点.DataTextField = "名称"; 存放地点.DataValueField = "ID"; 存放地点.DataSource = 查询建筑物; 存放地点.DataBind(); 存放地点.EmptyText = "全部"; 二级.Enabled = false; 级.Enabled = false; 负责人.Enabled = false; 房间.Enabled = false; 二级.EmptyText = "全部"; 级.EmptyText = "全部"; 负责人.EmptyText = "全部"; 房间.EmptyText = "全部"; } }
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(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { 二级.Enabled = false; 级.Enabled = false; 负责人.Enabled = false; 房间.Enabled = false; //btnCheckSelection.OnClientClick = Grid1.GetNoSelectionAlertInTopReference("没有选中项!"); //BindGrid(); School清查盘点BLL pdbll = new School清查盘点BLL(); List <School一级部门表> xxmc = pdbll.查询一级部门(); 部门.DataTextField = "名称"; 部门.DataValueField = "ID"; 部门.DataSource = xxmc; 部门.DataBind(); 部门.EmptyText = "全部"; List <School一级类别表> yjlb = pdbll.查询一级类别(); 一级.DataTextField = "名称"; 一级.DataValueField = "ID"; 一级.DataSource = yjlb; 一级.DataBind(); 一级.EmptyText = "全部"; List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表(); 存放地点.DataTextField = "名称"; 存放地点.DataValueField = "ID"; 存放地点.DataSource = 查询建筑物; 存放地点.DataBind(); 存放地点.EmptyText = "全部"; 二级.Enabled = false; 级.Enabled = false; 负责人.Enabled = false; 房间.Enabled = false; 二级.EmptyText = "全部"; 级.EmptyText = "全部"; 负责人.EmptyText = "全部"; 房间.EmptyText = "全部"; //DataSet dsa = bll.资产汇总查询(); //DataTable dta = dsa.Tables[0].Copy();//复制一份table //DataTable sourcea = dta; //// 3.绑定到Grid //Grid1.DataSource = dta;//DataTable //Grid1.DataBind(); DataSet dss = zjfxbll.一级类别(); DataTable dts = dss.Tables[0].Copy();//复制一份table DataTable sourcea = dts; Grid1.DataSource = dts; Grid1.DataBind(); DataSet ds = bll.资产明细查询(); DataTable dt = ds.Tables[0].Copy();//复制一份table DataTable source = dt; // 3.绑定到Grid //Grid2.DataSource = dt;//DataTable //Grid2.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataSet ds = bll.首页_X_资产报修流程表("全部"); DataTable dt = ds.Tables[0].Copy();//复制一份table DataTable source = dt; // 3.绑定到Grid Grid1.DataSource = dt;//DataTable Grid1.DataBind(); DateTime dtime = DateTime.Now; string sj = dtime.Year + "-" + dtime.Month + "-" + dtime.Day; 报修时间2.EmptyText = sj; DatePicker1.EmptyText = sj; 完成时间.EmptyText = sj; List <School房间信息表> cfdd = bll.cfdd(); 报修地址.DataTextField = "名称"; 报修地址.DataValueField = "ID"; 报修地址.DataSource = cfdd; 报修地址.DataBind(); //DatePicker1.MinDate = DateTime.Now; //DatePicker1.MaxDate = DateTime.Now.AddDays(10); // 3.绑定到Grid Grid4.DataSource = dt;//DataTable Grid4.DataBind(); //绑定条件 School清查盘点BLL pdbll = new School清查盘点BLL(); List <School一级部门表> xxmc = pdbll.查询一级部门(); 部门.DataTextField = "名称"; 部门.DataValueField = "ID"; 部门.DataSource = xxmc; 部门.DataBind(); List <School一级类别表> yjlb = pdbll.查询一级类别(); 一级.DataTextField = "名称"; 一级.DataValueField = "ID"; 一级.DataSource = yjlb; 一级.DataBind(); List <School建筑物信息表> 查询建筑物 = pdbll.查询建筑物信息表(); 存放地点.DataTextField = "名称"; 存放地点.DataValueField = "ID"; 存放地点.DataSource = 查询建筑物; 存放地点.DataBind(); 二级.Enabled = false; 级.Enabled = false; 负责人.Enabled = false; 房间.Enabled = false; 二级.EmptyText = "全部"; 级.EmptyText = "全部"; 负责人.EmptyText = "全部"; 房间.EmptyText = "全部"; OffSession(); string 职务 = HttpContext.Current.Session["职务"].ToString(); 联系电话.Text = HttpContext.Current.Session["电话号码"].ToString(); if (职务 == "资产管理员") { Button1.Hidden = false; } } }