/// <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));
}
/// <summary>
/// 就是为了跟WCF一致
/// </summary>
/// <param name="dgv"></param>
/// <param name="sql"></param>
/// <param name="ic"></param>
/// <param name="pb"></param>
/// <param name="lb"></param>
public static void bindDataGridView_Async(DataGridView dgv, string sql, Core.IoRyClass ic, ProgressBar pb, List <Button> lb)
{
dgv.DataSource = ic.GetTable(sql);
}
/// <summary>
/// 这里区分同步异步纯粹是为了跟WCF的方式保持一致 同步异步方式无区别
/// </summary>
/// <param name="dgv"></param>
/// <param name="sql"></param>
/// <param name="ic"></param>
public static void bindDataGridView_Async(DataGridView dgv, string sql, Core.IoRyClass ic)
{
dgv.DataSource = ic.GetTable(sql);
}
