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)
});
}
