public static T_ad_ad admin_ad_id(int id) { using (SqlDataReader dr = a.data.mssql.ExecuteReader(1, "[p-sys-ad-all]", new SqlParameter[] { new SqlParameter("@id", id) })) { T_ad_ad model = null; while (dr.Read()) { model = new T_ad_ad(); model.Id = a.normal.toInt(dr["id"]); model.Ad_img = a.normal.toString(dr["ad_img"]); model.Ad_name = a.normal.toString(dr["ad_name"]); model.Ad_text = a.normal.toString(dr["ad_text"]); } dr.Close(); dr.Dispose(); return model; } }
public static List<T_ad_ad> admin_ad_ad(string tblName, string fldName, int PageSize, int PageIndex, string OrderType, string strWhere, out int Count) { SqlParameter[] parameters = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@strGetFields", SqlDbType.VarChar, 1000), new SqlParameter("@fldName", SqlDbType.VarChar, 255), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@strOrder", SqlDbType.VarChar,100), new SqlParameter("@strWhere", SqlDbType.VarChar,1500), new SqlParameter("@Count", SqlDbType.Int), }; parameters[0].Value = tblName; parameters[1].Value = "*"; parameters[2].Value = fldName; parameters[3].Value = PageSize; parameters[4].Value = PageIndex; parameters[5].Value = OrderType; parameters[6].Value = strWhere; parameters[7].Direction = ParameterDirection.Output; using (SqlDataReader dr = a.data.mssql.ExecuteReader(1, "[UP_PaginationAnyOrderCount]", parameters)) { List<T_ad_ad> list = new List<T_ad_ad>(); while (dr.Read()) { T_ad_ad model = new T_ad_ad(); model.Id = a.normal.toInt(dr["id"]); model.Ad_img = a.normal.toString(dr["ad_img"]); model.Ad_name = a.normal.toString(dr["ad_name"]); model.Ad_text = a.normal.toString(dr["ad_text"]); model.Ad_weizhi = io_io.io_weizhi(a.normal.toInt(dr["Ad_weizhi"])); list.Add(model); } dr.Close(); dr.Dispose(); Count = a.normal.toInt(parameters[7].Value); return list; } }
protected void butsubmint_Click(object sender, EventArgs e) { T_ad_ad ad = new T_ad_ad(); ad.Id = a.query.toInt("aid"); ad.Ad_num = a.normal.toInt(txtnum.Text.Trim()); ad.Ad_name = a.normal.toString(txttitle.Text.Trim()); ad.Ad_text = a.normal.toString(content1.InnerHtml); if (Radiotrue.Checked) { ad.Ad_img = img(File1); } else { ad.Ad_img = ""; } if (ad_main.admin_up_ad(ad) > 0) { Response.Redirect("ad_ad.aspx"); } else { MessShowBox.show("网络链接错误,修改失败",this); } }
public static int admin_in_ad(T_ad_ad ad) { return a.data.mssql.ExecuteNonQuery(1, "[p-sys-in-ad]", new SqlParameter[] { new SqlParameter("@ad_name",ad.Ad_name), new SqlParameter("@ad_text",ad.Ad_text), new SqlParameter("@ad_img",ad.Ad_img), new SqlParameter("@ad_weizhi",ad.Ad_weizhi) }); }
public static int admin_up_ad(T_ad_ad model) { return a.data.mssql.ExecuteNonQuery(1, "[p-sys-up-ad-id]", new SqlParameter[] { new SqlParameter("@id",model.Id), new SqlParameter("@ad_name",model.Ad_name), new SqlParameter("@ad_num",model.Ad_num), new SqlParameter("@ad_img",model.Ad_img), new SqlParameter("@ad_text",model.Ad_text) }); }