/// <summary> /// /// </summary> private void BindDataGrid() { //退货明细 var source = SqlService.Where(string.Format(@"SELECT * FROM dbo.vm_SalesReturnDetails WHERE keyId='{0}' and FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId)); //绑定数据源 Grid1.DataSource = source; Grid1.DataBind(); var table = source.Tables[0]; if (table != null && table.Rows.Count > 0) { decimal sumFQty = 0.00M; decimal sumFAmount = 0.00M; for (int i = 0; i < table.Rows.Count; i++) { sumFQty += Convert.ToDecimal(table.Rows[i]["FQty"]); sumFAmount += Convert.ToDecimal(table.Rows[i]["FAmount"]); } var summary = new JObject { { "FItemCode", "合计" }, { "FQty", sumFQty }, { "FAmount", sumFAmount } }; Grid1.SummaryData = summary; } //单据状态 //---------------------------------------------------------- var dataStatus = SqlService.Where(string.Format(@"SELECT FId ,KeyId ,a.FCompanyId ,FDeptId ,b.org_name FDeptName ,FOperator ,FDate ,FActionName ,FMemo FROM dbo.LHBillStatus a LEFT JOIN dbo.base_orgnization b ON a.FDeptId=b.id WHERE KeyId='{0}' and a.FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId)); //绑定数据源 Grid2.DataSource = dataStatus; Grid2.DataBind(); //审批流程过程 //---------------------------------------------------------- var dataFlow = SqlService.Where(string.Format(@"SELECT FId ,KeyId ,a.FCompanyId ,FDeptId ,b.org_name FDeptName ,FOperator ,FDate ,FMemo FROM dbo.LHBillFlow a LEFT JOIN dbo.base_orgnization b ON a.FDeptId=b.id WHERE KeyId='{0}' and a.FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId)); //绑定数据源 Grid3.DataSource = dataFlow; Grid3.DataBind(); //中间变更日志 //---------------------------------------------------------- var log = SqlService.Where(string.Format(@"SELECT * FROM dbo.vm_SalesReturnDetailsLog a WHERE keyId='{0}' and FCompanyId={1}", lblKeyId.Text, CurrentUser.AccountComId)); //绑定数据源 Grid4.DataSource = log; Grid4.DataBind(); }
//实现从grid1往grid3添加选中人员的方法 protected void addRow() { //初始化datatable,遍历当前grid3的所有数据并存放进去 DataTable curdt = new DataTable(); curdt.Columns.Add("id"); curdt.Columns.Add("chineseName"); for (int j = 0; j < Grid3.Rows.Count; j++) { DataRow dr = curdt.NewRow(); dr[0] = Grid3.DataKeys[j][0]; dr[1] = Grid3.Rows[j].Values[0]; curdt.Rows.Add(dr); } //再遍历grid1选定行的数据,添加到datatable int[] selections = Grid1.SelectedRowIndexArray; foreach (int rowIndex in selections) { String selectedUserId = null; String selectedName = null; int find = -1; selectedUserId = Grid1.DataKeys[rowIndex][0].ToString(); selectedName = Grid1.Rows[rowIndex].Values[1].ToString(); //去除重复选中的人员 for (int j = 0; j < curdt.Rows.Count; j++) { if (curdt.Rows[j]["id"].ToString() == selectedUserId) { find = j; } } if (find >= 0) { continue; } DataRow dr = curdt.NewRow(); dr[0] = selectedUserId; dr[1] = selectedName; curdt.Rows.Add(dr); } Grid3.DataSource = curdt; Grid3.DataBind(); //int selectedCount = Grid1.SelectedRowIndexArray.Length; //if (selectedCount > 0) //{ // String selectedUserId = null; // String selectedName = null; // for (int i = 0; i < selectedCount; i++) // { // int find = -1; // int rowIndex = Grid1.SelectedRowIndexArray[i]; // selectedUserId = Grid1.DataKeys[Grid1.SelectedRowIndexArray[i]][0].ToString(); // selectedName = Grid1.Rows[i].Values[1].ToString(); // //去除重复选中的人员 // for (int j = 0; j < curdt.Rows.Count; j++) // { // if (curdt.Rows[j]["id"].ToString() == selectedUserId) // { // find = j; // } // } // if (find >= 0) // { // continue; // } // DataRow dr = curdt.NewRow(); // dr[0] = selectedUserId; // dr[1] = selectedName; // curdt.Rows.Add(dr); // } // //最后重新绑定datatable,实现动态添加的功能 // Grid3.DataSource = curdt; // Grid3.DataBind(); //} //else //{ // Alert.ShowInTop("请选择至少一名人员。"); //} }
//点击查看详情 protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Action1") { OffSession(); string username = Session["姓名"].ToString(); 流程状态待派单.Hidden = false; object[] keys = Grid1.DataKeys[e.RowIndex]; int ID = Convert.ToInt32(keys[0].ToString());//获取ID int Sort = Convert.ToInt32(keys[9].ToString()); string 流程状态 = keys[1].ToString(); if (流程状态 == "待派单") { Button9.Text = "派单"; } else if (流程状态 == "已派单,维修中") { Button9.Text = "派单并报修"; } else if (流程状态 == "已完工,待反馈") { Button9.Text = "结果反馈"; } xx.Text = ID.ToString(); 查看报修人.Text = keys[3].ToString(); 查看报修时间.Text = keys[4].ToString(); 查看单号.Text = keys[2].ToString(); 查看报修地址.Text = keys[5].ToString(); string zt = keys[1].ToString(); SchoolX_资产报修流程表 model = bll.详情(ID); if (model.派单时间 != "" && model.派单时间 != null) { TextBox9.Text = model.派单时间; } else { TextBox9.Text = "未完成"; } TextBox5.Text = "未完成"; TextBox6.Text = "未完成"; TextBox8.Text = "未完成"; TextBox9.Text = "未完成"; TextBox10.Text = "未完成"; TextBox11.Text = "未完成"; TextBox12.Text = "未完成"; 查看故障描述.Text = "未完成"; TextBox13.Text = "未完成"; if (model.维修人员 != "" & model.维修人员 != null) { TextBox5.Text = model.维修人员; } if (model.维修人电话 != "" && model.维修人电话 != null) { TextBox11.Text = model.维修人电话; } if (model.解决时间 != "" && model.解决时间 != null) { TextBox6.Text = model.解决时间; } if (model.管理员 != "" && model.管理员 != null) { TextBox8.Text = model.管理员; } if (model.派单时间 != "" && model.派单时间 != null) { TextBox9.Text = model.派单时间; } if (model.报修人电话 != "" && model.报修人电话 != null) { TextBox10.Text = model.报修人电话; } if (model.维修人电话 != "" && model.维修人电话 != null) { TextBox11.Text = model.维修人电话; } if (model.管理员电话 != "" && model.管理员电话 != null) { TextBox12.Text = model.管理员电话; } if (model.结果反馈 != "" && model.结果反馈 != null) { TextBox13.Text = model.结果反馈; } if (model.故障原因 != "" && model.故障原因 != null) { 查看故障描述.Text = model.故障原因; } if (zt == "已完成") { Button9.Hidden = true; Button3.Text = "取消"; } else if (zt == "待派单") { Button9.Hidden = false; Button3.Text = "拒绝"; } else { Button9.Hidden = false; Button3.Text = "取消"; } try { string iamgeurl = keys[11].ToString(); Image2.ImageUrl = iamgeurl; } catch (Exception) { } List <int> inlist = new List <int>(); string[] sbid = keys[12].ToString().Split(','); foreach (string item in sbid) { if (item == "" || item == null) { break; } inlist.Add(Convert.ToInt32(item)); } School资产报修BLL blla = new School资产报修BLL(); List <School办公设备信息表> listdata = blla.资产转移确定设备(inlist); Grid3.DataSource = listdata;//DataTable Grid3.DataBind(); } }