public StudentData1 getStudentData1(string ID)
{
// select A.StudentID, A.StudentName,A.StudentIdentity,A.ConsultDate,A.EvaluationDate,A.Updated,
//A.StudentBirthday,B.UnitName, C.StatusName,D.SexName,
//(A.AddressZip1+E.CityName + A.AddressOther1) as '居住地' ,
//(A.AddressZip2+F.CityName + A.AddressOther2) as '戶籍地'
//from StudentDatabase A
//left join StaffUnit B on A.Unit=B.ID
//left join CaseStatus C on A.caseStatu=C.ID
//left join StudentSex D on A.StudentSex=D.ID
//left join CityName E on A.AddressCity1=E.ID
//left join CityName F on A.AddressCity2=F.ID
//where isDeleted=0
StudentData1 returnValue = new StudentData1();
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = "SELECT * FROM StudentDatabase WHERE isDeleted=0 AND ID=(@ID)";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = Chk.CheckStringtoInt64Function(ID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
StaffDataBase sDB = new StaffDataBase();
List<string> StaffData = sDB.getStaffDataName(dr["WriteName"].ToString());
returnValue.fillInName = StaffData[1];
returnValue.ID = dr["ID"].ToString();
returnValue.assessDate = DateTime.Parse(dr["EvaluationDate"].ToString()).ToString("yyyy-MM-dd");
returnValue.consultationDate = DateTime.Parse(dr["ConsultDate"].ToString()).ToString("yyyy-MM-dd");
returnValue.upDate = DateTime.Parse(dr["Updated"].ToString()).ToString("yyyy-MM-dd");
returnValue.caseStatu = dr["CaseStatu"].ToString();
returnValue.Unit = dr["Unit"].ToString();
returnValue.studentID = dr["StudentID"].ToString();
returnValue.studentName = dr["StudentName"].ToString();
returnValue.studentTWID = dr["StudentIdentity"].ToString();
returnValue.censusAddressZip = dr["AddressZip1"].ToString();
returnValue.censusAddressCity = dr["AddressCity1"].ToString();
returnValue.censusAddress = dr["AddressOther1"].ToString();
returnValue.addressZip = dr["AddressZip2"].ToString();
returnValue.addressCity = dr["AddressCity2"].ToString();
returnValue.address = dr["AddressOther2"].ToString();
returnValue.studentbirthday = DateTime.Parse(dr["StudentBirthday"].ToString()).ToString("yyyy-MM-dd");
returnValue.studentSex = dr["StudentSex"].ToString();
returnValue.firstClassDate = DateTime.Parse(dr["ClassDate"].ToString()).ToString("yyyy-MM-dd");
returnValue.guaranteeDate = DateTime.Parse(dr["GuaranteeDate"].ToString()).ToString("yyyy-MM-dd");
returnValue.BackGuaranteeDate = DateTime.Parse(dr["BackGuaranteeDate"].ToString()).ToString("yyyy-MM-dd");
returnValue.endReasonDate = DateTime.Parse(dr["CompletedDate"].ToString()).ToString("yyyy-MM-dd");
returnValue.endReasonType = dr["CompletedType"].ToString();
returnValue.endReason = dr["CompletedReason"].ToString();
returnValue.sendDateSince = DateTime.Parse(dr["ShortEndDateSince"].ToString()).ToString("yyyy-MM-dd");
returnValue.sendDateUntil = DateTime.Parse(dr["ShortEndDateUntil"].ToString()).ToString("yyyy-MM-dd");
returnValue.nomembershipType = dr["NomembershipType"].ToString();
returnValue.nomembershipReason = dr["NomembershipReason"].ToString();
returnValue.studentPhoto = dr["StudentAvatar"].ToString();
returnValue.wCare = dr["CaregiversDaytime"].ToString();
returnValue.wCareName = dr["CaregiversDaytimeText"].ToString();
returnValue.bCare = dr["CaregiversNight"].ToString();
returnValue.bCareName = dr["CaregiversNightText"].ToString();
returnValue.fPRelation1 = dr["ContactRelation1"].ToString();
returnValue.fPName1 = dr["ContactName1"].ToString();
returnValue.fPTel1 = dr["ContactTel_company1"].ToString();
returnValue.fPPhone1 = dr["ContactPhone1"].ToString();
returnValue.fPHPhone1 = dr["ContactTel_home1"].ToString();
returnValue.fPFax1 = dr["ContactFax1"].ToString();
returnValue.fPRelation2 = dr["ContactRelation2"].ToString();
returnValue.fPName2 = dr["ContactName2"].ToString();
returnValue.fPTel2 = dr["ContactTel_company2"].ToString();
returnValue.fPPhone2 = dr["ContactPhone2"].ToString();
returnValue.fPHPhone2 = dr["ContactTel_home2"].ToString();
returnValue.fPFax2 = dr["ContactFax2"].ToString();
returnValue.fPRelation3 = dr["ContactRelation3"].ToString();
returnValue.fPName3 = dr["ContactName3"].ToString();
returnValue.fPTel3 = dr["ContactTel_company3"].ToString();
returnValue.fPPhone3 = dr["ContactPhone3"].ToString();
returnValue.fPHPhone3 = dr["ContactTel_home3"].ToString();
returnValue.fPFax3 = dr["ContactFax3"].ToString();
returnValue.fPRelation4 = dr["ContactRelation4"].ToString();
returnValue.fPName4 = dr["ContactName4"].ToString();
returnValue.fPTel4 = dr["ContactTel_company4"].ToString();
returnValue.fPPhone4 = dr["ContactPhone4"].ToString();
returnValue.fPHPhone4 = dr["ContactTel_home4"].ToString();
returnValue.fPFax4 = dr["ContactFax4"].ToString();
returnValue.email = dr["StudentEmail"].ToString();
returnValue.sourceType = dr["ReferralSourceType"].ToString();
returnValue.sourceName = dr["ReferralSource"].ToString();
returnValue.manualWhether = dr["PhysicalAndMentalDisabilityHandbook"].ToString();
returnValue.manualCategory1 = dr["DisabilityCategory1"].ToString();
returnValue.manualGrade1 = dr["DisabilityGrade1"].ToString();
returnValue.manualCategory2 = dr["DisabilityCategory2"].ToString();
returnValue.manualGrade2 = dr["DisabilityGrade2"].ToString();
returnValue.manualCategory3 = dr["DisabilityCategory3"].ToString();
returnValue.manualGrade3 = dr["DisabilityGrade3"].ToString();
returnValue.manualNo = dr["NoDisabilityHandbook"].ToString();
returnValue.manualUnit = dr["ApplyDisabilityHandbook"].ToString();
returnValue.studentManualImg = dr["DisabilityProve"].ToString();
returnValue.notificationWhether = dr["Notify"].ToString();
returnValue.notificationUnit = dr["Notify_Unit"].ToString();
returnValue.notificationManage = dr["Notify_Member"].ToString();
returnValue.notificationTel = dr["Notify_Tel"].ToString();
returnValue.notificationDate = DateTime.Parse(dr["Notify_Date"].ToString()).ToString("yyyy-MM-dd");
returnValue.notificationCity = dr["Notify_City"].ToString();
returnValue.economy = dr["EconomyState"].ToString();
returnValue.economyLow = dr["EconomyLow"].ToString();
}
dr.Close();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue.checkNo = "-1";
returnValue.errorMsg = e.Message.ToString();
}
}
return returnValue;
}
public StudentData1 getStudentDataBase1(string ID)
{
CaseDataBase SDB = new CaseDataBase();
StudentData1 returnValue=new StudentData1();
if (int.Parse(SDB._StaffhaveRoles[3]) == 1)
{
returnValue=SDB.getStudentData1(ID);
}
else
{
returnValue.checkNo = _getcheckNo;
returnValue.errorMsg = _errorMsg;
}
StaffDataBase sDB = new StaffDataBase();
List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
if (returnValue.Unit != UserFile[2] && int.Parse(SDB._StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0)
{
returnValue.checkNo = _getcheckNo;
returnValue.errorMsg = _errorMsg;
}
return returnValue;
}
