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); }