public static List <HControl> GetByField(string Field, string Type)
{
try
{
List <HControl> fields = new List <HControl>();
string sql = @"select * from QLCV_FieldSetting where Field='" + Field + "' and Type='" + Type + "'";
DataTable table = ServerProvider.ExecuteToDataTable(sql);
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
HControl ctr = new HControl();
ctr.Control = row["Control"].ToString();
ctr.Attribute = row["Attribute"].ToString();
ctr.Value = row["Value"].ToString();
fields.Add(ctr);
}
}
return(fields);
}
catch (Exception ex)
{
return(null);
}
}
public static DataTable GetActive(string Type)
{
string sql = @"select * from QLCV_WebPage where Active=1 and Type='" + NumCode.UPWEB + "'";
DataTable dtTable = ServerProvider.ExecuteToDataTable(sql);
return(dtTable);
}
public static DataTable GetAll()
{
string sql = @"select * from QLCV_WebPage";
DataTable dtTable = ServerProvider.ExecuteToDataTable(sql);
return(dtTable);
}
public static DataTable GetByFieldDataTable(string Field, string Type)
{
try
{
string sql = @"select * from QLCV_FieldSetting where Field='" + Field + "' and Type='" + Type + "'";
return(ServerProvider.ExecuteToDataTable(sql));
}
catch (Exception ex)
{
return(null);
}
}
public static DataTable GetFieldForum()
{
try
{
string strSQL = "Select * From QLCV_FieldForum";
return(ServerProvider.ExecuteToDataTable(strSQL));
}
catch (Exception ex)
{
return(null);
}
}
public static WebPage GetByPage(string page)
{
string sql = @"select * from QLCV_WebPage where Page='" + page + "' and Type='" + NumCode.UPWEB + "'";
DataTable dtTable = ServerProvider.ExecuteToDataTable(sql);
if (dtTable.Rows.Count > 0)
{
WebPage cus = new WebPage();
return((WebPage)RootLibrary.GetObjectValue(dtTable.Rows[0], cus));
}
return(null);
}
public static WebPage Get(long ID)
{
string sql = @"select * from QLCV_WebPage where ID=" + ID;
DataTable dtTable = ServerProvider.ExecuteToDataTable(sql);
if (dtTable.Rows.Count > 0)
{
WebPage cus = new WebPage();
return((WebPage)RootLibrary.GetObjectValue(dtTable.Rows[0], cus));
}
return(null);
}
public static FieldSetting Get(long ID)
{
Type type = typeof(FieldSetting);
string sql = @"select * from QLCV_FieldSetting where ID=" + ID;
DataTable dtTable = ServerProvider.ExecuteToDataTable(sql);
if (dtTable.Rows.Count > 0)
{
FieldSetting cus = new FieldSetting();
return((FieldSetting)Common.GetObjectValue(dtTable.Rows[0], type, cus));
}
return(null);
}