/// <summary>
/// 取得Defect信息
/// </summary>
/// <param name="defectId">Defect标识</param>
/// <returns>Defect信息</returns>
public DefectInfo GetDefectInfo(string defectId)
{
DefectInfo defectInfo = new DefectInfo();
try
{
if (!String.IsNullOrEmpty(defectId))
{
string sqlStr = @"SELECT Defect, Type, Descr
FROM DefectCode
WHERE Defect=@Defect";
DataTable dt = SQLHelper.ExecuteDataFill(SQLHelper.ConnectionString_CFG(),
System.Data.CommandType.Text,
sqlStr,
SQLHelper.CreateSqlParameter("@Defect", 32, defectId));
foreach (DataRow dr in dt.Rows)
{
defectInfo.id = dr["Defect"].ToString().Trim();
defectInfo.friendlyName = dr["Descr"].ToString().Trim();
defectInfo.description = dr["Descr"].ToString().Trim();
}
}
return defectInfo;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 根据type,customer获取对应的Defect信息列表
/// </summary>
/// <param name="type">type</param>
/// <param name="customer">customer</param>
/// <returns>Defect信息列表</returns>
public IList<DefectInfo> GetDefectInfoByTypeAndCustomer(string type, string customer)
{
IList<DefectInfo> retLst = new List<DefectInfo>();
try
{
string sqlStr = @"SELECT Code, Description, Type
FROM DefectInfo
WHERE Type=@Type AND CustomerID= @CustomerID";
DataTable dt = SQLHelper.ExecuteDataFill(SQLHelper.ConnectionString_CFG(),
System.Data.CommandType.Text,
sqlStr,
SQLHelper.CreateSqlParameter("@Type", 32, type),
SQLHelper.CreateSqlParameter("@CustomerID", 32, customer));
foreach (DataRow dr in dt.Rows)
{
DefectInfo item = new DefectInfo();
item.id = dr["Code"].ToString().Trim();
item.friendlyName = dr["Descr"].ToString().Trim();
item.description = dr["Descr"].ToString().Trim();
retLst.Add(item);
}
return retLst;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 取得Defect列表
/// </summary>
/// <param name="type">类型</param>
/// <returns>Defect信息列表</returns>
public IList<DefectInfo> GetDefectList(string type)
{
IList<DefectInfo> retLst = new List<DefectInfo>();
try
{
if (!String.IsNullOrEmpty(type))
{
string sqlStr =@"SELECT Defect, Type, Descr
FROM DefectCode
WHERE Type=@Type";
DataTable dt= SQLHelper.ExecuteDataFill(SQLHelper.ConnectionString_CFG(),
System.Data.CommandType.Text,
sqlStr,
SQLHelper.CreateSqlParameter("@Type",32,type));
foreach (DataRow dr in dt.Rows)
{
DefectInfo item = new DefectInfo();
item.id = dr["Defect"].ToString().Trim();
item.friendlyName = dr["Descr"].ToString().Trim();
item.description = dr["Descr"].ToString().Trim();
retLst.Add(item);
}
}
return retLst;
}
catch (Exception)
{
throw;
}
}