protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Grid2.Hidden = true; //Grid3.Hidden = true; DataSet ds = bll.首页_X_资产转移流程表("流程状态-全部"); DataTable dt = ds.Tables[0].Copy();//复制一份table DataTable source = dt; // 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 Button4_Click(object sender, EventArgs e) { if (Grid2.GetModifiedData().Count == 0) { //labResult.Text = ""; //ShowNotify("表格数据没有变化!"); Alert.ShowInTop("表格内没有数据!"); return; } // 复制原始表格的结构 DataTable newTable = GetSourceData().Clone(); DataRow newRow; int rowIndex = 0; JArray mergedData = Grid2.GetMergedData(); int 总数 = 0; double 价格 = 0; SchoolX_购置验收流程表 modelgz = new SchoolX_购置验收流程表(); modelgz.流程状态 = 流程状态.Text; modelgz.单据编号 = 单据编号.Text; modelgz.事项名称 = 事项名称.Text; modelgz.备注信息 = 备注.Text; modelgz.申请人 = 申请人.Text; modelgz.制单日期 = 制单日期.Text; modelgz.供应商 = 供应商.Text; modelgz.供应商联系方式 = 供应商联系方式.Text; modelgz.合同编号 = 合同编号.Text; modelgz.发票号 = 发票号.Text; //modelgz.验收人 = 验收人.Text; //modelgz.记账人 = 记账人.Text; modelgz.取得方式 = 取得方式.SelectedItem.Text; modelgz.购置日期 = 购置日期.Text; //modelgz.验收日期 = 验收日期.Text; List <School办公设备信息表> listmodel = new List <School办公设备信息表>(); foreach (JObject mergedRow in mergedData) { School办公设备信息表 model = new School办公设备信息表(); JObject values = mergedRow.Value <JObject>("values"); newRow = newTable.NewRow(); newRow[0] = rowIndex; // 实际项目中请使用数据库中的自增长主键,无需设置此列的值 newRow[1] = values.Value <string>("资产编号"); newRow[2] = values.Value <string>("资产分类"); newRow[3] = values.Value <string>("资产名称"); newRow[4] = values.Value <string>("规格型号"); newRow[5] = values.Value <string>("使用方向"); try { newRow[6] = values.Value <int>("number"); newRow[7] = values.Value <double>("prise"); } catch (Exception) { Alert.ShowInTop("数量/单价请填写数字!", "警告信息", MessageBoxIcon.Error); return; } newRow[8] = values.Value <string>("归属部门"); newRow[9] = values.Value <string>("负责人"); newRow[10] = values.Value <string>("存放地点"); newRow[11] = values.Value <string>("资产状态"); newTable.Rows.Add(newRow); model.编号 = values.Value <string>("资产编号"); string 类别名称 = values.Value <string>("三级分类名称"); string[] arr = 类别名称.Split('.'); if (arr.Length == 2) { model.二级类别名称 = arr[0]; List <School一级类别表> listuser = pdbll.查询一级类别(model.二级类别名称); model.一级类别名称 = listuser[0].称.ToString(); } else if (arr.Length == 3) { model.级类别名称 = arr[0]; List <School二级类别表> listusers = pdbll.查询二级类别(arr[0]); model.二级类别名称 = listusers[0].称.ToString(); List <School一级类别表> listuser = pdbll.查询一级类别(model.二级类别名称); model.一级类别名称 = listuser[0].称.ToString(); } else if (arr.Length == 1) { model.一级类别名称 = arr[0]; } //model.二级类别名称 = values.Value<string>("Window1_SimpleForm1_TabStrip1_ctl00_Grid2_ctl02_ctl01"); //model.三级类别名称 = values.Value<string>("Window1_SimpleForm1_TabStrip1_ctl00_Grid2_ctl02_ctl02"); model.称 = values.Value <string>("资产名称"); model.型号 = values.Value <string>("规格型号"); model.使用方向 = values.Value <string>("使用方向"); try { model.数量 = values.Value <int>("number"); 总数 += model.数量; model.价格 = values.Value <double>("prise"); 价格 += model.价格; } catch (Exception) { Alert.ShowInTop("数量/单价请填写数字!", "警告信息", MessageBoxIcon.Error); return; } model.str归属部门 = values.Value <string>("归属部门"); model.负责人 = values.Value <string>("负责人"); model.存放地点 = values.Value <string>("存放地点"); model.资产状态 = values.Value <string>("资产状态"); if (model.编号 == null || model.称 == null || model.型号 == null || model.使用方向 == null || model.str归属部门 == null || model.负责人 == null || model.存放地点 == null || model.资产状态 == null || modelgz.购置日期 == null) { Alert.ShowInTop("请将信息填写完整!", "警告信息", MessageBoxIcon.Error); return; } listmodel.Add(model); rowIndex++; } modelgz.数量合计 = 总数; modelgz.金额合计 = 价格; AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起人 = 申请人.Text; ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "待办事项通知"; ammodel.通知职务 = "财务人员"; ammodel.消息内容 = "您来自" + 申请人.Text + "的购置验收/入库-申请通知!"; ammodel.消息事项 = "购置验收"; int result = gzysbll.插入X_购置验收流程表(modelgz, listmodel, ammodel); if (result > 0) { Grid2.GetRejectChangesReference(); Window1.Hidden = true; Alert.ShowInTop("创建成功!"); //return; BindGrid(); } }
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; } } }