public int Insert(frmU U)
{
return(base.ExecNonQuery("INSERT INTO " +
"Users(UName, Password) " +
"VALUES(@UName, @Password)",
GetParameter(U)));
}
public object InsertScalar(frmU U)
{
return(base.ExecScalar("INSERT INTO " +
"Users(UName, Password ) " +
"OUTPUT INSERTED.UID VALUES(@UName, @Password)",
GetParameter(U)));
}
public SqlParameter[] GetParameter(frmU U)
{
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("UID", U.UID);
param[1] = new SqlParameter("UCode", U.UCode);
param[2] = new SqlParameter("UName", U.UName);
param[3] = new SqlParameter("Password", U.Password);
return(param);
}
private frmU GetUser()
{
frmU U = new frmU();
U.UID = Convert.ToInt32(txtUID.Text);
U.UCode = txtUCode.Text;
U.UName = txtUName.Text;
U.Password = txtPass.Text;
return(U);
}
public int Update(frmU U)
{
return(base.ExecNonQuery("UPDATE Users " +
"SET UName=@UName, Password=@Password WHERE UID=@UID", GetParameter(U)));
}
