protected void LinkButton1_Click(object sender, EventArgs e)
{
if (TextBox1.Text == "")
{
ClientScript.RegisterStartupScript(GetType(), "", "alert('请输入您投诉的理由" +
"');window.location='tousu.aspx';", true);
//Response.Write("<script>alert('请输入您的投诉理由！')</script>");
return;
}
else
{
tousuModel model = new tousuModel();
model.touname = DropDownList1.SelectedItem.Text;
model.toufang = Convert.ToInt32(DropDownList2.SelectedItem.Text);
model.toudui = DropDownList3.SelectedItem.Text;
model.touliyou = TextBox1.Text;
LBH_BLL blll = new LBH_BLL();
int result = 0;
result = blll.addUser(model);
if (result > 0)
{
ClientScript.RegisterStartupScript(GetType(), "", "alert('添加成功');window.location='tousu.aspx';", true);
//Response.Write("<script>alert('保存成功！')</script>");
return;
}
}
}
public List <tousuModel> gettousu()
{
string sql = "select * from [JDGL].[dbo].[tousu]";
SqlDataReader reader = SqlHelper.QueryReader(sql);
List <tousuModel> users = new List <tousuModel>();
if (reader.HasRows)
{
while (reader.Read())
{
tousuModel model = new tousuModel();
model.touid = Convert.ToInt32(reader["touid"]);
model.touname = reader["touname"].ToString();
model.toufang = Convert.ToInt32(reader["toufang"]);
model.toudui = reader["toudui"].ToString();
model.touliyou = reader["touliyou"].ToString();
users.Add(model);
}
}
return(users);
}
public int addUser(tousuModel model)
{
string sql = @"insert into [JDGL].[dbo].[tousu](touname,toufang,toudui,touliyou) values (@touname,@toufang,@toudui,@touliyou)";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@touname", model.touname));
parameters.Add(new SqlParameter("@toufang", model.toufang));
parameters.Add(new SqlParameter("@toudui", model.toudui));
parameters.Add(new SqlParameter("@touliyou", model.touliyou));
//string sqlExist = "select UserID from [Test].[dbo].[UserInfo] where username=@name and isdelete=0";
//SqlParameter[] sqlp = new SqlParameter[1];
//sqlp[0] = new SqlParameter("@touname", model.username);
//object obj = SqlHelper.NoQuery(sqlExist, sqlp);
int result = 0;
//if (obj != null)
//{
// result = 100;
// return result;
//}
result = SqlHelper.NoQuery(sql, parameters.ToArray());
return(result);
}
public int addUser(tousuModel model)
{
return(dal.addUser(model));
}
