public void btn5click() { string sid = ""; List <int> inlist = new List <int>(); int 总数 = 0; int 总价 = 0; //获取grid3选中行数据 int[] selections = Grid3.SelectedRowIndexArray; foreach (int rowIndex in selections) { int ID = Convert.ToInt32(Grid3.DataKeys[rowIndex][0]); sid += rowIndex.ToString() + ","; inlist.Add(ID); } if (inlist.Count == 0) { Alert.ShowInTop("请选中!", "提示信息", MessageBoxIcon.Warning); return; } School资产转移BLL bll = new School资产转移BLL(); List <School办公设备信息表> listdata = bll.资产转移确定设备(inlist); foreach (School办公设备信息表 itemjj in listdata) { 总数 += itemjj.数量; 总价 += Convert.ToInt32(itemjj.价格); } Grid2.DataSource = listdata;//DataTable Grid2.DataBind(); Grid2.SelectedRowIndexArray = new int[] { 0, 1 }; Window2.Hidden = true; }
protected void 部门_SelectedIndexChanged(object sender, EventArgs e) { 负责人.Enabled = true; int ID = Convert.ToInt32(部门.SelectedValue); if (ID > 0) { School资产转移BLL zybll = new School资产转移BLL(); List <用户表> listuser = zybll.listuser(ID); 负责人.DataTextField = "姓名"; 负责人.DataValueField = "ID"; 负责人.DataSource = listuser; 负责人.DataBind(); } else { 负责人.Enabled = false; School资产转移BLL zybll = new School资产转移BLL(); List <用户表> listuser = zybll.listuser(ID); 负责人.DataTextField = "姓名"; 负责人.DataValueField = "ID"; 负责人.DataSource = listuser; 负责人.DataBind(); } }
protected void 部门_SelectedIndexChanged(object sender, EventArgs e) { School资产转移BLL blluser = new School资产转移BLL(); int ID = Convert.ToInt32(部门.SelectedValue); if (ID > 0) { List <用户表> listuser = blluser.listuser(ID); 负责人.DataTextField = "姓名"; 负责人.DataValueField = "ID"; 负责人.DataSource = listuser; 负责人.DataBind(); } }
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 Grid1_PageIndexChange(object sender, GridPageEventArgs e) //{ // BindGrid(); //} //private DataTable GetPagedDataTable(int pageIndex, int pageSize) //{ // DataSet ds = bl2.查询全部资产信息(); // DataTable dt = ds.Tables[0].Copy();//复制一份table // DataTable source = dt; // DataTable paged = source.Clone(); // int rowbegin = pageIndex * pageSize; // int rowend = (pageIndex + 1) * pageSize; // if (rowend > source.Rows.Count) // { // rowend = source.Rows.Count; // } // for (int i = rowbegin; i < rowend; i++) // { // paged.ImportRow(source.Rows[i]); // } // return paged; //} //private void BindGrid() //{ // DataSet ds = bl2.查询全部资产信息(); // DataTable dt = ds.Tables[0].Copy();//复制一份table // DataTable source = dt; // // 3.绑定到Grid // Grid3.DataSource = dt;//DataTable // Grid3.DataBind(); //} protected void Button5_Click(object sender, EventArgs e) { Grid1.Hidden = true; Grid2.Hidden = false; School查询办公设备条件表 model = new School查询办公设备条件表(); string str一级 = 一级.SelectedText; string str二级 = 二级.SelectedText; string str三级 = 级.SelectedText; if (str一级 == "全部" || str一级 == null) { str一级 = ""; } if (str二级 == "全部" || str二级 == null) { str二级 = ""; } if (str三级 == "全部" || str三级 == null) { str三级 = ""; } model.一级分类 = str一级; model.二级分类 = str二级; model.级分类 = str三级; string str部门 = 部门.SelectedText; if (str部门 != "全部" && str部门 != null) { model.归属部门 = Convert.ToInt32(部门.SelectedValue); if (负责人.SelectedText != null) { model.负责人 = Convert.ToInt32(负责人.SelectedValue); } else { model.负责人 = 0; } } else { model.归属部门 = 0; } if (存放地点.SelectedText != null) { model.存放地点 = Convert.ToInt32(存放地点.SelectedValue); if (房间.SelectedText != null) { model.房间 = Convert.ToInt32(房间.SelectedValue); } else { model.房间 = 0; } } else { model.存放地点 = 0; } if (起始投入日期.Text != "") { model.起始投入日期 = Convert.ToDateTime(起始投入日期.Text).ToShortDateString(); } else { model.起始投入日期 = ""; } if (结束投入日期.Text != "") { model.结束投入日期 = Convert.ToDateTime(结束投入日期.Text).ToShortDateString(); } else { model.结束投入日期 = ""; } model.关键字 = TwinTriggerBox1.Text; School资产转移BLL bll = new School资产转移BLL(); DataSet ds = bll.资产转移查询明细_X(model); DataTable dt = ds.Tables[0].Copy();//复制一份table DataTable source = dt; // 3.绑定到Grid Grid2.DataSource = dt;//DataTable Grid2.DataBind(); 二级.EmptyText = "全部"; 级.EmptyText = "全部"; 负责人.EmptyText = "全部"; 房间.EmptyText = "全部"; }