private void InitializeDateRange()
{
#region 日期定義
K12.Data.Configuration.ConfigData DateConfig = K12.Data.School.Configuration["Attendance_BatchEditor"];
string date = DateConfig["MutiEditor"];
if (date == "")
{
DSXmlHelper helper = new DSXmlHelper("xml");
helper.AddElement("Date");
helper.AddText("Date", DateTime.Today.ToShortDateString());
helper.AddElement("Locked");
helper.AddText("Locked", "false");
date = helper.BaseElement.OuterXml;
DateConfig["MutiEditor"] = date;
DateConfig.Save(); //儲存此預設檔
}
XmlElement loadXml = DSXmlHelper.LoadXml(date);
checkBoxX1.Checked = bool.Parse(loadXml.SelectSingleNode("Locked").InnerText);
if (checkBoxX1.Checked) //如果是鎖定,就取鎖定日期
{
dateTimeInput1.Text = loadXml.SelectSingleNode("Date").InnerText;
}
else //如果沒有鎖定,就取當天
{
dateTimeInput1.Text = DateTime.Today.ToShortDateString();
}
_currentDate = dateTimeInput1.Value;
#endregion
}
/// <summary>
/// 取得學生類別字串
/// </summary>
public string GetSY(GraduateUDT udt)
{
//如果此學生有類別資訊
if (TagDic.ContainsKey(udt.StudentID))
{
DSXmlHelper helper = new DSXmlHelper("TagList");
foreach (StudentTagRecord each in TagDic[udt.StudentID])
{
//each.FullName; //完整名稱
//each.Prefix; //前置詞
//each.Name; //標籤名稱
//<Tag FullName="" Prefix="" Name="">
helper.AddElement("Tag");
helper.SetAttribute("Tag", "Prefix", each.Prefix); //前置詞
helper.SetAttribute("Tag", "Name", each.Name); //前置詞
helper.AddText("Tag", each.FullName); //前置詞
}
return(helper.BaseElement.OuterXml);
}
return("");
}
private void SaveDateSetting()
{
#region 儲存日期資料
K12.Data.Configuration.ConfigData DateConfig = K12.Data.School.Configuration["Attendance_BatchEditor"];
DSXmlHelper helper = new DSXmlHelper("xml");
helper.AddElement("Date");
helper.AddText("Date", dateTimeInput1.Value.ToShortDateString());
helper.AddElement("Locked");
helper.AddText("Locked", checkBoxX1.Checked.ToString());
DateConfig["MutiEditor"] = helper.BaseElement.OuterXml;
DateConfig.Save(); //儲存此預設檔
#endregion
}
/// <summary>
/// 取得XML結構之科別清單狀態
/// </summary>
public string GetDeptXML(string Dept)
{
if (!string.IsNullOrEmpty(Dept))
{
string[] DeptList = Dept.Split('/');
DSXmlHelper dsXml = new DSXmlHelper("Department");
foreach (string each in DeptList)
{
dsXml.AddElement("Dept");
dsXml.AddText("Dept", each);
}
return(dsXml.BaseElement.OuterXml);
}
else
{
DSXmlHelper dsXml = new DSXmlHelper("Department");
return(dsXml.BaseElement.OuterXml);
}
}
private void btnQueryPoint_Click(object sender, EventArgs e)
{
try
{
DSXmlHelper h = new DSXmlHelper("Request");
string address = cboCounty.GetText() + cboTown.GetText() + txtDistrict.Text + txtArea.Text + txtDetail.Text;
h.AddText(".", address);
DSResponse rsp = FISCA.Authentication.DSAServices.CallService("SmartSchool.Common.QueryCoordinates", new DSRequest(h));
h = rsp.GetContent();
if (h.GetElement("Error") != null)
{
MsgBox.Show("無法查詢此地址座標相關資訊");
}
else
{
string latitude = h.GetText("Latitude");
string longitude = h.GetText("Longitude");
if (!string.IsNullOrEmpty(txtLatitude.Text) || !string.IsNullOrEmpty(txtLongtitude.Text))
{
string msg = "已查詢出此地址座標為：\n\n(" + longitude + "," + latitude + ")\n\n要取代目前座標設定嗎？";
if (MsgBox.Show(msg, Application.ProductName, MessageBoxButtons.YesNo) == DialogResult.Yes)
{
txtLatitude.Text = latitude;
txtLongtitude.Text = longitude;
}
}
else
{
txtLatitude.Text = latitude;
txtLongtitude.Text = longitude;
}
}
}
catch (Exception ex)
{
MsgBox.Show("查詢座標資訊錯誤。");
Diagnostic.FeedbackError(ex, "地址資料項目的查詢座標資訊。");
}
}
/// <summary>
/// 取得XML結構之科別清單狀態
/// </summary>
public string GetDeptXML(string Dept)
{
if (!string.IsNullOrEmpty(Dept))
{
string[] DeptList = Dept.Split('/');
DSXmlHelper dsXml = new DSXmlHelper("Department");
foreach (string each in DeptList)
{
dsXml.AddElement("Dept");
dsXml.AddText("Dept", each);
}
return dsXml.BaseElement.OuterXml;
}
else
{
DSXmlHelper dsXml = new DSXmlHelper("Department");
return dsXml.BaseElement.OuterXml;
}
}
private void GetChengeObj()
{
//人數限制
if (!string.IsNullOrEmpty(tbGrade1Limit.Text.Trim())) //一年級人限
{
ClubPrimary.Grade1Limit = tool.StringIsInt_DefIsZero(tbGrade1Limit.Text.Trim());
}
else
{
ClubPrimary.Grade1Limit = null;
}
if (!string.IsNullOrEmpty(tbGrade2Limit.Text.Trim())) //二年級人限
{
ClubPrimary.Grade2Limit = tool.StringIsInt_DefIsZero(tbGrade2Limit.Text.Trim());
}
else
{
ClubPrimary.Grade2Limit = null;
}
if (!string.IsNullOrEmpty(tbGrade3Limit.Text.Trim())) //三年級人限
{
ClubPrimary.Grade3Limit = tool.StringIsInt_DefIsZero(tbGrade3Limit.Text.Trim());
}
else
{
ClubPrimary.Grade3Limit = null;
}
if (!string.IsNullOrEmpty(tbLimit.Text.Trim())) //人數上限
{
ClubPrimary.Limit = tool.StringIsInt_DefIsZero(tbLimit.Text.Trim());
}
else
{
ClubPrimary.Limit = null;
}
//性別限制
if (cbGenderRestrict.SelectedItem != null) //男女限制
{
string res = cbGenderRestrict.GetItemText(cbGenderRestrict.SelectedItem);
if (res == "")
{
ClubPrimary.GenderRestrict = "";
}
else
{
ClubPrimary.GenderRestrict = res;
}
}
//科別限制
DSXmlHelper dsXml = new DSXmlHelper("Department");
foreach (ListViewItem each in listDepartment.Items)
{
if (each.Checked)
{
dsXml.AddElement("Dept");
dsXml.AddText("Dept", each.Text);
}
}
ClubPrimary.DeptRestrict = dsXml.BaseElement.OuterXml;
}
private CLUBRecord GetClub()
{
CLUBRecord club = new CLUBRecord();
club.ClubName = txtClubName.Text.Trim(); //社團名稱
club.SchoolYear = intSchoolYear.Value; //學年度
club.Semester = intSemester.Value; //學期
club.ClubCategory = cbCategory.Text.Trim(); //類型
club.ClubNumber = tbClubNumber.Text.Trim(); //類型
if (!string.IsNullOrEmpty(tbGrade1Limit.Text.Trim())) //一年級人限
{
club.Grade1Limit = tool.StringIsInt_DefIsZero(tbGrade1Limit.Text.Trim());
}
if (!string.IsNullOrEmpty(tbGrade2Limit.Text.Trim())) //二年級人限
{
club.Grade2Limit = tool.StringIsInt_DefIsZero(tbGrade2Limit.Text.Trim());
}
if (!string.IsNullOrEmpty(tbGrade3Limit.Text.Trim())) //三年級人限
{
club.Grade3Limit = tool.StringIsInt_DefIsZero(tbGrade3Limit.Text.Trim());
}
if (!string.IsNullOrEmpty(tbLimit.Text.Trim())) //三年級人限
{
club.Limit = tool.StringIsInt_DefIsZero(tbLimit.Text.Trim());
}
if (cbGenderRestrict.SelectedItem != null) //男女限制
{
string res = cbGenderRestrict.GetItemText(cbGenderRestrict.SelectedItem);
club.GenderRestrict = res;
}
//社團老師
if (cbTeacher.SelectedItem != null)
{
TeacherObj cbi = (TeacherObj)cbTeacher.SelectedItem;
club.RefTeacherID = cbi.TeacherID;
}
if (cbTeacher2.SelectedItem != null)
{
TeacherObj cbi = (TeacherObj)cbTeacher2.SelectedItem;
club.RefTeacherID2 = cbi.TeacherID;
}
if (cbTeacher3.SelectedItem != null)
{
TeacherObj cbi = (TeacherObj)cbTeacher3.SelectedItem;
club.RefTeacherID3 = cbi.TeacherID;
}
//社團場地
if (!string.IsNullOrEmpty(cbLocation.Text.Trim()))
{
club.Location = cbLocation.Text.Trim();
}
//社團限制 - 科別
DSXmlHelper dsXml = new DSXmlHelper("Department");
foreach (ListViewItem each in listDepartment.Items)
{
if (each.Checked)
{
dsXml.AddElement("Dept");
dsXml.AddText("Dept", each.Text);
}
}
club.DeptRestrict = dsXml.BaseElement.OuterXml;
club.About = tbAboutClub.Text.Trim(); //簡介
return(club);
}
public BatchAddressLatitudeManager(List <string> StudIDList, AddressTye at)
{
_AddressType = at;
_StudAddressRecDic = new Dictionary <string, JHAddressRecord>();
foreach (JHAddressRecord addRec in JHAddress.SelectByStudentIDs(StudIDList))
{
if (!_StudAddressRecDic.ContainsKey(addRec.RefStudentID))
{
_StudAddressRecDic.Add(addRec.RefStudentID, addRec);
}
}
foreach (KeyValuePair <string, JHAddressRecord> studAddRec in _StudAddressRecDic)
{
string Address = "", latitude = "", longitude = "";
if (_AddressType == AddressTye.Permanent)
{
Address = studAddRec.Value.Permanent.County + studAddRec.Value.Permanent.Town + studAddRec.Value.Permanent.District + studAddRec.Value.Permanent.Area + studAddRec.Value.Permanent.Detail;
}
if (_AddressType == AddressTye.Mailing)
{
Address = studAddRec.Value.Mailing.County + studAddRec.Value.Mailing.Town + studAddRec.Value.Mailing.District + studAddRec.Value.Mailing.Area + studAddRec.Value.Mailing.Detail;
}
if (_AddressType == AddressTye.Address1)
{
Address = studAddRec.Value.Address1.County + studAddRec.Value.Address1.Town + studAddRec.Value.Address1.District + studAddRec.Value.Address1.Area + studAddRec.Value.Address1.Detail;
}
try
{
DSXmlHelper h = new DSXmlHelper("Request");
h.AddText(".", Address);
DSResponse rsp = FISCA.Authentication.DSAServices.CallService("SmartSchool.Common.QueryCoordinates", new DSRequest(h));
h = rsp.GetContent();
if (h.GetElement("Error") == null)
{
latitude = h.GetText("Latitude");
longitude = h.GetText("Longitude");
}
}
catch (Exception ex)
{
}
// 回寫經緯度
if (_AddressType == AddressTye.Permanent)
{
studAddRec.Value.Permanent.Latitude = latitude;
studAddRec.Value.Permanent.Longitude = longitude;
}
if (_AddressType == AddressTye.Mailing)
{
studAddRec.Value.Mailing.Latitude = latitude;
studAddRec.Value.Mailing.Longitude = longitude;
}
if (_AddressType == AddressTye.Address1)
{
studAddRec.Value.Address1.Latitude = latitude;
studAddRec.Value.Address1.Longitude = longitude;
}
}
// 更新 DAL
List <JHAddressRecord> addRecList = new List <JHAddressRecord>();
foreach (JHAddressRecord addrec in _StudAddressRecDic.Values)
{
addRecList.Add(addrec);
}
JHAddress.Update(addRecList);
}
private void btnQueryPoint_Click(object sender, EventArgs e)
{
try
{
DSXmlHelper h = new DSXmlHelper("Request");
string address = cboCounty.GetText() + cboTown.GetText() + txtDistrict.Text + txtArea.Text + txtDetail.Text;
h.AddText(".", address);
DSResponse rsp = FISCA.Authentication.DSAServices.CallService("SmartSchool.Common.QueryCoordinates", new DSRequest(h));
h = rsp.GetContent();
if (h.GetElement("Error") != null)
MsgBox.Show("�L�k�d�ߦ��a�}�y�Ь�����T");
else
{
string latitude = h.GetText("Latitude");
string longitude = h.GetText("Longitude");
if (!string.IsNullOrEmpty(txtLatitude.Text) || !string.IsNullOrEmpty(txtLongtitude.Text))
{
string msg = "�w�d�ߥX���a�}�y�Ь��G\n\n(" + longitude + "," + latitude + ")\n\n�n���N�ثe�y�г]�w�ܡH";
if (MsgBox.Show(msg, Application.ProductName, MessageBoxButtons.YesNo) == DialogResult.Yes)
{
txtLatitude.Text = latitude;
txtLongtitude.Text = longitude;
}
}
else
{
txtLatitude.Text = latitude;
txtLongtitude.Text = longitude;
}
}
}
catch (Exception)
{
MsgBox.Show("�d�߮y�и�T���~�C");
//Diagnostic.FeedbackError(ex, "�a�}��ƶ��ت��d�߮y�и�T�C");
}
}