示例#1
0
        /// <summary>
        /// Creates the department ListView.
        /// </summary>
        /// <param name="selectedCompanyId">The selected company identifier.</param>
        /// <param name="selectedDepartmentId">The selected department identifier.</param>
        /// <param name="selectedDepartment">The selected department.</param>
        /// <param name="companyList">The company list.</param>
        /// <param name="departmentsList">The departments list.</param>
        /// <param name="message">The message.</param>
        /// <returns></returns>
        public IDepartmentListView CreateDepartmentListView(int selectedCompanyId, int selectedDepartmentId,
                                                            string selectedDepartment,
                                                            IList <ICompanyDetail> companyList, IList <IDepartment> departmentsList, string message)
        {
            // get parentcompany  drop down list
            var companytDDL = GetDropDownList.CompanyListItems(companyList, selectedCompanyId);

            // filter with companyId
            var filteredList = departmentsList
                               .Where(x => x.CompanyId.Equals(selectedCompanyId < 1 ? x.CompanyId : selectedCompanyId)).ToList();

            //filter with departmentId
            filteredList = filteredList.Where(x =>
                                              x.DepartmentId.Equals(selectedDepartmentId < 1 ? x.DepartmentId : selectedDepartmentId)).ToList();

            //filter with departmentname
            filteredList = filteredList.Where(x =>
                                              x.DepartmentName.Contains(string.IsNullOrEmpty(selectedDepartment)
                    ? x.DepartmentName
                    : selectedDepartment)).ToList();


            var viewModel = new DepartmentListView
            {
                CompanyDropDownList  = companytDDL,
                DepartmentCollection = filteredList.ToList(),
                ProcessingMessage    = message,
                SelectedCompanyId    = selectedCompanyId,
                SelectedDepartment   = selectedDepartment,
                SelectedDepartmentId = selectedDepartmentId
            };

            return(viewModel);
        }
示例#2
0
    protected void departmentdelete_Click(object sender, EventArgs e)
    {
        int    dno = Int32.Parse((sender as Button).CommandArgument.ToString());
        string sql = "delete from tb_department where dno  ='" + dno + "'";

        try
        {
            if (DBControl.delete(sql) > 0)
            {
                DepartmentListView.DataSource = null;
                DepartmentListView.DataBind();
                ScriptManager.RegisterStartupScript(this.department_panel, this.GetType(), "updateScript", "alert('删除成功')", true);
            }
            else
            {
                DepartmentListView.DataSource = null;
                DepartmentListView.DataBind();
                ScriptManager.RegisterStartupScript(this.department_panel, this.GetType(), "updateScript", "alert('该系不存在')", true);
            }
        }
        catch (Exception ex)
        {
            ScriptManager.RegisterStartupScript(this.department_panel, this.GetType(), "updateScript", "alert('系统异常')", true);
        }
    }
示例#3
0
        /// <summary>
        /// Creates the department ListView.
        /// </summary>
        /// <param name="departmentsCollection">The departments collection.</param>
        /// <param name="companyInfo">The company information.</param>
        /// <returns></returns>
        public IDepartmentListView CreateDepartmentListView(IEnumerable <IDepartment> departmentsCollection,
                                                            ICompanyDetail companyInfo)
        {
            var viewModel = new DepartmentListView
            {
                DepartmentsCollection = departmentsCollection,
                CompanyDetails        = companyInfo,
            };

            return(viewModel);
        }
示例#4
0
    protected void departmenteditsub_Click(object sender, EventArgs e)
    {
        if (string.IsNullOrEmpty(departmenteditdna.Text.Trim()))
        {
            ScriptManager.RegisterStartupScript(this.department_panel, this.GetType(), "updateScript", "alert('系名不能为空!')", true);
        }
        if (string.IsNullOrEmpty(departmenteditdeo.Text.Trim()))
        {
            ScriptManager.RegisterStartupScript(this.department_panel, this.GetType(), "updateScript", "alert('系负责人不能为空!')", true);
        }
        if (string.IsNullOrEmpty(departmenteditdso.Text.Trim()))
        {
            ScriptManager.RegisterStartupScript(this.department_panel, this.GetType(), "updateScript", "alert('专业数不能为空!')", true);
        }
        int    dno = 0;
        string dna = null;
        string deo = null;
        int    dso = 0;

        try
        {
            dno = Convert.ToInt32(departmenteditdno.Text.Trim());
            dna = departmenteditdna.Text.Trim();
            deo = departmenteditdeo.Text.Trim();
            dso = Convert.ToInt32(departmenteditdso.Text.Trim());
        }
        catch (Exception)
        {
            ScriptManager.RegisterStartupScript(this.department_panel, this.GetType(), "updateScript", "alert('请在专业数中输入数字!')", true);
        }


        string sql = "update tb_department set dna='" + dna + "',deo='" + deo + "',dso='" + dso + "' where dno ='" + dno + "'";

        try
        {
            DBControl.update(sql);
            ScriptManager.RegisterStartupScript(this.department_panel, this.GetType(), "updateScript", "alert('编辑成功')", true);
            DepartmentListView.DataSource = null;
            DepartmentListView.DataBind();
            managedepartment_panel.Visible = true;
            editdepartment_panel.Visible   = false;
        }
        catch (Exception ex)
        {
            ScriptManager.RegisterStartupScript(this.department_panel, this.GetType(), "updateScript", "alert('编辑失败')", true);
        }
    }