} bll层; public static int updUser(Users use) { return AdminUsersService.updUser(use); }dal层; public static int updUser(Users use) { string sql = string.Format("insert into users values ('{0}','{1}','{2}','{3}','{4}','{5}',1,1)", use.LoginId1, use.LoginPwd1, use.Name1, use.Address1, use.Phone1, use.Mail1); return DBhelp.DBHelper.ExecuteCommand(sql); }model; namespace MyBookShopModel { public class Users { private int id; public int Id { get { return id; } set { id = value; } } private string LoginId; public string LoginId1 { get { return LoginId; } set { LoginId = value; } } private string LoginPwd; public string LoginPwd1 { get { return LoginPwd; } set { LoginPwd = value; } } private string Name; public string Name1 { get { return Name; } set { Name = value; } } private string Address; public string Address1 { get { return Address; } set { Address = value; } } private string Phone; public string Phone1 { get { return Phone; } set { Phone = value; } } private string Mail; public string Mail1 { get { return Mail; } set { Mail = value; } } private int UserRoleid; public int UserRoleid1 { get { return UserRoleid; } set { UserRoleid = value; } } private int UserStateid; public int UserStateid1 { get { return UserStateid; } set { UserStateid = value; } } } }
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
Users use = new Users();
string loginid = e.Values[0].ToString();
DataTable dt = UsersManager.dt(loginid);
if (dt.Rows.Count==0)
{
use.LoginId1 = loginid;
use.LoginPwd1 = e.Values[1].ToString();
use.Phone1 = e.Values[2].ToString();
use.Address1 = e.Values[3].ToString();
use.Name1 = e.Values[4].ToString();
use.Mail1 = e.Values[5].ToString();
int upd = ADminUsersManager.updUser(use);
if (upd > 0)
{
Label1.Text = "添加用户成功";
}
else
{
Label1.Text = "添加用户失败";
}
DetailsView1.DataBind();
}
else {
Label1.Text = "此账号已存在!";
}
}
bll层;
public static int updUser(Users use)
{
return AdminUsersService.updUser(use);
}dal层;
public static int updUser(Users use)
{
string sql = string.Format("insert into users values ('{0}','{1}','{2}','{3}','{4}','{5}',1,1)", use.LoginId1, use.LoginPwd1, use.Name1, use.Address1, use.Phone1, use.Mail1);
return DBhelp.DBHelper.ExecuteCommand(sql);
}model;
namespace MyBookShopModel
{
public class Users
{
private int id; public int Id
{
get { return id; }
set { id = value; }
}
private string LoginId; public string LoginId1
{
get { return LoginId; }
set { LoginId = value; }
}
private string LoginPwd; public string LoginPwd1
{
get { return LoginPwd; }
set { LoginPwd = value; }
}
private string Name; public string Name1
{
get { return Name; }
set { Name = value; }
}
private string Address; public string Address1
{
get { return Address; }
set { Address = value; }
}
private string Phone; public string Phone1
{
get { return Phone; }
set { Phone = value; }
}
private string Mail; public string Mail1
{
get { return Mail; }
set { Mail = value; }
}
private int UserRoleid; public int UserRoleid1
{
get { return UserRoleid; }
set { UserRoleid = value; }
}
private int UserStateid; public int UserStateid1
{
get { return UserStateid; }
set { UserStateid = value; }
}
}
}
搞了半天了。我断点调试,程序走完 了,数据库也添加完了,最后结束的时候就蹦出个出错,说没有找到loginid。
好烦躁啊。
DataTable dt = UsersManager.dt(loginid);
这部分代码有问题吧。