/// <summary> /// 增加一条数据 /// </summary> public int Add(WebApi_Model.T_Photo_Collection model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Photo_Collection("); strSql.Append("CoverPhoto,Likes,Views,CreateDate,PhotoTagID,TotalImg,IsActive,RefProductID,PhotoType,IsFree,PiaoZi,TuiMao,Description,Category1,Category2)"); strSql.Append(" values ("); strSql.Append("@CoverPhoto,@Likes,@Views,@CreateDate,@PhotoTagID,@TotalImg,@IsActive,@RefProductID,@PhotoType,@IsFree,@PiaoZi,@TuiMao,@Description,@Category1,@Category2)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CoverPhoto", SqlDbType.NVarChar, 50), new SqlParameter("@Likes", SqlDbType.Int, 4), new SqlParameter("@Views", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@PhotoTagID", SqlDbType.Int, 4), new SqlParameter("@TotalImg", SqlDbType.Int, 4), new SqlParameter("@IsActive", SqlDbType.Int, 4), new SqlParameter("@RefProductID", SqlDbType.NVarChar, 50), new SqlParameter("@PhotoType", SqlDbType.Int, 4), new SqlParameter("@IsFree", SqlDbType.Int, 4), new SqlParameter("@PiaoZi", SqlDbType.Int, 4), new SqlParameter("@TuiMao", SqlDbType.Int, 4), new SqlParameter("@Description", SqlDbType.NVarChar, 100), new SqlParameter("@Category1", SqlDbType.Int, 4), new SqlParameter("@Category2", SqlDbType.Int, 4), }; parameters[0].Value = model.CoverPhoto; parameters[1].Value = model.Likes; parameters[2].Value = model.Views; parameters[3].Value = model.CreateDate; parameters[4].Value = model.PhotoTagID; parameters[5].Value = model.TotalImg; parameters[6].Value = model.IsActive; parameters[7].Value = model.RefProductID; parameters[8].Value = model.PhotoType; parameters[9].Value = model.IsFree; parameters[10].Value = model.PiaoZi; parameters[11].Value = model.TuiMao; parameters[12].Value = model.Description; parameters[13].Value = model.Category1; parameters[14].Value = model.Category2; object obj = DBHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebApi_Model.T_Photo_Collection GetModel(int PhotoCollectionID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from V_Photo_Collection "); strSql.Append(" where PhotoCollectionID=@PhotoCollectionID"); SqlParameter[] parameters = { new SqlParameter("@PhotoCollectionID", SqlDbType.Int, 4) }; parameters[0].Value = PhotoCollectionID; WebApi_Model.T_Photo_Collection model = new WebApi_Model.T_Photo_Collection(); DataSet ds = DBHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebApi_Model.T_Photo_Collection model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Photo_Collection set "); strSql.Append("CoverPhoto=@CoverPhoto,"); strSql.Append("Likes=@Likes,"); strSql.Append("Views=@Views,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("PhotoTagID=@PhotoTagID,"); strSql.Append("TotalImg=@TotalImg,"); strSql.Append("IsActive=@IsActive,"); strSql.Append("RefProductID=@RefProductID,"); strSql.Append("PhotoType=@PhotoType,"); strSql.Append("IsFree=@IsFree,"); strSql.Append("PiaoZi=@PiaoZi,"); strSql.Append("TuiMao=@TuiMao,"); strSql.Append("Description=@Description"); strSql.Append("Category1=@Category1"); strSql.Append("Category2=@Category2"); strSql.Append(" where PhotoCollectionID=@PhotoCollectionID"); SqlParameter[] parameters = { new SqlParameter("@CoverPhoto", SqlDbType.NVarChar, 50), new SqlParameter("@Likes", SqlDbType.Int, 4), new SqlParameter("@Views", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@PhotoTagID", SqlDbType.Int, 4), new SqlParameter("@TotalImg", SqlDbType.Int, 4), new SqlParameter("@IsActive", SqlDbType.Int, 4), new SqlParameter("@RefProductID", SqlDbType.NVarChar, 50), new SqlParameter("@PhotoType", SqlDbType.Int, 4), new SqlParameter("@IsFree", SqlDbType.Int, 4), new SqlParameter("@PiaoZi", SqlDbType.Int, 4), new SqlParameter("@TuiMao", SqlDbType.Int, 4), new SqlParameter("@Description", SqlDbType.NVarChar, 100), new SqlParameter("@Category1", SqlDbType.Int, 4), new SqlParameter("@Category2", SqlDbType.Int, 4), new SqlParameter("@PhotoCollectionID", SqlDbType.Int, 4) }; parameters[0].Value = model.CoverPhoto; parameters[1].Value = model.Likes; parameters[2].Value = model.Views; parameters[3].Value = model.CreateDate; parameters[4].Value = model.PhotoTagID; parameters[5].Value = model.TotalImg; parameters[6].Value = model.IsActive; parameters[7].Value = model.RefProductID; parameters[8].Value = model.PhotoType; parameters[9].Value = model.IsFree; parameters[10].Value = model.PiaoZi; parameters[11].Value = model.TuiMao; parameters[12].Value = model.Description; parameters[13].Value = model.Category1; parameters[14].Value = model.Category2; parameters[15].Value = model.PhotoCollectionID; int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebApi_Model.T_Photo_Collection DataRowToModel(DataRow row) { WebApi_Model.T_Photo_Collection model = new WebApi_Model.T_Photo_Collection(); if (row != null) { if (row["PhotoCollectionID"] != null && row["PhotoCollectionID"].ToString() != "") { model.PhotoCollectionID = int.Parse(row["PhotoCollectionID"].ToString()); } if (row["CoverPhoto"] != null) { model.CoverPhoto = row["CoverPhoto"].ToString(); } if (row["Likes"] != null && row["Likes"].ToString() != "") { model.Likes = int.Parse(row["Likes"].ToString()); } if (row["Views"] != null && row["Views"].ToString() != "") { model.Views = int.Parse(row["Views"].ToString()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["PhotoTagID"] != null && row["PhotoTagID"].ToString() != "") { model.PhotoTagID = row["PhotoTagID"].ToString(); } if (row["TotalImg"] != null && row["TotalImg"].ToString() != "") { model.TotalImg = int.Parse(row["TotalImg"].ToString()); } if (row["IsActive"] != null && row["IsActive"].ToString() != "") { model.IsActive = int.Parse(row["IsActive"].ToString()); } if (row["RefProductID"] != null) { model.RefProductID = row["RefProductID"].ToString(); } if (row["PhotoType"] != null && row["PhotoType"].ToString() != "") { model.PhotoType = int.Parse(row["PhotoType"].ToString()); } if (row["IsFree"] != null && row["IsFree"].ToString() != "") { model.IsFree = int.Parse(row["IsFree"].ToString()); } if (row["PiaoZi"] != null && row["PiaoZi"].ToString() != "") { model.PiaoZi = int.Parse(row["PiaoZi"].ToString()); } if (row["TuiMao"] != null && row["TuiMao"].ToString() != "") { model.TuiMao = int.Parse(row["TuiMao"].ToString()); } if (row["Description"] != null) { model.Description = row["Description"].ToString(); } if (row["Category1"] != null && row["Category1"].ToString() != "") { model.Category1 = int.Parse(row["Category1"].ToString()); } if (row["Category2"] != null && row["Category2"].ToString() != "") { model.Category2 = int.Parse(row["Category2"].ToString()); } if (row["CategoryName1"] != null && row["CategoryName1"].ToString() != "") { model.CategoryName1 = row["CategoryName1"].ToString(); } if (row["CategoryName2"] != null && row["CategoryName2"].ToString() != "") { model.CategoryName2 = row["CategoryName2"].ToString(); } } return(model); }