/// <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("");
}
}
