public SingleClassShortTerm GetSingleTeachShortTerm(int SCSTID)
{
SingleClassShortTerm returnValue = new SingleClassShortTerm();
returnValue.SingleClassShortTermTarget = new List<SingleClassShortTermTarget>();
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = " select a.*,b.*,c.studentName,d.TeacherName ";
sql += " from SingleClassShortTerm a left join SingleClassShortTermTarget b on a.ID = b.SCSTID ";
sql += " left join (select studentName , studentID as cid from studentdatabase) c on a.studentID = c.cid ";
sql += " left join ( select staffid as did , StaffName as TeacherName from staffDatabase ) d on a.teacherid = d.did";
sql += " where 1=1 ";
sql += " and a.ID = @SCSTID ";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@SCSTID", SqlDbType.Int).Value = SCSTID;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (returnValue.studentID == null)
{
returnValue.studentName = dr["studentName"].ToString();
returnValue.studentID = dr["studentID"].ToString();
returnValue.teacherID = dr["teacherID"].ToString();
returnValue.teacherName = dr["TeacherName"].ToString();
returnValue.Remark = dr["remark"].ToString();
returnValue.PlanDateStart = DateTime.Parse(dr["PlanDateStart"].ToString()).ToString("yyyy-MM-dd");
returnValue.PlanDateEnd = DateTime.Parse(dr["PlanDateEnd"].ToString()).ToString("yyyy-MM-dd");
}
SingleClassShortTermTarget addValue = new SingleClassShortTermTarget();
addValue.DetailOrder = dr["DetailOrder"].ToString();
addValue.PlanOrder = dr["PlanOrder"].ToString();
addValue.TargetMain = dr["TargetMain"].ToString();
addValue.TargetContent = dr["targetContent"].ToString();
addValue.Assessment1 = dr["Assessment1"].ToString();
addValue.Assessment2 = dr["Assessment2"].ToString();
addValue.Assessment3 = dr["Assessment3"].ToString();
addValue.Assessment4 = dr["Assessment4"].ToString();
addValue.Assessment5 = dr["Assessment5"].ToString();
addValue.PlanExecutionDate1 = DateTime.Parse(dr["PlanExecutionDate1"].ToString()).ToString("yyyy-MM-dd");
addValue.PlanExecutionDate2 = DateTime.Parse(dr["PlanExecutionDate2"].ToString()).ToString("yyyy-MM-dd");
addValue.PlanExecutionDate3 = DateTime.Parse(dr["PlanExecutionDate3"].ToString()).ToString("yyyy-MM-dd");
addValue.PlanExecutionDate4 = DateTime.Parse(dr["PlanExecutionDate4"].ToString()).ToString("yyyy-MM-dd");
addValue.PlanExecutionDate5 = DateTime.Parse(dr["PlanExecutionDate5"].ToString()).ToString("yyyy-MM-dd");
addValue.Performance1 = dr["Performance1"].ToString();
addValue.Performance2 = dr["Performance2"].ToString();
addValue.Performance3 = dr["Performance3"].ToString();
addValue.Performance4 = dr["Performance4"].ToString();
addValue.Performance5 = dr["Performance5"].ToString();
returnValue.SingleClassShortTermTarget.Add(addValue);
}
Sqlconn.Close();
}
catch (Exception e)
{
string item = e.Message.ToString();
//returnValue = -1;
}
}
return returnValue;
}
public List<SingleClassShortTermTarget> GetSingleTeachCase(int studentID, string StartDate, string EndDate)
{
List<SingleClassShortTermTarget> returnValue = new List<SingleClassShortTermTarget>();
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = " select * ";
sql += " from TeachingPlanDetail a left join TeachingPlan b on a.TPMID = b.ID ";
sql += " where 1=1 ";
sql += " and b.ispID in (select ID from CaseISPstate where StudentID = @StudentID) ";
sql += " and (( DateStart between @Start and @End or DateEnd between @Start and @End ) or ( DateStart < @Start and DateEnd > @End )) ";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = studentID;
cmd.Parameters.Add("@Start", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StartDate);
cmd.Parameters.Add("@End", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(EndDate);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
SingleClassShortTermTarget addValue = new SingleClassShortTermTarget();
addValue.ID = dr["id"].ToString();
addValue.PlanOrder = dr["TeachOrder"].ToString();
addValue.TargetMain = dr["TargetShort"].ToString();
returnValue.Add(addValue);
}
Sqlconn.Close();
}
catch (Exception e)
{
string item = e.Message.ToString();
//returnValue = -1;
}
}
return returnValue;
}
