public static System.Data.DataTable TransDTOToTable(Dictionary<string, Model.DTO.UKHandleQuanDetail> ukQuanList) { Model.DTO.UKHandleQuanDetail ukQuan = new Model.DTO.UKHandleQuanDetail(); System.Data.DataTable dt = new System.Data.DataTable(); //初始化列 //ID System.Data.DataColumn col = new System.Data.DataColumn(); col.Caption = "ID"; col.ColumnName = "ID"; dt.Columns.Add(col); //合同编号 col = new System.Data.DataColumn(); col.Caption = "合同编号"; col.ColumnName = "ContractNum"; dt.Columns.Add(col); //学生姓名 col = new System.Data.DataColumn(); col.Caption = "学生姓名"; col.ColumnName = "StudentName"; dt.Columns.Add(col); //院校名称 col = new System.Data.DataColumn(); col.Caption = "院校名称"; col.ColumnName = "University"; dt.Columns.Add(col); //申请类别 col = new System.Data.DataColumn(); col.Caption = "申请类别"; col.ColumnName = "ApplicationType"; dt.Columns.Add(col); //网申 col = new System.Data.DataColumn(); col.Caption = "网申"; col.ColumnName = "Online"; dt.Columns.Add(col); //套磁 col = new System.Data.DataColumn(); col.Caption = "套磁"; col.ColumnName = "Megnetic"; dt.Columns.Add(col); //文书 col = new System.Data.DataColumn(); col.Caption = "文书"; col.ColumnName = "PS"; dt.Columns.Add(col); //录取 col = new System.Data.DataColumn(); col.Caption = "录取"; col.ColumnName = "Admission"; dt.Columns.Add(col); //资深文案 col = new System.Data.DataColumn(); col.Caption = "资深文案"; col.ColumnName = "Senior"; dt.Columns.Add(col); //制作文案 col = new System.Data.DataColumn(); col.Caption = "制作文案"; col.ColumnName = "Author"; dt.Columns.Add(col); //文书文案 col = new System.Data.DataColumn(); col.Caption = "文书文案"; col.ColumnName = "PSAuthor"; dt.Columns.Add(col); //文书部门 col = new System.Data.DataColumn(); col.Caption = "文书部门"; col.ColumnName = "PSDepartment"; dt.Columns.Add(col); //转案区间 col = new System.Data.DataColumn(); col.Caption = "转案区间"; col.ColumnName = "GetPeriod"; dt.Columns.Add(col); //备注 col = new System.Data.DataColumn(); col.Caption = "备注"; col.ColumnName = "Note"; dt.Columns.Add(col); foreach (Model.DTO.UKHandleQuanDetail item in ukQuanList.Values) { System.Data.DataRow row = dt.NewRow(); row["ID"] = item.ID; row["ContractNum"] = item.ContractNum; row["StudentName"] = item.StudentName; row["University"] = item.University; row["ApplicationType"] = item.ApplicationType; row["Online"] = item.SendQuan.Online; row["Megnetic"] = item.SendQuan.Magnetic; row["PS"] = item.SendQuan.PS; row["Admission"] = item.Admission; row["Author"] = item.CopyWriting.Author; row["Senior"] = item.CopyWriting.Senior; row["PSAuthor"] = item.PS.Author; row["PSDepartment"] = item.PS.Department; row["Note"] = item.Note; row["GetPeriod"] = item.GetPeriod; dt.Rows.Add(row); } return dt; }
private bool collectData() { if (string.IsNullOrEmpty(this.mruContractNum.Text)) { XtraMessageBox.Show("合同编号不能为空。", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } if (string.IsNullOrEmpty(this.mruStudentName.Text)) { XtraMessageBox.Show("学生姓名不能为空。", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } if (string.IsNullOrEmpty(this.mruUniversity.Text)) { XtraMessageBox.Show("院校缩写不能为空。", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } if (this.dtSendDate.EditValue == null) { XtraMessageBox.Show("寄出日期不能为空。", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } if (string.IsNullOrEmpty(this.cbSenior.Text)) { XtraMessageBox.Show("资深文案不能为空。", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } if (string.IsNullOrEmpty(this.tbAuthor.Text)) { XtraMessageBox.Show("制作文案不能为空。", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } if (!Controller.SQLiteController.BizContract.CheckQuanSendDate(this.mruContractNum.Text, this.mruStudentName.Text, this.cbUniversity.Text, this.cbCourse.Text)) { if (XtraMessageBox.Show("当前合同信息还没有转交外联日期,\r\n是否仍要新增?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No) { return false; } } if (!Controller.SQLiteController.BizContract.CheckQuanSubmit(this.mruContractNum.Text, this.mruStudentName.Text, this.cbUniversity.Text, this.cbCourse.Text)) { if (XtraMessageBox.Show("当前合同信息可能已报过量化,\r\n是否仍要新增?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No) { return false; } } if (this.country == Model.MotivationEnum.CountryEnum.UK)//英国 { Model.DTO.UKHandleQuanDetail ukHandleQuanDetail; if (!string.IsNullOrEmpty(this.handleQuanDetailKey))//编辑时保证量化对象ID不变 { ukHandleQuanDetail = Controller.MainWin.MotivationData.Instanse.HandleQuan.UKDetails[this.handleQuanDetailKey]; ukHandleQuanDetail.ContractNum = this.mruContractNum.Text; } else { ukHandleQuanDetail = new Model.DTO.UKHandleQuanDetail(); } ukHandleQuanDetail.ContractNum = this.mruContractNum.Text; ukHandleQuanDetail.StudentName = this.mruStudentName.Text; ukHandleQuanDetail.University = this.mruUniversity.Text; ukHandleQuanDetail.UniversityFullName = this.cbUniversity.Text; ukHandleQuanDetail.Course = this.cbCourse.Text; ukHandleQuanDetail.ApplicationType = this.cbApplicationType.Text; ukHandleQuanDetail.SendQuan.Online = this.cbOnline.Text; ukHandleQuanDetail.SendQuan.SendDate = this.dtSendDate.DateTime; ukHandleQuanDetail.SendQuan.Magnetic = this.cbMagnetic.Text; ukHandleQuanDetail.SendQuan.PS = this.cbPS.Text; ukHandleQuanDetail.Admission = this.cbAdmission.Text; ukHandleQuanDetail.CopyWriting.Senior = this.cbSenior.Text; ukHandleQuanDetail.CopyWriting.Author = this.tbAuthor.Text; ukHandleQuanDetail.PS.Author = this.tbPSAuthor.Text; ukHandleQuanDetail.PS.Department = this.tbPSDepartment.Text; ukHandleQuanDetail.Note = this.tbNote.Text; ukHandleQuanDetail.GetPeriod = this.cbGetPeriod.Text; this.HandleQuanDetail = ukHandleQuanDetail; return true; } else { Model.DTO.HKHandleQuanDetail hkHandleQuanDetail; if (!string.IsNullOrEmpty(this.handleQuanDetailKey))//编辑时保证量化对象ID不变 { hkHandleQuanDetail = Controller.MainWin.MotivationData.Instanse.HandleQuan.HKDetails[this.handleQuanDetailKey]; hkHandleQuanDetail.ContractNum = this.mruContractNum.Text; } else { hkHandleQuanDetail = new Model.DTO.HKHandleQuanDetail(); } hkHandleQuanDetail.ContractNum = this.mruContractNum.Text; hkHandleQuanDetail.StudentName = this.mruStudentName.Text; hkHandleQuanDetail.University = this.mruUniversity.Text; hkHandleQuanDetail.UniversityFullName = this.cbUniversity.Text; hkHandleQuanDetail.Course = this.cbCourse.Text; hkHandleQuanDetail.ApplicationType = this.cbApplicationType.Text; hkHandleQuanDetail.SendQuan.Online = this.cbOnline.Text; hkHandleQuanDetail.SendQuan.Translation = this.cbTranslation.Text; hkHandleQuanDetail.SendQuan.Visa = this.cbVisa.Text; hkHandleQuanDetail.SendDate = this.dtSendDate.DateTime; hkHandleQuanDetail.Admission = this.cbAdmission.Text; hkHandleQuanDetail.Sign = this.cbSign.Text; hkHandleQuanDetail.CopyWriting.Senior = this.cbSenior.Text; hkHandleQuanDetail.CopyWriting.Author = this.tbAuthor.Text; hkHandleQuanDetail.PS.Author = this.tbPSAuthor.Text; hkHandleQuanDetail.PS.Department = this.tbPSDepartment.Text; hkHandleQuanDetail.Note = this.tbNote.Text; this.HandleQuanDetail = hkHandleQuanDetail; return true; } }
public static Model.DTO.HandleQuantification LoadQuanXml(string filePath) { if (string.IsNullOrEmpty(filePath)) { throw new Exception("没有传入文件路径"); } XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(filePath); if (xmlDoc == null) { throw new Exception("缓存数据获取失败"); } Model.DTO.HandleQuantification handleQuan = new Model.DTO.HandleQuantification(); //首先获取UKDetails Dictionary<string, Model.DTO.UKHandleQuanDetail> ukDetails = new Dictionary<string, Model.DTO.UKHandleQuanDetail>(); XmlNodeList nodelList = xmlDoc.SelectNodes("Performance/HandleQuantification/UKDetails/Detail"); if (nodelList != null && nodelList.Count > 0) { foreach (XmlNode node in nodelList) { Model.DTO.UKHandleQuanDetail detail = new Model.DTO.UKHandleQuanDetail(); detail.ID = node.Attributes["ID"].Value; detail.ContractNum = node.Attributes["ContractNum"].Value; detail.StudentName = node.Attributes["StudentName"].Value; detail.University = node.Attributes["University"].Value; detail.ApplicationType = node.Attributes["ApplicationType"].Value; detail.SendQuan.Online = node.SelectSingleNode("SendQuan").Attributes["Online"].Value; detail.SendQuan.SendDate = DateTime.Parse(node.SelectSingleNode("SendQuan").Attributes["SendDate"].Value); detail.SendQuan.Magnetic = node.SelectSingleNode("SendQuan").Attributes["Magnetic"] == null ? "" : node.SelectSingleNode("SendQuan").Attributes["Magnetic"].Value; detail.SendQuan.PS = node.SelectSingleNode("SendQuan").Attributes["PS"] == null ? "" : node.SelectSingleNode("SendQuan").Attributes["PS"].Value; detail.Admission = node.Attributes["Admission"].Value; detail.CopyWriting.Senior = node.SelectSingleNode("Copywriting").Attributes["Senior"].Value; detail.CopyWriting.Author = node.SelectSingleNode("Copywriting").Attributes["Author"].Value; detail.PS.Author = node.SelectSingleNode("PSInfo").Attributes["Author"].Value; detail.PS.Department = node.SelectSingleNode("PSInfo").Attributes["Department"].Value; detail.Note = node.Attributes["Note"].Value; detail.GetPeriod = node.Attributes["GetPeriod"] == null ? "" : node.Attributes["GetPeriod"].Value; ukDetails.Add(detail.ID, detail); } } handleQuan.UKDetails = ukDetails; //然后加载HKDetails Dictionary<string, Model.DTO.HKHandleQuanDetail> hkDetails = new Dictionary<string, Model.DTO.HKHandleQuanDetail>(); nodelList = xmlDoc.SelectNodes("Performance/HandleQuantification/HKDetails/Detail"); if (nodelList != null && nodelList.Count > 0) { foreach (XmlNode node in nodelList) { Model.DTO.HKHandleQuanDetail detail = new Model.DTO.HKHandleQuanDetail(); detail.ID = node.Attributes["ID"].Value; detail.ContractNum = node.Attributes["ContractNum"].Value; detail.StudentName = node.Attributes["StudentName"].Value; detail.University = node.Attributes["University"].Value; detail.ApplicationType = node.Attributes["ApplicationType"].Value; detail.SendQuan.Online = node.SelectSingleNode("SendQuan").Attributes["Online"].Value; detail.SendQuan.Translation = node.SelectSingleNode("SendQuan").Attributes["Translation"].Value; detail.SendQuan.Visa = node.SelectSingleNode("SendQuan").Attributes["Visa"].Value; detail.SendDate = DateTime.Parse(node.Attributes["SendDate"].Value); detail.CopyWriting.Senior = node.SelectSingleNode("Copywriting").Attributes["Senior"].Value; detail.CopyWriting.Author = node.SelectSingleNode("Copywriting").Attributes["Author"].Value; detail.Admission = node.Attributes["Admission"].Value; detail.Sign = node.Attributes["Sign"].Value; detail.PS.Author = node.SelectSingleNode("PSInfo").Attributes["Author"].Value; detail.PS.Department = node.SelectSingleNode("PSInfo").Attributes["Department"].Value; detail.Note = node.Attributes["Note"].Value; hkDetails.Add(detail.ID, detail); } } handleQuan.HKDetails = hkDetails; handleQuan.HandleDate = DateTime.Now; return handleQuan; }