Exemplo n.º 1
0
        protected void Btn_Find_Click(object sender, EventArgs e)
        {
            string Name         = txtName.Text;
            string Family       = txtFamily.Text;
            string NationalCode = txtNationalCode.Text;

            DataTable DTDate   = new DataTable();
            DataTable DTSource = new DataTable();

            DTSource.Columns.Add("ProfessorGuide", typeof(string));
            DTSource.Columns.Add("ProfessorAdvisor", typeof(string));
            DTSource.Columns.Add("ProfessorRefereeOne", typeof(string));
            DTSource.Columns.Add("ProfessorRefereeTwo", typeof(string));
            DTSource.Columns.Add("Student", typeof(string));
            DTSource.Columns.Add("Type", typeof(string));

            DTSource.Columns.Add("ClassName", typeof(string));
            DTSource.Columns.Add("LatinClassName", typeof(string));
            DTSource.Columns.Add("CountOfClass", typeof(string));
            DTSource.Columns.Add("CountOfUser", typeof(string));
            DTSource.Columns.Add("DateStart", typeof(string));
            DTSource.Columns.Add("DateEnd", typeof(string));
            DTSource.Columns.Add("DateDef", typeof(string));
            DTSource.Columns.Add("ClassType", typeof(string));
            DTSource.Columns.Add("UserType", typeof(string));
            DTSource.Columns.Add("ClasDayTime", typeof(string));

            DTSource.Columns.Add("UserId", typeof(string));       //StudentCode Or ProfCode
            DTSource.Columns.Add("Name", typeof(string));         // Name
            DTSource.Columns.Add("Family", typeof(string));       // Family
            DTSource.Columns.Add("FatherName", typeof(string));   // FatherName
            DTSource.Columns.Add("Id", typeof(string));           // شماره شناسنامه
            DTSource.Columns.Add("NationalCode", typeof(string)); // کدملی

            ManagementPanelBusiness MPB = new ManagementPanelBusiness();



            if (lbl_Type.Text == "Student")
            {
                DTDate = MPB.Get_Student_ByName_Family_NationalCode(Name, Family, NationalCode);
            }
            else if (lbl_Type.Text != "")
            {
                DTDate = MPB.Get_Professor_ByName_Family_NationalCode(Name, Family, NationalCode);
            }



            for (int i = 0; i < DTDate.Rows.Count; i++)
            {
                DataRow row = DTSource.NewRow();
                row["ProfessorGuide"]      = lbl_ProfessorGuide.Text;
                row["ProfessorAdvisor"]    = lbl_ProfessorAdvisor.Text;
                row["ProfessorRefereeOne"] = lbl_ProfessorRefereeOne.Text;
                row["ProfessorRefereeTwo"] = lbl_ProfessorRefereeTwo.Text;
                row["Student"]             = lbl_Student.Text;
                row["Type"] = lbl_Type.Text;

                row["ClassName"]      = lbl_ClassName.Text;
                row["LatinClassName"] = lbl_LatinClassName.Text;
                row["CountOfClass"]   = lbl_CountOfClass.Text;
                row["CountOfUser"]    = lbl_CountOfUser.Text;
                row["DateStart"]      = lbl_DateStart.Text;
                row["DateEnd"]        = lbl_DateEnd.Text;
                row["DateDef"]        = lbl_DateDef.Text;
                row["ClassType"]      = lbl_ClassType.Text;
                row["UserType"]       = lbl_UserType.Text;
                row["ClasDayTime"]    = lbl_ClasDayTime.Text;

                row["UserId"]       = DTDate.Rows[i]["Code"].ToString();
                row["Name"]         = DTDate.Rows[i]["name"].ToString();
                row["Family"]       = DTDate.Rows[i]["family"].ToString();
                row["FatherName"]   = DTDate.Rows[i]["namep"].ToString();
                row["Id"]           = DTDate.Rows[i]["id"].ToString();
                row["NationalCode"] = DTDate.Rows[i]["idd_meli"].ToString();

                DTSource.Rows.Add(row);
            }


            RadGrid1.DataSource = DTSource;
            RadGrid1.DataBind();
        }