/// <summary> /// 添加实验室 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDepSave_Click(object sender, EventArgs e) { try { StringBuilder sb = new StringBuilder(); SortedList SQLlist = new SortedList(new MySort()); if (DictUserId != 0) { if (gdDep.SelectedRowIndexArray.Length != 0) { var library = new DictuserandlabdeptService(); Dictuserandlabdept userdep = new Dictuserandlabdept(); userdep.Dictuserid = DictUserId; Hashtable hts = new Hashtable(); hts.Add("value", userdep.Dictuserid); SQLlist.Add(new Hashtable() { { "DELETE", "Dict.DeleteDictuserandlabdeptByUserId" } }, userdep.Dictuserid); foreach (int row in gdDep.SelectedRowIndexArray) { Dictuserandlabdept dictuserandlabdep = new Dictuserandlabdept(); dictuserandlabdep.Dictuserandlabdeptid = library.getSeqID("SEQ_DICTUSERANDLABDEPT"); dictuserandlabdep.Dictlabdeptid = Convert.ToDouble(gdDep.DataKeys[row][0].ToString()); dictuserandlabdep.Dictuserid = Convert.ToInt32(DictUserId); dictuserandlabdep.Createdate = DateTime.Now; SQLlist.Add(new Hashtable() { { "INSERT", "Dict.InsertDictuserandlabdept" } }, dictuserandlabdep); } if (library.ExecuteSqlTran(SQLlist)) { BindGridDep(); MessageBoxShow("所选实验室已成功保存,需重新登陆数据才能生效!", MessageBoxIcon.Information); } else { MessageBoxShow("所选实验室添加有误!", MessageBoxIcon.Warning); } } else { MessageBoxShow("您未选择实验室!", MessageBoxIcon.Warning); } } else { MessageBoxShow("您还未选择用户!", MessageBoxIcon.Warning); } } catch (Exception ex) { MessageBoxShow(ex.Message, MessageBoxIcon.Error); } }
/// <summary> /// 绑定实验室 /// </summary> private void BindGridDep() { try { //分页查询条件 PageUtil pageUtil = new PageUtil(gdDep.PageIndex, gdDep.PageSize); Hashtable ht1 = new Hashtable(); //ht1.Add("Userid", DictUserId); ht1.Add("pageStart", pageUtil.GetPageStartNum()); ht1.Add("pageEnd", pageUtil.GetPageEndNum()); //设置总项数 gdDep.RecordCount = new DictlabdeptService().GetDictlabdeptPageLstCount(ht1); gdDep.DataSource = new DictlabdeptService().GetDictlabdeptPageLst(ht1); //查询全部 List <Dictlabdept> dictlabdep = new DictlabdeptService().GetDictlabdeptPageLstUser(ht1).ToList(); //double userId = 0; //if (gvList.SelectedRowIndexArray.Length > 0) //{ // object[] objValue = gvList.DataKeys[gvList.SelectedRowIndexArray[0]]; // userId = TypeParse.StrToDouble(objValue[0], 0); //} Hashtable ht2 = new Hashtable(); ht2.Add("Userid", DictUserId); ht2.Add("pageStart", pageUtil.GetPageStartNum()); ht2.Add("pageEnd", pageUtil.GetPageEndNum()); IList <Dictuserandlabdept> dictlabIlst = new DictuserandlabdeptService().GetDictuserandlabdeptPageLst(ht2); gdDep.DataBind(); int[] labArray = new int[dictlabIlst.Count]; if (dictlabIlst.Count != 0) { int index = 0; foreach (Dictuserandlabdept item in dictlabIlst) { labArray[index] = dictlabdep.IndexOf(dictlabdep.Find(lab => lab.Dictlabdeptid == item.Dictlabdeptid)); index++; } gdDep.SelectedRowIndexArray = labArray; } else { gdDep.SelectedRowIndexArray = new int[] { }; } } catch (Exception ex) { MessageBoxShow(ex.Message, MessageBoxIcon.Error); } }