/// <summary> /// 创建皮肤 /// </summary> /// <param name="skin">皮肤实体</param> /// <returns></returns> public int CreateSkin(Skin skin) { SqlParameter sp0 = new SqlParameter("@Id", SqlDbType.VarChar, 36); sp0.Value = skin.Id; SqlParameter sp1 = new SqlParameter("@Name", SqlDbType.NVarChar, 50); sp1.Value = skin.Name; SqlParameter sp2 = new SqlParameter("@Pic", SqlDbType.NVarChar, 255); sp2.Value = skin.Pic; SqlParameter sp3 = new SqlParameter("@Info", SqlDbType.NVarChar, 255); sp3.Value = skin.WebKeyWords; SqlParameter sp5 = new SqlParameter("@Filename", SqlDbType.NVarChar, 100); sp5.Value = skin.Filename; SqlParameter sp4 = new SqlParameter("@reValue", SqlDbType.Int, 36); sp4.Direction = ParameterDirection.Output; string[] reValues = conn.Execute("SP_Skin_CreateSkin", new SqlParameter[] { sp0, sp1, sp2, sp3, sp4,sp5}, new int[] { 4 }); if (reValues != null) { int rtn = (int)Convert.ChangeType(reValues[0], typeof(int)); return rtn; } return -19000000; }
/// <summary> /// 创建皮肤 /// </summary> /// <param name="skin">皮肤实体</param> /// <returns></returns> public int CreateSkin(Skin skin) { string errText = string.Empty; string s_cont = string.Empty; int rtn = MsSqlFactory.conn.m_ExecuteScalar(ref errText, "SELECT COUNT(1) FROM Skin WHERE id = '" + skin.Id + "'", ref s_cont); if (rtn < 0) return rtn; int count = objectHandlers.ToInt(s_cont); string sql = "UPDATE Skin SET [Name]='" + skin.Name + "',Pic='" + skin.Pic + "',WebDescription='" + skin.WebDescription + "',Filename='" + skin.Filename + "',IndexPage='" + skin.IndexPage + "',WebKeyWords='" + skin.WebKeyWords + "' WHERE id = '" + skin.Id + "'"; if (count == 0) { sql = "INSERT INTO Skin (ID,[NAME],PIC,WebDescription,Filename,IndexPage,WebKeyWords) VALUES('" + skin.Id + "','" + skin.Name + "','" + skin.Pic + "','" + skin.WebDescription + "','" + skin.Filename + "','" + skin.IndexPage + "','" + skin.WebKeyWords + "')"; } return MsSqlFactory.conn.m_RunSQL(ref errText, sql); }
/// <summary> /// 修改皮肤 /// </summary> /// <param name="skin">皮肤实体</param> /// <returns></returns> public int UpdateSkin(Skin skin) { return -19000000; }
private void LoadSkinFiles() { DirectoryInfo dinfo = new DirectoryInfo(Server.MapPath("~/skin")); FileSystemInfo[] fsinfos = dinfo.GetFileSystemInfos(); foreach (FileSystemInfo fsinfo in fsinfos) { FileInfo finfo = new FileInfo(fsinfo.FullName); FileSystemInfo[] files = new DirectoryInfo(finfo.FullName).GetFileSystemInfos(); foreach (FileSystemInfo file in files) { string path = file.FullName; string filename = file.Name; if (filename == "skin.config") { XmlDocument document = new XmlDocument(); document.Load(path); XmlNodeList nodelist = document.GetElementsByTagName("Skin"); if (nodelist != null && nodelist.Count == 1) { Skin skin = new Skin(); skin.Id = nodelist[0].SelectSingleNode("Id").InnerText.ToString(); skin.WebDescription = nodelist[0].SelectSingleNode("WebDescription").InnerText.ToString(); skin.Name = nodelist[0].SelectSingleNode("Name").InnerText.ToString(); skin.Pic = nodelist[0].SelectSingleNode("Pic").InnerText.ToString(); skin.IndexPage = nodelist[0].SelectSingleNode("IndexPage").InnerText.ToString(); skin.WebKeyWords = nodelist[0].SelectSingleNode("WebKeyWords").InnerText.ToString(); skin.Filename = finfo.Name; int rtn = base.handlerService.skinService.skinHandlers.CreateSkin(skin); } } } } CachingService.Remove(CachingService.CACHING_ALL_SKIN_ENTITY); CachingService.Remove(CachingService.CACHING_ALL_SKIN); }
/// <summary> /// 从记录行中得到实体 /// </summary> /// <param name="?"></param> /// <param name="type"></param> /// <returns></returns> public EntityBase GetEntityObjectFromRow(DataRow row, Type type) { if (row == null) return null; switch (type.ToString()) { case "TCG.Entity.Categories": Categories categories = new Categories(); categories.Id = row["Id"].ToString().Trim(); categories.ResourceListTemplate = this.handlerService.skinService.templateHandlers.GetTemplateByID(row["iListTemplate"].ToString()); categories.iOrder = (int)row["iOrder"]; categories.Parent = row["Parent"].ToString().Trim(); categories.ResourceTemplate = this.handlerService.skinService.templateHandlers.GetTemplateByID(row["iTemplate"].ToString()); categories.vcClassName = row["vcClassName"].ToString().Trim(); categories.vcDirectory = row["vcDirectory"].ToString().Trim(); categories.vcName = row["vcName"].ToString().Trim(); categories.vcUrl = row["vcUrl"].ToString().Trim(); categories.dUpdateDate = (DateTime)row["dUpdateDate"]; categories.cVisible = row["Visible"].ToString().Trim(); categories.DataBaseService = row["DataBaseService"].ToString().Trim(); //categories.SkinInfo = row["SkinId"].ToString().Trim(); return (EntityBase)categories; case "TCG.Entity.Resources": Resources resources = new Resources(); resources.Id = row["iId"].ToString(); resources.vcTitle = row["vcTitle"].ToString(); resources.Categorie = this.handlerService.skinService.categoriesHandlers.GetCategoriesById(row["iClassID"].ToString()); resources.vcUrl = (string)row["vcUrl"].ToString(); resources.vcContent = (string)row["vcContent"].ToString().Trim(); resources.vcAuthor = (string)row["vcAuthor"].ToString().Trim(); resources.iCount = (int)row["iCount"]; resources.vcKeyWord = (string)row["vcKeyWord"].ToString().Trim(); resources.vcEditor = (string)row["vcEditor"].ToString().Trim(); resources.cCreated = (string)row["cCreated"].ToString().Trim(); resources.vcSmallImg = (string)row["vcSmallImg"].ToString().Trim(); resources.vcBigImg = (string)row["vcBigImg"].ToString().Trim(); resources.vcShortContent = (string)row["vcShortContent"].ToString().Trim(); resources.vcSpeciality = (string)row["vcSpeciality"].ToString().Trim(); resources.cChecked = (string)row["cChecked"].ToString().Trim(); resources.cDel = (string)row["cDel"].ToString().Trim(); resources.cPostByUser = (string)row["cPostByUser"].ToString().Trim(); resources.vcFilePath = (string)row["vcFilePath"].ToString().Trim(); resources.dAddDate = (DateTime)row["dAddDate"]; resources.dUpDateDate = (DateTime)row["dUpDateDate"]; resources.vcTitleColor = (string)row["vcTitleColor"].ToString().Trim(); resources.cStrong = (string)row["cStrong"].ToString().Trim(); resources.SheifUrl = (string)row["SheifUrl"].ToString().Trim(); CachingService.Set(resources.Id, resources, null); return (EntityBase)resources; case "TCG.Entity.Template": Template template = new Template(); template.Id = row["Id"].ToString(); //template.SkinInfo = row["SkinId"].ToString(); template.TemplateType = this.handlerService.skinService.templateHandlers.GetTemplateType((int)row["TemplateType"]); template.iParentId = row["iParentId"].ToString(); template.iSystemType = (int)row["iSystemType"]; template.vcTempName = (string)row["vcTempName"]; template.Content = (string)row["vcContent"]; template.vcUrl = (string)row["vcUrl"]; template.dAddDate = (DateTime)row["dAddDate"]; template.dUpdateDate = (DateTime)row["dUpdateDate"]; return (EntityBase)template; case "TCG.Entity.Skin": Skin skin = new Skin(); skin.Id = row["Id"].ToString().Trim(); skin.Name = row["Name"].ToString().Trim(); skin.Pic = row["Pic"].ToString().Trim(); //skin.Info = row["info"].ToString().Trim(); skin.Filename = row["Filename"].ToString().Trim(); return (EntityBase)skin; case "TCG.Entity.SheifSourceInfo": SheifSourceInfo sourceinfo = new SheifSourceInfo(); sourceinfo.Id = row["ID"].ToString().Trim(); sourceinfo.SourceName = row["SourceName"].ToString().Trim(); sourceinfo.SourceUrl = row["SourceUrl"].ToString().Trim(); sourceinfo.CharSet = row["CharSet"].ToString().Trim(); sourceinfo.ListAreaRole = row["ListAreaRole"].ToString().Trim(); sourceinfo.TopicListRole = row["TopicListRole"].ToString().Trim(); sourceinfo.TopicListDataRole = row["TopicListDataRole"].ToString().Trim(); sourceinfo.TopicRole = row["TopicRole"].ToString().Trim(); sourceinfo.TopicDataRole = row["TopicDataRole"].ToString().Trim(); sourceinfo.TopicPagerOld = row["TopicPagerOld"].ToString().Trim(); sourceinfo.TopicPagerTemp = row["TopicPagerTemp"].ToString().Trim(); sourceinfo.IsRss = (bool)row["IsRss"]; return (EntityBase)sourceinfo; case "TCG.Entity.FileCategories": FileCategories filecagegories = new FileCategories(); filecagegories.Id = row["iId"].ToString(); filecagegories.iParentId = objectHandlers.ToInt(row["iParentId"]); filecagegories.dCreateDate = objectHandlers.ToTime(row["dCreateDate"].ToString()); filecagegories.vcFileName = row["vcFileName"].ToString().Trim(); filecagegories.vcMeno = row["vcMeno"].ToString().Trim(); filecagegories.vcKey = row["vcKey"].ToString().Trim(); filecagegories.MaxSpace = objectHandlers.ToLong(row["MaxSpace"]); filecagegories.Space = objectHandlers.ToLong(row["Space"]); return (EntityBase)filecagegories; case "TCG.Entity.FileResources": FileResources fileresource = new FileResources(); fileresource.Id = row["iID"].ToString().Trim(); fileresource.iClassId = (int)row["iClassId"]; fileresource.iSize = (int)row["iSize"]; fileresource.vcFileName = row["vcFileName"].ToString().Trim(); fileresource.vcIP = row["vcIP"].ToString().Trim(); fileresource.vcType = row["vcType"].ToString().Trim(); fileresource.iRequest = (int)row["iRequest"]; fileresource.iDowns = (int)row["iDowns"]; fileresource.dCreateDate = (DateTime)row["dCreateDate"]; return (EntityBase)fileresource; case "TCG.Entity.SheifCategorieConfig": SheifCategorieConfig sheifcategorieconfig = new SheifCategorieConfig(); sheifcategorieconfig.Id = row["Id"].ToString(); sheifcategorieconfig.SheifSourceId = row["SheifSourceId"].ToString().Trim(); sheifcategorieconfig.LocalCategorieId = row["LocalCategorieId"].ToString().Trim(); sheifcategorieconfig.ResourceCreateDateTime = objectHandlers.ToTime(row["ResourceCreateDateTime"].ToString().Trim()); return (EntityBase)sheifcategorieconfig; } return null; }
/// <summary> /// 修改皮肤 /// </summary> /// <param name="skin">皮肤实体</param> /// <returns></returns> public int UpdateSkin(Skin skin) { return DataBaseFactory.SkinHandlers.UpdateSkin(skin); }
/// <summary> /// 从记录行中得到实体 /// </summary> /// <param name="?"></param> /// <param name="type"></param> /// <returns></returns> public static EntityBase GetEntityObjectFromRow(DataRow row, Type type) { if (row == null) return null; switch (type.ToString()) { case "TCG.Entity.Categories": Categories categories = new Categories(); categories.Id = row["Id"].ToString().Trim(); categories.ResourceListTemplate = templateHandlers.GetTemplateByID(row["iListTemplate"].ToString()); categories.iOrder = (int)row["iOrder"]; categories.Parent = row["Parent"].ToString().Trim(); categories.ResourceTemplate = templateHandlers.GetTemplateByID(row["iTemplate"].ToString()); categories.vcClassName = row["vcClassName"].ToString().Trim(); categories.vcDirectory = row["vcDirectory"].ToString().Trim(); categories.vcName = row["vcName"].ToString().Trim(); categories.vcUrl = row["vcUrl"].ToString().Trim(); categories.dUpdateDate = (DateTime)row["dUpdateDate"]; categories.cVisible = row["Visible"].ToString().Trim(); categories.DataBaseService = row["DataBaseService"].ToString().Trim(); categories.SkinInfo = skinHandlers.GetSkinEntityBySkinId(row["SkinId"].ToString().Trim()); categories.IsSinglePage = row["IsSinglePage"].ToString().Trim(); categories.vcPic = row["vcPic"].ToString().Trim(); categories.vcSpeciality = (row["vcSpeciality"] == null) ? "" : row["vcSpeciality"].ToString(); return (EntityBase)categories; case "TCG.Entity.Resources": Resources resources = new Resources(); resources.Id = row["Id"].ToString(); resources.vcTitle = row["vcTitle"].ToString(); resources.Categorie = categoriesHandlers.GetCategoriesById(row["iClassID"].ToString()); resources.vcUrl = (string)row["vcUrl"].ToString(); resources.vcContent = (string)row["vcContent"].ToString().Trim(); resources.vcAuthor = (string)row["vcAuthor"].ToString().Trim(); resources.iCount = (int)row["iCount"]; resources.vcKeyWord = (string)row["vcKeyWord"].ToString().Trim(); resources.vcEditor = (string)row["vcEditor"].ToString().Trim(); resources.cCreated = (string)row["cCreated"].ToString().Trim(); resources.vcSmallImg = (string)row["vcSmallImg"].ToString().Trim(); resources.vcBigImg = (string)row["vcBigImg"].ToString().Trim(); resources.vcShortContent = (string)row["vcShortContent"].ToString().Trim(); resources.vcSpeciality = (string)row["vcSpeciality"].ToString().Trim(); resources.cChecked = (string)row["cChecked"].ToString().Trim(); resources.cDel = (string)row["cDel"].ToString().Trim(); resources.cPostByUser = (string)row["cPostByUser"].ToString().Trim(); resources.vcFilePath = (string)row["vcFilePath"].ToString().Trim(); resources.dAddDate = (DateTime)row["dAddDate"]; resources.dUpDateDate = (DateTime)row["dUpDateDate"]; resources.vcTitleColor = (string)row["vcTitleColor"].ToString().Trim(); resources.cStrong = (string)row["cStrong"].ToString().Trim(); resources.SheifUrl = (string)row["SheifUrl"].ToString().Trim(); resources.PropertiesCategorieId = objectHandlers.ToInt(row["PropertiesCategorieId"]); resources.CCCategories = row["CCCategories"].ToString(); CachingService.Set(resources.Id, resources, null); return (EntityBase)resources; case "TCG.Entity.Template": Template template = new Template(); template.Id = row["Id"].ToString(); template.SkinInfo = skinHandlers.GetSkinEntityBySkinId(row["SkinId"].ToString()); template.TemplateType = templateHandlers.GetTemplateType((int)row["TemplateType"]); template.iParentId = row["iParentId"].ToString(); template.iSystemType = (int)row["iSystemType"]; template.vcTempName = (string)row["vcTempName"]; template.Content = (string)row["vcContent"]; template.vcUrl = (string)row["vcUrl"]; template.dAddDate = (DateTime)row["dAddDate"]; template.dUpdateDate = (DateTime)row["dUpdateDate"]; return (EntityBase)template; case "TCG.Entity.Skin": Skin skin = new Skin(); skin.Id = row["Id"].ToString().Trim(); skin.Name = row["Name"].ToString().Trim(); skin.Pic = row["Pic"].ToString().Trim(); skin.WebDescription = row["WebDescription"].ToString().Trim(); skin.Filename = row["Filename"].ToString().Trim(); skin.WebKeyWords = row["WebKeyWords"].ToString().Trim(); skin.IndexPage = row["IndexPage"].ToString().Trim(); return (EntityBase)skin; case "TCG.Entity.SheifSourceInfo": SheifSourceInfo sourceinfo = new SheifSourceInfo(); sourceinfo.Id = row["ID"].ToString().Trim(); sourceinfo.SourceName = row["SourceName"].ToString().Trim(); sourceinfo.SourceUrl = row["SourceUrl"].ToString().Trim(); sourceinfo.CharSet = row["CharSet"].ToString().Trim(); sourceinfo.ListAreaRole = row["ListAreaRole"].ToString().Trim(); sourceinfo.TopicListRole = row["TopicListRole"].ToString().Trim(); sourceinfo.TopicListDataRole = row["TopicListDataRole"].ToString().Trim(); sourceinfo.TopicRole = row["TopicRole"].ToString().Trim(); sourceinfo.TopicDataRole = row["TopicDataRole"].ToString().Trim(); sourceinfo.TopicPagerOld = row["TopicPagerOld"].ToString().Trim(); sourceinfo.TopicPagerTemp = row["TopicPagerTemp"].ToString().Trim(); sourceinfo.IsRss = (bool)row["IsRss"]; return (EntityBase)sourceinfo; case "TCG.Entity.FileCategories": //FileCategories filecagegories = new FileCategories(); //filecagegories.Id = row["iId"].ToString(); //filecagegories.iParentId = objectHandlers.ToInt(row["iParentId"]); //filecagegories.dCreateDate = objectHandlers.ToTime(row["dCreateDate"].ToString()); //filecagegories.vcFileName = row["vcFileName"].ToString().Trim(); //filecagegories.vcMeno = row["vcMeno"].ToString().Trim(); //filecagegories.vcKey = row["vcKey"].ToString().Trim(); //filecagegories.MaxSpace = objectHandlers.ToLong(row["MaxSpace"]); //filecagegories.Space = objectHandlers.ToLong(row["Space"]); //return (EntityBase)filecagegories; case "TCG.Entity.FileResources": //FileResources fileresource = new FileResources(); //fileresource.Id = row["iID"].ToString().Trim(); //fileresource.iClassId = (int)row["iClassId"]; //fileresource.iSize = (int)row["iSize"]; //fileresource.vcFileName = row["vcFileName"].ToString().Trim(); //fileresource.vcIP = row["vcIP"].ToString().Trim(); //fileresource.vcType = row["vcType"].ToString().Trim(); //fileresource.iRequest = (int)row["iRequest"]; //fileresource.iDowns = (int)row["iDowns"]; //fileresource.dCreateDate = (DateTime)row["dCreateDate"]; //return (EntityBase)fileresource; case "TCG.Entity.SheifCategorieConfig": SheifCategorieConfig sheifcategorieconfig = new SheifCategorieConfig(); sheifcategorieconfig.Id = row["Id"].ToString(); sheifcategorieconfig.SheifSourceId = row["SheifSourceId"].ToString().Trim(); sheifcategorieconfig.LocalCategorieId = row["LocalCategorieId"].ToString().Trim(); sheifcategorieconfig.ResourceCreateDateTime = objectHandlers.ToTime(row["ResourceCreateDateTime"].ToString().Trim()); return (EntityBase)sheifcategorieconfig; case "TCG.Entity.Properties": Properties categorieProperties = new Properties(); categorieProperties.Id = row["Id"].ToString(); categorieProperties.ProertieName = row["ProertieName"].ToString(); categorieProperties.PropertiesCategorieId = row["PropertiesCategorieId"].ToString(); categorieProperties.Type = row["Type"].ToString(); categorieProperties.Values = row["Values"].ToString(); categorieProperties.width = objectHandlers.ToInt(row["width"].ToString()); categorieProperties.height = objectHandlers.ToInt(row["height"].ToString()); categorieProperties.iOrder = objectHandlers.ToInt(row["iOrder"].ToString()); return (EntityBase)categorieProperties; case "TCG.Entity.ResourceProperties": ResourceProperties rategorieProperties = new ResourceProperties(); rategorieProperties.Id = row["Id"].ToString(); rategorieProperties.ResourceId = row["ResourceId"].ToString(); rategorieProperties.PropertieName = row["PropertieName"].ToString(); rategorieProperties.PropertieValue = row["PropertieValue"].ToString(); rategorieProperties.PropertieId = objectHandlers.ToInt(row["PropertieId"].ToString()); rategorieProperties.iOrder = objectHandlers.ToInt(row["iOrder"].ToString()); return (EntityBase)rategorieProperties; case "TCG.Entity.PropertiesCategorie": PropertiesCategorie pc = new PropertiesCategorie(); pc.CategoriePropertiesName = row["CategoriePropertiesName"].ToString(); pc.Id = row["Id"].ToString(); pc.Visible = row["Visible"].ToString(); pc.Visible = row["Visible"].ToString(); return (EntityBase)pc; case "TCG.Entity.Speciality": Speciality speciality = new Speciality(); speciality.Id = row["Id"].ToString(); speciality.SkinId = (string)row["SkinId"]; speciality.iParent = (int)row["iParent"]; speciality.vcTitle = (string)row["vcTitle"]; speciality.vcExplain = (string)row["vcExplain"]; speciality.dUpDateDate = (DateTime)row["dUpDateDate"]; return (EntityBase)speciality; case "TCG.Entity.FeedBack": FeedBack feedBack = new FeedBack(); feedBack.Id = row["Id"].ToString(); feedBack.UserName = row["UserName"].ToString(); feedBack.Tel = row["Tel"].ToString(); feedBack.QQ = row["QQ"].ToString(); feedBack.Content = row["Content"].ToString(); feedBack.AddDate = objectHandlers.ToTime(row["AddDate"].ToString()); feedBack.Ip = row["Ip"].ToString(); feedBack.SkinId = row["SkinId"].ToString(); feedBack.Title = row["Title"].ToString(); feedBack.Email = row["Email"].ToString(); return (EntityBase)feedBack; } return null; }