/// <summary> /// 注意这个函数只能是相对路径!!!超牛的办法,不仅仅在调试的时候用本地文件,并且可以同步更新到配置表,并且发布版本直接用配置表 /// </summary> /// <param name="rucan">注意这个函数只能是相对路径!!!</param> /// <param name="ic"></param> /// <returns></returns> public static QueryForm Create_QueryForm(string rucan, Core.IoRyClass ic) { #if DEBUG string path = AppDomain.CurrentDomain.BaseDirectory + rucan; XElement xe = XElement.Load(path); string sql = string.Format("select value_str from PC_config where key_str='{0}'", rucan.Replace('\'', ' ')); DataSet ds = ic.GetDataSet(sql); if (ds.Tables[0].Rows.Count == 0) { sql = string.Format("insert into PC_config (PC_config_GUID,IP_str,key_str,value_str,createtime_dt) values (newid(),'*.*.*.*','{0}','{1}',getdate())", rucan, xe.ToString()); } else { sql = string.Format("update PC_config set value_str='{1}',changetime_dt=getdate() where key_str='{0}'", rucan, xe.ToString()); } ic.ExecuteSql(sql); QueryForm QF = new QueryForm(InitType.XmlPath, path); return(QF); #else string sql = string.Format("select value_str from PC_config where key_str='{0}'", rucan.Replace('\'', ' ')); DataSet ds = ic.GetDataSet(sql); QueryForm QF = new QueryForm(InitType.XmlString, Convert.ToString(ds.Tables[0].Rows[0][0])); return(QF); #endif }
/// <summary> /// 获取小dataset /// </summary> /// <param name="sql"></param> /// <param name="ic"></param> public static DataSet GetDataSet(string sql, Core.IoRyClass ic) { return(ic.GetDataSet(sql)); }