/// <summary> /// 以sql语句填充DataSet的第一张表(Table1) /// </summary> /// <param name="sql"></param> /// <returns></returns> public static DataSet Query(string sql) { //锁上oleDbConn,保证每时刻只有一个线程使用oleDbConn。 lock (oleDbConn) { OleDbDataAdapter myAdapter = new OleDbDataAdapter(sql, oleDbConn); DataSet ds = new DataSet(); try { myAdapter.Fill(ds, "Table1"); } catch (OleDbException ex) { MessageHandle.MessageError(ex.ToString(), "错误信息"); } return(ds); } }
/// <summary> /// 构造系统运行参数 /// </summary> public static void InitSysParameter() { ChineseCalendarInfo cClaendar = new ChineseCalendarInfo(DateTime.Today); //string strLunar = cClaendar.LunarYear + "-" + cClaendar.LunarMonth + "-" + cClaendar.LunarDay; //LUNAR_TODAY = Convert.ToDateTime(strLunar); XmlDocument xml = new XmlDocument(); string fileName = Application.StartupPath + "\\Config.xml"; try { xml.Load(fileName); } catch (Exception ex) { MessageHandle.MessageError(ex.Message, "错误信息"); Application.Exit(); } XmlNode xmlNode = xml.SelectSingleNode("Root"); if (xmlNode != null && xmlNode.HasChildNodes) { XmlNodeList xmlNodeList = xmlNode.ChildNodes; if (xmlNodeList.Count == 4) { Int32.TryParse(xmlNodeList[0].InnerText.Trim(), out TIMES); Int32.TryParse(xmlNodeList[1].InnerText.Trim(), out MINUTES); DEFAULT_MUSIC_PATH = xmlNodeList[2].InnerText.Trim(); bool.TryParse(xmlNodeList[3].InnerText.Trim(), out RUN_BACKGROUND); } } RegistryKey dailyRun = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Windows\CurrentVersion\Run"); string[] subkeyNames = dailyRun.GetValueNames(); foreach (string key in subkeyNames) { if (key.ToLower() == "daily") { RUN_ON_START = true; break; } } BusinessFacade.BusAdminDaily.InitTodayUnDoDaily(); }
public static bool UpdateDataSet(string sql, DataSet ds) { lock (oleDbConn) { oleDbConn.Open(); OleDbTransaction trans = oleDbConn.BeginTransaction(); try { OleDbDataAdapter myAdapter = new OleDbDataAdapter(sql, trans.Connection); myAdapter.ContinueUpdateOnError = false; myAdapter.SelectCommand = new OleDbCommand(); myAdapter.SelectCommand.Connection = trans.Connection; myAdapter.SelectCommand.CommandText = sql; OleDbCommandBuilder builder = new OleDbCommandBuilder(); builder.DataAdapter = myAdapter; builder.ConflictOption = ConflictOption.OverwriteChanges; myAdapter.SelectCommand.Transaction = trans; myAdapter.InsertCommand = builder.GetInsertCommand(); myAdapter.InsertCommand.Transaction = trans; myAdapter.DeleteCommand = builder.GetDeleteCommand(); myAdapter.DeleteCommand.Transaction = trans; myAdapter.UpdateCommand = builder.GetUpdateCommand(); myAdapter.UpdateCommand.Transaction = trans; string srcTable = ds.Tables[0].TableName; myAdapter.Update(ds, srcTable); trans.Commit(); } catch (OleDbException ex) { trans.Rollback(); MessageHandle.MessageError(ex.ToString(), "错误信息"); return(false); } finally { oleDbConn.Close(); } return(true); } }
/// <summary> /// 执行一个sql语句,返回受影响的行数 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static int ExecuteNonQuery(string sql) { int count = 0; oleDbConn.Open(); OleDbTransaction trans = oleDbConn.BeginTransaction(); try { OleDbCommand myCmd = new OleDbCommand(sql, oleDbConn, trans); count = myCmd.ExecuteNonQuery(); trans.Commit(); } catch (OleDbException ex) { trans.Rollback(); MessageHandle.MessageError(ex.ToString(), "错误信息"); } finally { oleDbConn.Close(); } return(count); }