private void Rebind() { DataSet Rs = StudentBasicInfoEx.SelectStudentAccount(); GridViewStudentInfo.DataSource = Rs; GridViewStudentInfo.DataBind(); }
protected void AddInfo_Click(object sender, EventArgs e) { if (!StudentBasicInfoEx.InsertStudent(txtStudentID.Text.Trim(), txtName.Text.Trim())) { lbErrorMessage.Visible = true; lbErrorMessage.Text = "插入失败!"; return; } lbErrorMessage.Visible = true; lbErrorMessage.Text = "插入成功!"; Rebind(); }
protected void Rebind() { String strStudentID = txtStudentID.Text.Trim(); String strName = txtName.Text.Trim(); String strNation = txtNation.Text.Trim(); Int16 strDepartment = CheckDropDownListContent(DropDownListDepartment); String strField = txtField.Text.Trim(); Int32 strEntranceYear = txtEntranceYear.Text.Trim() == String.Empty ? 0 : Convert.ToInt32(txtEntranceYear.Text.Trim()); Int16 strStudentType = CheckDropDownListContent(DropDownListStudentType); Int16 strGraduationType = CheckDropDownListContent(DropDownListGraduationType); Int16 strWorkUnit = CheckDropDownListContent(DropDownListWorkUnit); Rs = StudentBasicInfoEx.QueryStudentInfo(strStudentID, strName, strNation, strDepartment, strField, strEntranceYear, strStudentType, strGraduationType, strWorkUnit); GridViewStudentInfo.DataSource = Rs; GridViewStudentInfo.DataBind(); }
protected void btConfirm_Click(object sender, EventArgs e) { String strPersonalPhoto = ImgPersonalPhoto.ImageUrl; String strCollege = txtCollege.Text.Trim(); String iDepartment = DropDownListDepartment.SelectedValue; String iWorkUnit = DropDownListWorkUnit.SelectedValue; String strStudentName = lbName.Text.Trim(); String strOriginalName = txtOriginalName.Text.Trim(); String iGender = DropDownListGender.SelectedValue; String strNativeProvince = txtNativeProvince.Text.Trim(); DateTime dt_BirthDay = Convert.ToDateTime(txtBirthDay.Text.Trim()); String strNation = txtNation.Text.Trim(); String strBirthPlace = txtBirthPlace.Text.Trim(); String strHomeBirth = txtHomeBirth.Text.Trim(); String iPoliticalStatus = DropDownListPoliticalStatus.Text.Trim(); String strPaperworktype = txtPaperworktype.Text.Trim(); String strPaperworkNum = txtPaperworkNum.Text.Trim(); String iMarriage = DropDownListMarriage.SelectedValue; String strConsortName = txtConsortName.Text.Trim(); String strConsortPhoneNumber = txtConsortPhoneNumber.Text.Trim(); String strConsortWorkingPlace = txtConsortWorkingPlace.Text.Trim(); String strEntranceYear = txtEntranceYear.Text.Trim(); String iEntranceSeason = DropDownListEntranceSeason.SelectedValue; String strGrade = txtGrade.Text.Trim(); String strClass = txtClass.Text.Trim(); String strStudyTime = txtStudyTime.Text.Trim(); String strWorkingPlaceBeforeSchool = txtWorkingPlaceBeforeSchool.Text.Trim(); String iStudyType = DropDownListStudyType.SelectedValue; String iNowCondition = DropDownListNowCondition.SelectedValue; String iContinent = DropDownListContinent.SelectedValue; String strCountry = txtCountry.Text.Trim(); String strStudentSource = txtStudentSource.Text.Trim(); String iStudentTyp = DropDownListStudentType.SelectedValue; String iTrainType = DropDownListTrainType.SelectedValue; String iSubsidizeType = DropDownListSubsidizeType.SelectedValue; String strField = txtField.Text.Trim(); String strFieldDirection = txtFieldDirection.Text.Trim(); String strTeacher = txtTeacher.Text.Trim(); String strHealth = txtHealth.Text.Trim(); String strBloodtype = txtBloodType.Text.Trim(); String strGraduation = txtGraduation.Text.Trim(); String iGraduationSeason = DropDownListGraduationSeason.SelectedValue; String strGraduationTime = txtGraduationTime.Text.Trim(); String iGraduationType = DropDownListGraduationType.SelectedValue; String strTrainArriveDestination = txtTrainArriveDestination.Text.Trim(); String strDormitoryNum = txtDormitoryNum.Text.Trim(); String strDormitoryRoom = txtDormitoryRoom.Text.Trim(); String strDormitoryPhone = txtDormitoryPhone.Text.Trim(); String strEmailAddress = txtEmailAddress.Text.Trim(); String strQQ = txtQQ.Text.Trim(); String strMSN = txtMSN.Text.Trim(); String strHomePhone = txtHomePhone.Text.Trim(); String strHomeAddress = txtHomeAddress.Text.Trim(); String strPostCode = txtPostCode.Text.Trim(); String strRegisteredResidence = txtRegisteredResidence.Text.Trim(); String strRegisteredResidenceProperty = txtRegisteredResidenceProperty.Text.Trim(); String strFatherName = txtFatherName.Text.Trim(); String strFatherPhone = txtFatherPhone.Text.Trim(); String strFatherWorkingPlace = txtFatherWorkingPlace.Text.Trim(); String strMotherName = txtMotherName.Text.Trim(); String strMotherPhone = txtMotherPhone.Text.Trim(); String strMotherWorkingPlace = txtMotherWorkingPlace.Text.Trim(); if (!StudentBasicInfoEx.InsertStudentInfo(strPersonalPhoto, strCollege, iDepartment, iWorkUnit, strStudentID, strStudentName, strOriginalName, iGender, strNativeProvince, dt_BirthDay, strNation, strBirthPlace, strHomeBirth, iPoliticalStatus, strPaperworktype, strPaperworkNum, iMarriage, strConsortName, strConsortPhoneNumber, strConsortWorkingPlace, strEntranceYear, iEntranceSeason, strGrade, strClass, strStudyTime, strWorkingPlaceBeforeSchool, iStudyType, iNowCondition, iContinent, strCountry, strStudentSource, iStudentTyp, iTrainType, iSubsidizeType, strField, strFieldDirection, strTeacher, strHealth, strBloodtype, strGraduation, iGraduationSeason, strGraduationTime, iGraduationType, strTrainArriveDestination, strDormitoryNum, strDormitoryRoom, strDormitoryPhone, strEmailAddress, strQQ, strMSN, strHomePhone, strHomeAddress, strPostCode, strRegisteredResidence, strRegisteredResidenceProperty, strFatherName, strFatherPhone, strFatherWorkingPlace, strMotherName, strMotherPhone, strMotherWorkingPlace)) { lbErrorMessage.Text = "数据插入失败!"; return; } if (!StudentBasicInfoEx.InsertValidity(strStudentID, txtReason.Text.ToString().Trim(), Convert.ToInt16(DropDownListVal.SelectedValue))) { lbErrorMessage.Text = "数据插入失败!"; return; } lbErrorMessage.Text = "数据插入成功!"; }
protected void BasicInfoInitialize() { DataSet QueryRs = StudentBasicInfoEx.SelectBasicInfo(strStudentID); ImgPersonalPhoto.ImageUrl = CheckContent(QueryRs.Tables[0].Rows[0][0]); txtCollege.Text = CheckContent(QueryRs.Tables[0].Rows[0][1]); DropDownListDepartment.SelectedValue = CheckDropDownListView(DropDownListDepartment, QueryRs.Tables[0].Rows[0][2]); DropDownListWorkUnit.SelectedValue = CheckDropDownListView(DropDownListWorkUnit, QueryRs.Tables[0].Rows[0][3]); lbStudentID.Text = strStudentID; lbName.Text = CheckContent(QueryRs.Tables[0].Rows[0][5]); txtOriginalName.Text = CheckContent(QueryRs.Tables[0].Rows[0][6]); DropDownListGender.SelectedValue = CheckDropDownListView(DropDownListGender, QueryRs.Tables[0].Rows[0][7]); txtNativeProvince.Text = CheckContent(QueryRs.Tables[0].Rows[0][8]); txtBirthDay.Text = DateStringFomate(CheckContent(QueryRs.Tables[0].Rows[0][9])); txtNation.Text = CheckContent(QueryRs.Tables[0].Rows[0][10]); txtBirthPlace.Text = CheckContent(QueryRs.Tables[0].Rows[0][11]); txtHomeBirth.Text = CheckContent(QueryRs.Tables[0].Rows[0][12]); DropDownListPoliticalStatus.SelectedValue = CheckDropDownListView(DropDownListPoliticalStatus, QueryRs.Tables[0].Rows[0][13]); txtPaperworktype.Text = CheckContent(QueryRs.Tables[0].Rows[0][14]); txtPaperworkNum.Text = CheckContent(QueryRs.Tables[0].Rows[0][15]); DropDownListMarriage.SelectedValue = CheckDropDownListView(DropDownListMarriage, QueryRs.Tables[0].Rows[0][16]); txtConsortName.Text = CheckContent(QueryRs.Tables[0].Rows[0][17]); txtConsortPhoneNumber.Text = CheckContent(QueryRs.Tables[0].Rows[0][18]); txtConsortWorkingPlace.Text = CheckContent(QueryRs.Tables[0].Rows[0][19]); txtEntranceYear.Text = CheckContent(QueryRs.Tables[0].Rows[0][20]); DropDownListEntranceSeason.SelectedValue = CheckDropDownListView(DropDownListEntranceSeason, QueryRs.Tables[0].Rows[0][21]); txtGrade.Text = CheckContent(QueryRs.Tables[0].Rows[0][22]); txtClass.Text = CheckContent(QueryRs.Tables[0].Rows[0][23]); txtStudyTime.Text = CheckContent(QueryRs.Tables[0].Rows[0][24]); txtWorkingPlaceBeforeSchool.Text = CheckContent(QueryRs.Tables[0].Rows[0][25]); DropDownListStudyType.SelectedValue = CheckDropDownListView(DropDownListStudyType, QueryRs.Tables[0].Rows[0][26]); DropDownListNowCondition.SelectedValue = CheckDropDownListView(DropDownListNowCondition, QueryRs.Tables[0].Rows[0][27]); DropDownListContinent.SelectedValue = CheckDropDownListView(DropDownListContinent, QueryRs.Tables[0].Rows[0][28]); txtCountry.Text = CheckContent(QueryRs.Tables[0].Rows[0][29]); txtStudentSource.Text = CheckContent(QueryRs.Tables[0].Rows[0][30]); DropDownListStudentType.SelectedValue = CheckDropDownListView(DropDownListStudentType, QueryRs.Tables[0].Rows[0][31]); DropDownListTrainType.SelectedValue = CheckDropDownListView(DropDownListTrainType, QueryRs.Tables[0].Rows[0][32]); DropDownListSubsidizeType.SelectedValue = CheckDropDownListView(DropDownListSubsidizeType, QueryRs.Tables[0].Rows[0][33]); txtField.Text = CheckContent(QueryRs.Tables[0].Rows[0][34]); txtFieldDirection.Text = CheckContent(QueryRs.Tables[0].Rows[0][35]); txtTeacher.Text = CheckContent(QueryRs.Tables[0].Rows[0][36]); txtHealth.Text = CheckContent(QueryRs.Tables[0].Rows[0][37]); txtBloodType.Text = CheckContent(QueryRs.Tables[0].Rows[0][38]); txtGraduation.Text = CheckContent(QueryRs.Tables[0].Rows[0][39]); DropDownListGraduationSeason.SelectedValue = CheckDropDownListView(DropDownListGraduationSeason, QueryRs.Tables[0].Rows[0][40]); txtGraduationTime.Text = CheckContent(QueryRs.Tables[0].Rows[0][41]); DropDownListGraduationType.SelectedValue = CheckDropDownListView(DropDownListGraduationType, QueryRs.Tables[0].Rows[0][42]); txtTrainArriveDestination.Text = CheckContent(QueryRs.Tables[0].Rows[0][43]); txtDormitoryNum.Text = CheckContent(QueryRs.Tables[0].Rows[0][44]); txtDormitoryRoom.Text = CheckContent(QueryRs.Tables[0].Rows[0][45]); txtDormitoryPhone.Text = CheckContent(QueryRs.Tables[0].Rows[0][46]); txtEmailAddress.Text = CheckContent(QueryRs.Tables[0].Rows[0][47]); txtQQ.Text = CheckContent(QueryRs.Tables[0].Rows[0][48]); txtMSN.Text = CheckContent(QueryRs.Tables[0].Rows[0][49]); txtHomePhone.Text = CheckContent(QueryRs.Tables[0].Rows[0][50]); txtHomeAddress.Text = CheckContent(QueryRs.Tables[0].Rows[0][51]); txtPostCode.Text = CheckContent(QueryRs.Tables[0].Rows[0][52]); txtRegisteredResidence.Text = CheckContent(QueryRs.Tables[0].Rows[0][53]); txtRegisteredResidenceProperty.Text = CheckContent(QueryRs.Tables[0].Rows[0][54]); txtFatherName.Text = CheckContent(QueryRs.Tables[0].Rows[0][55]); txtFatherPhone.Text = CheckContent(QueryRs.Tables[0].Rows[0][56]); txtFatherWorkingPlace.Text = CheckContent(QueryRs.Tables[0].Rows[0][57]); txtMotherName.Text = CheckContent(QueryRs.Tables[0].Rows[0][58]); txtMotherPhone.Text = CheckContent(QueryRs.Tables[0].Rows[0][59]); txtMotherWorkingPlace.Text = CheckContent(QueryRs.Tables[0].Rows[0][60]); Int16 ivalidate = Convert.ToInt16(QueryRs.Tables[0].Rows[0][62]); DropDownListVal.SelectedValue = ivalidate.ToString(); txtReason.Text = CheckContent(QueryRs.Tables[0].Rows[0][61]); }