/// <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)); }