protected string ViewTitle(int _kindId, int _parentId) { string str = "错误,暂无找到该信息标题!"; switch (_kindId) { case (int)Channel.Article: DtCms.BLL.Article abll = new DtCms.BLL.Article(); DtCms.Model.Article amodel = abll.GetModel(_parentId); if (amodel != null) { str = amodel.Title; } break; case (int)Channel.Pictures: DtCms.BLL.Pictures pbll = new DtCms.BLL.Pictures(); DtCms.Model.Pictures pmodel = pbll.GetModel(_parentId); if (pmodel != null) { str = pmodel.Title; } break; case (int)Channel.Downloads: DtCms.BLL.Downloads dbll = new DtCms.BLL.Downloads(); DtCms.Model.Downloads dmodel = dbll.GetModel(_parentId); if (dmodel != null) { str = dmodel.Title; } break; } return(str); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DtCms.Model.Downloads model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_Downloads("); strSql.Append("Title,ClassId,ImgUrl,FileType,FileSize,FilePath,Click,DownNum,Content,IsMsg,IsRed,IsLock,AddTime)"); strSql.Append(" values ("); strSql.Append("@Title,@ClassId,@ImgUrl,@FileType,@FileSize,@FilePath,@Click,@DownNum,@Content,@IsMsg,@IsRed,@IsLock,@AddTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@ClassId", SqlDbType.Int, 4), new SqlParameter("@ImgUrl", SqlDbType.NVarChar, 250), new SqlParameter("@FileType", SqlDbType.NVarChar, 30), new SqlParameter("@FileSize", SqlDbType.Int, 4), new SqlParameter("@FilePath", SqlDbType.NVarChar, 250), new SqlParameter("@Click", SqlDbType.Int, 4), new SqlParameter("@DownNum", SqlDbType.Int, 4), new SqlParameter("@Content", SqlDbType.NText), new SqlParameter("@IsMsg", SqlDbType.Int, 4), new SqlParameter("@IsRed", SqlDbType.Int, 4), new SqlParameter("@IsLock", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.DateTime) }; parameters[0].Value = model.Title; parameters[1].Value = model.ClassId; parameters[2].Value = model.ImgUrl; parameters[3].Value = model.FileType; parameters[4].Value = model.FileSize; parameters[5].Value = model.FilePath; parameters[6].Value = model.Click; parameters[7].Value = model.DownNum; parameters[8].Value = model.Content; parameters[9].Value = model.IsMsg; parameters[10].Value = model.IsRed; parameters[11].Value = model.IsLock; parameters[12].Value = model.AddTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DtCms.Model.Downloads GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,Title,ClassId,ImgUrl,FileType,FileSize,FilePath,Click,DownNum,Content,IsMsg,IsRed,IsLock,AddTime from dt_Downloads "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; DtCms.Model.Downloads model = new DtCms.Model.Downloads(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); if (ds.Tables[0].Rows[0]["ClassId"].ToString() != "") { model.ClassId = int.Parse(ds.Tables[0].Rows[0]["ClassId"].ToString()); } model.ImgUrl = ds.Tables[0].Rows[0]["ImgUrl"].ToString(); model.FileType = ds.Tables[0].Rows[0]["FileType"].ToString(); if (ds.Tables[0].Rows[0]["FileSize"].ToString() != "") { model.FileSize = int.Parse(ds.Tables[0].Rows[0]["FileSize"].ToString()); } model.FilePath = ds.Tables[0].Rows[0]["FilePath"].ToString(); if (ds.Tables[0].Rows[0]["Click"].ToString() != "") { model.Click = int.Parse(ds.Tables[0].Rows[0]["Click"].ToString()); } if (ds.Tables[0].Rows[0]["DownNum"].ToString() != "") { model.DownNum = int.Parse(ds.Tables[0].Rows[0]["DownNum"].ToString()); } model.Content = ds.Tables[0].Rows[0]["Content"].ToString(); if (ds.Tables[0].Rows[0]["IsMsg"].ToString() != "") { model.IsMsg = int.Parse(ds.Tables[0].Rows[0]["IsMsg"].ToString()); } if (ds.Tables[0].Rows[0]["IsRed"].ToString() != "") { model.IsRed = int.Parse(ds.Tables[0].Rows[0]["IsRed"].ToString()); } if (ds.Tables[0].Rows[0]["IsLock"].ToString() != "") { model.IsLock = int.Parse(ds.Tables[0].Rows[0]["IsLock"].ToString()); } if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DtCms.Model.Downloads model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_Downloads set "); strSql.Append("Title=@Title,"); strSql.Append("ClassId=@ClassId,"); strSql.Append("ImgUrl=@ImgUrl,"); strSql.Append("FileType=@FileType,"); strSql.Append("FileSize=@FileSize,"); strSql.Append("FilePath=@FilePath,"); strSql.Append("Click=@Click,"); strSql.Append("DownNum=@DownNum,"); strSql.Append("Content=@Content,"); strSql.Append("IsMsg=@IsMsg,"); strSql.Append("IsRed=@IsRed,"); strSql.Append("IsLock=@IsLock,"); strSql.Append("AddTime=@AddTime"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@ClassId", SqlDbType.Int, 4), new SqlParameter("@ImgUrl", SqlDbType.NVarChar, 250), new SqlParameter("@FileType", SqlDbType.NVarChar, 30), new SqlParameter("@FileSize", SqlDbType.Int, 4), new SqlParameter("@FilePath", SqlDbType.NVarChar, 250), new SqlParameter("@Click", SqlDbType.Int, 4), new SqlParameter("@DownNum", SqlDbType.Int, 4), new SqlParameter("@Content", SqlDbType.NText), new SqlParameter("@IsMsg", SqlDbType.Int, 4), new SqlParameter("@IsRed", SqlDbType.Int, 4), new SqlParameter("@IsLock", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.DateTime) }; parameters[0].Value = model.Id; parameters[1].Value = model.Title; parameters[2].Value = model.ClassId; parameters[3].Value = model.ImgUrl; parameters[4].Value = model.FileType; parameters[5].Value = model.FileSize; parameters[6].Value = model.FilePath; parameters[7].Value = model.Click; parameters[8].Value = model.DownNum; parameters[9].Value = model.Content; parameters[10].Value = model.IsMsg; parameters[11].Value = model.IsRed; parameters[12].Value = model.IsLock; parameters[13].Value = model.AddTime; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DtCms.Model.Downloads model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DtCms.Model.Downloads model) { return(dal.Add(model)); }