示例#1
0
        /// <summary>
        /// 选择所有的使用范围和职务职称等
        /// </summary>
        private void RangeSelectAllByNode(TreeNode node)
        {
            Doc_Ranges.Clear();

            //Doc_Job.Clear();

            //Doc_Other.Clear();

            Class_Text_A selectdoc = (Class_Text_A)node.Tag;

            /*
             * 使用范围部分
             */
            string  Sql_textusearea = "select * from t_textusearea where texttype=" + selectdoc.Id + "";
            DataSet ds_textusearea  = App.GetDataSet(Sql_textusearea);

            for (int i = 0; i < ds_textusearea.Tables[0].Rows.Count; i++)
            {
                Class_Doc_User_Range temp = new Class_Doc_User_Range();
                temp.Texttype              = selectdoc.Id;
                temp.Workgroup             = Convert.ToInt16(ds_textusearea.Tables[0].Rows[i]["WORKGROUP"]);
                cboWorkGroup.SelectedValue = temp.Workgroup;
                Doc_Ranges.Add(temp);
            }

            Save_WorkGroup();
        }
示例#2
0
 /// <summary>
 /// 移除某一分院所有的科室或病区
 /// </summary>
 /// <param name="shid">分院ID</param>
 private void RemoveAllSectionByShid(int shid)
 {
     for (int i = 0; i < Doc_Ranges.Count; i++)
     {
         Class_Doc_User_Range temp = (Class_Doc_User_Range)Doc_Ranges[i];
         if (temp.Belonghospital == shid)
         {
             Doc_Ranges.Remove(Doc_Ranges[i]);
             RemoveAllSectionByShid(shid);
         }
     }
 }
示例#3
0
        /// <summary>
        /// 范围修改
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void chkListSection_MouseUp(object sender, MouseEventArgs e)
        {
            if (chkListFenyuan.SelectedItem != null)
            {
                Class_Sub_Hospital temp_hospital = (Class_Sub_Hospital)chkListFenyuan.SelectedItem;
                RemoveAllSectionByShid(Convert.ToInt16(temp_hospital.Id));

                /*
                 * 加载新设置的分院科室或病区
                 */
                for (int i = 0; i < chkListSection.CheckedItems.Count; i++)
                {
                    Class_Sections       temp_section = (Class_Sections)chkListSection.CheckedItems[i];
                    Class_Doc_User_Range temp         = new Class_Doc_User_Range();
                    temp.Belonghospital = Convert.ToInt16(temp_hospital.Id);
                    temp.Section        = temp_section.Sid;
                    temp.Texttype       = CurrentSelectDocId;
                    temp.Workgroup      = Convert.ToInt16(cboWorkGroup.SelectedValue);
                    Doc_Ranges.Add(temp);
                }
            }
        }
示例#4
0
        /// <summary>
        /// 所有文书子节点的使用范围设置
        /// </summary>
        private void ChildNodeRangeSet(TreeNodeCollection nodes)
        {
            for (int i = 0; i < nodes.Count; i++)
            {
                if (nodes[i].Nodes.Count > 0)
                {
                    ChildNodeRangeSet(nodes[i].Nodes);
                }
                else
                {
                    if (nodes[i].Tag.GetType().ToString().Contains("Class_Text_A"))
                    {
                        Class_Text_A selectdoc = (Class_Text_A)nodes[i].Tag;
                        ArrayList    strSqls   = new ArrayList();
                        strSqls.Add("delete from T_TEXTUSEAREA where TEXTTYPE=" + selectdoc.Id.ToString() + "");
                        //分院信息
                        string  Sql         = "select * from T_SUB_HOSPITALINFO";
                        DataSet ds_hospital = App.GetDataSet(Sql);

                        //医生组
                        string  Sql_section = "select * from T_SECTIONINFO";
                        DataSet ds_section  = App.GetDataSet(Sql_section);
                        for (int i1 = 0; i1 < ds_hospital.Tables[0].Rows.Count; i1++)
                        {
                            DataRow[] Rows = ds_section.Tables[0].Select("shid = " + ds_hospital.Tables[0].Rows[i1]["SHID"].ToString() + "");
                            if (Rows.Length > 0)
                            {
                                for (int j = 0; j < Rows.Length; j++)
                                {
                                    Class_Doc_User_Range temp = new Class_Doc_User_Range();
                                    temp.Texttype       = selectdoc.Id;
                                    temp.Section        = Convert.ToInt16(Rows[j]["sid"].ToString());
                                    temp.Belonghospital = Convert.ToInt16(ds_hospital.Tables[0].Rows[i1]["SHID"].ToString());
                                    temp.Workgroup      = 212;
                                    strSqls.Add("insert into T_TEXTUSEAREA(TEXTTYPE,BELONGHOSPITAL,SECTION,WORKGROUP)values(" +
                                                temp.Texttype.ToString() + "," +
                                                temp.Belonghospital.ToString() + "," +
                                                temp.Section.ToString() + "," +
                                                temp.Workgroup.ToString() + ")");
                                }
                            }
                            else
                            {
                                strSqls.Add("insert into T_TEXTUSEAREA(TEXTTYPE,BELONGHOSPITAL,SECTION,WORKGROUP)values(" +
                                            selectdoc.Id.ToString() + "," + ds_hospital.Tables[0].Rows[i1]["SHID"].ToString() + ",0," + 212 + ")");
                            }
                        }
                        //护士组
                        string  Sql_sickarea = "select * from t_sickareainfo";
                        DataSet ds_sickarea  = App.GetDataSet(Sql_sickarea);
                        for (int i1 = 0; i1 < ds_hospital.Tables[0].Rows.Count; i1++)
                        {
                            DataRow[] Rows = ds_sickarea.Tables[0].Select("shid = " + ds_hospital.Tables[0].Rows[i1]["SHID"].ToString() + "");
                            if (Rows.Length > 0)
                            {
                                for (int j = 0; j < Rows.Length; j++)
                                {
                                    Class_Doc_User_Range temp = new Class_Doc_User_Range();
                                    temp.Texttype       = selectdoc.Id;
                                    temp.Section        = Convert.ToInt16(Rows[j]["said"].ToString());
                                    temp.Belonghospital = Convert.ToInt16(ds_hospital.Tables[0].Rows[i1]["SHID"].ToString());
                                    temp.Workgroup      = 213;
                                    strSqls.Add("insert into T_TEXTUSEAREA(TEXTTYPE,BELONGHOSPITAL,SECTION,WORKGROUP)values(" +
                                                temp.Texttype.ToString() + "," +
                                                temp.Belonghospital.ToString() + "," +
                                                temp.Section.ToString() + "," +
                                                temp.Workgroup.ToString() + ")");
                                }
                            }
                            else
                            {
                                strSqls.Add("insert into T_TEXTUSEAREA(TEXTTYPE,BELONGHOSPITAL,SECTION,WORKGROUP)values(" +
                                            selectdoc.Id.ToString() + "," + ds_hospital.Tables[0].Rows[i1]["SHID"].ToString() + ",0," + 213 + ")");
                            }
                        }
                        string[] strsqls2 = new string[strSqls.Count];
                        for (int k = 0; k < strsqls2.Length; k++)
                        {
                            strsqls2[k] = strSqls[k].ToString();
                        }
                        if (App.ExecuteBatch(strsqls2) > 0)
                        {
                            SaveCount++;
                        }
                    }
                }
            }
        }