/// <summary>
/// 转换数据实体
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private static Model.Contents TranEntity(DataRow dr)
{
Model.Contents model = new Model.Contents();
if (dr["CID"] != null)
{
model.CID = dr["CID"].ToString();
}
if (dr["CTitle"] != null)
{
model.CTitle = dr["CTitle"].ToString();
}
if (dr["CLevel"] != null)
{
model.CLevel = int.Parse(dr["CLevel"].ToString());
}
if (dr["CIndex"] != null)
{
model.CIndex = int.Parse(dr["CIndex"].ToString());
}
if (dr["CAddress"] != null)
{
model.CAddress = dr["CAddress"].ToString();
}
if (dr["CFID"] != null)
{
model.CFID = dr["CFID"].ToString();
}
if (dr["CImage"] != null)
{
model.CImage = dr["CImage"].ToString();
}
if (dr["CState"].ToString() != "")
{
model.CState = bool.Parse(dr["CState"].ToString());
}
if (dr["VState"].ToString() != "")
{
model.VState = bool.Parse(dr["VState"].ToString());;
}
if (dr["IsQuickMenu"].ToString() != "")
{
model.IsQuickMenu = bool.Parse(dr["IsQuickMenu"].ToString());;
}
model.Remark = dr["Remark"].ToString();
if (dr["IsOuterLink"].ToString() != "")
{
model.IsOuterLink = bool.Parse(dr["IsOuterLink"].ToString());;
}
model.OuterAddress = dr["OuterAddress"].ToString();
return(model);
}
public void Write(Model.Contents contents)
{
_xDoc.Element("result").Add(
new XElement("row",
new XElement("idx", contents.Idx),
new XElement("title", new XCData(contents.Title)),
new XElement("summary", new XCData(contents.Summary)),
new XElement("create_date", contents.CreateDt),
new XElement("create_user", new XCData(contents.CreateUserNm)),
new XElement("tags", new XCData(contents.Tags))
));
}
public static bool Update(Model.Contents model)
{
StringBuilder sb = new StringBuilder("update Contents set ");
sb.Append("CTitle=@CTitle,");
sb.Append("CLevel=@CLevel,");
sb.Append("CAddress=@CAddress,");
sb.Append("CFID=@CFID,");
sb.Append("CState=@CState,");
sb.Append("CIndex=@CIndex,");
sb.Append("CImage=@CImage,");
sb.Append("VState=@VState,");
sb.Append("IsQuickMenu=@IsQuickMenu,");
sb.Append("Remark=@Remark,");
sb.Append("IsOuterLink=@IsOuterLink,");
sb.Append("OuterAddress=@OuterAddress");
sb.Append(" where ");
sb.Append("CID=@CID");
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CID", SqlDbType.VarChar, 10),
new SqlParameter("@CTitle", SqlDbType.VarChar, 50),
new SqlParameter("@CLevel", SqlDbType.Int, 4),
new SqlParameter("@CAddress", SqlDbType.VarChar, 100),
new SqlParameter("@CFID", SqlDbType.VarChar, 10),
new SqlParameter("@CState", SqlDbType.Bit, 1),
new SqlParameter("@CIndex", SqlDbType.Int, 4),
new SqlParameter("@CImage", SqlDbType.VarChar, 100),
new SqlParameter("@VState", SqlDbType.Bit, 1),
new SqlParameter("@IsQuickMenu", SqlDbType.Bit, 1),
new SqlParameter("@Remark", SqlDbType.VarChar, 150),
new SqlParameter("@IsOuterLink", SqlDbType.Bit, 1),
new SqlParameter("@OuterAddress", SqlDbType.VarChar, 150)
};
para[0].Value = model.CID;
para[1].Value = model.CTitle;
para[2].Value = model.CLevel;
para[3].Value = model.CAddress;
para[4].Value = model.CFID;
para[5].Value = model.CState;
para[6].Value = model.CIndex;
para[7].Value = model.CImage;
para[8].Value = model.VState;
para[9].Value = model.IsQuickMenu;
para[10].Value = model.Remark;
para[11].Value = model.IsOuterLink;
para[12].Value = model.OuterAddress;
List = null;
return(DbHelperSQL.ExecuteSql(sb.ToString(), para) > 0);
}
public static bool SaveOrUpdate(Model.Contents obj, bool isSave)
{
bool result = false;
if (isSave) //需要插入的
{
result = DAL.Contents.Insert(obj);
}
else
{
//需要更新的
result = DAL.Contents.Update(obj);
}
return(result);
}
public static bool Insert(Model.Contents model)
{
StringBuilder sb = new StringBuilder("insert into Contents");
sb.Append("([CID],[CTitle],[CLevel],[CAddress],[CFID],[CState],[CIndex],[CImage],[VState],[IsQuickMenu],[Remark],IsOuterLink,OuterAddress)");
sb.Append("values");
sb.Append("(@CID,@CTitle,@CLevel,@CAddress,@CFID,@CState,@CIndex,@CImage,@VState,@IsQuickMenu,@Remark,@IsOuterLink,@OuterAddress)");
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CID", SqlDbType.VarChar, 10),
new SqlParameter("@CTitle", SqlDbType.VarChar, 50),
new SqlParameter("@CLevel", SqlDbType.Int, 4),
new SqlParameter("@CAddress", SqlDbType.VarChar, 100),
new SqlParameter("@CFID", SqlDbType.VarChar, 10),
new SqlParameter("@CState", SqlDbType.Bit, 1),
new SqlParameter("@CIndex", SqlDbType.Int, 4),
new SqlParameter("@CImage", SqlDbType.VarChar, 100),
new SqlParameter("@VState", SqlDbType.Bit, 1),
new SqlParameter("@IsQuickMenu", SqlDbType.Bit, 1),
new SqlParameter("@Remark", SqlDbType.VarChar, 150),
new SqlParameter("@IsOuterLink", SqlDbType.Bit, 1),
new SqlParameter("@OuterAddress", SqlDbType.VarChar, 150)
};
para[0].Value = model.CID;
para[1].Value = model.CTitle;
para[2].Value = model.CLevel;
para[3].Value = model.CAddress;
para[4].Value = model.CFID;
para[5].Value = model.CState;
para[6].Value = model.CIndex;
para[7].Value = model.CImage;
para[8].Value = model.VState;
para[9].Value = model.IsQuickMenu;
para[10].Value = model.Remark;
para[11].Value = model.IsOuterLink;
para[12].Value = model.OuterAddress;
List = null;
return(DbHelperSQL.ExecuteSql(sb.ToString(), para) > 0);
}
public static bool Update(Model.Contents model)
{
return(DAL.Contents.Update(model));
}
public static bool Insert(Model.Contents model)
{
return(DAL.Contents.Insert(model));
}
