Example #1
0
 // 新增一筆rationale
 public bool AddRationale(string CaseID, string ClinicNum, string SectionName, string SelectionID, string Content)
 {
     query = "Insert Into RationaleForExam Values('" + CaseID + "'," + ClinicNum + ",'" + SectionName + "','" + SelectionID + "','" + Content + "')";
     try
     {
         mydb.ExecuteNonQuery(query);
         return(true);
     }
     catch
     {
         return(false);
     }
 }
Example #2
0
    void btnFinish_ServerClick(object sender, EventArgs e)
    {
        //呼叫寫入Paper_AssignedQuestion的函式
        string strSQL = "";

        if (rbClass.Checked == true)
        {
            strSQL = "SELECT DISTINCT cUserID FROM HintsUser WHERE cClass = '" + dlClass1.SelectedItem.Value + "' ";
        }
        else
        {
            strSQL = "SELECT DISTINCT cUserID FROM UserGroup WHERE cGroup = '" + dlGroup.SelectedItem.Value + "' ";
        }

        Hints.Learning.Question.QuestionUtility myUtility = new Hints.Learning.Question.QuestionUtility();
        Hints.DB.clsHintsDB myDB = new Hints.DB.clsHintsDB();
        DataTable           dt   = myDB.getDataSet(strSQL).Tables[0];

        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string strUserID = dt.Rows[i]["cUserID"].ToString();

                //確認此問卷是不是有資料存在Paper_AssignedQuestion,如果沒有則寫入資料。
                bool bCheck = Hints.Learning.Question.DataReceiver.checkUserDataFromPaper_AssignedQuestion(usi.PaperID, "00000000000000", strUserID);
                if (bCheck == false)
                {
                    myUtility.setupPaper_AssignedQuestionByPaperIDStartTimeUserID(usi.PaperID, "00000000000000", strUserID);
                }
            }
        }

        //將指派測驗的日期和對象記錄在OnlineQuiz_Assign
        string StartTime     = TransferDateFormat(tb_StartTime, ddl_StartHr, ddl_StartMin);
        string EndTime       = TransferDateFormat(tb_EndTime, ddl_EndHr, ddl_EndMin);
        string SelectedValue = "";

        if (rbClass.Checked == true)
        {
            SelectedValue = dlClass1.SelectedItem.Value;
            strSQL        = "INSERT INTO OnlineQuiz_Assign VALUES ('" + usi.CaseID + "','" + usi.PaperID + "','" + StartTime + "','" + EndTime + "','" + SelectedValue + "','class',0)";
        }
        else
        {
            SelectedValue = dlGroup.SelectedItem.Value;
            strSQL        = "INSERT INTO OnlineQuiz_Assign VALUES ('" + usi.CaseID + "','" + usi.PaperID + "','" + StartTime + "','" + EndTime + "','" + SelectedValue + "','group',0)";
        }
        try
        {
            myDB.ExecuteNonQuery(strSQL);
        }
        catch
        { }

        string strScript = "<script language='javascript'>\n";

        strScript += "closeWindow();\n";
        strScript += "</script>\n";
        Page.RegisterStartupScript("closeWindow", strScript);
    }