public DateTime SDate() { var sdate = int.Parse(ConfigurationOperator.GetValue("syear")); var sql = @"select isnull(max(日期),'1900-01-01')日期 from " + tableName + " where 年=" + sdate; var riqi = FITTHelper.GetSingleVal(sql).ToString(); if (DateTime.Parse(riqi) == DateTime.Parse("1900-01-01")) { return(new DateTime(sdate, 1, 1)); } else { return(DateTime.Parse((riqi))); } }
/// <summary> /// 取webconfig中的配置 /// </summary> /// <param name="SourceName"></param> /// <returns></returns> private static FileConfigurationSource GetFileConfigurationSource() { FileConfigurationSource fileSource; string configPath = new ConfigurationOperator().getRedirectConfigPath(); //获取重定向配置文件资源 if (string.IsNullOrEmpty(configPath)) { fileSource = null; } else { fileSource = new FileConfigurationSource(HttpContext.Current.Server.MapPath(configPath)); } return(fileSource); }
/// <summary> /// 获得SqlSugarClient /// </summary> public static SqlSugarClient GetIntance() { var listConn = new List <string>(); var list = new ConfigurationOperator().ALLConnectionStrings(); foreach (var item in list) { if (!string.IsNullOrWhiteSpace(item)) { listConn.Add(item); } } if (listConn.Count < 1) { throw new Exception("数据库配置错误"); } return(InitDataBase(listConn)); }
/// <summary> /// 添加数据库连接字符串 /// </summary> /// <param name="connName"></param> /// <param name="connStr"></param> /// <param name="xType"></param> /// <param name="configName"></param> /// <returns></returns> public static bool addConnection(string connName, string connStr, string prividerName) { bool bRet = false; try { ConfigurationOperator cfgOper = new ConfigurationOperator(configFilePath); cfgOper.setConnectionString(connName, connStr, prividerName); cfgOper.Dispose(); bRet = true; } catch (System.Exception ex) { throw ex; } return(bRet); }
/// <summary> /// 构造函数 /// </summary> static ConnectionAdmin() { ConfigurationOperator cfgOper = new ConfigurationOperator(configFilePath); string filePath = cfgOper.getRedirectConfigPath(); try { if (string.IsNullOrEmpty(filePath)) { configFilePath = "~"; } else { configFilePath = @"~/" + filePath.Substring(0, filePath.LastIndexOf(@"/")); } } catch (System.Exception ex) { throw ex; } }
/// <summary> /// 删除数据库连接字符串 /// </summary> /// <param name="connName"></param> /// <returns></returns> public static bool deleteConnection(string connName) { ConfigurationOperator cfgOper = new ConfigurationOperator(configFilePath); return(cfgOper.deleteConnectionNode(connName)); }
public static ConnDef getConnDef(string connName) { ConfigurationOperator cfgOper = new ConfigurationOperator(configFilePath); return(cfgOper.getConnDef(connName)); }
/// <summary> /// 取默认连接串 /// </summary> /// <returns></returns> public static string getDefaultConnName() { ConfigurationOperator cfgOper = new ConfigurationOperator(configFilePath); return(cfgOper.getDefaultConnName()); }
/// <summary> /// 设置默认数据库连接 /// </summary> /// <returns></returns> public static bool setDefaultConn(string connName) { ConfigurationOperator cfgOper = new ConfigurationOperator(configFilePath); return(cfgOper.setDefaultConnStr(connName)); }
/// <summary> /// 返回数据库连接名列表 /// </summary> /// <returns>ListData<string></returns> public static List <string> getConnNameList() { ConfigurationOperator cfgOper = new ConfigurationOperator(configFilePath); return(cfgOper.getConnNameList()); }
/// <summary> /// 获取所有数据库连接内容 /// </summary> /// <param name="connName"></param> /// <returns>DataTable 列包括:name、val、xtype、xdefault</returns> public static DataTable getAllConnInfoTable() { ConfigurationOperator cfgOper = new ConfigurationOperator(configFilePath); return(cfgOper.allConnectionStrings()); }