protected void Button2_Click(object sender, EventArgs e) { T_ad_img mo = new T_ad_img(); mo.Path_img3 = img(FileUpload3, 3); if (DAL.ad_main.admin_in_img(mo,3) > 0) { MessShowBox.show("添加成功", this); } else { MessShowBox.show("添加失败", this); } }
protected void butsubmint_Click(object sender, EventArgs e) { T_ad_img mo = new T_ad_img(); mo.Path_img1 = img(FileUpload1, 1); if (DAL.ad_main.admin_in_img(mo,1) > 0) { MessShowBox.show("添加成功", this); } else { MessShowBox.show("添加失败", this); } }
public static T_ad_img user_se_ad_img() { string sql = "select * from t_ad_img order by id desc"; using (SqlDataReader dr = a.data.mssql.ExecuteReader(0, sql)) { T_ad_img model = null; while (dr.Read()) { model = new T_ad_img(); model.Id = a.normal.toInt(dr["id"]); model.Path_img1 = a.normal.toString(dr["Path_img1"]); model.Path_img2 = a.normal.toString(dr["Path_img2"]); model.Path_img3 = a.normal.toString(dr["Path_img3"]); model.Path_img4 = a.normal.toString(dr["Path_img4"]); model.Path_img5 = a.normal.toString(dr["Path_img5"]); } dr.Close(); dr.Dispose(); return model; } }
public static T_ad_img admin_select_img() { using (SqlDataReader dr = a.data.mssql.ExecuteReader(0, "select * from t_ad_img")) { T_ad_img img = null; while (dr.Read()) { img = new T_ad_img(); img.Path_img1 = a.normal.toString(dr["Path_img1"]); img.Path_img2 = a.normal.toString(dr["Path_img2"]); img.Path_img3 = a.normal.toString(dr["Path_img3"]); img.Path_img4 = a.normal.toString(dr["Path_img4"]); img.Path_img5 = a.normal.toString(dr["Path_img5"]); } dr.Close(); dr.Dispose(); return img; } }
public static int admin_in_img(T_ad_img model, int i) { int k = 0; if (i == 1) { string sql = @"update t_ad_img set path_img1=@path_img1 where id=1"; k = a.data.mssql.ExecuteNonQuery(0, sql, new SqlParameter[] { new SqlParameter("@path_img1", model.Path_img1) }); } else if (i == 2) { string sql = @"update t_ad_img set path_img2=@path_img2 where id=1"; k = a.data.mssql.ExecuteNonQuery(0, sql, new SqlParameter[] { new SqlParameter("@path_img2", model.Path_img2) }); } else if (i == 3) { string sql = @"update t_ad_img set path_img3=@path_img3 where id=1"; k = a.data.mssql.ExecuteNonQuery(0, sql, new SqlParameter[] { new SqlParameter("@path_img3", model.Path_img3) }); } else if (i == 4) { string sql = @"update t_ad_img set path_img4=@path_img4 where id=1"; k = a.data.mssql.ExecuteNonQuery(0, sql, new SqlParameter[] { new SqlParameter("@path_img4", model.Path_img4) }); } else if (i == 5) { string sql = @"update t_ad_img set path_img5=@path_img5 where id=1"; k = a.data.mssql.ExecuteNonQuery(0, sql, new SqlParameter[] { new SqlParameter("@path_img5", model.Path_img5) }); } return k; }