/// <summary>
/// 获取内容模板信息
/// </summary>
/// <param name="url"></param>
/// <param name="isMobile"></param>
void GetContentTemplate(string url, bool isMobile)
{
Console.WriteLine(url);
//url = url.Replace("." + BaseConfig.extension, "");
double dataTypeId = 0, rootId = 0, moduleId = 0, skinId = 0, id = 0, classId = 0;
TableHandle table = new TableHandle("maintable");
Dictionary <string, object> p = new Dictionary <string, object>();
p.Add("url", url);
Dictionary <string, object> variable = DAL.DAL.M("maintable").Field("dataTypeId,classId,id,skinId,moduleId, rootId").Where(new object[, ] {
{ "url", "=", url },
{ "orderId", ">", -1 }
}).Find();
if (variable == null)
{
throw new Exception("访问数据不存在");
}
moduleId = (double)variable["moduleId"];
rootId = (double)variable["rootId"];
dataTypeId = (double)variable["dataTypeId"];
skinId = (double)variable["skinId"];
id = (double)variable["id"];
classId = (double)variable["classId"];
if (skinId == 0)
{
Dictionary <string, object> rs = DAL.DAL.M("class").Field((isMobile ? "_contentSkinID" : "contentSkinID") + " contentSkinID").Get(classId);
if (rs != null)
{
skinId = rs["contentSkinID"].ToDouble();
}
}
DAL.Datatype.TableHandle T = new DAL.Datatype.TableHandle(dataTypeId);
variable = T.GetModel(id);
variable["attribute"] = "";
this.Variable = variable;
if (skinId > 0)
{
try
{
Get(skinId);
}
catch
{
Get(moduleId, rootId, 2, dataTypeId, isMobile);
}
}
else
{
Get(moduleId, rootId, 2, dataTypeId, isMobile);
}
}
/// <summary>
/// 获取内容模板信息
/// </summary>
/// <param name="url"></param>
/// <param name="isMobile"></param>
void GetContentTemplate(string url, bool isMobile)
{
//url = url.Replace("." + BaseConfig.extension, "");
double dataTypeId = 0, rootId = 0, moduleId = 0, skinId = 0, id = 0, classId = 0;
TableHandle table = new TableHandle("maintable");
Dictionary <string, object> p = new Dictionary <string, object>();
p.Add("url", url);
Dictionary <string, object> variable = table.GetModel("dataTypeId,classId,id,skinId,moduleId, rootId", "url=@url and orderId>-1", p);
if (variable == null)
{
throw new Exception("访问数据不存在");
}
moduleId = (double)variable["moduleId"];
rootId = (double)variable["rootId"];
dataTypeId = (double)variable["dataTypeId"];
skinId = (double)variable["skinId"];
id = (double)variable["id"];
classId = (double)variable["classId"];
MySqlDataReader rs = null;
if (skinId == 0)
{
rs = Sql.ExecuteReader("select " + (isMobile ? "_contentSkinID" : "contentSkinID") + " from class where id=@id", new MySqlParameter[] { new MySqlParameter("id", classId) });
if (rs.Read())
{
skinId = rs.IsDBNull(0) ? 0 : rs.GetDouble(0);
}
rs.Close();
}
DAL.Datatype.TableHandle T = new DAL.Datatype.TableHandle(dataTypeId);
variable = T.GetModel(id);
variable["attribute"] = "";
/*
* string tableName = (string)Helper.Sql.ExecuteScalar("select tableName from datatype where id=" + dataTypeId.ToString());
* rs = Helper.Sql.ExecuteReader("select * from " + tableName + " where id=@id", new MySqlParameter[] {
* new MySqlParameter("id",id)});
* if (rs.Read())
* {
* for (int i = 0; i < rs.FieldCount; i++)
* {
* string fieldName = rs.GetName(i);
*
* if (rs.IsDBNull(i))
* {
* variable[rs.GetName(i)] = "";
* }
* else
* {
* if (rs.GetDataTypeName(rs.GetOrdinal(fieldName)) == "ntext")
* {
* //SystemLink v1 = new SystemLink();
* string FieldValue = rs[i] + "";
* //FieldValue = v1.Replace(FieldValue);
* variable[fieldName] = FieldValue;
* }
* else
* {
* variable[fieldName] = rs[i];
* }
* }
* }
* }
* rs.Close();*/
this.Variable = variable;
if (skinId > 0)
{
try
{
Get(skinId);
}
catch
{
Get(moduleId, rootId, 2, dataTypeId, isMobile);
}
}
else
{
Get(moduleId, rootId, 2, dataTypeId, isMobile);
}
}
