public static List<LXJHGLInstance> ImportTasks(string filename) { List<LXJHGLInstance> tasks = new List<LXJHGLInstance>(); using (FileStream fs = File.OpenRead(filename)) { IWorkbook wb = WorkbookFactory.Create(fs); var sheet = wb.GetSheetAt(0); for (int i = sheet.FirstRowNum + 1; i <= sheet.LastRowNum; i++) { IRow row = sheet.GetRow(i); ICell cell = row == null ? null : row.GetCell(0); if (cell != null && !string.IsNullOrEmpty(cell.StringCellValue)) { var task = new LXJHGLInstance(); task.Id = cell.StringCellValue; task.Name = row.GetCell(1).StringCellValue; cell = row == null ? null : row.GetCell(2); if(cell.CellType == CellType.String) task.Version = int.Parse(row.GetCell(2).StringCellValue); if (cell.CellType == CellType.Numeric) task.Version = (int)(row.GetCell(2).NumericCellValue); task.Releaser = row.GetCell(3).StringCellValue; task.Releasetime = DateTime.ParseExact(row.GetCell(4).StringCellValue, "yyyy年MM月dd日", CultureInfo.InvariantCulture); task.Type = row.GetCell(5).StringCellValue; task.Creator = row.GetCell(6) == null ? string.Empty : row.GetCell(6).StringCellValue; task.Status = LXJHGLStatus.未分配; task.Taskcreatime = DateTime.Now; tasks.Add(task); } } } return tasks; }
private void button3_Click(object sender, EventArgs e) { try { //判断checkbox是否选中 int count = 0; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if ((bool)dataGridView1.Rows[i].Cells[0].EditedFormattedValue == true) { count++; } } if (count == 0) { MessageBox.Show("请至少选择一条数据!", "提示"); return; } else { if (MessageBox.Show(this, "您要更新数据么?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information).ToString() == "Yes") { List<LXJHGLInstance> updateList = new List<LXJHGLInstance>(); var task = new LXJHGLInstance(); for (int j = 0; j < dataGridView1.Rows.Count; j++) { if ((bool)dataGridView1.Rows[j].Cells[0].EditedFormattedValue == true) { Tasks[j].Status = LXJHGLStatus.未接收; Tasks[j].Creator = dataGridView1.Rows[j].Cells[7].Value.ToString(); if (dataGridView1.Rows[j].Cells[11].Value != null) { Tasks[j].Bz = dataGridView1.Rows[j].Cells[11].Value.ToString(); } Tasks[j].Difficulty =(int)( dataGridView1.Rows[j].Cells[13].Value); } } } else { return; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } //改变数据库中数据 LXJHGLCLT.Agent.UpdateTasks(Tasks); //重新绑定datagridview dataGridView1.DataSource = Tasks; }
static LXJHGLInstance CreateTask(string Id, string Name, int Version, string Releaser, DateTime Releasetime, string Type, string Creator, DateTime Planedtime, DateTime Taskcreatime, string Bz, string Process, int Difficulty, DateTime Completetime) { LXJHGLInstance task = new LXJHGLInstance(); task.Id = Id; task.Name = Name; task.Version = Version; task.Releaser = Releaser; task.Releasetime = Releasetime; task.Type = Type; task.Creator = Creator; task.Planedtime = Planedtime; task.Taskcreatime = Taskcreatime; task.Status = LXJHGLStatus.未分配; task.Bz = Bz; task.Process = Process; task.Difficulty = Difficulty; task.Completetime = Completetime; return task; }
public static List <LXJHGLInstance> ImportTasks(string filename) { List <LXJHGLInstance> tasks = new List <LXJHGLInstance>(); using (FileStream fs = File.OpenRead(filename)) { IWorkbook wb = WorkbookFactory.Create(fs); var sheet = wb.GetSheetAt(0); for (int i = sheet.FirstRowNum + 1; i <= sheet.LastRowNum; i++) { IRow row = sheet.GetRow(i); ICell cell = row == null ? null : row.GetCell(0); if (cell != null && !string.IsNullOrEmpty(cell.StringCellValue)) { var task = new LXJHGLInstance(); task.Id = cell.StringCellValue; task.Name = row.GetCell(1).StringCellValue; cell = row == null ? null : row.GetCell(2); if (cell.CellType == CellType.String) { task.Version = int.Parse(row.GetCell(2).StringCellValue); } if (cell.CellType == CellType.Numeric) { task.Version = (int)(row.GetCell(2).NumericCellValue); } task.Releaser = row.GetCell(3).StringCellValue; task.Releasetime = DateTime.ParseExact(row.GetCell(4).StringCellValue, "yyyy年MM月dd日", CultureInfo.InvariantCulture); task.Type = row.GetCell(5).StringCellValue; task.Creator = row.GetCell(6) == null ? string.Empty : row.GetCell(6).StringCellValue; task.Status = LXJHGLStatus.未分配; task.Taskcreatime = DateTime.Now; tasks.Add(task); } } } return(tasks); }
internal List<LXJHGLInstance> GetAllTasks() { List<LXJHGLInstance> result = new List<LXJHGLInstance>(); this.dbParam.Open(); OracleCommand queryCmd = new OracleCommand(); queryCmd.Connection = (OracleConnection)this.dbParam.Connection; queryCmd.CommandText = @"SELECT ID, NAME, VERSION, RELEASER, RELEASETIME, TYPE, CREATOR, PLANEDTIME, TASKCREATIME, STATUS, BZ, PROCESS, DIFFICULTY, COMPLETETIME FROM dq_route_taskmng"; var reader = queryCmd.ExecuteReader(); while (reader.Read()) { LXJHGLInstance task = new LXJHGLInstance(); task.Id = reader.GetOracleString(0).IsNull ? string.Empty : reader.GetOracleString(0).Value; task.Name = reader.GetOracleString(1).IsNull ? string.Empty : reader.GetOracleString(1).Value; task.Version = reader.GetOracleDecimal(2).IsNull ? 0 : reader.GetOracleDecimal(2).ToInt32(); task.Releaser = reader.GetOracleString(3).IsNull ? string.Empty : reader.GetOracleString(3).Value; task.Releasetime = reader.GetOracleDate(4).IsNull ? DateTime.MinValue : reader.GetOracleDate(4).Value; task.Type = reader.GetOracleString(5).IsNull ? string.Empty : reader.GetOracleString(5).Value; task.Creator = reader.GetOracleString(6).IsNull ? string.Empty : reader.GetOracleString(6).Value; task.Planedtime = reader.GetOracleDate(7).IsNull ? DateTime.MinValue : reader.GetOracleDate(7).Value; task.Taskcreatime = reader.GetOracleDate(8).IsNull ? DateTime.MinValue : reader.GetOracleDate(8).Value; task.Status = reader.GetOracleDecimal(9).IsNull ? (LXJHGLStatus)1 : (LXJHGLStatus)reader.GetOracleDecimal(9).ToInt32(); task.Bz = reader.GetOracleString(10).IsNull ? string.Empty : reader.GetOracleString(10).Value; task.Process = reader.GetOracleString(11).IsNull ? string.Empty : reader.GetOracleString(11).Value; task.Difficulty = reader.GetOracleDecimal(12).IsNull ? 0 : reader.GetOracleDecimal(12).ToInt32(); task.Completetime = reader.GetOracleDate(13).IsNull ? DateTime.MinValue : reader.GetOracleDate(13).Value; result.Add(task); } this.dbParam.Close(); return result; }