private void OnUpdateStudentPlacement(object obj) { Services.NewStudentIdServicesClient service = new Services.NewStudentIdServicesClient(); try { DataRow[] drs= DataList.Select("是否修改=1"); if (drs.Count() == 0) { ModernDialog.ShowMessage("没有修改过班级信息的记录", "消息", System.Windows.MessageBoxButton.OK); return; } foreach (DataRow item in drs) { if ((item["班级编号"] != null || item["班级编号"].ToString() != string.Empty)) { int id = int.Parse(item["ID"].ToString()); NewStudentIdModel model = service.GetModelById(id); model.BJBH = item["班级编号"].ToString(); service.NewStudentIdUpdate(model); } } ModernDialog.ShowMessage("分班信息写入成功", "消息", System.Windows.MessageBoxButton.OK); } catch(Exception ex) { ModernDialog.ShowMessage(ex.Message, "消息", System.Windows.MessageBoxButton.OK); } finally { service.Close(); } }
/// <summary> /// 获取数据 /// </summary> private void RefreshData(string searchString) { Status = EnumViewModelStatus.Loading; Services.NewStudentIdServicesClient service = new Services.NewStudentIdServicesClient(); string result = service.GetExportStudentData(searchString); StudentDataTable = JsonConvert.DeserializeObject<DataTable>(result); //StudentDataTable.TableName = "Student"; //StudentDataTable.WriteXml("123.xml"); service.Close(); Status = EnumViewModelStatus.Loaded; }
private void OnDataGridMouseDoubleClick(object obj) { if (obj == null) { return; } else { Services.NewStudentIdServicesClient service = new Services.NewStudentIdServicesClient(); int id = Convert.ToInt32((obj as DataRowView).Row["ID"].ToString()); NewStudentIdModel student=service.GetModelById(id); Views.Windows.UpdateNewStudent updateWindow = new Views.Windows.UpdateNewStudent(student); updateWindow.ShowDialog(); } }
private void BeginPrint(IProgress<PrintProgressValue> progress) { Services.NewStudentIdServicesClient service = new Services.NewStudentIdServicesClient(); LocalPrintServer lps = new LocalPrintServer(); PrintQueue pq = lps.DefaultPrintQueue; try { PrintProgressValue progressValue = new PrintProgressValue(); progressValue.MaxValue = printDataTable.Rows.Count; foreach (DataRow dr in printDataTable.Rows) { //标识开始打印状态 printState = PrintState.正在打印; //如果点击了取消则退出打印循环 if (isCancel) break; pq.Refresh(); //控制打印机任务最多只能有2个 while (pq.NumberOfJobs > 1 &!isCancel) { pq.Refresh(); } DataTable dt = printDataTable.Clone(); dt.TableName = "Student"; dt.ImportRow(dr); //dr["打印状态"] = "正在打印"; //获取学生照片 Byte[] bytes = service.GetStudentImage(dr["考生号"].ToString()); if (bytes != null) { MemoryStream ms = new MemoryStream(); ms.Write(bytes, 0, bytes.Length); //打印照片 PrintHelper.Print(dt, templateFile, ms); } else PrintHelper.Print(dt, templateFile); //更新数据库 NewStudentIdModel model = service.GetModelById(int.Parse(dr["ID"].ToString())); if (model.DYXH == 0) { //设置打印序号 model.DYXH = service.GetMaxPrintNum(int.Parse(SystemConfig.CurrentYear)) + 1; } //3表示通知书和邮寄单都打印 switch (printType) { case PrintType.通知书打印: { if (model.DYBZ != 1 || model.DYBZ != 3) model.DYBZ = ((int)printType) + model.DYBZ; }; break; case PrintType.邮寄单打印: { if (model.DYBZ != 2 || model.DYBZ != 3) model.DYBZ = ((int)printType) + model.DYBZ; }; break; } service.NewStudentIdUpdate(model); if (progress != null) { progressValue.CurrentValue++; progress.Report(progressValue); } } //dr["打印状态"] = "打印完成"; } finally { //标识开始打印状态 printState = PrintState.完成打印; service.Close(); } }
private void RefreshData(string search) { Services.NewStudentIdServicesClient service = new Services.NewStudentIdServicesClient(); string result = service.GetExportStudentData(search); DataList = JsonConvert.DeserializeObject<DataTable>(result); if (!DataList.Columns.Contains("是否修改")) { DataColumn col = new DataColumn("是否修改", typeof(bool));//标记记录是否修改过 DataList.Columns.Add(col); } service.Close(); }
private void RefreshData(string search) { Services.NewStudentIdServicesClient service = new Services.NewStudentIdServicesClient(); string result = service.GetExportStudentData(search); CurrentAllStudent = JsonConvert.DeserializeObject<DataTable>(result); if (!CurrentAllStudent.Columns.Contains("打印状态")) CurrentAllStudent.Columns.Add("打印状态"); service.Close(); }
/// <summary> /// 上传体检表 /// </summary> /// <param name="path"></param> private void UploadTjb(string path) { if (!Directory.Exists(path)) { ErrorMsg = "选择的路径中不存在体检表格文件夹"; return; } DirectoryInfo dir = new DirectoryInfo(path); FileInfo[] files = dir.GetFiles("*.*");//获取目录下所有的文件 Services.NewStudentIdServicesClient service = new Services.NewStudentIdServicesClient(); foreach (FileInfo item in files) { if (item.Exists) { FileStream fs = new FileStream(item.FullName, FileMode.Open); byte[] byteData = new byte[fs.Length]; fs.Read(byteData, 0, byteData.Length); fs.Close(); service.UpLoadStudentTjb(byteData, item.Name); } } service.Close(); }
private void InserNewStudent(IProgress<int> progress) { SetErrorMsg("正在导入新生基础数据"); Services.NewStudentIdServicesClient student = new Services.NewStudentIdServicesClient(); //List<NewStudentNameModel> list = new List<NewStudentNameModel>(); int current = 0; int stuCount = NewStudents.Count; foreach (NewStudentNameModel item in NewStudents) { item.NJ = SystemConfig.CurrentYear;//新生年级 item.ZDYPCDM = SelectPcdmItem.Pcdm;//系统使用的批次代码 if (ImporttypeValue == "完全覆盖") student.NewStudentIdAdd(item, 1); else student.NewStudentIdAdd(item, 0); progress.Report(((++current)*100)/stuCount); }; student.Close(); }