private void btnSave_Click(object sender, EventArgs e) { List <UDT.ScoreSheet> listInsertData = new List <UDT.ScoreSheet>(); UDT.ScoreSheet data = new UDT.ScoreSheet(); data.Acount = lbAccount.Text; data.SchoolYear = int.Parse(lbSchoolYear.Text); data.Semester = int.Parse(lbSemester.Text); data.RefPeriodID = int.Parse(this._dicPeriodByName[cbxPeriod.SelectedItem.ToString()].UID); data.RefPlaceID = int.Parse(this._dicPlaceByName[cbxPlace.SelectedItem.ToString()].UID); data.RefDeductionItemID = int.Parse(this._dicItemByName[cbxItem.SelectedItem.ToString()].UID); data.RefDeductionStandardID = int.Parse(this._dicStandardByName[cbxStandard.SelectedItem.ToString()].UID); data.Remark = tbxRemark.Text.Trim(); data.CreateTime = DateTime.Parse(dateTimeInput1.Value.ToString("yyyy/MM/dd")); data.LastUpdateName = this._userName; data.LastUpdateBy = this._userAccount; listInsertData.Add(data); try { // 新增資料 this._access.InsertValues(listInsertData); // 新增LOG string log = GetLogString(); FISCA.LogAgent.ApplicationLog.Log("整潔競賽", "新增評分紀錄", log); MsgBox.Show("資料儲存成功!"); this.DialogResult = DialogResult.Yes; this.Close(); } catch (Exception ex) { MsgBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { if (Validate()) // 資料驗證 { #region 資料整理 List <UDT.ScoreSheet> listUpdateData = this._access.Select <UDT.ScoreSheet>(string.Format("uid = {0}", this._row["uid"])); UDT.ScoreSheet data = listUpdateData[0]; string orgPeriodName = this._dicPeriodByID.ContainsKey("" + data.RefPeriodID) ? this._dicPeriodByID["" + data.RefPeriodID].Name : ""; string orgPlaceName = this._dicPlaceByID.ContainsKey("" + data.RefPlaceID) ? this._dicPlaceByID["" + data.RefPlaceID].Name : ""; string orgItemName = this._dicItemByID.ContainsKey("" + data.RefDeductionItemID) ? this._dicItemByID["" + data.RefDeductionItemID].Name : ""; string orgStandardName = this._dicStandardByID.ContainsKey("" + data.RefDeductionStandardID) ? this._dicStandardByID["" + data.RefDeductionStandardID].Name : ""; // LOG StringBuilder logs = new StringBuilder(string.Format( "管理員「{0}」修改「'{1}'時段,'{2}'位置,'{3}'扣分物件,'{4}'扣分項目,'{5}'建立日期」的評分紀錄。內容如下:" , this._userName, orgPeriodName, orgPlaceName, orgItemName, orgStandardName, data.CreateTime.ToString("yyyy/MM/dd"))); #region 評分紀錄 // 時段 if (data.RefPeriodID != int.Parse(this._dicPeriodByName[cbxPeriod.SelectedItem.ToString()].UID)) { logs.AppendLine(string.Format("\n 原時段「{0}」修改為「{1}」", orgPeriodName, cbxPeriod.SelectedItem.ToString())); data.RefPeriodID = int.Parse(this._dicPeriodByName[cbxPeriod.SelectedItem.ToString()].UID); } // 位置 if (data.RefPlaceID != int.Parse(this._dicPlaceByName[cbxPlace.SelectedItem.ToString()].UID)) { logs.AppendLine(string.Format("\n 原位置「{0}」修改為「{1}」", orgPlaceName, cbxPlace.SelectedItem.ToString())); data.RefPlaceID = int.Parse(this._dicPlaceByName[cbxPlace.SelectedItem.ToString()].UID); } // 扣分物件 if (data.RefDeductionItemID != int.Parse(this._dicItemByName[cbxItem.SelectedItem.ToString()].UID)) { logs.AppendLine(string.Format("原扣分物件「{0}」修改為「{1}」", orgItemName, cbxItem.SelectedItem.ToString())); data.RefDeductionItemID = int.Parse(this._dicItemByName[cbxItem.SelectedItem.ToString()].UID); } // 扣分項目 if (data.RefDeductionStandardID != int.Parse(this._dicStandardByName[cbxStandard.SelectedItem.ToString()].UID)) { logs.AppendLine(string.Format("原扣分項目「{0}」修改為「{1}」", orgStandardName, cbxStandard.SelectedItem.ToString())); data.RefDeductionStandardID = int.Parse(this._dicStandardByName[cbxStandard.SelectedItem.ToString()].UID); } // 備註 if (data.Remark != tbxRemark.Text.Trim()) { logs.AppendLine(string.Format("原備註「{0}」修改為「{1}」", data.Remark, tbxRemark.Text.Trim())); data.Remark = tbxRemark.Text.Trim(); } // 照片1位置 if (data.Picture1 != tbxUrl1.Text.Trim()) { logs.AppendLine(string.Format("原照片1位置「{0}」修改為「{1}」", data.Picture1, tbxUrl1.Text.Trim())); data.Picture1 = tbxUrl1.Text.Trim(); } // 照片1評論 if (data.Pic1Comment != tbxPicComment1.Text.Trim()) { logs.AppendLine(string.Format("原照片1評論「{0}」修改為「{1}」", data.Pic1Comment, tbxPicComment1.Text.Trim())); data.Pic1Comment = tbxPicComment1.Text.Trim(); } // 照片2位置 if (data.Picture2 != tbxUrl2.Text.Trim()) { logs.AppendLine(string.Format("原照片2評論「{0}」修改為「{1}」", data.Picture2, tbxUrl2.Text.Trim())); data.Picture2 = tbxUrl2.Text.Trim(); } // 照片2評論 if (data.Pic2Comment != tbxPicComment2.Text.Trim()) { logs.AppendLine(string.Format("原照片2評論「{0}」修改為「{1}」", data.Pic2Comment, tbxPicComment2.Text.Trim())); data.Pic2Comment = tbxPicComment2.Text.Trim(); } #endregion #region 查核 if (data.CheckedName != tbxCheckName.Text.Trim()) { logs.AppendLine(string.Format("原查核者「{0}」變更為「{1}」", data.CheckedName, tbxCheckName.Text.Trim())); data.CheckedName = tbxCheckName.Text.Trim(); } if (data.CheckedBy != tbxCheckAccount.Text.Trim()) { logs.AppendLine(string.Format("原查核者帳號「{0}」變更為「{1}」", data.CheckedBy, tbxCheckAccount.Text.Trim())); data.CheckedBy = tbxCheckAccount.Text.Trim(); } if (data.CheckedTime.ToString("yyyy/MM/dd hh:mm") != lbCheckTime.Text.Trim()) { logs.AppendLine(string.Format("原查核時間「{0}」變更為「{1}」", (data.CheckedTime.ToString("yyyy/MM/dd") == "0001/01/01") ? "" : data.CheckedTime.ToString("yyyy/MM/dd hh:mm"), lbCheckTime.Text.Trim())); data.CheckedTime = (lbCheckTime.Text.Trim() == "") ? new DateTime() : DateTime.Parse(lbCheckTime.Text.Trim()); } #endregion #region 取消 if (data.IsCanceled != ckbxCancel.Checked) { logs.AppendLine(string.Format("取消此評分紀錄「{0}」變更為「{1}」", data.IsCanceled == true ? "是" : "否", ckbxCancel.Checked == true ? "是" : "否")); data.IsCanceled = ckbxCancel.Checked; } if (data.CanceledName != tbxCancelName.Text.Trim()) { logs.AppendLine(string.Format("原取消者「{0}」變更為「{1}」", data.CanceledName, tbxCancelName.Text.Trim())); data.CanceledName = tbxCancelName.Text.Trim(); } if (data.CanceledBy != tbxCancelAccount.Text.Trim()) { logs.AppendLine(string.Format("原取消者帳號「{0}」變更為「{1}」", data.CanceledBy, tbxCancelAccount.Text.Trim())); data.CanceledBy = tbxCancelAccount.Text.Trim(); } if (data.CanceledReason != tbxCancelReason.Text.Trim()) { logs.AppendLine(string.Format("原取消原因「{0}」變更為「{1}」", data.CanceledReason, tbxCancelReason.Text.Trim())); data.CanceledReason = tbxCancelReason.Text.Trim(); } if (data.CanceledTime.ToString("yyyy/MM/dd hh:mm") != lbCancelTime.Text.Trim()) { logs.AppendLine(string.Format("原取消時間「{0}」變更為「{1}」", (data.CanceledTime.ToString("yyyy/MM/dd") == "0001/01/01") ? "" : data.CanceledTime.ToString("yyyy/MM/dd hh:mm"), lbCancelTime.Text.Trim())); data.CanceledTime = lbCancelTime.Text.Trim() == "" ? new DateTime() : DateTime.Parse(lbCancelTime.Text.Trim()); } #endregion #region 修改者資料 if (data.LastUpdateName != tbxUpdateName.Text.Trim()) { logs.AppendLine(string.Format("原修改者「{0}」變更為「{1}」", data.LastUpdateName, tbxUpdateName.Text.Trim())); data.LastUpdateName = tbxUpdateName.Text.Trim(); } if (data.LastUpdateBy != tbxUpdateBy.Text.Trim()) { logs.AppendLine(string.Format("原修改者帳號「{0}」變更為「{1}」", data.LastUpdateBy, tbxUpdateBy.Text.Trim())); data.LastUpdateBy = tbxUpdateBy.Text.Trim(); } if (data.LastUpdateTime != DateTime.Parse(lbUpdateTime.Text.Trim())) { logs.AppendLine(string.Format("原修改者時間「{0}」變更為「{1}」", (data.LastUpdateTime.ToString("yyyy/MM/dd") == "0001/01/01") ? "" : data.LastUpdateTime.ToString("yyyy/MM/dd hh:mm"), lbUpdateTime.Text.Trim())); data.LastUpdateTime = (lbUpdateTime.Text.Trim() == "") ? new DateTime() : DateTime.Parse(lbUpdateTime.Text.Trim()); } #endregion #endregion // 資料儲存 try { this._access.UpdateValues(listUpdateData); FISCA.LogAgent.ApplicationLog.Log("整潔競賽", "修改評分紀錄", logs.ToString()); MsgBox.Show("資料更新成功!"); this.DialogResult = DialogResult.Yes; this.Close(); } catch (Exception ex) { MsgBox.Show(ex.Message); } } }