/// <summary> /// Ìí¼ÓͼƬ /// </summary> /// <param name="picture"></param> /// <returns></returns> public bool AddPicture(Tz888.Model.Picture.PictureInfo Picture) { string sql = "insert into PictureInfo(Title,ImgUrl,Target,SourceId,IsRecommend,ShowId,Remarks,TypeId) values(@Title,@ImgUrl,@Target,@SourceId,@IsRecommend,@ShowId,@Remarks,@TypeId)"; SqlParameter[] Paras = new SqlParameter[] { new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@ImgUrl", SqlDbType.VarChar, 200), new SqlParameter("@Target", SqlDbType.VarChar, 200), new SqlParameter("@SourceId", SqlDbType.Int, 4), new SqlParameter("@IsRecommend", SqlDbType.Int, 4), new SqlParameter("@ShowId", SqlDbType.Int, 4), new SqlParameter("@Remarks", SqlDbType.VarChar, 200), new SqlParameter("@TypeId", SqlDbType.Int, 4) }; Paras[0].Value = Picture.Title; Paras[1].Value = Picture.ImgUrl; Paras[2].Value = Picture.Target; Paras[3].Value = Picture.SourceId; Paras[4].Value = Picture.IsRecommend; Paras[5].Value = Picture.ShowId; Paras[6].Value = Picture.Remarks; Paras[7].Value = Picture.TypeId; int row = crm.ExecuteSql(sql, Paras); if (row > 0) { return(true); } else { return(false); } }
/// <summary> /// ÐÞ¸ÄͼƬ /// </summary> /// <param name="picture"></param> /// <returns></returns> public bool ModfiyPicture(Tz888.Model.Picture.PictureInfo Picture) { string sql = "update PictureInfo set Title=@Title,ImgUrl=@ImgUrl,SourceId=@SourceId,IsRecommend=@IsRecommend,ShowId=@ShowId,Remarks=@Remarks,Target=@Target,TypeId=@TypeId where Id=@Id"; SqlParameter[] Paras = new SqlParameter[] { new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@ImgUrl", SqlDbType.VarChar, 200), new SqlParameter("@SourceId", SqlDbType.Int, 4), new SqlParameter("@IsRecommend", SqlDbType.Int, 4), new SqlParameter("@ShowId", SqlDbType.Int, 4), new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Target", SqlDbType.VarChar, 200), new SqlParameter("@Remarks", SqlDbType.VarChar, 200), new SqlParameter("@TypeId", SqlDbType.Int, 4) }; Paras[0].Value = Picture.Title; Paras[1].Value = Picture.ImgUrl; Paras[2].Value = Picture.SourceId; Paras[3].Value = Picture.IsRecommend; Paras[4].Value = Picture.ShowId; Paras[5].Value = Picture.Id; Paras[6].Value = Picture.Target; Paras[7].Value = Picture.Remarks; Paras[8].Value = Picture.TypeId; int row = crm.ExecuteSql(sql, Paras); if (row > 0) { return(true); } else { return(false); } }