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 = "全部";
}
