protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DateTime dt = DateTime.Now;
StartDate_txb.Text = dt.ToString("yyyy/MM/dd");
EndDate_txb.Text = dt.ToString("yyyy/MM/dd");
}
string sErrMsg = string.Empty;
DataTable dataTable = new DataTable();
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_ClassInfo";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@StartDate"].Value = StartDate_txb.Text;
sqlObj.SqlCmd.Parameters["@EndDate"].Value = EndDate_txb.Text;
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dataTable);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
BootstrapGridView1.DataSource = dataTable; //告訴GridView資料來源為誰
BootstrapGridView1.DataBind(); //綁定
}
public static string BecomeStudent(string ClassNo, string BackPage)
{
string sErrMsg = string.Empty;
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_UI_MemberClass";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@Account"].Value = HttpContext.Current.Session["Account"].ToString();
sqlObj.SqlCmd.Parameters["@ClassNo"].Value = ClassNo;
try
{
sqlObj.SqlConn.Open();
sqlObj.SqlCmd.ExecuteNonQuery();
HttpContext.Current.Session["ClassNo"] = ClassNo;
HttpContext.Current.Session["ClassroomBackPage"] = BackPage;
return("success");
}
catch (Exception ex)
{
return(ex.Message);
}
finally
{
sqlObj.SqlConn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string sErrMsg = string.Empty;
DataTable dataTable = new DataTable();
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_MemberClass";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@Account"].Value = HttpContext.Current.Session["Account"].ToString();
sqlObj.SqlCmd.Parameters["@XOLTP"].Value = 5;
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dataTable);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
BootstrapGridView.DataSource = dataTable; //告訴GridView資料來源為誰
BootstrapGridView.DataBind(); //綁定
}
protected void Search_btn_Click(object sender, EventArgs e)
{
string sErrMsg = string.Empty;
DataTable dataTable = new DataTable();
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_ClassInfo";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@ClassName"].Value = ClassName_txb.Text;
sqlObj.SqlCmd.Parameters["@Instructor"].Value = Instructor_txb.Text;
sqlObj.SqlCmd.Parameters["@Organizer"].Value = Organizer_txb.Text;
sqlObj.SqlCmd.Parameters["@OpenType"].Value = OpenType_ddl.SelectedValue;
sqlObj.SqlCmd.Parameters["@StartType"].Value = StartType_ddl.SelectedValue;
sqlObj.SqlCmd.Parameters["@ClassType"].Value = ClassType_ddl.SelectedValue;
sqlObj.SqlCmd.Parameters["@StartDate"].Value = StartDate_txb.Text;
sqlObj.SqlCmd.Parameters["@EndDate"].Value = EndDate_txb.Text;
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dataTable);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
BootstrapGridView1.DataSource = dataTable; //告訴GridView資料來源為誰
BootstrapGridView1.DataBind(); //綁定
}
protected void GridViewBind()
{
string sErrMsg = string.Empty;
DataTable dataTable = new DataTable();
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_ClassSub";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@ClassNo"].Value = Session["ClassNo"].ToString();
sqlObj.SqlCmd.Parameters["@Account"].Value = Session["Account"].ToString();
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dataTable);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
BootstrapGridView1.DataSource = dataTable;
BootstrapGridView1.DataBind();
}
public static string ExitVideo(string ReadTime)
{
string sErrMsg = string.Empty;
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_UI_MemberStudyRecord";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@Account"].Value = HttpContext.Current.Session["Account"].ToString();
sqlObj.SqlCmd.Parameters["@ClassNo"].Value = HttpContext.Current.Session["ClassNo"].ToString();
sqlObj.SqlCmd.Parameters["@ChapterNo"].Value = HttpContext.Current.Session["ChapterNo"].ToString();
sqlObj.SqlCmd.Parameters["@ReadTime"].Value = ReadTime;
sqlObj.SqlCmd.Parameters["@ReturnMsg"].Value = DBNull.Value;
try
{
sqlObj.SqlConn.Open();
sqlObj.SqlCmd.ExecuteNonQuery();
sErrMsg = sqlObj.SqlCmd.Parameters["@ReturnMsg"].Value.ToString();
return("success");
}
catch (Exception ex)
{
return(ex.Message);
}
finally
{
sqlObj.SqlConn.Close();
}
}
public static string InsertToOpinion(string Body)
{
DBUtility sqlObj = null;
string sErrMsg = string.Empty;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_UI_Opinion";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@Account"].Value = HttpContext.Current.Session["Account"].ToString();
sqlObj.SqlCmd.Parameters["@Body"].Value = Body;
try
{
sqlObj.SqlConn.Open();
sqlObj.SqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
sErrMsg = ex.Message;
}
finally
{
sqlObj.SqlConn.Close();
}
return(sErrMsg);
}
protected void GridViewBind()
{
string sErrMsg = string.Empty;
DataTable dt = new DataTable();
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_MemberExam";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@Account"].Value = Session["Account"].ToString();
sqlObj.SqlCmd.Parameters["@ClassNo"].Value = Session["ClassNo"].ToString();
sqlObj.SqlCmd.Parameters["@ExamPaperName"].Value = ExamPaperName_txb.Text;
sqlObj.SqlCmd.Parameters["@Pass"].Value = Pass_ddl.SelectedValue;
sqlObj.SqlCmd.Parameters["@StartDate"].Value = StartDate_txb.Text;
sqlObj.SqlCmd.Parameters["@EndDate"].Value = EndDate_txb.Text;
sqlObj.SqlCmd.Parameters["@XOLTP"].Value = 5;
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
BootstrapGridView1.DataSource = dt;
BootstrapGridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string sErrMsg = string.Empty;
DataTable dt = new DataTable();
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_News";
sqlObj.SetupSqlCommand(ref sErrMsg);
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dt);
BootstrapGridView_News.DataSource = dt;
BootstrapGridView_News.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
dt = new DataTable();
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_MemberStudyRecord";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@Account"].Value = Session["Account"].ToString();
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dt);
BootstrapGridView_Record.DataSource = dt;
BootstrapGridView_Record.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
}
public static string InsertToMember(string Account, string Password, string FirstName, string MidName,
string LastName, string Email, string Gender, string CompanyType, string CompanyName, string Division,
string Country, string Address, string Title, string Phone)
{
DBUtility sqlObj = null;
string sErrMsg = string.Empty;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_UI_Member";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@Account"].Value = Account;
sqlObj.SqlCmd.Parameters["@Password"].Value = Password;
sqlObj.SqlCmd.Parameters["@FirstName"].Value = FirstName;
sqlObj.SqlCmd.Parameters["@MidName"].Value = MidName;
sqlObj.SqlCmd.Parameters["@LastName"].Value = LastName;
sqlObj.SqlCmd.Parameters["@Email"].Value = Email;
sqlObj.SqlCmd.Parameters["@Gender"].Value = Gender;
sqlObj.SqlCmd.Parameters["@CompanyType"].Value = CompanyType;
sqlObj.SqlCmd.Parameters["@CompanyName"].Value = CompanyName;
sqlObj.SqlCmd.Parameters["@Division"].Value = Division;
sqlObj.SqlCmd.Parameters["@Country"].Value = Country;
sqlObj.SqlCmd.Parameters["@Address"].Value = Address;
sqlObj.SqlCmd.Parameters["@Title"].Value = Title;
sqlObj.SqlCmd.Parameters["@Phone"].Value = Phone;
sqlObj.SqlCmd.Parameters["@XOLTP"].Value = 0;
sqlObj.SqlCmd.Parameters["@ReturnMsg"].Value = DBNull.Value;
try
{
sqlObj.SqlConn.Open();
sqlObj.SqlCmd.ExecuteNonQuery();
sErrMsg = sqlObj.SqlCmd.Parameters["@ReturnMsg"].Value.ToString();
}
catch (Exception ex)
{
sErrMsg = "申請帳號失敗:" + ex.Message;
}
finally
{
sqlObj.SqlConn.Close();
}
if (sErrMsg.IndexOf("成功") >= 0)
{
sErrMsg = "申請帳號成功!";
}
return(sErrMsg);
}
public static string GetRecordInfo()
{
List <RecordInfo> recordInfos = new List <RecordInfo>();
string sErrMsg = string.Empty;
DataTable dt = new DataTable();
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_ClassRecord";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@ClassNo"].Value = HttpContext.Current.Session["ClassNo"].ToString();
sqlObj.SqlCmd.Parameters["@ExamID"].Value = HttpContext.Current.Session["ExamID"].ToString();
sqlObj.SqlCmd.Parameters["@Account"].Value = HttpContext.Current.Session["Account"].ToString();
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
recordInfos.Add(new RecordInfo
{
ExamName = dt.Rows[i]["ExamName"].ToString(),
ExamScore = dt.Rows[i]["ExamScore"].ToString(),
ExamPassScore = dt.Rows[i]["ExamPassScore"].ToString(),
ClassPass = dt.Rows[i]["ClassPass"].ToString(),
ExamFinishTime = dt.Rows[i]["ExamFinishTime"].ToString(),
ChapterName = dt.Rows[i]["ChapterName"].ToString(),
ReadTime = dt.Rows[i]["ReadTime"].ToString(),
PassCondition = dt.Rows[i]["PassCondition"].ToString(),
ChapterPass = dt.Rows[i]["ChapterPass"].ToString(),
LastReadTime = dt.Rows[i]["LastReadTime"].ToString(),
TotalReadTime = dt.Rows[i]["TotalReadTime"].ToString()
});
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
return(new JavaScriptSerializer().Serialize(recordInfos));
}
public static string LoginCheck(string Account, string Password)
{
DBUtility sqlObj = null;
string sErrMsg = string.Empty;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_Member";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@Account"].Value = Account;
sqlObj.SqlCmd.Parameters["@Password"].Value = Password;
sqlObj.SqlCmd.Parameters["@ReturnName"].Value = DBNull.Value;
sqlObj.SqlCmd.Parameters["@ReturnDivision"].Value = DBNull.Value;
sqlObj.SqlCmd.Parameters["@ReturnMsg"].Value = DBNull.Value;
try
{
sqlObj.SqlConn.Open();
sqlObj.SqlCmd.ExecuteNonQuery();
HttpContext.Current.Session["Account"] = Account;
HttpContext.Current.Session["MemberName"] = sqlObj.SqlCmd.Parameters["@ReturnName"].Value.ToString();
HttpContext.Current.Session["Division"] = sqlObj.SqlCmd.Parameters["@ReturnDivision"].Value.ToString();
sErrMsg = sqlObj.SqlCmd.Parameters["@ReturnMsg"].Value.ToString();
}
catch (Exception ex)
{
sErrMsg = "登入失敗:" + ex.Message;
}
finally
{
sqlObj.SqlConn.Close();
}
if (sErrMsg.IndexOf("成功") >= 0)
{
sErrMsg = "登入成功!";
}
else
{
sErrMsg = "帳號或密碼錯誤!";
}
return(sErrMsg);
}
public static string GetPassInfo()
{
List <PassInfo> PassInfos = new List <PassInfo>();
string sErrMsg = string.Empty;
DataTable dt = new DataTable();
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_ClassDetail";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@ClassNo"].Value = HttpContext.Current.Session["ClassNo"].ToString();
sqlObj.SqlCmd.Parameters["@XOLTP"].Value = 1;
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
PassInfos.Add(new PassInfo
{
ExamName = dt.Rows[i]["ExamName"].ToString(),
ExamPassScore = dt.Rows[i]["ExamPassScore"].ToString(),
ChapterName = dt.Rows[i]["ChapterName"].ToString(),
PassCondition = dt.Rows[i]["PassCondition"].ToString()
});
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
return(new JavaScriptSerializer().Serialize(PassInfos));
}
public static string ChangePassword(string OldPassword, string NewPassword)
{
DBUtility sqlObj = null;
string sErrMsg = string.Empty;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_UI_Member";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@Account"].Value = HttpContext.Current.Session["Account"].ToString();
sqlObj.SqlCmd.Parameters["@Password"].Value = OldPassword;
sqlObj.SqlCmd.Parameters["@NewPassword"].Value = NewPassword;
sqlObj.SqlCmd.Parameters["@XOLTP"].Value = 1;
sqlObj.SqlCmd.Parameters["@ReturnMsg"].Value = DBNull.Value;
try
{
sqlObj.SqlConn.Open();
sqlObj.SqlCmd.ExecuteNonQuery();
sErrMsg = sqlObj.SqlCmd.Parameters["@ReturnMsg"].Value.ToString();
}
catch (Exception ex)
{
sErrMsg = ex.Message;
}
finally
{
sqlObj.SqlConn.Close();
}
if (sErrMsg.IndexOf("成功") >= 0)
{
sErrMsg = "變更密碼成功!";
}
else if (sErrMsg.IndexOf("失敗") >= 0)
{
sErrMsg = "舊密碼錯誤!";
}
return(sErrMsg);
}
public static string GetClassInfo()
{
ClassInfo classInfo = new ClassInfo();
string sErrMsg = string.Empty;
DataTable dt = new DataTable();
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_ClassDetail";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@ClassNo"].Value = HttpContext.Current.Session["ClassNo"].ToString();
sqlObj.SqlCmd.Parameters["@XOLTP"].Value = 0;
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dt);
classInfo.ClassName = dt.Rows[0]["ClassName"].ToString();
classInfo.ClassType = dt.Rows[0]["ClassType"].ToString();
classInfo.OpenType = dt.Rows[0]["OpenType"].ToString();
classInfo.Organizer = dt.Rows[0]["Organizer"].ToString();
classInfo.Instructor = dt.Rows[0]["Instructor"].ToString();
classInfo.Date = dt.Rows[0]["Date"].ToString();
classInfo.Hours = dt.Rows[0]["Hours"].ToString();
classInfo.Fee = dt.Rows[0]["Fee"].ToString();
classInfo.Contact = dt.Rows[0]["Contact"].ToString();
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
return(new JavaScriptSerializer().Serialize(classInfo));
}
public static string CheckStudent(string ClassNo)
{
string sErrMsg = string.Empty;
DataTable dataTable = new DataTable();
DBUtility sqlObj = null;
sqlObj = new DBUtility();
sqlObj.StoreProcedureName = "SP_Qry_MemberClass";
sqlObj.SetupSqlCommand(ref sErrMsg);
sqlObj.SqlCmd.Parameters["@Account"].Value = HttpContext.Current.Session["Account"].ToString();
sqlObj.SqlCmd.Parameters["@ClassNo"].Value = ClassNo;
sqlObj.SqlCmd.Parameters["@XOLTP"].Value = 0;
try
{
sqlObj.SqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd);
da.Fill(dataTable);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlObj.SqlConn.Close();
}
if (dataTable.Rows.Count > 0)
{
return("isStudent");
}
else
{
return("notStudent");
}
}
