/// <summary> /// 更新回复、内容、状态 /// </summary> public bool Update1(GL.Model.GuestBookModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GL_GuestBook set "); strSql.Append("Contents=@Contents,"); strSql.Append("Verific=@Verific,"); strSql.Append("Reply=@Reply,"); strSql.Append("ReplyTime=@ReplyTime"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@Contents", SqlDbType.NText), new SqlParameter("@Verific", SqlDbType.Int, 4), new SqlParameter("@Reply", SqlDbType.NText), new SqlParameter("@ReplyTime", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.Contents; parameters[1].Value = model.Verific; parameters[2].Value = model.Reply; parameters[3].Value = model.ReplyTime; parameters[4].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(GL.Model.GuestBookModel model) { BasePage.CheckSerialnumber(); StringBuilder strSql = new StringBuilder(); strSql.Append("update GL_GuestBook set "); strSql.Append("Title=@Title,"); strSql.Append("UserName=@UserName,"); strSql.Append("Tel=@Tel,"); strSql.Append("Fax=@Fax,"); strSql.Append("Mobile=@Mobile,"); strSql.Append("Company=@Company,"); strSql.Append("Address=@Address,"); strSql.Append("Email=@Email,"); strSql.Append("SiteUrl=@SiteUrl,"); strSql.Append("Code=@Code,"); strSql.Append("Sex=@Sex,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("QQ=@QQ,"); strSql.Append("WangWang=@WangWang,"); strSql.Append("MSN=@MSN,"); strSql.Append("Contents=@Contents,"); strSql.Append("Verific=@Verific,"); strSql.Append("IP=@IP,"); strSql.Append("Reply=@Reply,"); strSql.Append("ReplyTime=@ReplyTime"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.NVarChar, 50), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@Tel", SqlDbType.NVarChar, 50), new SqlParameter("@Fax", SqlDbType.NVarChar, 50), new SqlParameter("@Mobile", SqlDbType.NVarChar, 50), new SqlParameter("@Company", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 50), new SqlParameter("@Email", SqlDbType.NVarChar, 50), new SqlParameter("@SiteUrl", SqlDbType.NVarChar, 50), new SqlParameter("@Code", SqlDbType.NVarChar, 50), new SqlParameter("@Sex", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@QQ", SqlDbType.NVarChar, 50), new SqlParameter("@WangWang", SqlDbType.NVarChar, 50), new SqlParameter("@MSN", SqlDbType.NVarChar, 50), new SqlParameter("@Contents", SqlDbType.NText), new SqlParameter("@Verific", SqlDbType.Int, 4), new SqlParameter("@IP", SqlDbType.NVarChar, 50), new SqlParameter("@Reply", SqlDbType.NText), new SqlParameter("@ReplyTime", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.Title; parameters[1].Value = model.UserName; parameters[2].Value = model.Tel; parameters[3].Value = model.Fax; parameters[4].Value = model.Mobile; parameters[5].Value = model.Company; parameters[6].Value = model.Address; parameters[7].Value = model.Email; parameters[8].Value = model.SiteUrl; parameters[9].Value = model.Code; parameters[10].Value = model.Sex; parameters[11].Value = model.AddTime; parameters[12].Value = model.QQ; parameters[13].Value = model.WangWang; parameters[14].Value = model.MSN; parameters[15].Value = model.Contents; parameters[16].Value = model.Verific; parameters[17].Value = model.IP; parameters[18].Value = model.Reply; parameters[19].Value = model.ReplyTime; parameters[20].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(GL.Model.GuestBookModel model) { BasePage.CheckSerialnumber(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into GL_GuestBook("); strSql.Append("Title,UserName,Tel,Fax,Mobile,Company,Address,Email,SiteUrl,Code,Sex,AddTime,QQ,WangWang,MSN,Contents,Verific,IP,Reply,ReplyTime)"); strSql.Append(" values ("); strSql.Append("@Title,@UserName,@Tel,@Fax,@Mobile,@Company,@Address,@Email,@SiteUrl,@Code,@Sex,@AddTime,@QQ,@WangWang,@MSN,@Contents,@Verific,@IP,@Reply,@ReplyTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.NVarChar, 50), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@Tel", SqlDbType.NVarChar, 50), new SqlParameter("@Fax", SqlDbType.NVarChar, 50), new SqlParameter("@Mobile", SqlDbType.NVarChar, 50), new SqlParameter("@Company", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 50), new SqlParameter("@Email", SqlDbType.NVarChar, 50), new SqlParameter("@SiteUrl", SqlDbType.NVarChar, 50), new SqlParameter("@Code", SqlDbType.NVarChar, 50), new SqlParameter("@Sex", SqlDbType.Int, 4), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@QQ", SqlDbType.NVarChar, 50), new SqlParameter("@WangWang", SqlDbType.NVarChar, 50), new SqlParameter("@MSN", SqlDbType.NVarChar, 50), new SqlParameter("@Contents", SqlDbType.NText), new SqlParameter("@Verific", SqlDbType.Int, 4), new SqlParameter("@IP", SqlDbType.NVarChar, 50), new SqlParameter("@Reply", SqlDbType.NText), new SqlParameter("@ReplyTime", SqlDbType.DateTime) }; parameters[0].Value = model.Title; parameters[1].Value = model.UserName; parameters[2].Value = model.Tel; parameters[3].Value = model.Fax; parameters[4].Value = model.Mobile; parameters[5].Value = model.Company; parameters[6].Value = model.Address; parameters[7].Value = model.Email; parameters[8].Value = model.SiteUrl; parameters[9].Value = model.Code; parameters[10].Value = model.Sex; parameters[11].Value = model.AddTime; parameters[12].Value = model.QQ; parameters[13].Value = model.WangWang; parameters[14].Value = model.MSN; parameters[15].Value = model.Contents; parameters[16].Value = model.Verific; parameters[17].Value = model.IP; parameters[18].Value = model.Reply; parameters[19].Value = model.ReplyTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public GL.Model.GuestBookModel GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,Title,UserName,Tel,Fax,Mobile,Company,Address,Email,SiteUrl,Code,Sex,AddTime,QQ,WangWang,MSN,Contents,Verific,IP,Reply,ReplyTime from GL_GuestBook "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; GL.Model.GuestBookModel model = new GL.Model.GuestBookModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["Title"] != null && ds.Tables[0].Rows[0]["Title"].ToString() != "") { model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); } if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "") { model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString(); } if (ds.Tables[0].Rows[0]["Tel"] != null && ds.Tables[0].Rows[0]["Tel"].ToString() != "") { model.Tel = ds.Tables[0].Rows[0]["Tel"].ToString(); } if (ds.Tables[0].Rows[0]["Fax"] != null && ds.Tables[0].Rows[0]["Fax"].ToString() != "") { model.Fax = ds.Tables[0].Rows[0]["Fax"].ToString(); } if (ds.Tables[0].Rows[0]["Mobile"] != null && ds.Tables[0].Rows[0]["Mobile"].ToString() != "") { model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString(); } if (ds.Tables[0].Rows[0]["Company"] != null && ds.Tables[0].Rows[0]["Company"].ToString() != "") { model.Company = ds.Tables[0].Rows[0]["Company"].ToString(); } if (ds.Tables[0].Rows[0]["Address"] != null && ds.Tables[0].Rows[0]["Address"].ToString() != "") { model.Address = ds.Tables[0].Rows[0]["Address"].ToString(); } if (ds.Tables[0].Rows[0]["Email"] != null && ds.Tables[0].Rows[0]["Email"].ToString() != "") { model.Email = ds.Tables[0].Rows[0]["Email"].ToString(); } if (ds.Tables[0].Rows[0]["SiteUrl"] != null && ds.Tables[0].Rows[0]["SiteUrl"].ToString() != "") { model.SiteUrl = ds.Tables[0].Rows[0]["SiteUrl"].ToString(); } if (ds.Tables[0].Rows[0]["Code"] != null && ds.Tables[0].Rows[0]["Code"].ToString() != "") { model.Code = ds.Tables[0].Rows[0]["Code"].ToString(); } if (ds.Tables[0].Rows[0]["Sex"] != null && ds.Tables[0].Rows[0]["Sex"].ToString() != "") { model.Sex = int.Parse(ds.Tables[0].Rows[0]["Sex"].ToString()); } if (ds.Tables[0].Rows[0]["AddTime"] != null && ds.Tables[0].Rows[0]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString()); } if (ds.Tables[0].Rows[0]["QQ"] != null && ds.Tables[0].Rows[0]["QQ"].ToString() != "") { model.QQ = ds.Tables[0].Rows[0]["QQ"].ToString(); } if (ds.Tables[0].Rows[0]["WangWang"] != null && ds.Tables[0].Rows[0]["WangWang"].ToString() != "") { model.WangWang = ds.Tables[0].Rows[0]["WangWang"].ToString(); } if (ds.Tables[0].Rows[0]["MSN"] != null && ds.Tables[0].Rows[0]["MSN"].ToString() != "") { model.MSN = ds.Tables[0].Rows[0]["MSN"].ToString(); } if (ds.Tables[0].Rows[0]["Contents"] != null && ds.Tables[0].Rows[0]["Contents"].ToString() != "") { model.Contents = ds.Tables[0].Rows[0]["Contents"].ToString(); } if (ds.Tables[0].Rows[0]["Verific"] != null && ds.Tables[0].Rows[0]["Verific"].ToString() != "") { model.Verific = int.Parse(ds.Tables[0].Rows[0]["Verific"].ToString()); } if (ds.Tables[0].Rows[0]["IP"] != null && ds.Tables[0].Rows[0]["IP"].ToString() != "") { model.IP = ds.Tables[0].Rows[0]["IP"].ToString(); } if (ds.Tables[0].Rows[0]["Reply"] != null && ds.Tables[0].Rows[0]["Reply"].ToString() != "") { model.Reply = ds.Tables[0].Rows[0]["Reply"].ToString(); } if (ds.Tables[0].Rows[0]["ReplyTime"] != null && ds.Tables[0].Rows[0]["ReplyTime"].ToString() != "") { model.ReplyTime = DateTime.Parse(ds.Tables[0].Rows[0]["ReplyTime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新回复、内容、状态 /// </summary> public bool Update1(GL.Model.GuestBookModel model) { return(dal.Update1(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(GL.Model.GuestBookModel model) { return(dal.Add(model)); }