private void SaveJobAction() { DataTable souceJobData = null; DataTable gridJobData = null; List <Job> jobs = null; try { int rowCount = jobGridView.RowCount; string jobxmlfileFullPath = Miscellaneous.GetJobXMLFullPath(); //MessageBox.Show(jobxmlfileFullPath); souceJobData = XMLHelper.GetJobsDataTable(); gridJobData = DatagridviewHelper.ConvertDataGridViewToTable(jobGridView); bool isSame = DatagridviewHelper.CompareDataTable(souceJobData, gridJobData, "JobName"); if (!isSame) { jobs = DataInit.CovertJobTableToLists(gridJobData); XMLHelper.UpdateJobNodes(jobxmlfileFullPath, jobs); //for (int index = 0; index < rowCount - 1; index++) //{ // string jobTitle = jobGridView.Rows[index].Cells[0].Value.ToString(); // string jobRating = jobGridView.Rows[index].Cells[1].Value.ToString(); // string id = jobGridView.Rows[index].Cells[2].Value.ToString(); // if (!string.IsNullOrEmpty(jobTitle) && !string.IsNullOrEmpty(jobRating)) // { // Job job = new Job(); // job.JobName = jobTitle; // job.JobIndex = jobRating; // //it's a new row if empty // if (string.IsNullOrEmpty(id)) // { // DataInit.AddJobNode(jobxmlfileFullPath, job); // } // else // { // job.Id = id; // DataInit.UpdateJobNode(jobxmlfileFullPath, "Jobs", job); // } // } // else // { // MessageBox.Show("岗位名称或者岗位系数不能为空", "保存失败"); // } //} } } catch (Exception ex) { MessageBox.Show("数据保存错误:" + ex.Message, "系统错误提示"); } finally { souceJobData = null; gridJobData = null; jobs = null; } }
private void UpdateScheduleJobDrop() { //if (!_monthPickerSelected) //{ //用户还没有选择排版日期,即排班计划还没有生成 // BindHomeJobDrop(); //} Control[] jobBox = dataGridView_home.Controls.Find("jobBox", false); List <Job> jobs = XMLHelper.GetJobs(Miscellaneous.GetJobXMLFullPath()); DataTable dtJobs = new DataTable(); dtJobs.Columns.Add("Id"); dtJobs.Columns.Add("Name"); foreach (Job item in jobs) { DataRow nameRow = dtJobs.NewRow(); //ComboBoxItem boxItem = new ComboBoxItem(item.JobIndex, item.JobName); nameRow["Id"] = item.JobIndex; nameRow["Name"] = item.JobName; dtJobs.Rows.Add(nameRow); } ComboBox cmb_temp = jobBox[0] as ComboBox; cmb_temp.ValueMember = "Id"; cmb_temp.DisplayMember = "Name"; cmb_temp.DropDownStyle = ComboBoxStyle.DropDownList; cmb_temp.DataSource = dtJobs; }
/// <summary> /// 生成排班信息中的排班下拉项 /// </summary> private void BindHomeJobDrop() { List <Job> jobs = XMLHelper.GetJobs(Miscellaneous.GetJobXMLFullPath()); //List<String> nursers = XMLHelper.GetNursersName(GetNurseXMLFullPath()); DataTable dtJobs = new DataTable(); dtJobs.Columns.Add("Id"); dtJobs.Columns.Add("Name"); ComboBox cmb_temp = new ComboBox(); foreach (Job item in jobs) { DataRow nameRow = dtJobs.NewRow(); //ComboBoxItem boxItem = new ComboBoxItem(item.JobIndex, item.JobName); nameRow["Id"] = item.JobIndex; nameRow["Name"] = item.JobName; dtJobs.Rows.Add(nameRow); } cmb_temp.ValueMember = "Id"; cmb_temp.Name = "jobBox"; cmb_temp.DisplayMember = "Name"; cmb_temp.DropDownStyle = ComboBoxStyle.DropDownList; cmb_temp.Visible = false; cmb_temp.DataSource = dtJobs; dataGridView_home.Controls.Add(cmb_temp); cmb_temp.SelectedIndexChanged += new EventHandler(cmb_Job_SelectedIndexChanged); }
private BindingSource DataBindingJobsSource() { System.Data.DataSet ds = new System.Data.DataSet(); string xmlfileFullPath = Miscellaneous.GetJobXMLFullPath(); //string rootElement = "Jobs"; ds.ReadXml(xmlfileFullPath); return(new BindingSource(ds.Tables[0], null)); }
private DataTable InitReporingForJobs() { List <string> jobsName = XMLHelper.GetJobsName(Miscellaneous.GetJobXMLFullPath()); DataTable dt = new DataTable(); dt.Columns.Add("姓名"); foreach (var item in jobsName) { dt.Columns.Add(item); } return(dt); }
void btnUploadSchedule_Click(object sender, EventArgs e) { OpenFileDialog ofd = new OpenFileDialog(); DateTime dtMonthCal = monthCalendarMain.SelectionStart; DateTime startWeek = dtMonthCal.AddDays(1 - Convert.ToInt16(dtMonthCal.DayOfWeek.ToString("d"))); List <string> weekdays = Miscellaneous.GenerateWeekDaysList(startWeek); if (ofd.ShowDialog() == DialogResult.OK) { string fileName = ofd.FileName.ToString(); List <string> nursersName = XMLHelper.GetNursersName(Miscellaneous.GetNurseXMLFullPath()); List <string> jobsName = XMLHelper.GetJobsName(Miscellaneous.GetJobXMLFullPath()); //只读取/处理表文件中的姓名和排班信息,如果姓名或者排班信息在系统中找不到,则抛出错误 ExcelHelper.UploadAndSaveExcel(fileName, nursersName, jobsName); } }