// 修改異動紀錄
private void EditStudentUpdateRecord()
{
JHSchool.Data.JHUpdateRecordRecord objUpdate = lstRecord.SelectedItems[0].Tag as JHSchool.Data.JHUpdateRecordRecord;
DAL.StudUpdateRecordEntity sure = DAL.DALTransfer2.SetStudUpdateRecordEntityTrans(objUpdate);
UpdateRecordItemForm form = new UpdateRecordItemForm(UpdateRecordItemForm.actMode.修改, sure, PrimaryKey);
form.ShowDialog();
}
private void btnAdd_Click(object sender, EventArgs e)
{
DAL.StudUpdateRecordEntity sure = DAL.DALTransfer2.AddStudUpdateRecordEntity(PrimaryKey, JHPermrec.UpdateRecord.DAL.DALTransfer2.UpdateType.Empty, DateTime.Now.ToShortDateString());
if (sure == null)
{
return;
}
UpdateRecordItemForm form = new UpdateRecordItemForm(UpdateRecordItemForm.actMode.新增, sure, PrimaryKey);
form.ShowDialog();
}
private void btnUpload_Click(object sender, EventArgs e)
{
IUpdateRecordInfo IU;
if (UpdateRecordEditorPanle.Controls.Count > 0)
{
IU = UpdateRecordEditorPanle.Controls[0] as IUpdateRecordInfo;
_StudUpdateRecordEntity = IU.GetStudUpdateRecordData();
}
string _base64Data = "";
string _FileName = "";
Guid g = Guid.NewGuid();
string DSNS = FISCA.Authentication.DSAServices.AccessPoint;
OpenFileDialog ofd = new OpenFileDialog();
if (ofd.ShowDialog() == DialogResult.OK)
{
// 取得檔案
_FileName = g.ToString() + ofd.SafeFileName;
_StudUpdateRecordEntity.SetComment("https://storage.googleapis.com/1campus-photo/j.kh.edu.tw/" + DSNS + "/upload_" + _FileName);
//txtEDoc.Text = "https://storage.googleapis.com/1campus-photo/j.kh.edu.tw/" + DSNS + "/upload_" + _FileName;
// 轉 Base64
try
{
MemoryStream ms = new MemoryStream();
ofd.OpenFile().CopyTo(ms);
_base64Data = Convert.ToBase64String(ms.ToArray());
if (_FileName != "" && _base64Data != "")
{
UpdateRecordUtil.UploadFile(_StudUpdateRecordEntity.StudentID, _base64Data, _FileName);
}
// 上傳後儲存
SaveData();
MsgBox.Show("上傳檔案完成");
this.Close();
}
catch (Exception ex)
{
FISCA.Presentation.Controls.MsgBox.Show("讀取上傳檔案失敗," + ex.Message);
}
}
}
public UpdateRecordItemForm(actMode mode, DAL.StudUpdateRecordEntity StudUdRecEnty, string _RunningID)
{
InitializeComponent();
// 判斷上傳檔案功能只有高雄使用
if (JHSchool.Permrec.Program.ModuleType == JHSchool.Permrec.Program.ModuleFlag.KaoHsiung)
{
btnUpload.Visible = true;
}
else
{
btnUpload.Visible = false;
}
if (Framework.User.Acl[GetType()].Editable)
{
btnConfirm.Enabled = true;
}
else
{
btnConfirm.Enabled = false;
}
_StudUpdateRecordEntity = StudUdRecEnty;
prlp = new JHSchool.PermRecLogProcess();
RunningID = _RunningID;
// 先將畫面學年度、學期、年級設空
intSchoolYear.IsEmpty = true;
intSemester.IsEmpty = true;
intGradeYear.IsEmpty = true;
if (mode == actMode.新增)
{
cbxSel.Enabled = true;
foreach (DAL.DALTransfer2.UpdateType ut in DAL.DALTransfer2.CheckCanInputUpdateType)
{
cbxSel.Items.Add(ut.ToString());
}
cbxSel.SelectedIndex = 0;
SetDefaultSchoolYearSemester();
// 加入 log
prlp.SetAction("新增");
}
if (mode == actMode.修改)
{
cbxSel.Enabled = false;
UpdateRecordEditorPanle.Controls.Clear();
UpdateRecordEditorPanle.Controls.Add(CreateByUpdateCode());
// 加入 log
prlp.SetAction("修改");
}
// 加入 log
prlp.SetBeforeSaveText("學年度", intSchoolYear.Text);
prlp.SetBeforeSaveText("學期", intSemester.Text);
}
private void btnConfirm_Click(object sender, EventArgs e)
{
IUpdateRecordInfo IU;
if (UpdateRecordEditorPanle.Controls.Count > 0)
{
IU = UpdateRecordEditorPanle.Controls[0] as IUpdateRecordInfo;
_StudUpdateRecordEntity = IU.GetStudUpdateRecordData();
}
// 當新增時才處理
if (cbxSel.Enabled)
{
if (cbxSel.Text == "新生")
{
bool checkSameUpdateCode1 = DAL.DALTransfer2.checkStudentSameUpdateCode(RunningID, _StudUpdateRecordEntity, "1");
if (checkSameUpdateCode1)
{
MsgBox.Show("已有1筆新生異動，請刪除後再新增");
return;
}
}
if (cbxSel.Text == "畢業")
{
bool checkSameUpdateCode2 = DAL.DALTransfer2.checkStudentSameUpdateCode(RunningID, _StudUpdateRecordEntity, "2");
if (checkSameUpdateCode2)
{
MsgBox.Show("已有1筆畢業異動，請刪除後再新增");
return;
}
}
// 檢查同一天是否有相同異動
bool checkSameUpdateDateAndCode = false;
checkSameUpdateDateAndCode = DAL.DALTransfer2.checkStudentSameUpdateCode(RunningID, _StudUpdateRecordEntity);
if (checkSameUpdateDateAndCode)
{
if (MsgBox.Show("此異動日期已有相同異動，請問是否新增?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
}
}
// 儲存學年度學期 年級
_StudUpdateRecordEntity.SchoolYear = intSchoolYear.Value;
_StudUpdateRecordEntity.Semester = intSemester.Value;
_StudUpdateRecordEntity.SetGradeYear(intGradeYear.Text);
// 儲存異動資料
DAL.DALTransfer2.SetStudUpdateRecordEntity(_StudUpdateRecordEntity);
// Log
string strItemName = "學生姓名:" + JHSchool.Data.JHStudent.SelectByID(RunningID).Name + "," + prlp.GetAction() + ":";
if (_StudUpdateRecordEntity.checkSameUpdateCode("1"))
{
strItemName += "新生異動";
}
if (_StudUpdateRecordEntity.checkSameUpdateCode("2"))
{
strItemName += "畢業異動";
}
if (_StudUpdateRecordEntity.checkSameUpdateCode("3"))
{
strItemName += "轉入異動";
}
if (_StudUpdateRecordEntity.checkSameUpdateCode("4"))
{
strItemName += "轉出異動";
}
if (_StudUpdateRecordEntity.checkSameUpdateCode("5"))
{
strItemName += "休學異動";
}
if (_StudUpdateRecordEntity.checkSameUpdateCode("6"))
{
strItemName += "復學異動";
}
if (_StudUpdateRecordEntity.checkSameUpdateCode("7"))
{
strItemName += "中輟異動";
}
if (_StudUpdateRecordEntity.checkSameUpdateCode("8"))
{
strItemName += "續讀異動";
}
if (_StudUpdateRecordEntity.checkSameUpdateCode("9"))
{
strItemName += "更正學籍異動";
}
if (_StudUpdateRecordEntity.checkSameUpdateCode("10"))
{
strItemName += "延長修業年限";
}
if (_StudUpdateRecordEntity.checkSameUpdateCode("11"))
{
strItemName += "死亡";
}
prlp.SetActionBy("學生", strItemName);
prlp.SaveLog("", ":", "student", RunningID);
JHSchool.Data.JHStudentRecord studRec = JHSchool.Data.JHStudent.SelectByID(RunningID);
bool checkUpdateStudStatus = false;
List <string> tmpList0 = new List <string>();
List <string> tmpList1 = new List <string>();
List <string> tmpList2 = new List <string>();
List <string> tmpList3 = new List <string>();
foreach (JHSchool.Data.JHStudentRecord stud in JHSchool.Data.JHStudent.SelectAll())
{
if (stud.Status == K12.Data.StudentRecord.StudentStatus.一般)
{
tmpList0.Add(stud.IDNumber);
}
if (stud.Status == K12.Data.StudentRecord.StudentStatus.畢業或離校)
{
tmpList1.Add(stud.IDNumber);
}
if (stud.Status == K12.Data.StudentRecord.StudentStatus.休學)
{
tmpList2.Add(stud.IDNumber);
}
if (stud.Status == K12.Data.StudentRecord.StudentStatus.輟學)
{
tmpList3.Add(stud.IDNumber);
}
}
// 轉出
if (_StudUpdateRecordEntity.checkSameUpdateCode("4") || _StudUpdateRecordEntity.checkSameUpdateCode("11"))
{
if (MessageBox.Show("請問是否更改學生狀態成 離校？", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
if (tmpList1.Contains(studRec.IDNumber))
{
MsgBox.Show("學生狀態 離校 有重複身分證號,請檢查後變更.");
return;
}
studRec.Status = JHSchool.Data.JHStudentRecord.StudentStatus.畢業或離校;
checkUpdateStudStatus = true;
strItemName += ",更改學生狀態成 離校";
}
}
// 休學
if (_StudUpdateRecordEntity.checkSameUpdateCode("5"))
{
if (MessageBox.Show("請問是否更改學生狀態成 休學？", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
if (tmpList2.Contains(studRec.IDNumber))
{
MsgBox.Show("學生狀態 休學 有重複身分證號,請檢查後變更.");
return;
}
studRec.Status = JHSchool.Data.JHStudentRecord.StudentStatus.休學;
checkUpdateStudStatus = true;
strItemName += "更改學生狀態成 休學";
}
}
// 中輟
if (_StudUpdateRecordEntity.checkSameUpdateCode("7"))
{
if (MessageBox.Show("請問是否更改學生狀態成 輟學？", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
if (tmpList3.Contains(studRec.IDNumber))
{
MsgBox.Show("學生狀態 輟學 有重複身分證號,請檢查後變更.");
return;
}
studRec.Status = JHSchool.Data.JHStudentRecord.StudentStatus.輟學;
checkUpdateStudStatus = true;
strItemName += "更改學生狀態成 輟學";
}
}
// 處理復學轉成一般
if (_StudUpdateRecordEntity.checkSameUpdateCode("6"))
{
if (MessageBox.Show("請問是否更改學生狀態成 一般？", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
if (tmpList0.Contains(studRec.IDNumber))
{
MsgBox.Show("學生狀態 一般 有重複身分證號,請檢查後變更.");
return;
}
studRec.Status = JHSchool.Data.JHStudentRecord.StudentStatus.一般;
checkUpdateStudStatus = true;
strItemName += "更改學生狀態成 一般";
}
}
// prlp.SaveLog("學生.異動資料", prlp.GetAction(),"學生",RunningID , strItemName);
if (checkUpdateStudStatus)
{
JHSchool.Data.JHStudent.Update(studRec);
JHSchool.Student.Instance.SyncDataBackground(RunningID);
}
JHSchool.Permrec.UpdateRecord.Instance.SyncAllBackground();
JHSchool.Student.Instance.SyncDataBackground(RunningID);
prlp = null;
}
