public int Delete(Role Role_Code)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetSqlStringCommand("DELETE FROM Role WHERE Role_Code = '" + Role_Code.Role_Code+"'");
return db.ExecuteNonQuery(cmd);
}
public int Update(Role Role)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetStoredProcCommand("p_Role_update");
db.AddInParameter(cmd, "@Role_Code", DbType.Guid, Role.Role_Code);
db.AddInParameter(cmd, "@Role_Name", DbType.String, Role.Role_Name);
db.AddInParameter(cmd, "@DES", DbType.String, Role.DES);
return db.ExecuteNonQuery(cmd);
}
public int Save(UserInfo t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from [UserInfo] ");
strSql.Append(" where UserID='" + t.UserID.ToString() + "'");
DBHelper db = new DBHelper();
DbCommand cmd = db.GetSqlStringCommand(strSql.ToString());
int rows = db.ExecuteNonQuery(cmd);
if (rows > 0)
{
return 1;
}
else
{
return -1;
}
}
public int Delete(UserInfo t)
{
string sql = "delete from [UserInfo] where UserID='" + t.UserID + "'";
DBHelper db = new DBHelper();
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteNonQuery(cmd);
}
public int Update(UserInfo t)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetStoredProcCommand("p_UserInfo_Update");
db.AddInParameter(cmd, "@UserID", DbType.String, t.UserID);
db.AddInParameter(cmd, "@Link_Tel", DbType.String, t.Link_Tel);
db.AddInParameter(cmd, "@Mob_Tel", DbType.String, t.Mob_Tel);
db.AddInParameter(cmd, "@LoginID", DbType.String, t.LoginID);
db.AddInParameter(cmd, "@Password", DbType.String, t.Password);
db.AddInParameter(cmd, "@UserName", DbType.String, t.UserName);
db.AddInParameter(cmd, "@Spell_Index", DbType.String, t.Spell_Index);
db.AddInParameter(cmd, "@Sex", DbType.String, t.Sex);
db.AddInParameter(cmd, "@IdentityCard", DbType.String, t.IdentityCard);
db.AddInParameter(cmd, "@Birthday", DbType.String, t.Birthday);
db.AddInParameter(cmd, "@EMail", DbType.String, t.EMail);
db.AddInParameter(cmd, "@Addr", DbType.String, t.Addr);
db.AddInParameter(cmd, "@State", DbType.String, t.State);
return db.ExecuteNonQuery(cmd);
}
