/// <summary> /// 添加类型 /// </summary> /// <param name="cs"></param> /// <returns></returns> public int InsertHomeType(MyHomeType cs) { try { return(type.InsertHomeType(cs)); } catch (Exception ex) { throw new Exception(ex.ToString()); } }
/// <summary> /// 显示信息绑定 /// </summary> protected void Bind() { string LoginName = Page.User.Identity.Name; int id = Convert.ToInt32(Request.QueryString["Id"]); MyHomeType homeType = type.GetAllTypeById(id); ddlType.DataSourceID = null; ddlType.DataSource = type.GetHomeTypeList(LoginName); ddlType.DataTextField = "TypeName"; ddlType.DataValueField = "TID"; ddlType.DataBind(); ddlType.Items.FindByText(homeType.TypeName).Selected = true; txtScort.Text = homeType.sort.ToString(); }
/// <summary> /// 显示类别 /// </summary> /// <param name="Id">Id</param> /// <returns></returns> public string ShowStateName(string UserId) { HomeTypeManager mbll = new HomeTypeManager(); MyHomeType model = new MyHomeType(); model = mbll.GetAllTypeById(Convert.ToInt32(UserId)); string strTemp = string.Empty; if (model != null) { strTemp = model.TypeName; } return(strTemp); }
public int InsertHomeType(MyHomeType cs) { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@TID", cs.TID), new SqlParameter("@TypeName", cs.TypeName), new SqlParameter("@LoginName", cs.LoginName), new SqlParameter("@LoginID", cs.LoginID), new SqlParameter("@sort", cs.sort), new SqlParameter("@Datatimes", cs.Datatimes) }; int num = Tz888.DBUtility.DBHelper.ExecuteNonQueryProc("SP_HomeType_ADD", para); return(num); }
public List <MyHomeType> GetTypeList(SqlDataReader reader) { List <MyHomeType> list = new List <MyHomeType>(); while (reader.Read()) { MyHomeType home = new MyHomeType(); home.TID = (int)reader["TID"]; home.LoginID = (int)reader["LoginID"]; home.Datatimes = (DateTime)reader["Datatimes"]; home.LoginName = (string)reader["LoginName"]; home.sort = (int)reader["sort"]; home.TypeName = (string)reader["TypeName"]; list.Add(home); } return(list); }
protected void btnType_Click(object sender, EventArgs e) { MyHomeType type = new MyHomeType(); type.TypeName = txtType.Text; type.Datatimes = DateTime.Now; type.LoginID = 1; type.LoginName = "admin";// Page.User.Identity.Name.Trim(); type.sort = Convert.ToInt32(txtTypeSort.Text); int num = TypeManager.InsertHomeType(type); if (num > 0) { Response.Write("<script>alert('添加成功!');</script>"); } else { Response.Write("<script>alert('添加失败!');</script>"); } }
/// <summary> /// 根据ID获取类型信息 /// </summary> /// <param name="Id"></param> /// <returns></returns> public MyHomeType GetAllTypeById(int Id) { string sql = "select TID,TypeName,LoginName,LoginID,sort,Datatimes from HomeType where TID=@Id"; SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; MyHomeType model = new MyHomeType(); DataSet ds = Tz888.DBUtility.DbHelperSQL.Query(sql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["TID"].ToString() != "") { model.TID = int.Parse(ds.Tables[0].Rows[0]["TID"].ToString()); } model.TypeName = ds.Tables[0].Rows[0]["TypeName"].ToString(); model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString(); if (ds.Tables[0].Rows[0]["LoginID"].ToString() != "") { model.LoginID = int.Parse(ds.Tables[0].Rows[0]["LoginID"].ToString()); } if (ds.Tables[0].Rows[0]["sort"].ToString() != "") { model.sort = int.Parse(ds.Tables[0].Rows[0]["sort"].ToString()); } if (ds.Tables[0].Rows[0]["Datatimes"].ToString() != "") { model.Datatimes = DateTime.Parse(ds.Tables[0].Rows[0]["Datatimes"].ToString()); } return(model); } else { return(null); } }
protected void btnType_Click(object sender, EventArgs e) { MyHomeType type = new MyHomeType(); type.TypeName = txtType.Text; type.Datatimes = DateTime.Now; type.LoginID = 1; type.LoginName = Page.User.Identity.Name.Trim(); type.sort = Convert.ToInt32(txtTypeSort.Text); int num = TypeManager.InsertHomeType(type); if (num > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功!');", true); TypeBind(); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败,或者数量已超过6条');", true); } }
/// <summary> /// 查询所有客房类型信息 /// </summary> /// <returns></returns public IList <MyHomeType> GetHomeTypeList(string LoginName) { //string sql = "select * from HomeType where LoginName=@LoginName"; List <MyHomeType> list = new List <MyHomeType>(); using (DataTable table = Tz888.DBUtility.DBHelper.GetDataSet("select * from HomeType where LoginName='" + LoginName + "' ")) { foreach (DataRow row in table.Rows) { MyHomeType home = new MyHomeType(); home.TID = (int)row["TID"]; home.LoginID = (int)row["LoginID"]; home.Datatimes = (DateTime)row["Datatimes"]; home.LoginName = (string)row["LoginName"]; home.sort = (int)row["sort"]; home.TypeName = (string)row["TypeName"]; list.Add(home); } return(list); } }
protected void btnUpdate_Click(object sender, EventArgs e) { MyHomeType homeType = new MyHomeType(); homeType.TID = Id; homeType.Datatimes = DateTime.Now; homeType.LoginID = 1; homeType.LoginName = Page.User.Identity.Name; homeType.sort = Convert.ToInt32(txtScort.Text.Trim()); homeType.TypeName = ddlType.SelectedItem.Text; int num = type.UpdateHomeType(homeType); if (num > 0) { //Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('修改成功!');history.go(-2);</script>"); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功!');window.location.href='HomeList.aspx';</script>"); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('修改失败!');", true); } }
/// <summary> /// 根据查询所有分类字段 /// </summary> /// <param name="LoginName"></param> /// <returns></returns> public string SelectType(string LoginName) { MyHomeType model = new MyHomeType(); string sql = "select top 6 TID, TypeName from HomeType where LoginName='" + LoginName + "' order by sort"; DataSet ds = Tz888.DBUtility.DbHelperSQL.ExecuteQuery(sql); StringBuilder sb = new StringBuilder(); if ((ds != null) && (ds.Tables[0].Rows.Count > 0)) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; int TID = Convert.ToInt32(dr["TID"].ToString()); string TypeName = dr["TypeName"].ToString(); sb.Append("<li id= nav_btn_" + (i + 3).ToString() + " onclick=SetBtn('nav'," + (i + 3).ToString() + "," + (dr["TID"].ToString()) + ")> " + dr["TypeName"].ToString() + "</li>"); } return(sb.ToString()); } else { return(""); } }