/// <summary> /// 增加一条数据 /// </summary> public int Add(Tc.Model.TcImage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TcImage("); strSql.Append("Fenleiid,Title,Jianyao,Tupian,Shipin,Url,Content,Click,AddUser,Addtime,Color,IsTuijian,IsTop,SeoTitle,SeoKeyword,SeoDescription)"); strSql.Append(" values ("); strSql.Append("@Fenleiid,@Title,@Jianyao,@Tupian,@Shipin,@Url,@Content,@Click,@AddUser,@Addtime,@Color,@IsTuijian,@IsTop,@SeoTitle,@SeoKeyword,@SeoDescription)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Fenleiid", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 200), new SqlParameter("@Jianyao", SqlDbType.NVarChar, 200), new SqlParameter("@Tupian", SqlDbType.NVarChar, 200), new SqlParameter("@Shipin", SqlDbType.NVarChar, 500), new SqlParameter("@Url", SqlDbType.NVarChar, 200), new SqlParameter("@Content", SqlDbType.NText), new SqlParameter("@Click", SqlDbType.Int, 4), new SqlParameter("@AddUser", SqlDbType.Int, 4), new SqlParameter("@Addtime", SqlDbType.DateTime), new SqlParameter("@Color", SqlDbType.NVarChar, 20), new SqlParameter("@IsTuijian", SqlDbType.Int, 4), new SqlParameter("@IsTop", SqlDbType.Int, 4), new SqlParameter("@SeoTitle", SqlDbType.NVarChar, 300), new SqlParameter("@SeoKeyword", SqlDbType.NVarChar, 300), new SqlParameter("@SeoDescription", SqlDbType.NVarChar, 300) }; parameters[0].Value = model.Fenleiid; parameters[1].Value = model.Title; parameters[2].Value = model.Jianyao; parameters[3].Value = model.Tupian; parameters[4].Value = model.Shipin; parameters[5].Value = model.Url; parameters[6].Value = model.Content; parameters[7].Value = model.Click; parameters[8].Value = model.AddUser; parameters[9].Value = model.Addtime; parameters[10].Value = model.Color; parameters[11].Value = model.IsTuijian; parameters[12].Value = model.IsTop; parameters[13].Value = model.SeoTitle; parameters[14].Value = model.SeoKeyword; parameters[15].Value = model.SeoDescription; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Tc.Model.TcImage GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Fenleiid,Title,Jianyao,Tupian,Shipin,Url,Content,Click,AddUser,Addtime,Color,IsTuijian,IsTop,SeoTitle,SeoKeyword,SeoDescription from TcImage "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Tc.Model.TcImage model = new Tc.Model.TcImage(); DataSet ds = DbHelperSQL.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(Tc.Model.TcImage model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tc.Model.TcImage model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Tc.Model.TcImage DataRowToModel(DataRow row) { Tc.Model.TcImage model = new Tc.Model.TcImage(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["Fenleiid"] != null && row["Fenleiid"].ToString() != "") { model.Fenleiid = int.Parse(row["Fenleiid"].ToString()); } if (row["Title"] != null) { model.Title = row["Title"].ToString(); } if (row["Jianyao"] != null) { model.Jianyao = row["Jianyao"].ToString(); } if (row["Tupian"] != null) { model.Tupian = row["Tupian"].ToString(); } if (row["Shipin"] != null) { model.Shipin = row["Shipin"].ToString(); } if (row["Url"] != null) { model.Url = row["Url"].ToString(); } if (row["Content"] != null) { model.Content = row["Content"].ToString(); } if (row["Click"] != null && row["Click"].ToString() != "") { model.Click = int.Parse(row["Click"].ToString()); } if (row["AddUser"] != null && row["AddUser"].ToString() != "") { model.AddUser = int.Parse(row["AddUser"].ToString()); } if (row["Addtime"] != null && row["Addtime"].ToString() != "") { model.Addtime = DateTime.Parse(row["Addtime"].ToString()); } if (row["Color"] != null) { model.Color = row["Color"].ToString(); } if (row["IsTuijian"] != null && row["IsTuijian"].ToString() != "") { model.IsTuijian = int.Parse(row["IsTuijian"].ToString()); } if (row["IsTop"] != null && row["IsTop"].ToString() != "") { model.IsTop = int.Parse(row["IsTop"].ToString()); } if (row["SeoTitle"] != null) { model.SeoTitle = row["SeoTitle"].ToString(); } if (row["SeoKeyword"] != null) { model.SeoKeyword = row["SeoKeyword"].ToString(); } if (row["SeoDescription"] != null) { model.SeoDescription = row["SeoDescription"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Tc.Model.TcImage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TcImage set "); strSql.Append("Fenleiid=@Fenleiid,"); strSql.Append("Title=@Title,"); strSql.Append("Jianyao=@Jianyao,"); strSql.Append("Tupian=@Tupian,"); strSql.Append("Shipin=@Shipin,"); strSql.Append("Url=@Url,"); strSql.Append("Content=@Content,"); strSql.Append("Click=@Click,"); strSql.Append("AddUser=@AddUser,"); strSql.Append("Addtime=@Addtime,"); strSql.Append("Color=@Color,"); strSql.Append("IsTuijian=@IsTuijian,"); strSql.Append("IsTop=@IsTop,"); strSql.Append("SeoTitle=@SeoTitle,"); strSql.Append("SeoKeyword=@SeoKeyword,"); strSql.Append("SeoDescription=@SeoDescription"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Fenleiid", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 200), new SqlParameter("@Jianyao", SqlDbType.NVarChar, 200), new SqlParameter("@Tupian", SqlDbType.NVarChar, 200), new SqlParameter("@Shipin", SqlDbType.NVarChar, 500), new SqlParameter("@Url", SqlDbType.NVarChar, 200), new SqlParameter("@Content", SqlDbType.NText), new SqlParameter("@Click", SqlDbType.Int, 4), new SqlParameter("@AddUser", SqlDbType.Int, 4), new SqlParameter("@Addtime", SqlDbType.DateTime), new SqlParameter("@Color", SqlDbType.NVarChar, 20), new SqlParameter("@IsTuijian", SqlDbType.Int, 4), new SqlParameter("@IsTop", SqlDbType.Int, 4), new SqlParameter("@SeoTitle", SqlDbType.NVarChar, 300), new SqlParameter("@SeoKeyword", SqlDbType.NVarChar, 300), new SqlParameter("@SeoDescription", SqlDbType.NVarChar, 300), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.Fenleiid; parameters[1].Value = model.Title; parameters[2].Value = model.Jianyao; parameters[3].Value = model.Tupian; parameters[4].Value = model.Shipin; parameters[5].Value = model.Url; parameters[6].Value = model.Content; parameters[7].Value = model.Click; parameters[8].Value = model.AddUser; parameters[9].Value = model.Addtime; parameters[10].Value = model.Color; parameters[11].Value = model.IsTuijian; parameters[12].Value = model.IsTop; parameters[13].Value = model.SeoTitle; parameters[14].Value = model.SeoKeyword; parameters[15].Value = model.SeoDescription; parameters[16].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }