private string GetLogString(UDT.ScoreSheet ss) { StringBuilder logs = new StringBuilder(); logs.AppendLine(string.Format("管理員「{0}」新增評分紀錄:\n 違規班級「{1}」\n 評分時段「{2}」 評分項目「{3}」\n 違規之座號「{4}」 違規之座標「{5}」\n 評分加減分「{6}」 \n 補充說明「{7}」\n 建立日期「{8}」" , this._userName, cbxClass.SelectedItem.ToString(), cbxPeriod.SelectedItem.ToString(), cbxCheckItem.SelectedItem.ToString(), tbxSeatNo.Text, tbxCoordinate.Text, cbxScore.SelectedItem.ToString(), tbxRemark.Text, dateTimeInput1.Value.ToString("yyyy/MM/dd HH:MM"))); return(logs.ToString()); }
private void btnSave_Click(object sender, EventArgs e) { if (Validate()) { List <UDT.ScoreSheet> listInsertData = new List <UDT.ScoreSheet>(); // 資料整理 UDT.ScoreSheet ss = new UDT.ScoreSheet(); ss.Account = lbAccount.Text; ss.RefCheckItemID = int.Parse(this._dicCheckItemBYName[cbxCheckItem.SelectedItem.ToString()].UID); ss.RefClassID = int.Parse(this._dicClassIDBYName[cbxClass.SelectedItem.ToString()]); ss.SeatNo = tbxSeatNo.Text; ss.Coordinate = tbxCoordinate.Text; ss.Remark = tbxRemark.Text; ss.CreateTime = dateTimeInput1.Value; ss.ScoreLastUpdate = dateTimeInput1.Value; ss.Score = int.Parse(cbxScore.SelectedItem.ToString()); ss.SchoolYear = int.Parse(School.DefaultSchoolYear); ss.Semester = int.Parse(School.DefaultSemester); listInsertData.Add(ss); string log = GetLogString(ss); // 寫入資料庫 try { this._access.InsertValues(listInsertData); FISCA.LogAgent.ApplicationLog.Log("秩序競賽", "新增評分紀錄", log); MsgBox.Show("儲存成功!"); this.Close(); } catch (Exception ex) { MsgBox.Show(ex.Message); } } }