/// <summary> /// 更新一条数据 /// </summary> public bool Update(LearnSite.Model.Soft model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Soft set "); strSql.Append("Ftitle=@Ftitle,"); strSql.Append("Fcontent=@Fcontent,"); strSql.Append("Furl=@Furl,"); strSql.Append("Fhit=@Fhit,"); strSql.Append("Fdate=@Fdate,"); strSql.Append("Ffiletype=@Ffiletype,"); strSql.Append("Fclass=@Fclass,"); strSql.Append("Fhide=@Fhide,"); strSql.Append("Fopen=@Fopen,"); strSql.Append("Fhid=@Fhid,"); strSql.Append("Fyid=@Fyid,"); strSql.Append("Fup=@Fup"); strSql.Append(" where Fid=@Fid"); SqlParameter[] parameters = { new SqlParameter("@Fid", SqlDbType.Int, 4), new SqlParameter("@Ftitle", SqlDbType.NVarChar, 50), new SqlParameter("@Fcontent", SqlDbType.NText), new SqlParameter("@Furl", SqlDbType.NVarChar, 200), new SqlParameter("@Fhit", SqlDbType.Int, 4), new SqlParameter("@Fdate", SqlDbType.DateTime), new SqlParameter("@Ffiletype", SqlDbType.NVarChar, 50), new SqlParameter("@Fclass", SqlDbType.NVarChar, 50), new SqlParameter("@Fhide", SqlDbType.Bit, 1), new SqlParameter("@Fopen", SqlDbType.Int, 4), new SqlParameter("@Fhid", SqlDbType.Int, 4), new SqlParameter("@Fyid", SqlDbType.Int, 4), new SqlParameter("@Fup", SqlDbType.Bit, 1) }; parameters[0].Value = model.Fid; parameters[1].Value = model.Ftitle; parameters[2].Value = model.Fcontent; parameters[3].Value = model.Furl; parameters[4].Value = model.Fhit; parameters[5].Value = model.Fdate; parameters[6].Value = model.Ffiletype; parameters[7].Value = model.Fclass; parameters[8].Value = model.Fhide; parameters[9].Value = model.Fopen; parameters[10].Value = model.Fhid; parameters[11].Value = model.Fyid; parameters[12].Value = model.Fup; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(LearnSite.Model.Soft model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Soft("); strSql.Append("Ftitle,Fcontent,Furl,Fhit,Fdate,Ffiletype,Fclass,Fhide,Fopen,Fhid,Fyid,Fup)"); strSql.Append(" values ("); strSql.Append("@Ftitle,@Fcontent,@Furl,@Fhit,@Fdate,@Ffiletype,@Fclass,@Fhide,@Fopen,@Fhid,@Fyid,@Fup)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Ftitle", SqlDbType.NVarChar, 50), new SqlParameter("@Fcontent", SqlDbType.NText), new SqlParameter("@Furl", SqlDbType.NVarChar, 200), new SqlParameter("@Fhit", SqlDbType.Int, 4), new SqlParameter("@Fdate", SqlDbType.DateTime), new SqlParameter("@Ffiletype", SqlDbType.NVarChar, 50), new SqlParameter("@Fclass", SqlDbType.NVarChar, 50), new SqlParameter("@Fhide", SqlDbType.Bit, 1), new SqlParameter("@Fopen", SqlDbType.Int, 4), new SqlParameter("@Fhid", SqlDbType.Int, 4), new SqlParameter("@Fyid", SqlDbType.Int, 4), new SqlParameter("@Fup", SqlDbType.Bit, 1) }; parameters[0].Value = model.Ftitle; parameters[1].Value = model.Fcontent; parameters[2].Value = model.Furl; parameters[3].Value = model.Fhit; parameters[4].Value = model.Fdate; parameters[5].Value = model.Ffiletype; parameters[6].Value = model.Fclass; parameters[7].Value = model.Fhide; parameters[8].Value = model.Fopen; parameters[9].Value = model.Fhid; parameters[10].Value = model.Fyid; parameters[11].Value = model.Fup; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public LearnSite.Model.Soft GetModel(int Fid) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 Fid,Ftitle,Fcontent,Furl,Fhit,Fdate,Ffiletype,Fclass from Soft "); strSql.Append(" where Fid=@Fid "); SqlParameter[] parameters = { new SqlParameter("@Fid", SqlDbType.Int,4)}; parameters[0].Value = Fid; LearnSite.Model.Soft model=new LearnSite.Model.Soft(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["Fid"].ToString()!="") { model.Fid=int.Parse(ds.Tables[0].Rows[0]["Fid"].ToString()); } model.Ftitle=ds.Tables[0].Rows[0]["Ftitle"].ToString(); model.Fcontent=ds.Tables[0].Rows[0]["Fcontent"].ToString(); model.Furl=ds.Tables[0].Rows[0]["Furl"].ToString(); if(ds.Tables[0].Rows[0]["Fhit"].ToString()!="") { model.Fhit=int.Parse(ds.Tables[0].Rows[0]["Fhit"].ToString()); } if(ds.Tables[0].Rows[0]["Fdate"].ToString()!="") { model.Fdate=DateTime.Parse(ds.Tables[0].Rows[0]["Fdate"].ToString()); } model.Ffiletype=ds.Tables[0].Rows[0]["Ffiletype"].ToString(); model.Fclass=ds.Tables[0].Rows[0]["Fclass"].ToString(); return model; } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public LearnSite.Model.Soft GetModel(int Fid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Fid,Ftitle,Fcontent,Furl,Fhit,Fdate,Ffiletype,Fclass,Fhide,Fopen,Fhid,Fyid from Soft "); strSql.Append(" where Fid=@Fid"); SqlParameter[] parameters = { new SqlParameter("@Fid", SqlDbType.Int, 4) }; parameters[0].Value = Fid; LearnSite.Model.Soft model = new LearnSite.Model.Soft(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Fid"].ToString() != "") { model.Fid = int.Parse(ds.Tables[0].Rows[0]["Fid"].ToString()); } model.Ftitle = ds.Tables[0].Rows[0]["Ftitle"].ToString(); model.Fcontent = ds.Tables[0].Rows[0]["Fcontent"].ToString(); model.Furl = ds.Tables[0].Rows[0]["Furl"].ToString(); if (ds.Tables[0].Rows[0]["Fhit"].ToString() != "") { model.Fhit = int.Parse(ds.Tables[0].Rows[0]["Fhit"].ToString()); } if (ds.Tables[0].Rows[0]["Fdate"].ToString() != "") { model.Fdate = DateTime.Parse(ds.Tables[0].Rows[0]["Fdate"].ToString()); } model.Ffiletype = ds.Tables[0].Rows[0]["Ffiletype"].ToString(); model.Fclass = ds.Tables[0].Rows[0]["Fclass"].ToString(); if (ds.Tables[0].Rows[0]["Fhide"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Fhide"].ToString() == "1") || (ds.Tables[0].Rows[0]["Fhide"].ToString().ToLower() == "true")) { model.Fhide = true; } else { model.Fhide = false; } } if (ds.Tables[0].Rows[0]["Fopen"].ToString() != "") { model.Fopen = int.Parse(ds.Tables[0].Rows[0]["Fopen"].ToString()); } if (ds.Tables[0].Rows[0]["Fhid"].ToString() != "") { model.Fhid = int.Parse(ds.Tables[0].Rows[0]["Fhid"].ToString()); } if (ds.Tables[0].Rows[0]["Fyid"].ToString() != "") { model.Fyid = int.Parse(ds.Tables[0].Rows[0]["Fyid"].ToString()); } return(model); } else { return(null); } }