/// <summary> /// 增加一条数据 /// </summary> public int Add(GL.Model.ClassModel model) { BasePage.CheckSerialnumber(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into GL_Class("); strSql.Append("ModelId,ClassName,ClassType,ParentId,ClassLayer,Px,SeoTitle,SeoKeyWord,SeoDescription,ClassIntro,Hide,ClassPic,AddDate,Languagen,Contents,InputA,InputUser,AllowComment)"); strSql.Append(" values ("); strSql.Append("@ModelId,@ClassName,@ClassType,@ParentId,@ClassLayer,@Px,@SeoTitle,@SeoKeyWord,@SeoDescription,@ClassIntro,@Hide,@ClassPic,@AddDate,@Languagen,@Contents,@InputA,@InputUser,@AllowComment)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ModelId", SqlDbType.Int, 4), new SqlParameter("@ClassName", SqlDbType.NVarChar, 50), new SqlParameter("@ClassType", SqlDbType.Int, 4), new SqlParameter("@ParentId", SqlDbType.Int, 4), new SqlParameter("@ClassLayer", SqlDbType.Int, 4), new SqlParameter("@Px", SqlDbType.Int, 4), new SqlParameter("@SeoTitle", SqlDbType.NVarChar, 100), new SqlParameter("@SeoKeyWord", SqlDbType.NVarChar, 150), new SqlParameter("@SeoDescription", SqlDbType.NVarChar, 250), new SqlParameter("@ClassIntro", SqlDbType.NVarChar, 250), new SqlParameter("@Hide", SqlDbType.Int, 4), new SqlParameter("@ClassPic", SqlDbType.NVarChar, 50), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@Languagen", SqlDbType.Int, 4), new SqlParameter("@Contents", SqlDbType.NText), new SqlParameter("@InputA", SqlDbType.Int, 4), new SqlParameter("@InputUser", SqlDbType.Int, 4), new SqlParameter("@AllowComment", SqlDbType.Int, 4) }; parameters[0].Value = model.ModelId; parameters[1].Value = model.ClassName; parameters[2].Value = model.ClassType; parameters[3].Value = model.ParentId; parameters[4].Value = model.ClassLayer; parameters[5].Value = model.Px; parameters[6].Value = model.SeoTitle; parameters[7].Value = model.SeoKeyWord; parameters[8].Value = model.SeoDescription; parameters[9].Value = model.ClassIntro; parameters[10].Value = model.Hide; parameters[11].Value = model.ClassPic; parameters[12].Value = model.AddDate; parameters[13].Value = model.Languagen; parameters[14].Value = model.Contents; parameters[15].Value = model.InputA; parameters[16].Value = model.InputUser; parameters[17].Value = model.AllowComment; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 批量更新seo /// </summary> public bool Updateseo(GL.Model.ClassModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GL_Class set "); strSql.Append("SeoKeyWord=@SeoKeyWord,"); strSql.Append("SeoDescription=@SeoDescription,"); strSql.Append("SeoTitle=@SeoTitle"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@SeoKeyWord", SqlDbType.NVarChar, 150), new SqlParameter("@SeoDescription", SqlDbType.NVarChar, 250), new SqlParameter("@SeoTitle", SqlDbType.NVarChar, 80), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.SeoKeyWord; parameters[1].Value = model.SeoDescription; parameters[2].Value = model.SeoTitle; parameters[3].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public GL.Model.ClassModel GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,ModelId,ClassName,ClassType,ParentId,ClassLayer,Px,SeoTitle,SeoKeyWord,SeoDescription,ClassIntro,Hide,ClassPic,AddDate,Languagen,Contents,InputA,InputUser,AllowComment from GL_Class "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; GL.Model.ClassModel model = new GL.Model.ClassModel(); 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(GL.Model.ClassModel model) { BasePage.CheckSerialnumber(); StringBuilder strSql = new StringBuilder(); strSql.Append("update GL_Class set "); //strSql.Append("ModelId=@ModelId,"); strSql.Append("ClassName=@ClassName,"); strSql.Append("ClassType=@ClassType,"); //strSql.Append("ParentId=@ParentId,"); //strSql.Append("ClassLayer=@ClassLayer,"); strSql.Append("Px=@Px,"); strSql.Append("SeoTitle=@SeoTitle,"); strSql.Append("SeoKeyWord=@SeoKeyWord,"); strSql.Append("SeoDescription=@SeoDescription,"); strSql.Append("ClassIntro=@ClassIntro,"); strSql.Append("Hide=@Hide,"); strSql.Append("ClassPic=@ClassPic,"); strSql.Append("Languagen=@Languagen,"); strSql.Append("Contents=@Contents,"); strSql.Append("InputA=@InputA,"); strSql.Append("InputUser=@InputUser,"); strSql.Append("AllowComment=@AllowComment"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { //new SqlParameter("@ModelId", SqlDbType.Int,4), new SqlParameter("@ClassName", SqlDbType.NVarChar, 50), new SqlParameter("@ClassType", SqlDbType.Int, 4), //new SqlParameter("@ParentId", SqlDbType.Int,4), //new SqlParameter("@ClassLayer", SqlDbType.Int,4), new SqlParameter("@Px", SqlDbType.Int, 4), new SqlParameter("@SeoTitle", SqlDbType.NVarChar, 100), new SqlParameter("@SeoKeyWord", SqlDbType.NVarChar, 150), new SqlParameter("@SeoDescription", SqlDbType.NVarChar, 250), new SqlParameter("@ClassIntro", SqlDbType.NVarChar, 250), new SqlParameter("@Hide", SqlDbType.Int, 4), new SqlParameter("@ClassPic", SqlDbType.NVarChar, 50), //new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@Languagen", SqlDbType.Int, 4), new SqlParameter("@Contents", SqlDbType.NText), new SqlParameter("@InputA", SqlDbType.Int, 4), new SqlParameter("@InputUser", SqlDbType.Int, 4), new SqlParameter("@AllowComment", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; //parameters[0].Value = model.ModelId; parameters[0].Value = model.ClassName; parameters[1].Value = model.ClassType; //parameters[3].Value = model.ParentId; //parameters[4].Value = model.ClassLayer; parameters[2].Value = model.Px; parameters[3].Value = model.SeoTitle; parameters[4].Value = model.SeoKeyWord; parameters[5].Value = model.SeoDescription; parameters[6].Value = model.ClassIntro; parameters[7].Value = model.Hide; parameters[8].Value = model.ClassPic; parameters[9].Value = model.Languagen; parameters[10].Value = model.Contents; parameters[11].Value = model.InputA; parameters[12].Value = model.InputUser; parameters[13].Value = model.AllowComment; parameters[14].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public GL.Model.ClassModel DataRowToModel(DataRow row) { GL.Model.ClassModel model = new GL.Model.ClassModel(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["ModelId"] != null && row["ModelId"].ToString() != "") { model.ModelId = int.Parse(row["ModelId"].ToString()); } if (row["ClassName"] != null) { model.ClassName = row["ClassName"].ToString(); } if (row["ClassType"] != null && row["ClassType"].ToString() != "") { model.ClassType = int.Parse(row["ClassType"].ToString()); } if (row["ParentId"] != null && row["ParentId"].ToString() != "") { model.ParentId = int.Parse(row["ParentId"].ToString()); } if (row["ClassLayer"] != null && row["ClassLayer"].ToString() != "") { model.ClassLayer = int.Parse(row["ClassLayer"].ToString()); } if (row["Px"] != null && row["Px"].ToString() != "") { model.Px = int.Parse(row["Px"].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(); } if (row["ClassIntro"] != null) { model.ClassIntro = row["ClassIntro"].ToString(); } if (row["Hide"] != null && row["Hide"].ToString() != "") { model.Hide = int.Parse(row["Hide"].ToString()); } if (row["ClassPic"] != null) { model.ClassPic = row["ClassPic"].ToString(); } if (row["AddDate"] != null && row["AddDate"].ToString() != "") { model.AddDate = DateTime.Parse(row["AddDate"].ToString()); } if (row["Languagen"] != null && row["Languagen"].ToString() != "") { model.Languagen = int.Parse(row["Languagen"].ToString()); } if (row["Contents"] != null) { model.Contents = row["Contents"].ToString(); } if (row["InputA"] != null && row["InputA"].ToString() != "") { model.InputA = int.Parse(row["InputA"].ToString()); } if (row["InputUser"] != null && row["InputUser"].ToString() != "") { model.InputUser = int.Parse(row["InputUser"].ToString()); } if (row["AllowComment"] != null && row["AllowComment"].ToString() != "") { model.AllowComment = int.Parse(row["AllowComment"].ToString()); } } return(model); }