protected void Button1_Click(object sender, EventArgs e)
{
MyHomeLink home = new MyHomeLink();
home.LID = Id;
home.Linkwww = txtWan.Text.Trim();
home.WDoc = txtDOC.Text.Trim();
home.WSort = Convert.ToInt32(txtsorct.Text.Trim());
home.LName = txtName.Text.Trim();
home.PassWord = txtPass.Text.Trim();
home.UserName = txtNumber.Text.Trim();
home.LoginName = Page.User.Identity.Name.Trim();
home.CreateTimes = DateTime.Now; //创建时间
home.Typeid.TID = Convert.ToInt32(ddlType.SelectedValue); //类型
home.LoginID = 1;
if (rdostar.Checked == true)
{
home.States = 1;
}
else if (rdostar.Checked == true)
{
home.States = 0;
}
int num = manger.UpdateMyHome(home);
if (num > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功！');window.location.href='HomeList.aspx';</script>");
}
else
{
Tz888.Common.Message.back("失败");
}
}
protected void btnAdHomelist_Click(object sender, EventArgs e)
{
MyHomeLink home = new MyHomeLink();
home.LName = txtName.Text; //网站名称
home.Linkwww = txtlink.Text.ToString(); //连接地址
home.PassWord = txtPass.Text; //密码
home.UserName = txtNumber.Text; //帐号
home.WSort = Convert.ToInt32(txtsorct.Text); //排序
home.LoginName = Page.User.Identity.Name.Trim();
home.CreateTimes = DateTime.Now; //创建时间
home.Typeid.TID = Convert.ToInt32(ddlType.SelectedValue); //类型
home.LoginID = 1;
home.WDoc = txtDOC.Text; //备注
if (rdostate.SelectedValue == "启用")
{
home.States = 1;
}
else
{
home.States = 0;
}
int num = manger.InsertHomeLink(home);
if (num > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功！');", true);
PageBind();
}
else
{
Response.Write("<script>alert('添加失败！');</script>");
}
}
/// <summary>
/// 显示信息绑定
/// </summary>
protected void Bind()
{
string LoginName = Page.User.Identity.Name;
int id = Convert.ToInt32(Request.QueryString["Id"]);
MyHomeLink home = manger.GetAllMyHomeById(id);
ddlType.DataSourceID = null;
ddlType.DataSource = type.GetHomeTypeList(LoginName);
ddlType.DataTextField = "TypeName";
ddlType.DataValueField = "TID";
ddlType.DataBind();
ddlType.SelectedValue = home.Typeid.TID.ToString();
txtDOC.Text = home.WDoc.ToString();
txtName.Text = home.LName.ToString();
txtNumber.Text = home.UserName.ToString();
txtPass.Text = home.PassWord.ToString();
txtsorct.Text = home.WSort.ToString();
txtWan.Text = home.Linkwww.ToString();
if (home.States == 1)
{
rdostar.Checked = true;
}
else if (home.States == 0)
{
rdostop.Checked = true;
}
}
/// <summary>
/// 根据ID查看信息
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public MyHomeLink GetAllMyHomeById(int Id)
{
string sql = "usp_SelcectMyHomeById";
MyHomeLink home = new MyHomeLink();
using (SqlDataReader reader = Tz888.DBUtility.DBHelper.ExecuteReaderProc(sql, new SqlParameter("@Id", Id)))
{
while (reader.Read())
{
home.CreateTimes = (DateTime)reader["CreateTimes"];
home.LID = (int)reader["LID"];
home.Linkwww = (string)reader["Linkwww"];
home.LName = (string)reader["LName"];
home.LoginID = (int)reader["LoginID"];
home.LoginName = (string)reader["LoginName"];
home.PassWord = (string)reader["PassWord"];
home.States = (int)reader["States"];
home.Typeid = type.GetAllTypeById((int)reader["NID"]);
home.UserName = (string)reader["UserName"];
home.WDoc = (string)reader["WDoc"];
home.WSort = (int)reader["WSort"];
}
}
return(home);
}
/////// <summary>
/////// 分页获取数据列表
/////// </summary>
/////// <param name="pb">分页基本信息</param>
/////// <param name="count">返回总条数</param>
/////// <returns></returns>
//public DataSet GetList(PageBase pb, ref int count)
//{
// SqlParameter[] parameters =
// {
// new SqlParameter("@tblName", SqlDbType.NVarChar, 255),
// new SqlParameter("@strGetFields", SqlDbType.NVarChar, 255),
// new SqlParameter("@fldName", SqlDbType.NVarChar, 255),
// new SqlParameter("@PageSize", SqlDbType.Int),
// new SqlParameter("@PageIndex", SqlDbType.Int),
// new SqlParameter("@doCount", SqlDbType.Int),
// new SqlParameter("@OrderType", SqlDbType.Int),
// new SqlParameter("@strWhere", SqlDbType.VarChar,5000),
// };
// parameters[0].Value = pb.TblName;
// parameters[1].Value = pb.StrGetFields;
// parameters[2].Value = pb.FldName;
// parameters[3].Value = pb.PageSize;
// parameters[4].Value = pb.PageIndex;
// parameters[5].Value = pb.DoCount;
// parameters[6].Value = pb.OrderType;
// parameters[7].Value = pb.StrWhere;
// DataSet ds = new DataSet();
// ds = Tz888.DBUtility.DbHelperSQL.RunProcedure(pb.ProcedureName, parameters, "ds");
// if (pb.DoCount == 1)
// {
// if (ds.Tables.Count == 1)
// count = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
// }
// return ds;
//}
#endregion
#region IHomeLink查询所有我的主页信息此方法暂时没有使用
/// <summary>
/// 查询所有我的主页信息
/// </summary>
/// <returns>list</returns>
public IList <MyHomeLink> GetAllMyHome(string LoginName)
{
string sql = "select * from HomeLink where LoginName =@LoginName";
DataTable tb = Tz888.DBUtility.DBHelper.GetDataSet(sql);
IList <MyHomeLink> list = new List <MyHomeLink>();
foreach (DataRow r in tb.Rows)
{
MyHomeLink home = new MyHomeLink();
home.CreateTimes = (DateTime)r["CreateTimes"];
home.LID = (int)r["LID"];
home.Linkwww = (string)r["Linkwww"];
home.LName = (string)r["LName"];
home.LoginID = (int)r["LoginID"];
home.LoginName = (string)r["LoginName"];
home.PassWord = (string)r["PassWord"];
home.States = (int)r["States"];
home.Typeid = type.GetAllTypeById((int)r["NID"]);
home.UserName = (string)r["UserName"];
home.WDoc = (string)r["WDoc"];
home.WSort = (int)r["WSort"];
list.Add(home);
}
return(list);
}
/// <summary>
/// 添加方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
MyHomeLink home = new MyHomeLink();
home.LName = txtName.Text; //网站名称
home.Linkwww = txtURL.Text; //连接地址
home.PassWord = txtPass.Text; //密码
home.UserName = txtNumber.Text; //帐号
home.WSort = Convert.ToInt32(txtsorct.Text); //排序
home.LoginName = "cc"; // Page.User.Identity.Name.Trim();
home.CreateTimes = DateTime.Now; //创建时间
home.Typeid.TID = Convert.ToInt32(ddlType.SelectedValue); //类型
home.LoginID = 1;
home.WDoc = txtDOC.Text; //备注
if (rdostate.SelectedValue == "启用")
{
home.States = 1;
}
else
{
home.States = 0;
}
int num = manger.InsertHomeLink(home);
if (num > 0)
{
Response.Write("<script>alert('添加成功！');</script>");
}
else
{
Response.Write("<script>alert('添加失败！');</script>");
}
}
/// <summary>
/// 查询主页列表
/// </summary>
/// <returns>model</returns>
public MyHomeLink GetAllhome()
{
DataTable dt = obj.GetList("HomeLink", "*", "LoginName", 1, 1, 0, 1, "");
MyHomeLink model = new MyHomeLink();
if (dt.Rows.Count > 0)
{
//model.CreateTimes = DateTime.Parse(dt.Rows[0]["CreateTimes"].ToString());
model.Linkwww = dt.Rows[0]["Linkwww"].ToString();
model.LName = dt.Rows[0]["LName"].ToString();
model.LoginName = dt.Rows[0]["LoginName"].ToString();
model.PassWord = dt.Rows[0]["PassWord"].ToString();
model.States = int.Parse(dt.Rows[0]["States"].ToString());
model.LoginID = int.Parse(dt.Rows[0]["LoginID"].ToString());
model.LID = int.Parse(dt.Rows[0]["LID"].ToString());
model.Tid = int.Parse(dt.Rows[0]["Tid"].ToString());
model.WDoc = dt.Rows[0]["WDoc"].ToString();
model.WSort = int.Parse(dt.Rows[0]["Wsort"].ToString());
model.LoginID = int.Parse(dt.Rows[0]["LoginID"].ToString());
model.UserName = dt.Rows[0]["UserName"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 添加主页信息
/// </summary>
/// <param name="cs"></param>
/// <returns></returns>
public int InsertHomeLink(MyHomeLink cs)
{
try
{
return(dal.InsertHomeLink(cs));
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="cs"></param>
/// <returns></returns>
public int UpdateMyHome(MyHomeLink cs)
{
try
{
return(dal.UpdateMyHome(cs));
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
HomeTypeService type = new HomeTypeService(); //实例化对象
#region IHomeType 添加我的主页信息
/// <summary>
/// 添加我的主页信息
/// </summary>
/// <param name="cs"></param>
/// <returns>num</returns>
public int InsertHomeLink(MyHomeLink cs)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@LID", cs.LID),
new SqlParameter("@NID", cs.Typeid.TID),
new SqlParameter("@LName", cs.LName),
new SqlParameter("@Linkwww", cs.Linkwww),
new SqlParameter("@WDoc", cs.WDoc),
new SqlParameter("@WSort", cs.WSort),
new SqlParameter("@UserName", cs.UserName),
new SqlParameter("@PassWord", cs.PassWord),
new SqlParameter("@States", cs.States),
new SqlParameter("@CreateTimes", cs.CreateTimes),
new SqlParameter("@LoginName", cs.LoginName),
new SqlParameter("@LoginID", cs.LoginID)
};
int num = Tz888.DBUtility.DBHelper.ExecuteNonQueryProc("usp_AddHomeLink", para);
return(num);
}
public List <MyHomeLink> GetHomeList(SqlDataReader reader)
{
List <MyHomeLink> list = new List <MyHomeLink>();
while (reader.Read())
{
MyHomeLink home = new MyHomeLink();
home.CreateTimes = (DateTime)reader["CreateTimes"];
home.LID = (int)reader["LID"];
home.Linkwww = (string)reader["Linkwww"];
home.LName = (string)reader["LName"];
home.LoginID = (int)reader["LoginID"];
home.LoginName = (string)reader["LoginName"];
home.PassWord = (string)reader["PassWord"];
home.States = (int)reader["States"];
home.Typeid = type.GetAllTypeById((int)reader["NID"]);
home.UserName = (string)reader["UserName"];
home.WDoc = (string)reader["WDoc"];
home.WSort = (int)reader["WSort"];
list.Add(home);
}
return(list);
}
public int UpdateMyHome(MyHomeLink cs)
{
// SqlParameter[] para = new SqlParameter[]
//{
// new SqlParameter("@LID",cs.LID),
// new SqlParameter("@NID", cs.Typeid.TID),
// new SqlParameter("@LName",cs.LName ),
// new SqlParameter("@Linkwww",cs.Linkwww ),
// new SqlParameter("@WDoc",cs.WDoc ),
// new SqlParameter("@WSort",cs.WSort ),
// new SqlParameter("@UserName", cs.UserName),
// new SqlParameter("@PassWord",cs.PassWord ),
// new SqlParameter("@States", cs.States),
// new SqlParameter("@CreateTimes", cs.CreateTimes),
// new SqlParameter("@LoginName",cs.LoginName ),
// new SqlParameter("@LoginID", cs.LoginID)
//};
// int num = Tz888.DBUtility.DBHelper.ExecuteNonQueryProc("up_updateMyHome", para);
// return num;
StringBuilder strSql = new StringBuilder();
strSql.Append("update HomeLink set ");
strSql.Append("NID=@NID,");
strSql.Append("LName=@LName,");
strSql.Append("Linkwww=@Linkwww,");
strSql.Append("WDoc=@WDoc,");
strSql.Append("WSort=@WSort,");
strSql.Append("UserName=@UserName,");
strSql.Append("PassWord=@PassWord,");
strSql.Append("States=@States,");
strSql.Append("CreateTimes=@CreateTimes,");
strSql.Append("LoginName=@LoginName,");
strSql.Append("LoginID=@LoginID");
strSql.Append(" where LID=@LID ");
SqlParameter[] parameters =
{
new SqlParameter("@LID", cs.LID),
new SqlParameter("@NID", cs.Typeid.TID),
new SqlParameter("@LName", cs.LName),
new SqlParameter("@Linkwww", cs.Linkwww),
new SqlParameter("@WDoc", cs.WDoc),
new SqlParameter("@WSort", cs.WSort),
new SqlParameter("@UserName", cs.UserName),
new SqlParameter("@PassWord", cs.PassWord),
new SqlParameter("@States", cs.States),
new SqlParameter("@CreateTimes", cs.CreateTimes),
new SqlParameter("@LoginName", cs.LoginName),
new SqlParameter("@LoginID", cs.LoginID)
};
parameters[0].Value = cs.LID;
parameters[1].Value = cs.Typeid.TID;
;
parameters[2].Value = cs.LName;
parameters[3].Value = cs.Linkwww;
parameters[4].Value = cs.WDoc;
parameters[5].Value = cs.WSort;
parameters[6].Value = cs.UserName;
parameters[7].Value = cs.PassWord;
parameters[8].Value = cs.States;
parameters[9].Value = cs.CreateTimes;
parameters[10].Value = cs.LoginName;
parameters[11].Value = cs.LoginID;
int num = Tz888.DBUtility.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return(num);
}
