/// <summary>
/// 获取类别
/// </summary>
/// <param name="parentid"></param>
/// <returns></returns>
public static List <NewsClassModel> GetNewsClassListByLang(int lang, int parentid)
{
string sql = "select * from T_NewsClass where F_ParentID = ? And F_Lang=? order by F_Sort desc";
OleDbParameter[] parameter = new OleDbParameter[2];
parameter[0] = new OleDbParameter("@F_ParentID", OleDbType.Integer);
parameter[0].Value = parentid;
parameter[1] = new OleDbParameter("@F_ParentID", OleDbType.Integer);
parameter[1].Value = lang;
List <NewsClassModel> list = new List <NewsClassModel>();
OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter);
NewsClassModel proclass = null;
while (dr.Read())
{
proclass = new NewsClassModel();
proclass.ID = Convert.ToInt32(dr["ID"].ToString());
proclass.F_ClassName = dr["F_ClassName"].ToString();
proclass.F_ParentID = Convert.ToInt32(dr["F_ParentID"]);
proclass.F_Sort = Convert.ToInt32(dr["F_Sort"]);
list.Add(proclass);
}
dr.Close();
dr.Dispose();
return(list);
}
public static NewsClassModel GetParentName(int parentid)
{
string sql = "select * from T_NewsClass where ID=?";
OleDbParameter[] parameter = new OleDbParameter[1];
parameter[0] = new OleDbParameter("@ID", OleDbType.Integer);
parameter[0].Value = parentid;
OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter);
NewsClassModel proclass = null;
if (dr.Read())
{
proclass = new NewsClassModel();
proclass.ID = Convert.ToInt32(dr["ID"].ToString());
proclass.F_ClassName = dr["F_ClassName"].ToString();
proclass.F_ParentID = Convert.ToInt32(dr["F_ParentID"]);
proclass.F_Sort = Convert.ToInt32(dr["F_Sort"]);
}
dr.Close();
dr.Dispose();
return(proclass);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="t"></param>
/// <returns>0失败，1成功</returns>
public static int AddNewsClass(NewsClassModel t)
{
string sql = "insert into T_NewsClass(F_ClassName,F_ParentID,F_Sort,F_Lang) values(@F_ClassName,@F_ParentID,@F_Sort,@F_Lang)";
OleDbParameter[] parameter = new OleDbParameter[4];
parameter[0] = new OleDbParameter("@F_ClassName", OleDbType.VarChar, 50);
parameter[1] = new OleDbParameter("@F_ParentID", OleDbType.Integer);
parameter[2] = new OleDbParameter("@F_Sort", OleDbType.Integer);
parameter[3] = new OleDbParameter("@F_Sort", OleDbType.Integer);
parameter[0].Value = t.F_ClassName;
parameter[1].Value = t.F_ParentID;
parameter[2].Value = t.F_Sort;
parameter[3].Value = t.F_Lang;
return(AccessorDB.ExecuteNonQuery(sql, parameter));
}
protected void Button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtClassName.Text))
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('分类名称不能为空!');", true);
return;
}
if (string.IsNullOrEmpty(this.txtSort.Text))
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('排序不能为空!');", true);
return;
}
if (!VerifyTool.IsInt(this.txtSort.Text, true, true))
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('排序格式只能是数字!');", true);
return;
}
int res;
NewsClassModel proclass = new NewsClassModel();
proclass.F_ParentID = Convert.ToInt32(this.hidParentID.Value);
proclass.F_ClassName = this.txtClassName.Text.Trim().ToString();
proclass.F_Sort = Convert.ToInt32(this.txtSort.Text);
proclass.F_Lang = lang;
if (this.txtHiddParentName.Value.Trim().ToString() == "编辑分类")
{
res = EispNewsClassBLL.UpdateNewsClass(proclass.F_ClassName, proclass.F_ParentID);
}
else
{
res = EispNewsClassBLL.AddNewsClass(proclass);
}
if (res > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功');location.href='NewsClassAdmin.aspx?lang=" + lang + "';", true);
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败,数据库繁忙');", true);
}
}
public ActionResult Edit(NewsClassModel model, string cdts)
{
GetConditions(cdts);
model.Update();
return(View("AdminIndex"));
}
public ActionResult Create(NewsClassModel model, string cdts)
{
GetConditions(cdts);
model.Insert();
return(View("AdminIndex"));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="t"></param>
/// <returns>0失败，1成功</returns>
public static int AddNewsClass(NewsClassModel t)
{
return(EispNewsClassDAL.AddNewsClass(t));
}
