public DataTable GetMaser(int productLineId)
{
string connectionString = ConnectionStringFactory.GetByProductLineId(productLineId);
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT VariableName, EquipmentName FROM ContrastTable WHERE Ismaster = 1";
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
return(dt);
}
public DataTable GetAlarmConfigure(int productLineId)
{
string connectionString = ConnectionStringFactory.GetByProductLineId(productLineId);
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT VariableName, EquipmentName, Ismaster, Belong, IsAlarm, StopPosition, AlarmPosition, AlarmMessage FROM ContrastTable WHERE Ismaster = 1 OR Belong is not null";
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
return(dt);
}
/// <summary>
/// 按生产线ID获取标签
/// </summary>
/// <param name="productLineId"></param>
/// <returns></returns>
public static DataTable GetLabelsByProductLineId(int productLineId)
{
string connectionString = ConnectionStringFactory.GetByProductLineId(productLineId);
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Query query = new Query("ContrastTable");
DataTable dt = factory.Query(query);
foreach (DataRow row in dt.Rows)
{
row["ViewName"] = ViewsDictionary.Current.GetChineseSafely(row["ViewName"].ToString().Trim());
}
return(dt);
}
