public static void WriteErrorOLEDB(ProblemOT pot) { using (OleDbConnection connection = new OleDbConnection(ConnStr)) { connection.Open(); string mysql = "INSERT INTO [Sheet4$] VALUES ("; StringBuilder sb = new StringBuilder(mysql); SetValueOnError(pot.EmpName,sb); SetValueOnError(pot.EmpNumber,sb); SetValueOnError(pot.OT_Date,sb); SetValueOnError(pot.Apply_Number,sb); SetValueOnError(pot.OT_Hours,sb); SetValueOnError(pot.Offset_hours,sb); sb.Append("'')"); OleDbCommand commande = new OleDbCommand(sb.ToString(), connection); commande.ExecuteNonQuery(); connection.Close(); connection.Dispose(); } }
public void CheckOffsetIntegrated() { var q = from p in context.OT_WORK where p.PAY_TYPE=="1" select p; Comm.Logger.Info(string.Format("等待确认记录共{0}条.", q.Count())); foreach (OT_WORK otwork in q) { decimal offset_hours = 0; foreach(OT_WORK_OFFSET work_offset in otwork.OT_WORK_OFFSET) { offset_hours +=(decimal)work_offset.OFFSET_HOURS; } if(!otwork.HOURS.Equals(offset_hours)) { ProblemOT pot = new ProblemOT(); pot.EmpName = otwork.OT_EMP.EMP_NAME; pot.EmpNumber = otwork.OT_EMP.EMP_NUMBER; pot.Offset_hours = ((DateTime)otwork.START_DATE).ToString("yyyy-MM-dd"); pot.Apply_Number = otwork.OT_APP1.APP1_NO; pot.OT_Hours = otwork.HOURS.ToString(); pot.Offset_hours = offset_hours.ToString(); ExcelTool.WriteErrorOLEDB(pot); } } }
public static void WriteError(ProblemOT pot) { ExcelTool.ErrSheet = (Worksheet)ErrBook.Sheets[4]; int lastRow = ErrSheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell).Row; int index = lastRow + 1; ErrSheet.Cells[index, 1] = pot.EmpName; ErrSheet.Cells[index, 2] = pot.EmpNumber; ErrSheet.Cells[index, 3] = pot.OT_Date; ErrSheet.Cells[index, 4] = pot.Apply_Number; ErrSheet.Cells[index, 5] = pot.OT_Hours; ErrSheet.Cells[index, 6] = pot.Offset_hours; ErrBook.Save(); }