/// <summary>
/// 查询基础程序配置
/// </summary>
public static DataTable QueryConfig()
{
string sql = "select * from ProgramInfomation";
var c = SQLite_Connection.QueryTab(sql);
return(c.Tables[0]);
}
/// <summary>
/// 根据ID查询所有的子项
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static DataTable QueryVM(string id)
{
string sql = "select * from VersionManagement where ProgreamInformation_ID='" + id + "'";
var ed = SQLite_Connection.QueryTab(sql);
return(ed.Tables[0]);
}
/// <summary>
/// 根据id和号码取到
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public static string QuertTest(string msg)
{
//msg ->"血常规-1.1"
string flag = null;
string sql = string.Format("select vm.LocalAddress from ProgramInfomation as pi LEFT join VersionManagement as vm on pi.ID = vm.ProgreamInformation_ID where pi.Name = '{0}' and vm.Nuber = '{1}'", msg.Split('-')[0], msg.Split('-')[1]);
DataTable ed = SQLite_Connection.QueryTab(sql).Tables[0];
if (!ed.Rows.Count.Equals(0))
{
flag = ed.Rows[0][0].ToString();
}
return(flag);
}
/// <summary>
/// 查询程序名是否已经存在
/// </summary>
/// <param name="name"></param>
/// <returns>返回true代表可用 false代表不可用</returns>
public static bool QueryProgramName(string name)
{
string sql = "";
bool flag = false;
try
{
var ed = SQLite_Connection.QueryTab(sql);
flag = ed.Tables[0].Rows.Count == 0;
}
catch (Exception ex)
{
Log.WriteLine(DateTime.Now + ex.Message);
}
return(flag);
}
/// <summary>
/// 查询是否存在该程序以及版本号
/// </summary>
/// <param name="name">程序名称 </param>
/// <param name="vm"> 版本号</param>
/// <returns></returns>
public static DataTable QueryIsVMAndPro(string name, string vm)
{
string sql = string.Format("select * from ProgramInfomation as pi left JOIN VersionManagement as vm on pi.ID=vm.ProgreamInformation_ID where pi.Name='{0}' and vm.Nuber>{1} order by Nuber", name, vm);
DataTable dataTable = null;
try
{
var ed = SQLite_Connection.QueryTab(sql);
dataTable = ed.Tables[0];
}
catch (Exception ex)
{
Log.WriteLine(DateTime.Now + ex.Message);
dataTable = dataTable is null ? new DataTable() : dataTable;
}
return(dataTable);
}