//----------------------------------------------------------
private List <Aligns> Init(string LogFilePath, string LogFileName, SqlCommand cmd)
{
List <Aligns> AlignList = new List <Aligns>();
SqlConnection con = db.getConnection();
cmd.Connection = con;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
Aligns m_Aligns = new Aligns(db.ConnectionString);
m_Aligns.AlignId = smartReader.GetByte("AlignId");
m_Aligns.AlignName = smartReader.GetString("AlignName");
m_Aligns.AlignDesc = smartReader.GetString("AlignDesc");
AlignList.Add(m_Aligns);
}
smartReader.DisposeReader(reader);
}
catch (SqlException ex)
{
LogFiles.WriteLog(ex.Message, LogFilePath + "\\Exception", LogFileName + "." + this.GetType().Name + "." + MethodBase.GetCurrentMethod().Name);
}
finally
{
con.Close();
}
return(AlignList);
}
//-----------------------------------------------------------------------
public static List <Aligns> Static_GetList(string LogFilePath, string LogFileName, string constr)
{
List <Aligns> RetVal = new List <Aligns>();
Aligns m_Aligns = new Aligns(constr);
try
{
RetVal = m_Aligns.GetList(LogFilePath, LogFileName);
}
catch (Exception ex)
{
LogFiles.WriteLog(ex.Message, LogFilePath + "\\Exception", LogFileName + "." + m_Aligns.GetType().Name + "." + MethodBase.GetCurrentMethod().Name);
}
return(RetVal);
}
//-------------------------------------------------------------
public Aligns Get(string LogFilePath, string LogFileName, string AlignName)
{
Aligns RetVal = new Aligns(db.ConnectionString);
try
{
List <Aligns> list = GetListByAlignName(LogFilePath, LogFileName, AlignName);
if (list.Count > 0)
{
RetVal = (Aligns)list[0];
}
}
catch (Exception ex)
{
LogFiles.WriteLog(ex.Message, LogFilePath + "\\Exception", LogFileName + "." + this.GetType().Name + "." + MethodBase.GetCurrentMethod().Name);
}
return(RetVal);
}
//-----------------------------------------------------------------------
public static string Static_GetName(string LogFilePath, string LogFileName, string constr, byte AllignId)
{
string RetVal = "";
Aligns m_Aligns = new Aligns(constr);
try
{
m_Aligns = m_Aligns.Get(LogFilePath, LogFileName, AllignId);
if (!string.IsNullOrEmpty(m_Aligns.AlignName))
{
RetVal = m_Aligns.AlignName;
}
}
catch (Exception ex)
{
LogFiles.WriteLog(ex.Message, LogFilePath + "\\Exception", LogFileName + "." + m_Aligns.GetType().Name + "." + MethodBase.GetCurrentMethod().Name);
}
return(RetVal);
}