/// <summary> /// 添加移除选择列表中的项 /// </summary> /// <param name="RemoveChkListBox">移除项</param> /// <param name="AddChkListBox">添加项</param> /// <param name="list">原列表所有集合项</param> private void MoveItem(CheckedListBox RemoveChkListBox, CheckedListBox AddChkListBox, ArrayList list) { Uobject[] objtemps = new Uobject[RemoveChkListBox.CheckedItems.Count]; //添加项 for (int i = 0; i < RemoveChkListBox.CheckedItems.Count; i++) { Uobject temp = (Uobject)RemoveChkListBox.CheckedItems[i]; objtemps[i] = temp; if (!isExistVal(temp.Id, AddChkListBox)) { AddChkListBox.Items.Add(temp); } } //移除项 for (int i = 0; i < objtemps.Length; i++) { RemoveItem(objtemps[i].Id, RemoveChkListBox); } AddChkListBox.Items.Clear(); for (int i = 0; i < list.Count; i++) { Uobject temp = (Uobject)list[i]; if (!isExistVal(temp.Id, RemoveChkListBox)) { AddChkListBox.Items.Add(temp); } } }
/// <summary> /// 根据工号获取病人信息 /// </summary> /// <param name="Gh"></param> private Uobject GetUserInfoByGh(string Gh) { lblUserInfo.Text = "用户基本信息"; string sql = "select a.user_id,c.account_name,a.user_name,d.section_name from t_userinfo a inner join t_account_user b on a.user_id=b.user_id inner join t_account c on b.account_id=c.account_id inner join t_sectioninfo d on a.section_id=d.sid "; DataSet ds = App.GetDataSet(sql + " where c.account_name='" + Gh.ToUpper() + "'"); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { lblUserInfo.Text = "登录名:" + ds.Tables[0].Rows[0]["account_name"].ToString() + " 姓名:" + ds.Tables[0].Rows[0]["user_name"].ToString() + " 姓名:" + ds.Tables[0].Rows[0]["section_name"].ToString(); Uobject tempuser = new Uobject(); tempuser.Id = ds.Tables[0].Rows[0]["user_id"].ToString(); tempuser.Name = ds.Tables[0].Rows[0]["user_name"].ToString(); return(tempuser); } else { return(null); } } else { return(null); } }
private void btnUserRemove_Click(object sender, EventArgs e) { for (int i = 0; i < chkUserSelectList.CheckedItems.Count; i++) { Uobject temp = (Uobject)chkUserSelectList.CheckedItems[i]; RemoveItem(temp.Id, chkUserSelectList); } }
private void btnUserAdd_Click(object sender, EventArgs e) { Uobject temp = GetUserInfoByGh(txtGh.Text); if (temp != null) { chkUserSelectList.Items.Add(temp); } }
/// <summary> /// 移除制定项2 /// </summary> /// <param name="ID"></param> /// <param name="RemoveChkListBox"></param> private void RemoveItem2(string ID, CheckedListBox RemoveChkListBox) { for (int i = 0; i < RemoveChkListBox.Items.Count; i++) { Uobject temp = (Uobject)RemoveChkListBox.Items[i]; if (temp.Id == ID) { RemoveChkListBox.Items.Remove(RemoveChkListBox.Items[i]); break; } } }
/// <summary> /// 判断对象是否已经被选择过 /// </summary> /// <param name="ID">主键</param> /// <param name="templistbox">被选择对象容器</param> /// <returns></returns> private bool isExistVal(string ID, CheckedListBox templistbox) { bool flag = false; for (int i = 0; i < templistbox.Items.Count; i++) { Uobject temp = (Uobject)templistbox.Items[i]; if (temp.Id == ID) { flag = true; } } return(flag); }
/// <summary> /// 初始化科室信息 /// </summary> private void DataSections() { DataSet ds_sec = App.GetDataSet("select a.sid,a.section_name from t_sectioninfo a inner join t_section_area b on a.sid=b.sid order by a.section_name,a.sid "); for (int i = 0; i < ds_sec.Tables[0].Rows.Count; i++) { Uobject temp = new Uobject(); temp.Id = ds_sec.Tables[0].Rows[i]["sid"].ToString(); temp.Name = ds_sec.Tables[0].Rows[i]["section_name"].ToString(); if (!isExistVal(temp.Id, chkSectionListselect)) { chkSectionList.Items.Add(temp); } ArySections.Add(temp); } }
void Update() { Uobject uobj = null; Ray ray = new Ray(mainCamera.transform.position, mainCamera.transform.forward); RaycastHit hit; if (Physics.Raycast(ray, out hit, 3f, LayerMask.GetMask("Default"))) { uobj = hit.transform.GetComponent <Uobject>(); if (uobj && !uobj.isBusy) { CanvasScript.Instance.SetInteract(uobj.InteractText); } else { CanvasScript.Instance.ResetInteract(); } } else { CanvasScript.Instance.ResetInteract(); } if (Input.GetKeyDown(KeyCode.E)) { if (CanvasScript.Instance.dialog.gameObject.activeSelf) { CanvasScript.Instance.dialog.Next(); return; } if (uobj && !uobj.isBusy) { uobj.InteractAction.Invoke(); } } }
/// <summary> /// 授权设置确定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSure_Click(object sender, EventArgs e) { string textid = ""; string relation = ""; string rtype = ""; string functions = ""; string[] sqls = new string[2]; if (chkCheck.Checked) { functions = functions + "," + chkCheck.Text; } if (chkUpdate.Checked) { functions = functions + "," + chkUpdate.Text; } if (chkCreate.Checked && chkPatch.Checked) { App.Msg("注意:创建和补录授权只能选择一个,请重新选择!"); return; } else { if (chkCreate.Checked) { functions = functions + "," + chkCreate.Text; } if (chkPatch.Checked) { functions = functions + "," + chkPatch.Text; } } if (chkTextSelect.Checked) { for (int i = 0; i < chkTextListSelect.Items.Count; i++) { Uobject temp = (Uobject)chkTextListSelect.Items[i]; if (textid == "") { textid = temp.Id; } else { textid = textid + "," + temp.Id; } } } else { textid = "0"; } if (textid == "") { textid = "0"; } if (radSectionSelect.Checked) { for (int i = 0; i < chkSectionListselect.Items.Count; i++) { Uobject temp = (Uobject)chkSectionListselect.Items[i]; if (relation == "") { relation = temp.Id; } else { relation = relation + "," + temp.Id; } } rtype = "S"; } if (radUserSelect.Checked) { for (int i = 0; i < chkUserSelectList.Items.Count; i++) { Uobject temp = (Uobject)chkUserSelectList.Items[i]; if (relation == "") { relation = temp.Id; } else { relation = relation + "," + temp.Id; } } rtype = "P"; } sqls[0] = "delete from T_SET_TEXT_RIGHTS where PATIENT_ID=" + Patient_Id + ""; sqls[1] = "insert into T_SET_TEXT_RIGHTS(PATIENT_ID,TEXT_ID,RIGHT_TYPE,RELATION_ID,BEGIN_TIME,END_TIME,FUNCTIONS)values(" + Patient_Id + ",'" + textid + "','" + rtype + "','" + relation + "',to_timestamp('" + dateTimePicker1.Value.ToString() + "','yyyy-MM-dd hh24:mi:ss'),to_timestamp('" + dateTimePicker2.Value.ToString() + "','yyyy-MM-dd hh24:mi:ss'),'" + functions + "')"; if (functions == "") { App.MsgWaring("请先选择要授权的权限!"); return; } if (App.ExecuteBatch(sqls) > 0) { App.Msg("操作已经成功!"); this.f.Close(); } }
private void ucSetTextRight_Load(object sender, EventArgs e) { chkTextList.DisplayMember = "Name"; chkTextList.ValueMember = "Id"; chkTextListSelect.DisplayMember = "Name"; chkTextListSelect.ValueMember = "Id"; chkSectionList.ValueMember = "Id"; chkSectionList.DisplayMember = "Name"; chkSectionListselect.DisplayMember = "Name"; chkSectionListselect.ValueMember = "Id"; chkUserSelectList.ValueMember = "Id"; chkUserSelectList.DisplayMember = "Name"; btnSure.Enabled = true; try { btnReSet_Click(sender, e); //获取已经设置的授权 DataSet ds = App.GetDataSet("select * from T_SET_TEXT_RIGHTS t where t.patient_id=" + Patient_Id + ""); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { string textids = ds.Tables[0].Rows[0]["TEXT_ID"].ToString(); string right_type = ds.Tables[0].Rows[0]["RIGHT_TYPE"].ToString(); string reationids = ds.Tables[0].Rows[0]["RELATION_ID"].ToString(); string functions = ds.Tables[0].Rows[0]["FUNCTIONS"].ToString(); dateTimePicker1.Value = Convert.ToDateTime(ds.Tables[0].Rows[0]["BEGIN_TIME"].ToString()); dateTimePicker2.Value = Convert.ToDateTime(ds.Tables[0].Rows[0]["END_TIME"].ToString()); if (dateTimePicker2.Value < App.GetSystemTime()) { dateTimePicker1.Value = App.GetSystemTime(); dateTimePicker2.Value = App.GetSystemTime().AddHours(48); } if (functions.Contains(chkCheck.Text)) { chkCheck.Checked = true; } if (functions.Contains(chkUpdate.Text)) { chkUpdate.Checked = true; } if (functions.Contains(chkCreate.Text)) { chkCreate.Checked = true; } if (functions.Contains(chkPatch.Text)) { chkPatch.Checked = true; } if (textids != "0") { //文书类型 for (int i = 0; i < textids.Split(',').Length; i++) { for (int j = 0; j < chkTextList.Items.Count; j++) { Uobject temp = (Uobject)chkTextList.Items[j]; if (temp.Id == textids.Split(',')[i]) { chkTextListSelect.Items.Add(temp); RemoveItem2(temp.Id, chkTextList); } } } } if (right_type == "S") { //科室 for (int i = 0; i < reationids.Split(',').Length; i++) { for (int j = 0; j < chkSectionList.Items.Count; j++) { Uobject temp = (Uobject)chkSectionList.Items[j]; if (temp.Id == reationids.Split(',')[i]) { chkSectionListselect.Items.Add(temp); RemoveItem2(temp.Id, chkSectionList); } } } } else if (right_type == "P") { DataSet ds_p = App.GetDataSet("select t.user_id,t.user_name from t_userinfo t where user_id in (" + reationids + ")"); //用户 for (int i = 0; i < ds_p.Tables[0].Rows.Count; i++) { Uobject tempobj = new Uobject(); tempobj.Id = ds_p.Tables[0].Rows[i]["user_id"].ToString(); tempobj.Name = ds_p.Tables[0].Rows[i]["user_name"].ToString(); chkUserSelectList.Items.Add(tempobj); } } btnSure.Visible = true; } } } catch { } }