public List<StudentWelfareResource> getStudentData3(string ID)
{
List<StudentWelfareResource> returnValue = new List<StudentWelfareResource>();
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = "SELECT StudentWelfareResource.*, ResourceCard.ORGName, ResourceCard.ORGItem, ResourceCard.Category FROM StudentWelfareResource " +
"INNER JOIN StudentDatabase ON StudentWelfareResource.StudentID=StudentDatabase.StudentID " +
"INNER JOIN ResourceCard ON StudentWelfareResource.ORGID=ResourceCard.ID " +
"WHERE StudentWelfareResource.isDeleted=0 AND StudentDatabase.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())
{
StudentWelfareResource addValue = new StudentWelfareResource();
addValue.wID = dr["wID"].ToString();
addValue.studentID = dr["StudentID"].ToString();
addValue.resourceDate = DateTime.Parse(dr["ORGDate"].ToString()).ToString("yyyy-MM-dd");
addValue.resourceID = dr["ORGID"].ToString();
addValue.resourceName = dr["ORGName"].ToString();
addValue.resourceItem = dr["ORGItem"].ToString();
addValue.resourceType = dr["Category"].ToString();
returnValue.Add(addValue);
}
Sqlconn.Close();
}
catch (Exception e)
{
StudentWelfareResource addValue = new StudentWelfareResource();
addValue.checkNo = "-1";
addValue.errorMsg = e.Message.ToString();
returnValue.Add(addValue);
}
return returnValue;
}
}
//學生基本資料(分頁)->福利資源使用狀況-新增
public string[] createStudentDataBase3(StudentWelfareResource StudentWelfare)
{
string[] returnValue = new string[2];
returnValue[0] = "0";
returnValue[1] = "";
DataBase Base = new DataBase();
SqlConnection Sqlconn = new SqlConnection(Base.GetConnString());
using (Sqlconn)
{
try
{
StaffDataBase sDB = new StaffDataBase();
List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
Sqlconn.Open();
string sql = "INSERT INTO StudentWelfareResource (StudentID, ORGDate, ORGID, CreateFileBy, UpFileBy, UpFileDate) " +
"VALUES (@StudentID, @ORGDate, @ORGID, @CreateFileBy, @UpFileBy, (getDate()))";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentWelfare.studentID);
cmd.Parameters.Add("@ORGDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentWelfare.resourceDate);
cmd.Parameters.Add("@ORGID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentWelfare.resourceID);
cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
returnValue[0] = cmd.ExecuteNonQuery().ToString();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message;
}
}
return returnValue;
}
public List<StudentWelfareResource> getStudentDataBase3(string ID)
{
CaseDataBase SDB = new CaseDataBase();
List<StudentWelfareResource> returnValue = new List<StudentWelfareResource>();
if (int.Parse(SDB._StaffhaveRoles[3]) == 1)
{
returnValue = SDB.getStudentData3(ID);
}
else
{
StudentWelfareResource addValue = new StudentWelfareResource();
addValue.checkNo = _noRole;
addValue.errorMsg = _errorMsg;
returnValue.Add(addValue);
}
return returnValue;
}
