public List<ExtensionImg> getExtensionImg(string Eid)
{
List<ExtensionImg> list = null;
try
{
IParameterMapper ipmapper = new getSubscribeInfoParameterMapper();
DataAccessor<ExtensionImg> tableAccessor;
string strSql = @" select e.EId,e.Photo from extension e where e.EId=@EId ";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<ExtensionImg>.
MapAllProperties().Map(t => t.Photo).ToColumn("Photo").Build());
list = tableAccessor.Execute(new string[] { Eid }).ToList();
return list;
}
catch (Exception ex)
{
Logger.Log(ex);
return null;
}
}
public List<Extension> getSubscribeInfo( string EId)
{
List<Extension> list = null;
try
{
IParameterMapper ipmapper = new getSubscribeInfoParameterMapper();
DataAccessor<Extension> tableAccessor;
string strSql = @" select e.CompanyId,e.Datetime,e.Econtent,e.EditMan,e.EId,e.Etype,e.OrderNo,e.Title ,p.Name
from extension e , Company p where e.CompanyId=p.id and e.EId=@EId ";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<Extension>.
MapAllProperties().Build());
list = tableAccessor.Execute(new string[] { EId }).ToList();
return list;
}
catch (Exception ex)
{
Logger.Log(ex);
return null;
}
}
public List <ExtensionImg> getExtensionImg(string Eid)
{
List <ExtensionImg> list = null;
try
{
IParameterMapper ipmapper = new getSubscribeInfoParameterMapper();
DataAccessor <ExtensionImg> tableAccessor;
string strSql = @" select e.EId,e.Photo from extension e where e.EId=@EId ";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <ExtensionImg> .
MapAllProperties().Map(t => t.Photo).ToColumn("Photo").Build());
list = tableAccessor.Execute(new string[] { Eid }).ToList();
return(list);
}
catch (Exception ex)
{
Logger.Log(ex);
return(null);
}
}
public List <Extension> getSubscribeInfo(string EId)
{
List <Extension> list = null;
try
{
IParameterMapper ipmapper = new getSubscribeInfoParameterMapper();
DataAccessor <Extension> tableAccessor;
string strSql = @" select e.CompanyId,e.Datetime,e.Econtent,e.EditMan,e.EId,e.Etype,e.OrderNo,e.Title ,p.Name
from extension e , Company p where e.CompanyId=p.id and e.EId=@EId ";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <Extension> .
MapAllProperties().Build());
list = tableAccessor.Execute(new string[] { EId }).ToList();
return(list);
}
catch (Exception ex)
{
Logger.Log(ex);
return(null);
}
}