private ModelInfoNameAndModelInfoValueMaintainInfo convertToMaintainInfoFromObj(ModelInfoNameAndModelInfoValue temp)
{
ModelInfoNameAndModelInfoValueMaintainInfo modelInfo = new ModelInfoNameAndModelInfoValueMaintainInfo();
modelInfo.Name = temp.Name;
modelInfo.Value = temp.Value;
modelInfo.Editor = temp.Editor;
modelInfo.Cdt = temp.Cdt;
modelInfo.Udt = temp.Udt;
modelInfo.Id = temp.ID;
modelInfo.Description = temp.Description;
return modelInfo;
}
public IList<ModelInfoNameAndModelInfoValueMaintainInfo> GetModelInfoNameAndModelInfoValueListByModels(IList<string> models)
{
try
{
IList<ModelInfoNameAndModelInfoValueMaintainInfo> ret = new List<ModelInfoNameAndModelInfoValueMaintainInfo>();
string SQLStatement = @"SELECT B.Name AS Name, B.Description AS Description, ISNULL(A.Value,'') AS Value,A.Editor AS Editor, A.Cdt AS Cdt, A.Udt AS Udt, A.ID AS ID
FROM (SELECT Model, Name, Value, Editor, Cdt, Udt, ID FROM ModelInfo NOLOCK WHERE Model in ('{0}') ) AS A
RIGHT OUTER JOIN ModelInfoName AS B with(NOLOCK) ON A.Name=B.Name ORDER BY Region,Name";
SQLStatement = string.Format(SQLStatement, string.Join("','", models.ToArray()));
using (DataTable dt = _Schema.SqlHelper.ExecuteDataFill(_Schema.SqlHelper.ConnectionString_GetData,
CommandType.Text, SQLStatement))
{
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ModelInfoNameAndModelInfoValueMaintainInfo item = new ModelInfoNameAndModelInfoValueMaintainInfo();
item.Name = ObjToString(dr["Name"]);
item.Description = ObjToString(dr["Description"]);
item.Value = ObjToString(dr["Value"]);
item.Editor = ObjToString(dr["Editor"]);
if (!"".Equals( ObjToString(dr["Cdt"])))
item.Cdt = DateTime.Parse(dr["Cdt"].ToString());
if (!"".Equals(ObjToString(dr["Udt"])))
item.Udt = DateTime.Parse(dr["Udt"].ToString());
if (!"".Equals(ObjToString(dr["ID"])))
item.Id = (long)dr["ID"];
ret.Add(item);
}
}
}
return ret;
}
catch (Exception)
{
throw;
}
}
//modelinfo
public IList<ModelInfoNameAndModelInfoValueMaintainInfo> GetModelInfoList(string strModelName)
{
IList<ModelInfoNameAndModelInfoValueMaintainInfo> modelInfoList = new List<ModelInfoNameAndModelInfoValueMaintainInfo>();
try
{
IList<ModelInfoNameAndModelInfoValue> tmpModelObj = modelRepository.GetModelInfoNameAndModelInfoValueListByModel(strModelName);
foreach (ModelInfoNameAndModelInfoValue temp in tmpModelObj)
{
ModelInfoNameAndModelInfoValueMaintainInfo modelinfo = new ModelInfoNameAndModelInfoValueMaintainInfo();
modelinfo = convertToMaintainInfoFromObj(temp);
modelInfoList.Add(modelinfo);
}
}
catch (FisException e)
{
logger.Error(e.mErrmsg);
throw e;
}
catch (Exception e)
{
logger.Error(e.Message);
throw;
}
return modelInfoList;
}
