protected void btnAdd_Click(object sender, EventArgs e) { //string strErr = ""; string ClassDesc = this.txtClassDesc.Text; string ClassPicture = this.txtClassPicture.Text; int ParentId = 0; if (this.dropParent.SelectedIndex > 0) { ParentId = int.Parse(this.dropParent.SelectedValue); } Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); model.ClassDesc = ClassDesc; model.ClassPicture = ClassPicture; model.ParentId = ParentId; Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); bll.Add(model); if (chkAddContinue.Checked) { Session["newsclass"] = model; Response.Redirect("Add.aspx"); } else { Session["newsclass"] = null; Response.Redirect("index.aspx"); } }
protected void gridView_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { string Dormancy = (string)DataBinder.Eval(e.Row.DataItem, "Dormancy"); int ClassId = (int)DataBinder.Eval(e.Row.DataItem, "ClassId"); int IsTop = (int)DataBinder.Eval(e.Row.DataItem, "IsTop"); if (Dormancy.ToLower() == "true") { e.Row.Cells[3].Text = "<span style=\" color:Red\">休眠</span>"; } else { e.Row.Cells[3].Text = "<span style=\" color:Green\">发布</span>"; } if (IsTop == 1) { e.Row.Cells[4].Text = "<span style=\" color:Green\">是</span>"; } else { e.Row.Cells[4].Text = "<span style=\" color:Red\">否</span>"; } Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); Maticsoft.Model.NewsManage.NewsClass mod = bll.GetModel(ClassId); if (mod != null) { e.Row.Cells[5].Text = mod.ClassDesc; } else { e.Row.Cells[5].Text = "未知类别"; } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.NewsManage.NewsClass GetModel(int ClassId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from T_NewsClass "); strSql.Append(" where ClassId=@ClassId"); SqlParameter[] parameters = { new SqlParameter("@ClassId", SqlDbType.Int, 4) }; parameters[0].Value = ClassId; Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); model.ClassId = ClassId; if (ds.Tables[0].Rows.Count > 0) { model.ClassDesc = ds.Tables[0].Rows[0]["ClassDesc"].ToString(); model.ClassPicture = ds.Tables[0].Rows[0]["ClassPicture"].ToString(); if (ds.Tables[0].Rows[0]["ParentId"].ToString() != "") { model.ParentId = int.Parse(ds.Tables[0].Rows[0]["ParentId"].ToString()); } return(model); } else { return(null); } }
protected void BindClassList(int ClassID) { string strWhere=""; Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); model = bll.GetModel(ClassID); int parentid = model.ParentId; if (parentid != 0) { model= bll.GetModelByCache(parentid); parentid = model.ParentId; } strWhere = "parentid="+model.ClassId; DataSet ds = new DataSet(); ds = bll.GetList(strWhere); DataTable dt = ds.Tables[0]; this.ClassName.InnerHtml = model.ClassDesc; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string classname="nav_2"; // Ñ¡ÖÐ״̬Ñùʽ if (ClassID.ToString() == dt.Rows[i][0].ToString()) classname = "nav_2_on"; this.ClassList.InnerHtml += "<li class='" + classname + "'><img src='images/picto_feuilles.gif' align='absmiddle' /><a href='main.aspx?classid=" + dt.Rows[i][0].ToString() + "' >" + dt.Rows[i][1].ToString() + "</a></li>"; } } }
protected void btnAdd_Click(object sender, EventArgs e) { //string strErr = ""; string ClassDesc = this.txtClassDesc.Text; string ClassPicture = this.txtClassPicture.Text; int ParentId = 0; if (this.dropParent.SelectedIndex > 0) { ParentId = int.Parse(this.dropParent.SelectedValue); } Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); model.ClassDesc = ClassDesc; model.ClassPicture = ClassPicture; model.ParentId = ParentId; Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); bll.Add(model); if (chkAddContinue.Checked) { Session["newsclass"] = model; Response.Redirect("Add.aspx"); } else { Session["newsclass"] = null; Response.Redirect("index.aspx"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.NewsManage.NewsClass GetModel(int ClassId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from T_NewsClass "); strSql.Append(" where ClassId=@ClassId"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ClassId", DbType.Int16, ClassId); DataSet ds = db.ExecuteDataSet(dbCommand); Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); model.ClassId = ClassId; if (ds.Tables[0].Rows.Count > 0) { model.ClassDesc = ds.Tables[0].Rows[0]["ClassDesc"].ToString(); model.ClassPicture = ds.Tables[0].Rows[0]["ClassPicture"].ToString(); if (ds.Tables[0].Rows[0]["ParentId"].ToString() != "") { model.ParentId = int.Parse(ds.Tables[0].Rows[0]["ParentId"].ToString()); } return(model); } else { return(null); } }
protected void grid_ItemDataBound(object sender, DataGridItemEventArgs e) { if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem)) { string Dormancy = (string)DataBinder.Eval(e.Item.DataItem, "Dormancy"); int ClassId = (int)DataBinder.Eval(e.Item.DataItem, "ClassId"); if (Dormancy.ToLower() == "true") { e.Item.Cells[4].Text = "<span style=\" color:Red\">休眠</span>"; } else { e.Item.Cells[4].Text = "<span style=\" color:Green\">发布</span>"; } Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); Maticsoft.Model.NewsManage.NewsClass mod = bll.GetModelByCache(ClassId); if (mod != null) { e.Item.Cells[5].Text = mod.ClassDesc; } else { e.Item.Cells[5].Text = "未知类别"; } } }
//#region BiudTree //private void BiudTree() //{ // // if(Session["UserInfo"]==null) // // { // // return ; // // } // // MoviePrincipal user=new MoviePrincipal(Context.User.Identity.Name); // // PowerWeb.Web.Accounts.CS.Bus.User currentUser=(PowerWeb.Web.Accounts.CS.Bus.User)Session["UserInfo"];00 // Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); // DataTable dt; // // if(user.HasPermissionID(newsmanageid)) // // { // // dt=nc.GetNewsClassList("").Tables[0]; // // } // // else // // { // // dt=nc.GetNewsClassList(int.Parse(currentUser.DepartmentID)).Tables[0]; // dt = bll.GetList("").Tables[0]; // // } // this.dropParent.Items.Clear(); // //加载树 // this.dropParent.Items.Add(new ListItem("顶级目录", "0")); // DataRow[] drs = dt.Select("ParentId= 0"); // foreach (DataRow r in drs) // { // string nodeid = r["ClassId"].ToString(); // string text = r["ClassDesc"].ToString(); // string parentid = r["ParentId"].ToString(); // // string permissionid=r["PermissionID"].ToString(); // text = "╋" + text; // this.dropParent.Items.Add(new ListItem(text, nodeid)); // int sonparentid = int.Parse(nodeid); // string blank = "├"; // BindNode(sonparentid, dt, blank); // } // this.dropParent.DataBind(); //} //private void BindNode(int parentid, DataTable dt, string blank) //{ // DataRow[] drs = dt.Select("ParentID= " + parentid); // foreach (DataRow r in drs) // { // string nodeid = r["ClassId"].ToString(); // string text = r["ClassDesc"].ToString(); // //string permissionid=r["PermissionID"].ToString(); // text = blank + "『" + text + "』"; // this.dropParent.Items.Add(new ListItem(text, nodeid)); // int sonparentid = int.Parse(nodeid); // string blank2 = blank + "─"; // BindNode(sonparentid, dt, blank2); // } //} //#endregion private void ShowInfo(int id) { Navigation011.Para_Str = "id=" + id; Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); Maticsoft.Model.NewsManage.NewsClass model = bll.GetModel(id); this.lblClassId.Text = model.ClassId.ToString(); txtClassDesc.Text = model.ClassDesc; txtClassPicture.Text = model.ClassPicture; }
private void ShowInfo(int Id) { Navigation011.Para_Str = "id=" + Id; Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); Maticsoft.Model.NewsManage.NewsClass model = bll.GetModel(Id); lblClassId.Text = model.ClassId.ToString(); lblClassDesc.Text = model.ClassDesc; lblClassPicture.Text = model.ClassPicture; lblParentId.Text = model.ParentId.ToString(); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Maticsoft.Model.NewsManage.NewsClass model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_NewsClass("); strSql.Append("ClassDesc,ClassPicture,ParentId)"); strSql.Append(" values ("); strSql.Append("@ClassDesc,@ClassPicture,@ParentId)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ClassDesc", DbType.String, model.ClassDesc); db.AddInParameter(dbCommand, "ClassPicture", DbType.String, model.ClassPicture); db.AddInParameter(dbCommand, "ParentId", DbType.Int16, model.ParentId); db.ExecuteNonQuery(dbCommand); //db.GetParameterValue(dbCommand,"ClassId"); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Maticsoft.Model.NewsManage.NewsClass model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_NewsClass set "); strSql.Append("ClassDesc=@ClassDesc,"); strSql.Append("ClassPicture=@ClassPicture,"); strSql.Append("ParentId=@ParentId"); strSql.Append(" where ClassId=@ClassId"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ClassId", DbType.Int16, model.ClassId); db.AddInParameter(dbCommand, "ClassDesc", DbType.String, model.ClassDesc); db.AddInParameter(dbCommand, "ClassPicture", DbType.String, model.ClassPicture); db.AddInParameter(dbCommand, "ParentId", DbType.Int16, model.ParentId); db.ExecuteNonQuery(dbCommand); }
protected void BindClassList(int ClassID) { string strWhere = ""; Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); model = bll.GetModel(ClassID); int parentid = model.ParentId; if (parentid != 0) { model = bll.GetModelByCache(parentid); parentid = model.ParentId; } strWhere = "parentid=" + model.ClassId; DataSet ds = new DataSet(); ds = bll.GetList(strWhere); DataTable dt = ds.Tables[0]; }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //邦定类别的树菜单 BiudTree(); if (Session["newsclass"] != null) { Maticsoft.Model.NewsManage.NewsClass model = (Maticsoft.Model.NewsManage.NewsClass)Session["newsclass"]; for (int m = 0; m < this.dropParent.Items.Count; m++) { if (this.dropParent.Items[m].Value == model.ParentId.ToString()) { this.dropParent.Items[m].Selected = true; } } this.chkAddContinue.Checked = true; } } }
protected void btnAdd_Click(object sender, EventArgs e) { int classid = int.Parse(lblClassId.Text); string ClassDesc = this.txtClassDesc.Text; string ClassPicture = this.txtClassPicture.Text; int ParentId = 0; if (this.dropParent.SelectedIndex > 0) { ParentId = int.Parse(this.dropParent.SelectedValue); } Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); model.ClassId = classid; model.ClassDesc = ClassDesc; model.ClassPicture = ClassPicture; model.ParentId = ParentId; Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); bll.Update(model); Response.Redirect("show.aspx?id=" + classid); }
protected void BindClassList(int ClassID) { string strWhere = ""; Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); model = bll.GetModel(ClassID); int parentid = model.ParentId; if (parentid != 0) { model = bll.GetModelByCache(parentid); parentid = model.ParentId; } strWhere = "parentid=" + model.ClassId; DataSet ds = new DataSet(); ds = bll.GetList(strWhere); DataTable dt = ds.Tables[0]; }
protected void btnAdd_Click(object sender, EventArgs e) { int classid = int.Parse(lblClassId.Text); string ClassDesc = this.txtClassDesc.Text; string ClassPicture = this.txtClassPicture.Text; int ParentId = 0; if (this.dropParent.SelectedIndex > 0) { ParentId = int.Parse(this.dropParent.SelectedValue); } Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); model.ClassId = classid; model.ClassDesc = ClassDesc; model.ClassPicture = ClassPicture; model.ParentId = ParentId; Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); bll.Update(model); Response.Redirect("show.aspx?id=" + classid); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Maticsoft.Model.NewsManage.NewsClass model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_NewsClass("); strSql.Append("ClassDesc,ClassPicture,ParentId)"); strSql.Append(" values ("); strSql.Append("@ClassDesc,@ClassPicture,@ParentId)"); SqlParameter[] parameters = { new SqlParameter("@ClassDesc", SqlDbType.VarChar, 50), new SqlParameter("@ClassPicture", SqlDbType.VarChar, 100), new SqlParameter("@ParentId", SqlDbType.Int, 4) }; parameters[0].Value = model.ClassDesc; parameters[1].Value = model.ClassPicture; parameters[2].Value = model.ParentId; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); //return model.ClassId; }
protected void BindClassList(int ClassID) { string strWhere = ""; Maticsoft.BLL.NewsManage.NewsClass bll = new Maticsoft.BLL.NewsManage.NewsClass(); Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); model = bll.GetModel(ClassID); int parentid = model.ParentId; if (parentid != 0) { model = bll.GetModelByCache(parentid); parentid = model.ParentId; } strWhere = "parentid=" + model.ClassId; DataSet ds = new DataSet(); ds = bll.GetList(strWhere); DataTable dt = ds.Tables[0]; this.ClassName.InnerHtml = model.ClassDesc; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string classname = "nav_2"; // Ñ¡ÖÐ״̬Ñùʽ if (ClassID.ToString() == dt.Rows[i][0].ToString()) { classname = "nav_2_on"; } this.ClassList.InnerHtml += "<li class='" + classname + "'><img src='images/picto_feuilles.gif' align='absmiddle' /><a href='main.aspx?classid=" + dt.Rows[i][0].ToString() + "' >" + dt.Rows[i][1].ToString() + "</a></li>"; } } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Maticsoft.Model.NewsManage.NewsClass model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_NewsClass set "); strSql.Append("ClassDesc=@ClassDesc,"); strSql.Append("ClassPicture=@ClassPicture,"); strSql.Append("ParentId=@ParentId"); strSql.Append(" where ClassId=@ClassId"); SqlParameter[] parameters = { new SqlParameter("@ClassId", SqlDbType.Int, 4), new SqlParameter("@ClassDesc", SqlDbType.VarChar, 50), new SqlParameter("@ClassPicture", SqlDbType.VarChar, 100), new SqlParameter("@ParentId", SqlDbType.Int, 4) }; parameters[0].Value = model.ClassId; parameters[1].Value = model.ClassDesc; parameters[2].Value = model.ClassPicture; parameters[3].Value = model.ParentId; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.NewsManage.NewsClass GetModel(int ClassId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from T_NewsClass "); strSql.Append(" where ClassId=@ClassId"); SqlParameter[] parameters = { new SqlParameter("@ClassId", SqlDbType.Int,4)}; parameters[0].Value = ClassId; Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); model.ClassId = ClassId; if (ds.Tables[0].Rows.Count > 0) { model.ClassDesc = ds.Tables[0].Rows[0]["ClassDesc"].ToString(); model.ClassPicture = ds.Tables[0].Rows[0]["ClassPicture"].ToString(); if (ds.Tables[0].Rows[0]["ParentId"].ToString() != "") { model.ParentId = int.Parse(ds.Tables[0].Rows[0]["ParentId"].ToString()); } return model; } else { return null; } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Maticsoft.Model.NewsManage.NewsClass model) { dal.Update(model); }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Maticsoft.Model.NewsManage.NewsClass GetModel(int ClassId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from T_NewsClass "); strSql.Append(" where ClassId=@ClassId"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ClassId", DbType.Int16, ClassId); DataSet ds=db.ExecuteDataSet(dbCommand); Maticsoft.Model.NewsManage.NewsClass model = new Maticsoft.Model.NewsManage.NewsClass(); model.ClassId = ClassId; if (ds.Tables[0].Rows.Count > 0) { model.ClassDesc = ds.Tables[0].Rows[0]["ClassDesc"].ToString(); model.ClassPicture = ds.Tables[0].Rows[0]["ClassPicture"].ToString(); if (ds.Tables[0].Rows[0]["ParentId"].ToString() != "") { model.ParentId = int.Parse(ds.Tables[0].Rows[0]["ParentId"].ToString()); } return model; } else { return null; } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Maticsoft.Model.NewsManage.NewsClass model) { dal.Add(model); }